Oracle Financials Interview Questions – Answers Included

Below is a list of 25 Important questions that is asked in almost every financials technical interview question. I have also included some of the functional questions that are asked.Answers are included.

Qns: What is Flex field? What are different types of Flex field?

Ans: Flex field is used to capture information of your Organisations.

Qns: Difference between KFF and DFF.

KFF

Unique identifier

Stored in segment Column

DFF

Is used to capture additional information

Stored in attribute Column

Qns: How many KFF are in GL. AP , AR.

Ans:

Module KFF

GL Accounting FF

AP No KFF

AR Sales tax Location FF

Territory Flexfield.

Qns: What is symbol of DFF in the Forms?

Ans: Square Bracket [ ].

Qns: What is structure of KFF in the Accounting Flexfields.

Ans: Company

Cost center

Account

Product

Future use.

Qns: How many segments are in AFF.

Ans: max 30 segments and min two.

Qns: What are flexfield Qualifiers.

Ans: Flexfield Qualifiers is used to identify the segments. Various types of flexfield qualifiers are listed below:

a) Balancing Segment Qualifier.

b) Cost Center segment Qualifier.

c) Natural Account Segment Qualifier.

d) Intercompany Segment Qualifier.

Qns: What is Dynamic Insertions?

Ans: u can create Code Combinations at run time.

Qns: In which table Code Cominations id is stored.

Ans: GL_CODE_COMBINATIONS.

Qns: In which table flex values are stored.

Ans: 1. fnd_ flex_Values

2. fnd_ flex_Values_tl

Qns: What is set of Books and in which table set of book is stored.

Ans : Set of Books is a Financial Reporting entity which Consist of three C.

a) Chart Of Accounts

b) Currency

c) Calendar.

Set of Books is stored in GL_SETS_OF_BOOKS

Qns: In which table Currency and Period Type Name are stored.

Currency – FND_CURRENCIES

Period – GL_PERIOD_STATUSES

Qns: In which table Segment Values are stored and concatenated values are stored.

Ans: 1. GL_CODE_COMBINATIONS

2. GL_CODE_COMBINATIONS_KFV.

Qns: What are different types of Currency.

Ans: Functional Currency

Foreign currency.

Qns: What are different types of Calendars .

Ans: Different types of Calendars are listed below

a) Fiscal

b) Accounting

Qns: How will you attach set of Books to the Responsibility?

Ans: through Profile. GL SETS OF Books Name.

Qns: What is Profile and what are different types of Profiles.

Ans: Profile: Profile is the changeable option that affects the way your application runs. There are two types of profile.

1. System defined

2. User defined

Qns: What are different Profiles Level available in oracle apps.

Ans: Below are the Profiles Level available in oracle apps

1. Site(Lowest level)

2. Application

3. Responsibility

4. User.

Qns: Write Name of some Profile options.

Ans:

1. GL Sets of Books Name

2. GL sets of Books id

3. MO:Operating unit (multi org).

4. HR:User type.

Qns: What is cycle of GL.?

Ans: In simple and layman words-

1. Open the period

2. Create Journal Enteries

3. Post the Journals.

Qns: In Which tables Journal entries created.

Ans: Important tables are-

1. Batch: GL_JE_BATCHES

2. Header: GL_JE_HEADERS

3. Lines : GL_JE_LINES

Qns: After Posting data goes in which tables.

Ans: GL_BALANCES.( Column Period_net_cr, period_net_dr).

Qns: What are Important tables in GL.

Ans:

1. GL_JE_BATCHES

2. GL_JE_HEADERS

3. GL_JE_LINES

4. GL_BALANCES

5. GL_SETS_OF_BOOKS

6. GL_CODE_COMBINATIONS

7. GL_PERIOD_STATUES

8. GL_INTERFACE

Qns: In which table Supplier information's is stored.

Ans: Supplier information can be found in following tables

1. PO_VENDORS

2. PO_VENDOR_SITES_ALL

3. PO_VENDOR_CONTACTS

Qns: What is difference org_id and Organization_id.

