-
-
Table Value Set
How to create a table value set which allows only numbers and upper case letters(A-Z)?
-
-
WHO Column
What is WHO column and how to insert a value in it?
neomukesh
- Jun 26th, 2010
WHO columns are maintained to know who updates the particular rows ans when.last_update_date, last_updated_by, creation_date, created_by, last_update_login are 5 WHO columns. following information sho...
-
Complete Auto invoice interface information?
nilanjanthacker
- Jun 21st, 2010
The two interface tables needed to be populated for running the auto invoices areRA_INTERFACE_LINES_ALL and RA_INTERFACE_DISTRIBUTIONS_ALLLater, the auto invoices will hit the following tables RA_CUST...
gsrikanthvarma
- Jun 4th, 2008
this is the standard program through which the data from interface table RA_interface_lines_all will be pulled into oracle receivables on making the validations on various feilds.batch source will pla...
-
Request Set
What is the Request Set?
alapatisureshbabu
- May 9th, 2010
To run the number of concurrent programs sequentially or parallely we use request set,in the request set window mention the concurrent programs that you want to execute.
-
Call Two Concurrent Programs
How to call two concurrent programs from backend by using fnd_request.submit_request API with time base?
-
Where do you use parametrized cursor in oracle apps? Explain with real-time example?
aksesa
- Apr 5th, 2010
Normally when we want to process the bulk records that time we use the parameterized cursor.Eg: If we want to extract certain PO details every day for DATA WAREHOUSE extract then we have to use the parameterized Cursor. In cursor parameter we can pass status of PO, Extract Date etc.
trraka
- Jan 23rd, 2008
Parametrized Cursors are frequently used when picking the data from master -detail tables .(Generally in interfaces) Or the same table with header as well as line informationcursor c1 is select a...
-
How do you configure the system to send notifications to the userid instead of email
aksesa
- Apr 5th, 2010
We can use ROLE in Workflow which will send the notification to user_id (email address present for that user id).
-
What is the difference between parameter passing by reference and passing by value
aksesa
- Apr 5th, 2010
In parameter in stored procedure is passing by refrence. OUT parameter is passing by value. If we want to use pass OUT parameter as passing by value then we can use NOCOPY for OUT parameter which will be used as passing by reference.
Senthil
- Aug 6th, 2007
IN parameter and IN OUT Parameter are the parameters can be passed by reference or Valur whereas OUT parameters are passed by value.
-
What is API? How we use it?
aksesa
- Apr 1st, 2010
API are application program interface. API are provided by Oracle in PLSQL code. Whenever you want to either load or update data in base tables like PO_HEADERS_ALL or FND_PROFILE_OPTIONS bulk records ...
sudheer12d
- Jan 18th, 2007
Hi API - Application Program Interface It is an inbuilt PL/SQL coding which explains the particular functionality which interfaces legacy to Apps.We use it by running the concurrent program; executable as one of the concerned API.Cheers Sudheer
-
-
Evaluated Receipt Settlement - ERS
Explain Automation of Accounts Payable activities (Evaluated Receipt Settlement)
-
Why we register a table in apps schema?
Why we register a table in apps schema by using ad_dd.register_table procedure
jith_in
- Feb 25th, 2010
We register the table using ad_dd for the sole purpose of using the same in flexfields and alerts.
VijayAkumalla
- Nov 18th, 2008
We register a custom table in the custom schema. Then give all permissions to APPS schema. Reason being, when stored procedures or functions are written to perform DMLs on the custom table, it is done from APPS schema.
-
If any conflict occurs in FSG the who will override Column Set or Row Set ?
agouthaman
- Feb 19th, 2010
FSG (Financial Statement Generator) is a tool for reporting on account balance by period. Accounting flexfield, accounting periods and type of balance these are the details which make the rowset and column set. Column set overrides rowset.
Divya
- Sep 26th, 2005
Column set provided while defining Columns you should have checked the "Override Row Calculations" checkbox.
-
What are different period types ?
agouthaman
- Feb 19th, 2010
Standard GL period types are Month, Quarter and Year. But User defined periods can also be used.
vmbv
- Nov 30th, 2005
Then come to Oracle Apps.It is best for u
-
-
ONT and PO
What is the table column link between ONT and PO?
selvaspak
- Jan 12th, 2010
In the ONT table OE_ORDER_HEADERS_ALL.ORIG_SYS_DOCUMENT_REF is matched with the Requisition Table PO_REQUISITION_HEADERS_ALL.SEGMENT1 for Internal Requisition Type only(STOCK Transfer)Regards,SSG
-
Can you add a descriptive FlexField to a table which already have data in it ?
-
Picking Rules
Explain the basic of Picking Rule.
pnarapuram
- Nov 20th, 2009
Picking rules tells which items have to be picked first from the inventories/sub inventory for shipping.Thanks and RegardsPradeep Narapuram
Oracle Apps Technical Interview Questions
Ans