-
Where does the customer information is stored in Oracle Apps tables
When they ask where does the customer information is stored in tables should we say hz_parties or ra_cust
rajivgupta780184
- Aug 11th, 2008
You can enhance processing time by formatting the code in right order.
Use less of cursor if possible
Avoid using conditions and loops as much as possible etc...ThanksRajiv Gupta -
How to pass lexical paramater for example &where_clause from forms 10g to report 10g using web
rajivgupta780184
- Aug 11th, 2008
Lexical parameters are used to substitute multiple values at runtime. It can be used in FROM TABLE NAME and in WHERE clause. Usually the lexical parameters are defined in After Parameter Report or in ...
-
How can we call one report from another report in Oracle Apps Reports?
rajivgupta780184
- Aug 11th, 2008
By Using run_product('reportname')? in-built feature? you can call one report from another.
-
Show report output reocrds in Blue and Black color alternatively
In a report output, How to show reocrds in blue and black color alternatively.
rajivgupta780184
- Aug 11th, 2008
By using conditional formatting in Oracle reports. You can get conditional formatting in reports properties, try it out.
bye Rajiv Gupta -
Steps for loading data from excel file in cash management using data loader?
rajivgupta780184
- Aug 11th, 2008
Firstly, you have to arrange the excel file in same manner as was the table.i.e., first column data in excel file should be of first column in the table and also remember the data in Excelfile shoul...
-
Revaluation, Translation & Consolidation
What is the difference between Revaluation, Translation & Consolidation?
-
Register Table
How to register table in Oracle Apps?
astaputra
- Jul 7th, 2008
you have to use AD_DD package for registering your tables and columns.Here is the codeAD_DD.register_table(p_appl_short_name => ,p_tab_name => ,p_tab_type => )AD_DD.register_column(p_appl_sho...
-
O2C Cycle Process
What is O2C Cycle? Explain the process.
patitapan
- Jul 4th, 2008
O2C REFFERS TO "Order To Remittance".This means for any sale or distribution done in the Order Management, Oracle Receivables is responsible for the remittance of amount sold.So the total process of r...
-
Fresh Instance in Implementation
How to start the implementation in fresh instance. Outline the steps briefly.
-
-
Single org and Multiple org
How to start implementation in Single organization and Multiple organization?
-
What is the difference between D2K Reports and Oracle Apps Reports?
raman av
- Jun 12th, 2008
Differences between D2k Report and Apps Report(1) in D2k Report there is no fecility to schedule the program where as in Apps report we have that fecility(2) in D2k Report we can't use User-Exits ...
AMIT SONI
- Aug 15th, 2007
D2K reports and Oracle Reports basically have no difference the main difference between them is only that simple D2k report run in any environment and we always use Tables if we want to run a repo...
-
Display "No Records Found" In Report Output
In a report output, How to display "no records found", if no records have been retrieved?
Rampraas
- Jun 8th, 2008
Dear anishajain,Define a Summary Column in Data Model with source of any driving column. Add a boilerplate text with "NO Records Found".Defin code in Format trigger for the same as followsfu...
-
What are the standard programs for Oracle GL,AP,PO modules open interfaces?
-
Hi to all, iam very new to oracle apps.when did order closes on header level in order management module?
mallikarjunekmn
- May 16th, 2008
Hi,As per my Knowledge as per ERP ProcessSteps:1. Purchase Order will be in Fresh Status when it is created.2. It will be in Approved Status after it is approved by Purchase Dep Head or correspon...
AYAN BASU
- Sep 29th, 2006
Please consider two situtions:1. An order with a single line2. An order with a multiple lineIn a single line order , when the entire quantity is fullfilled i.e shipped and AR interface being run the l...
-
What is a template?What is a token?
kader_bathusha
- May 14th, 2008
Template is predefine , future purpose like expenses template,or quick codes ,Token is unique no every user entering orcle gateway used owen token same thing any problam or issuse share probalm ...
knarender
- Jun 27th, 2007
Template.fmb is a predefined standard form ,which is having 21 libraries to support oracle application structureToken is a field in the parameter window of a concurrent program which is used to map concurrent program parameter with the report builder bindvariable.
-
-
What is R2R Cycle in Apps?
vsn0208
- May 6th, 2008
R2R stands for Record 2 Report i.e. Record Jounal entries in the General Ledger and Report to the Financial Managers using reporting tools such as hyperion. Below modules come under R2R cycle1) Genera...
-
What is FlexField?
Oracle Application uses Flexfield to capture information about Your organization. Flexfield have flexible structure for storing key information. Like Company, Cost Center, and Account. They also give u highly adaptable Structure for storing customized information in oracle Applications.
shrikantgarud
- Apr 25th, 2008
Simple way to descriptive flexfield are the flexible data fields designed and customised according to business needs. Types1. kff- key flexfeilds 2. dff- descriptive flex fieldsThe basic steps in de...
Dawson
- Apr 20th, 2007
KFF - DFFWrong. Please follow GL Module document. in OTN
-
How to run a report in a multi org environment for all orgs at one stroke Typically, to run for a single org, in the before report trigger, user_exit FND GETPROFILE is used. What if the report at a single run has to generate data for all offices.
vipulgosai
- Apr 25th, 2008
Hi,Use Base table instead of multi-org table. Mean to say...use AP_INVOICEs_All instead of AP_INVOICE(view) as AP_INVOICE is multi-org view and it fetch rows based on org_id.
PREM
- Oct 30th, 2006
IN THE CONCURRENT PROGRAMM FORM OR WINDOW U HAVE "COPY TO' OPTION AT THE BOTTOM LEFT. CLICK THAT OPTION AND THE SAME REPORT CAN ATTACH TO OTHER ORGANIZATIONS REPEAT IT FOR MULTI ORGANIZATIONS.
Oracle Apps Technical Interview Questions
Ans