Ans: Org_id is for operating unit and organization_id is for inventory organization.

--

Interview Questions on Oracle Apps AR module – Functional

racle Receivables is not an easy module to set-up. To crack the interview is bit more tedious.Below are some of the Functional questions pertaining to Oracle AR module. Just go through them and brush up your skills.

1. How many Address's can have one Customer?
Primary Address, Bill – To – Address, Ship – To – Address

2. Customer Number Always Automatic / Manual?
Any thing Either Manual or Automatic

3. What are the Mandatory Address's you should create a Customer for Communicate him?
Remit – To – Address

4. Can U Merge the Customers? If How?
Using the Merging Customer Window

5. What is Accounting Rules?
It is For Generating Revenue Recognition Programs like Monthly, Quarterly

6. What is Invoicing Rules?
The Invoicing Rules Helps you when you receive data from Outside systems like Auto Invoices how the data should insert and It contains 2 rules Advance Invoice, Arrears Invoice.

7. Where should the customers send the payments of Invoices?
Remittance Banks or Vendor Places

8. What is the Transaction Type?
It describes us Whether you want transfer the Receivables data into General Ledger or not. And also when ever you create an invoice what are the accounts should be effected and also the sign of Transaction also.

9. What is a Transaction Source?
It is For Invoice or Invoice Batch numbers whether automatically or manually

10. How many Transactions we have?
Six, Credit Transactions: Invoice: Debit Memo: Charge back: Guarantee: Deposit

11. How can i reduce the Invoice amount?
Using with Credit Transactions

12. What are the Accounts to be use in Transaction Types (Few)?
Revenue, Receivables, Freight, Tax, Clearing, Unearned, Unbilled

13. How can i Assign a Deposit amount to an Invoice?
In the Invoice Window "Commitment" Region

14. What is the Guarantee?
It is agreement between both sides for goods or services in the future , specific range of periods

15. Give the Navigation for Credit Transactions?
Transactions/Credit Transactions

16. How many ways you can apply the Receipt Amount?
Application: Mass Apply

17. How will you know a Customer Balance Amount?
Using with the Customer Account Overview window

18. Can U Define Customer Agreements using with AR?
No, In the Oracle Order Entry Module

19. What are Aging Buckets?
It is for Outstanding Reports purpose the no of days in various ranges

20. How will U View the Outstanding Balance of a Customer?
Generating the Aging Buckets Report

--

Oracle Apps Technical Interview Questions

Below is the list of question asked in Oracle Apps Technical Interviews.

1. Explain Directory Structure of APPS?
2. How to activate, deactivate and run Concurrent Managers?
3. What is the location for concurrent request or manager logfiles and output files?
4. Specify the standard naming conventions for the logfile and output file?
5. How to write LOG information from PL/SQL block to log file?
6. What is Request Group?
7. What is Request Set?
8. What is difference between the Request Group and Request Set?
9. What are the steps to develop a simple Oracle Apps form?
10. What are the important Libraries in Template.fmb?
11. Which Concurrent Manager will run when you run the report in Oracle Application ?
12. How to create a Multi-org report in Apps?
13. State the mandatory parameters while developing Multi-org report in Apps?
14. What is the Schema for AOL?
15. What is the significance of :$FLEX$ ?
16. State some of the FND tables?
17. How to create Query-only form in Oracle Apps with out touching the fmb file?
18. What is the profile option pertaining to Operating Unit?
19. What is the difference between Applsys and Apps?
20. How to Register Shell Script Program in Oracle Applications? How to use parameters while registering shell script as a concurrent program?
21. How to Register PL/SQL Stored Procedure in Oracle Apps? What are the Mandatory thing we need to do for creating PL/SQL Procedure before Registering into Apps?
22. What is Zoom? How to enable zoom feature using Custom.pll?

--

Interview Questions – Oracle Apps AOL and Sysadmin

Interview Questions – Oracle Apps AOL and Sysadmin

