What were the documents you have prepared during implementation project?
What are the major difference between 11i and R12?

VIVEK RAO

• Nov 18th, 2015

11i 1) Consist of 3C 2) No concept of MOAC. 3) Major table changes like po_vendors. 4) Banks are created in Account Payables. 5) Ap_Invoices_lines_all table in finance is not there. R12 1) Consist of...

Surendra

• Nov 20th, 2014

So many changes are there in tables.

Mainly In multi org architecture
in 11i set of books, 3cs (Currency,Calender,Chart of accounts)
now in R12 Set of books call it as a ledger 4cs(Currency,Calender,Chart of accounts,subledger accounting).

Answer Question  Select Best Answer

What are the manadatory parameters in Oracle Apps Reports?

ANsar Aluva

• Oct 20th, 2015

There is no fixed mandatory parameter for Oracle reports. Instead it based on how the reports develops. Normally the "Region, Location" can be mandatory.

Naresh Bandla

• Jun 24th, 2015

There is no mandatory parameters in reports. If you are using User Exits in your report then only we have to pass P_CONC_REQUEST_ID parameter.

Answer Question  Select Best Answer

hat is diagnostics in apps? How do you enable/disable it?How do you run diagnostics for a particular module to send it to Oracle support?

Dhanaraju

• Oct 14th, 2015

How are the opportunities for Oracle Apps Tech?

Neha

• Aug 29th, 2015

Application Diagnostics Responsibility --> Diagnose --> select application --> setup General --> execute

Answer Question  Select Best Answer

What is the purpose of ON-POPULATE-DETAILS ON-CHECK-DELETE-MASTER? What happens when delete ON-POPULATE-DETAILS ON-CHECK-DELETE-MASTER?

veerendra reddy

• Aug 24th, 2015

On_check_delete_master,on_populate_details are used to check the records whether details are exit or not
when we create the non isolated automatically this two triggers are created and one more trigger is created i.e on_clear_details trigger

Answer Question  Select Best Answer

How many forms/reports have you designed/customised.

md nasim akhter

• Aug 19th, 2015

Two forms and 50 reports

Answer Question  Select Best Answer

There is parent frame and for that parent frame there is child frame, suppose child field is placed in parent frame what message you will get.

Debasmita Sur Dam

• Jul 17th, 2015

REP-1213: Field XXX references column YYY at a frequency below its group. Actually the repeating frame frequency is equal to your group frequency. So the field of parent repeating frame is placed in c...

venu

• Jun 27th, 2014

Frequency below group/abouve group

Answer Question  Select Best Answer

Why we used compulsory executable in report registration ?
what is the main purpose of executable?

Debasmita Sur Dam

• Jul 16th, 2015

The purpose of executable is to links the execution file with concurrent program and the method used to execute it. Actually the name and application (Application name determine in which directory str...

Answer Question  Select Best Answer

sonal

• Jul 11th, 2015

Whenever you submit a purchase order or requisition for approval or take an action in the Notifications Summary window, Purchasing uses Oracle Workflow technology in the background to handle the appro...

Sonal

• Jul 11th, 2015

Approval hierarchies let you automatically route documents for approval. There are two kinds of approval hierarchies in Purchasing: position hierarchy and employee/supervisor relationships

Answer Question  Select Best Answer

When we enter a Blanket Release data where it will be stored?

Sonal

• Jul 11th, 2015

Po_releases_all

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

User Exits are Which makes User to Exit on going environment to perform certain actions. There are Five types of User Exits ---------------------------------------------- 1. SRW.USER_EXIT(FND SRW...

chandu

• Jun 4th, 2015

These are not user exits
user exits are
FND SRWINIT
FND SRWEXIT
FND FORMAT_CURRENCY
FND FLEXSQL
FND FLEXID VAL
these are profile values

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

In R122 we use to store supplier/customers data in different tables, where as In R12 Oracle has introduced TCA(Trading Community Architecture) which will bring both Supplier/Customer data under one umbrella(TCA).

All the data stored in HZ tables in R12.

Sridhar

• May 9th, 2013

HZ_ stands for human Zone

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

Yes , We can develop reports without using "User Exit" , in this scenario no need define P_CONC_REQUEST_ID also.

arun kumar somayajula

• May 22nd, 2015

Yes, We can develop without using user exits, but our report shouldnt have p_conc_request_id

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

You can define max of 100 parameters to a concurrent program.

pavan

• Apr 7th, 2015

100 parameters

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

Token field is used to map the concurrent program parameter to report parameters .

Poorna Nannapaneni

• Jan 28th, 2015

Token is an Interface between Concurrent Program and Report builder. This will map the concurrent program parameter values to the report builder parameters.It is case sensitive.

And it is enabled for Oracle Reports only.

Answer Question  Select Best Answer

What are the manadatory user exits in Oracle Apps Reports?

Naresh Bandla

• Jun 24th, 2015

There are no mandatory User Exits , If business is asking for User Exits then we need to use
SRWINIT and SRWEXIT.

CHALAM

• Jan 29th, 2013

Srwinit and srwexit

Answer Question  Select Best Answer

Naresh Bandla

• Jun 24th, 2015

We will set the org by using "MO_GLOBAL.SET_POLICY_CONTEXT(S,101)" in reports in R12.

kvijay5924

 Profile Answers by kvijay5924 Questions by kvijay5924

• Mar 6th, 2012

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

Answer Question  Select Best Answer

varun kumar

• Jun 19th, 2015

1) Org-ID comes under Operating UNIT level,
Organization_id comes under Inventory Level.
2) Base table for Org_id is hr_operating_units,
Base table for Organization_id is Mtl_perameters.
3) Org_id involves in PO,OM,AP,AR....,
Organization_id involves in INV, BOM, WIP..

sivareddy

• Mar 15th, 2015

Org_id contains the -all ex:-po_headers_all and organization doesnt contains -all :--mtl_system_items_b

Answer Question  Select Best Answer

Dinesh

• Feb 27th, 2015

PRE-LOGON

anil

• Sep 10th, 2014

Pre trigger

Answer Question  Select Best Answer

What are the types of Fast Formulas available in HRMS Payroll and their details?

Vinoth

• Feb 19th, 2015

Types of Fast Formula frequently used for payroll
1.Oracle Payroll
2. Element input validation
3. Element Skip
4.Payroll run pr-oration

Answer Question  Select Best Answer

How to activate, deactivate and run concurrent managers?

Bharat Bhatia

 Profile Answers by Bharat Bhatia Questions by Bharat Bhatia

• Jan 4th, 2015

Concurrent managers are components of Concurrent Processing that monitor and run time-consuming, non-interactive tasks without tying up your terminal. Whenever you or your users submit a request to ru...

sushma_anil

 Profile Answers by sushma_anil Questions by sushma_anil

• Apr 28th, 2009

CONCSUB is used to execute both seeded and customized concurrent programs. CONCSUB is a utility that allows you to submit concurrent program to the concurrent Manager from operation unit level. ...

Answer Question  Select Best Answer