-
-
Legal Entity
Define Legal Entity
ash0917
- Aug 30th, 2009
The Legal Entity represents a legal company for which the user prepares tax reports. Tax identifiers and other relevant information are assigned to this entity.
-
I have question about patch application. Assume that we are applying a major rollup patch and after considerable time it hangs on few workers. When contacted oracle suggests applying a pre requisite patch as a solution. what should i do
Please advise
naeemq
- Oct 29th, 2009
Oracle Support should provide you a complete plan of action in case of a patch failure. If they do not provide you complete plan of action ask for it.In case of a patch failure, different patches need different steps to be taken. There is no universal plan of action after a patch has failed.
Devesh Gupta
- Jun 7th, 2006
If you have wasted your time in main patch near about 8 to 10hrs.,then you should take backup of FND_INSTALL_PROCESSES,AD_DEFFERED_JOBS and baclup of restart files which extension is .bk9,rf9 nd...
-
Item Master Organization
What is Item Master Organization in Oracle Inventory? What is its use?
jphanireddy
- Nov 20th, 2009
This is not Mandatory but recommanded by Oracle. Master Org is used only for Item defination. And later it can be assign to other Organization (Child Organization). You can restrict item attributes at master level or Chlid Organization Level.
madaninterview
- May 15th, 2008
To create any item we use item master organization responsibility madan
-
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
-
Can you add a descriptive FlexField to a table which already have data in it ?
-
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
-
-
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
-
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.
-
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.
-
Evaluated Receipt Settlement - ERS
Explain Automation of Accounts Payable activities (Evaluated Receipt Settlement)
-
-
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
-
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.
-
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).
-
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...
-
Call Two Concurrent Programs
How to call two concurrent programs from backend by using fnd_request.submit_request API with time base?
-
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.
-
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...
Oracle Apps Technical Interview Questions
Ans