Find below the Interview questions related to oracle apps technical interview. The Questions are primarily on Sysadmin and AOL (Application Object Library) Responsibilities. The questions are in MCQ style. The answers are written at the end of each question.
1. Which of the following is not associated with a responsibility?
A. Menu
B. Request group
C. Data group
D. Password expiration
Ans:D

2. What do you need to do to allow a different user to see your output file?
A. The user must log on as a system administrator.
B. The user must have the View My Requests form in system administrator mode.
C. The user must be logged on with the same responsibility as the user that generated the output file, and the profile option Concurrent: Report Access Level value must be set to Responsibility.
D. The user must be logged on as the same responsibility as the one that generated the output file and profile option Concurrent: Report Access Level value is User.
Ans:C

3. When will a request group become a request security group?
A. When the request group is assigned to a responsibility
B. When the request group is specified for the Submit Request form
C. When the request group is defined with request sets
D. When the request group is defined with stage functions
Ans:A

4. How can you customize the SRS process?
A. Change the form title
B. Restrict it by request group
C Eliminate the Submit Another Request dialog window
D. All of the above
Ans:D

5. Which is not a component of a request set?
A. Stage
B. Group
C. Request
D. Parameter Ans:B

6. Which of the following operations cannot be performed with the internal concurrent manager?
A. Restart
B. Verify
C. Deactivate
D. Terminate
Ans:A

7. Which one of the following will be the correct outcome with two include rules in a combined rule?
A. Program will be included if the program is in one of the include rules
B. Program will be included if the program is in both of the include rules
C. Program will be included if the program is run by one of the two Oracle IDs in the include rules
D. None of the above
Ans:B

8. When will the number of actual processes be less than the number of target processes?
A. When the concurrent manager is down
B. When the concurrent manager is coming up
C. When there are not enough requests
D. All of the above
Ans:D

9. Which of the following is not a component of parallel concurrent processing?
A. Internal monitor
B. Transaction manager
C. Primary node
D. Secondary node
Ans:B

10. Which of the following is the overriding level for profile option values?
A. Site
B. Application
C. Responsibility
D. User
Ans:D

11. Which of the following is the correct sequence for setting up database change audits? A. Audit installations, audit tables, audit groups, audit trail update tables request
B. Audit installation, audit groups, audit tables, audit trail update tables request
C. Audit trail update tables request, audit installation, audit groups, audit tables
D. Audit groups, audit tables, audit trail update tables request, Audit Installation
Ans:B

12. Which of the following is not a document sequence type?
A. Category
B. Automatic
C. Gapless
D. Manual
Ans:A

13. Which of the following determines the subdirectory for an executable?
A. Application name
B. Execution method
C. Subroutine
D. Execution filename
Ans:B

14. For what is the Token field used?
A. Default value
B. Profile option value
C. Oracle Reports parameter
D. Value set
Ans:C

15. How are output files associated with various printer components?
A. Through the printer type of the selected printer and the selected print style
B. Through the selected print style and the selected printer driver
C. Through the selected printer type and the selected print style
D. Through the printer type of the selected printer and the selected
Ans:A

--

ORACLE PURCHASING – PURCHASE ORDERS FREQUENTLY ASKED QUESTIONS

ORACLE PURCHASING – PURCHASE ORDERS FREQUENTLY ASKED QUESTIONS
CONTENTS
——–
1. In the Price type quickpick in the Purchase Order Lines zone in enter
Purchase Order form, there is a value called COST PLUS FEE. What is the
COST PLUS FEE price type? How is Purchase Order treating this
price type?
2. What is 2-way, 3-way, 4-way matching? How is this set up?
3. How do you reflect discount from a supplier on a Purchase orders?
4. How do you change the created date on a Purchase Order?
5. What is the sorting order for requisition lines in autocreation of a
Purchase Order?
6. What does the error 'APP-50022: Oracle Human Resources could not retrieve a
value for User Type profile option' mean?
7. In the Enter Receipts (RCVRCERC) form and using different responsibilities
produces different values in the action required field. The Purchasing
Responsibility shows Direct and Standard while the Inventory Responsibility
shows just Direct.
Why are the action options for creating receipts different in Inventory
compared Purchasing?
8. How do you purge Cancelled Requisitions?
9. On the requisition form in the source details zone, there is a field
labeled supplier item. Where does this information on the quickpick come
from and how can this information default in?
10. You are entering a requisition and are unable to find the header or line
note fields. Was this replaced in GUI by attachments?
11. When you select the Notifications form to review approvals and click on
approve button for a Requisition waiting for approval, the 'Reject' box is
greyed out. How does the approver reject a requisition?
12. What are standard Quotations used for?
13. When do you see the status of a Purchase order as Archived?
14. Where are standard notes in GUI?
15. In Oracle Purchasing, where is the automatic numbering for Purchase Order
defined and maintained?
16. There is a field for the organization code. What is this code?
17. Can the original Purchase Order can be viewed in any way without resorting
to SQL, for a revised Purchase Order?

