Oracle Apps Technical Interview Questions

There are no mandatory parameters . All parameters are optional including p_conc_request_id.

The mandatory parameter in apps reports is P_CONC_REQUEST_ID                       &n...

There are no mandatory exits. Without using User Exit, we can run the report in Apps.

user exists are to pass profile values likeorg_id in multi_org view.it is not mandatory to pass

org_id is belongs to operating unit level.It will be available on modules like PO, AP, AR,...... organization_id belongs to inventory level.It will be available on modules like INVENTORY,BOM,WIP

org_id available at operating unit level,
it is specific for the operating unit.
organization_id available at inventory level

"sql SELECT COUNT(*) FROM PO_HEADERS_ALL --OUTPUT =10835 SELECT COUNT(*) FROM PO_HEADERS --OUTPUT = 0 "sql DECLARE V_ORG_ID NUMBER :=FND_PROFILE....

begin

Fnd_client_info.set_org_context();

 End;

Using Group BY and Having clause

We can use rownum

Your answer is absolutely wrong, because the only way to register our own table into apps is AD_DD package, that to from back end only we must register, from front end we don't have a permission to do so.

Flexfields and Oracle Alert are the only features or products that require the custom tables to be registered in Oracle Applications (Application Object Library) before they can be used. Custom applic...

In 11i
BEGIN
FND_CLIENT_INFO.SET_ORG_CONTEXT(204);
END;

Earlier in 11i, it was dbms_application_info.set_client_info(). But in R12, it is MO_GLOBAL.SET_POLICY_CONTEXT(S,101); --where S-For Single organization

Think child frame could be repeating frame. If so it show no message.

Uncheck purchasing

Inventory is nothing but, it is an organisation where we do material transaction.

In R12 Set Of Books(SOB) means combination of

1)Chart of Accounts

2)currency

3)calender

4) Sub Ledger Account(SLA).

The above 4 conditions used to change the SOBs

SOB are the legal entities, are used to define the profiles for a responsibility.
For defining the SOB, you need 4 conditions.

1. Chart of Accounts
2. Calendar
3. Currency
4. Retained Earnings (Mandatory)

credit memo:The negative transaction is created by supplier

There are 11 types of invoices in AP..
1. Standard
2. Prepayment
3. Debit Memo
4. Credit Memo
5. With Holding Tax
6. Expense Report
7. Mixed Invoice
8. Interest
9. PO default
10.Quick Match
11. Recurring Invoice

you need to define independent values set for country and dependent for states on the independent values set(which you created for country).

Hi Kiran,
You need to define independent Value set for Country and dependent for States, on the independent value set(Which you created for Country). That will solve your issue.
Hope it is clear.
Regards,
Amit

based on your requirement like from data and for this take bind parameter while registering in concurrent program in parameter form give range low and high....

based on your requirement...like from_date and to_date for this take bind parameters... while registering in concurrent program...in parameter form...give range low and high....

There are total 6 Types of Journals 1. Functional Journals, Where functional currency will be used. 2.Foreign Currency journals, where Foreign currency will be used. 3.Reversal Journals, this will be...

Seketon, formula and Standard JE are types of Recurring JE.
The JE types are only five:
1. Basic JE
2. Importing from other subledgers
3. Recurring
4.Reversal
5. Mass Allocation

Oracle Apps process of item conversion and interface tables. Interface tables involved in Item Conversion: MTL_SYSTEM_ITEMS_INTERFACE Base Tables: MTL_SYSTEM_ITEMS MTL_PARAMETERS MTL_UNITS_O...

BASE TABLE: MTL_SYTEM_ITEMS_B INTERFACE TABLE: MTL_SYSTEM_ITEMS_INTERFACE ERROR_TABLE :MTL_INTERFACE_ERRORS VALIDATIONS: ORGANIZATION IS VALID OR NOT MA...

p2p PROCURE TO PAY CYCLE

Hi Soumya, P2P(Procure to pay Cycle): 1. Requisition 2. RFQ(Request for Quotation) 3. Quotation 4. PO(Purchase Order) 5. Receiving 6. Invoicing 7. Validation of Invoice 8. Accounting of Invoice 9. Pay...

Steps done in project creation 1.create project i.e. copy from existing projects. go to projects and you can create here , for key members and remaining things you can see the project which you are c...

"oracle8 ---- Junaid Usman (JBS) DECLARE l_request_id NUMBER(30); begin FND_GLOBAL.APPS_INITIALIZE(user_id => 7938, resp_id => 52342, ...

If you want to run a concurrent request in application through PL/SQL code, then you can used an inbuilt funtion in Apps.

Fnd_request.submit_Request

Insert the customer details viz., name, country, ship to address, bill to address etc into ra_customer_interface_all table. Then run the customer interface program to import the customers.

Hi,

Take the error code which you have encountered in the interface table and check it in AR document where u can find the list of customer error codes and their description.

You can act on the error code accordingly.

Thanks

Ganga

Hi,

While receiving if Invoice received is different than PO price, Standard Purchase price variance (PPV) report can be used to report the difference.

Optionally you can revise PO (it will create a new revision for PO) and get approvals before receiving it.

Thanks,
Jigisha