QUESTIONS & ANSWERS
——————-
1. In the Price type quickpick in the Purchase Order Lines zone in enter
Purchase Order form, there is a value called COST PLUS FEE. What is the
COST PLUS FEE price type? How is Purchase Order treating this
price type?
Answer
——
The functionality for COST PLUS FEE price type is not in Oracle Purchasing at
this point of time. PO does not do anything with this price type.
It is an enhancement request that is being looked at for future releases.
2. What is 2-way, 3-way, 4-way matching? How is this set-up?
Answer
——
2-way matching verifies that Purchase order and invoice information match within your tolerances as follows:
Quantity billed <= Quantity Ordered Invoice price <= Purchase order price (<= sign is used because of tolerances) 3-way matching verifies that the receipt and invoice information match with the quantity tolerances defined: Quantity billed <= Quantity received 4-way matching verifies that acceptance documents and invoice information match within the quantity tolerances defined: Quantity billed <= Quantity accepted. (Acceptance is done at the time of Inspecting goods). Whether a PO shipment has 2-way, 3-way or 4-way matching can be setup in the Shipment Details zone of the Enter PO form (character) Receipt required Inspection required Matching Yes Yes 4-way Yes No 3-way No No 2-way In GUI, Shipments block, alternative region, click on More…this brings up a region with 'Invoice matching' column where you can choose 2-way, 3-way or 4- way match. You can find more detailed information about matching in the Oracle Payables Reference Manual (Volume 3) Topical Essay on Integrating your Payables and Purchasing Information. 3. How do you reflect discount from a supplier on a Purchase orders? Answer —— The legal document is the Purchase order not the quote and therefore the purchase order should reflect agreed upon price. Secondly if the discount comes after the PO then AP should handle it when invoicing. If you are using a blanket Purchase order then you can use price breaks. 4. How do you change the created date on a Purchase Order? Answer —— The 'Created' date on the Purchase order is not an updateable field, due to it being a legal document once approved. 5. What is the sorting order for requisition lines in autocreation of a Purchase Order? Answer —— Requisition lines first meet search criteria determined by "find" screen, and then are grouped together by item and item category, then by need-by date. After you choose an action, enter any search criteria to narrow the selection of requisition lines. Oracle Purchasing chooses requisition lines from the requisition pool that meet your search criteria. All requisition lines for the same item and item category are grouped together, but they are not necessarily in order alphabetically. Within each grouping of item and item category, requisition lines are ordered by need-by date. 6. What does the error 'APP-50022: Oracle Human Resources could not retrieve a value for User Type profile option' mean? Answer —— The profile HR: User Type needs to be set. Set the profile option 'HR: User Type' at the Responsibility level. 7. In the Enter Receipts (RCVRCERC) form and using different responsibilities produces different values in the action required field. The Purchasing Responsibility shows Direct and Standard while the Inventory Responsibility shows just Direct. Why are the action options for creating receipts different in Inventory compared Purchasing? Answer —— Set the Profile option RCV: Allow routing override to 'YES' at the application level. 8. How do you purge Cancelled Requisitions? Answer —— To purge any Purchase orders or Requisitions: – assign the Payables Purge GUI responsibility to the user – have the user choose that responsibility – then choose Purge from the menu – under the Category field do a List of Values and pick Simple Requisitions for cancelled requisitions The choices are listed. 9. On the requisition form in the source details zone, there is a field labeled supplier item. Where does this information on the quickpick come from and how can this information default in? Answer —— The supplier item field on the requisition can be populated by using either the supplier item catalog or ASL. Take an item from the supplier item catalog that has an associated supplier item, add it to the order pad and then add it to the requisition. After doing this go to the source details zone. The supplier item is defaulted in for that item you choose from the catalog. Navigation: –> Purchasing –> Supplier Item catalog
10. You are entering a requisition and are unable to find the header or line
note fields. Was this replaced in GUI by attachments?
Answer
——
The attachments have replaced notes. The attachments are better because at the
header level, the requisition notes were not coming over to the Purchase Order
whereas the attachment does come over to the Purchase Order.
11. When you select the Notifications form to review approvals and click on
approve button for a Requisition waiting for approval, the 'Reject' box is
greyed out. How does the approver reject a requisition?
Answer
——
You cannot reject Requisitions submitted to yourself. You can only reject those
from others.
12. What are standard Quotations used for?
Answer
——
Standard quote is one that you can tie back to a PO. For example, navigate to
RFQ -> Auto create -> enter a PO and reference it back.
13. When do you see the status of a Purchase order as Archived?
Answer
——
You must approve or print a specific purchase order before you can see it in
the history information.
14. Where are standard notes in GUI?
Answer
——
Go to Setup –> Attachments –>Create attachment. Go to Purchase Order and
attach the attachment to the Purchase Order. In GUI, notes are replaced by
attachments.
15. In Oracle Purchasing, where is the automatic numbering for Purchase Order
defined and maintained?
Answer
——
The navigation path for GUI is:
Setup –> Organizations –> Purchasing Options, Numbering alternate region
The navigation path for Character is:
\ Navigate Setup Purchasing Options Purchasing, Numbering options
16. There is a field for the organization code. What is this code?
Answer
——
This code is a short abbreviation for the organization.
17. Can the original Purchase Order can be viewed in any way without resorting
to SQL, for a revised Purchase Order?
Answer
——
The original version of a revised PO cannot be viewed from the PO form or PO
summary form. Information on the original PO can be obtained from the
PO_HEADERS_ARCHIVE and PO_LINES_ARCHIVE tables using the PO_HEADER_ID column as
a common reference using SQL only.

--

Update The Item Average Cost From Transaction Open Interface

Update The Item Average Cost From Transaction Open Interface

INSERT
INTO mtl_transactions_interface
(
source_code ,
source_line_id ,
source_header_id ,
process_flag ,
transaction_mode ,
creation_date ,
last_update_date ,
created_by ,
last_updated_by ,
inventory_item_id ,
organization_id ,
transaction_date ,
transaction_quantity ,
transaction_uom ,
transaction_type_id ,
transaction_interface_id ,
material_overhead_account ,
material_account ,
resource_account ,
overhead_account ,
outside_processing_account,
cost_group_id
)
SELECT 'AvgCostUpdate' ,
1 ,
1 ,
1 ,
3 ,
SYSDATE ,
SYSDATE ,
1010026 ,
1010026 ,
1137465 ,
606 ,
sysdate ,
0 ,
'Ea' ,
80 ,
mtl_material_transactions_s.nextval ,
17347 ,
17347 ,
17347 ,
17347 ,
17347 ,
1327
FROM dual;

INSERT
INTO mtl_txn_cost_det_interface
(
cost_element_id ,
level_Type ,
Organization_id ,
new_average_cost ,
transaction_interface_id,
last_update_date ,
creation_date ,
last_updated_by ,
created_by
)
VALUES
(
1 ,
1 ,
606 ,
20 ,
16032545,
sysdate ,
sysdate ,
1010026 ,
1010026
);

COMMIT;

Next step, Please query and submit these transactions from:
Inventory -> Transactions -> Transaction Open Interface, submit by selecting Tools -> Resubmit All.

Note: Ensure that you have the transaction managers (Inventory -> Setup -> Interface Managers – Material Transaction Manager) up and running.

--

Interview Questions on Inventory,Purchasing

Interview Questions on Inventory,Purchasing

Questions:

1. What is an Organization & Location?
2. What are the KeyFlexFields in Oracle Inventory Module?
3. What are the Attributes of Item Category & System Items?
4. What are the KeyFlexFields in Oracle Purchasing & Oracle Payables?
5. What are the KeyFlexFields in Oracle HumanResources & Oracle Payroll?
6. How would you create an Employee (Module Name) Describe?
7. What is a Position Hierarchy? Is there any restriction to create that?
8. To whom we call as a Buyer? What are the Responsibilities?
9. How do you Setup an Employee as a User – Navigation?
10. How many Approval Groups we have? Describe?
11. Describe the Types of Requisition?
12. How many Status's and Types For RFQ's & Quotations Describe?
13. How many Types of Purchase Orders We Have?
14. What is a Receipt?
15. What is Catlog Rfq?
16. Give me online about Planned Po?
17. How can the manger view the Approval Documents Information?
18. Whether the manager can forward to Any other person? How?
19. Can u resend the document your subordinate how?
20. What is Po Summary?

Answers:

1. It is a Ware House Which you can Store the Items, And You can setup your business Organization Information Like Key Flexfilelds,Currency,Hr Information and starting time and end time. Location's are like godown place, office place, production point.

2. System items,Item Categories,Account Alias,Sales Order,Item Catalog,Stock Locators

3. The classification of items are Category Like Hard ware and Software, where as the Systems are individual items like Cpu,Key Board.

4. No Flexfields, But the help of Inventory And Human Resources we can use

5. Job Flexfield,Position Flexfield,Grade Flexfiled,Costing,People Group Flexfield,Personal Analysis Flexfield.

6. If Human Resource is Installed Hr/Payroll, If Not I can create Employee using with Gl,Ap,Purchasing,Fixed Assets

7. It is a Grouping of Persons for Approving and Forwarding the Documents from one person to another person, there is no restriction.

8. The Employee is nothing a Buyer, who is responsible for Purchase of Goods or services.

9. Security—-User—-Define, System Administration Module

10. Document Total,Accounts,Items,Item Categories,Location

11. Purchase Requistion,Internal Requistion

12. In Process,Print,Active,Closed for Rfq's In Process,Active,Closed for Quotation

13. Standard,Purchase Agreement,Blanket Po,Planned Po

14. To Register the Purchase orders/Po lines for shipment purpose

15. It contains Price breaks with different quantity levels

16. For a Agreement for long period for goods

17. Notifications Window

18. Yes, In the Notifications Window under the Forward to Push Button

19. Yes, In the Notifications Window under the Forward to Push Button

20. The Purchase Order Summay Information like total lines, and status.

--

Types of Natural Accounts in Accounting

Types of Natural Accounts in Accounting

There are 5 natures of account. Every account can have any one nature and that's why we can also call it natural account. These natures are:

Assets
Liabilities
Revenue
Expenses
Owner's Equity

ASSET: Literally asset is any thing which is valuable to a person, organization or any entity. For example we say that "his quick learning ability is an asset to him" or "Her writing ability is her asset". Why do we say that? Because quick learning skill or writing ability adds value to a person. A writer sells his writing skills to earn money, similarly in terms of business anything which is valuable to a business is the asset.
Say your organization is a pharmaceutical and manufactures Medicines, then all the chemicals used to manufacture medicine is your asset or in other words the Raw Material is your asset. The cash your organization own is an asset because it can be used to buy items or pay your employee who in turn are used to run your business. There are different types of assets, the broader categories of asset are Current Asset and Fixed, but let's not discuss it here. For now it is enough to know that asset is anything which is valuable to your organization.
Asset INCREASES when it is Debited and DECREASES when Credited.
Any organization which is registered with the government and exists as Legal Entity is obligated to disclose its Assets on the balance sheet to the government and its Creditors. You might ask Who are creditors and Why is it that an organization is obligated to disclose asset to them? With Creditor comes in the liability.
LIABILITY: Comes from the word "Liable". Literal meaning of Liable is "to be obligated" , "to be responsible" or "Legally responsible". In terms of accounting you become liable, responsible to pay when you buy or purchase any thing from another entity. You are liable to compensate whatever you've bought. Generally an organization records its liability and pays it afterward. Again, there are different types of liabilities like Short Term Liability and Long Term Liability.
Liability INCREASES when it is Credited and DECREASES when Debited.
OWNER'S EQUITY: This is the share of owner in the business.
Equity INCREASES when it is Credited and DECREASES when Debited.
REVENUE: By definition it is the total gain before inducting any expense. It is mostly associated with the Asset. When any organization sell goods or renders its services, it records an increase in Asset and with this increase comes the gain it has made from selling the goods or services. This gain is called Revenue or Income.
Revenue INCREASES when it is Credited and DECREASES when Debited.
Revenue are not displayed in Balance Sheet. They are reflected in Owner's Equity.
EXPENSE: By definition any payment made is an expense. How payments are made? Either by Cash or Credit which eventually means Cash. So redefining Expense "The outflow of cash to any person or organization for its supplied Goods or rendered Services". We incur expenses daily, for example, taxi fare is an expense, dine-out payments are expenses. Expenses are associated with Liability. Whenever an organization books a liability, it is mostly against some expense. There are different type of expense

Expense INCREASES when it is Debited and DECREASES when Credited.

Following table shows the Tabular form of the effect

Nature	DEBIT	CREDIT
Asset	Increase (+)	Decrease (-)
Liability	Decrease (-)	Increase (+)
Equity	Decrease (-)	Increase (+)
Revenue	Decrease (-)	Increase (+)
Expense	Increase (+)	Decrease (-)

Pricing information query R12

Pricing tables and links:

 pricing base tables and their links with other

 We have tested this query in R12.1.1 instance.


SELECT 
      qph.list_header_id
     ,qph.name
     ,qph.description
     ,qphh.start_date_active
     ,qphh.currency_code
     ,qphh.source_system_code
     ,qphh.active_flag
     ,qphh.orig_system_header_ref
     ,qphh.orig_org_id
     ,qphh.global_flag
     ,qpl.list_line_id
     ,qpl.start_date_active
     ,qpl.end_date_active
     ,qpl.arithmetic_operator
     ,qpl.operand
     ,qpl.orig_sys_line_ref
     ,qpp.pricing_attribute_id
     ,qpp.product_attribute_context
     ,qpp.product_attribute
     ,qpp.product_attr_value
     ,qpp.product_uom_code
     ,qpp.comparison_operator_code
     ,qpp.orig_sys_pricing_attr_ref
     ,mtl.inventory_item_id
     ,mtl.segment1
     ,mtlc.cross_reference_type
     ,mtlc.cross_reference
FROM  apps.qp_list_headers_b qphh 
     ,apps.qp_list_headers_tl qph 
     ,apps.qp_list_lines qpl 
     ,apps.qp_pricing_attributes qpp
     ,apps.mtl_system_items_b mtl
     ,apps.mtl_cross_references_b mtlc
WHERE qph.list_header_id    = qphh.list_header_id
AND   qph.list_header_id    = qpl.list_header_id
AND   qph.list_header_id    = qpp.list_header_id
AND   qpl.list_line_id      = qpp.list_line_id
AND   mtl.inventory_item_id = qpp.product_attr_value
AND   mtl.organization_id   = (SELECT UNIQUE master_organization_id
                               FROM   mtl_parameters)
AND   mtl.inventory_item_id = mtlc.inventory_item_id
AND   SYSDATE BETWEEN qpl.start_date_active  
                AND   NVL(qpl.end_date_active,SYSDATE)
AND   SYSDATE BETWEEN qphh.start_date_active 
                AND   NVL(qphh.end_date_active,SYSDATE)
AND   qph.name LIKE '%&priceListName%';

--