-
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.
-
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...
-
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...
-
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...
-
-
How many types of sales orders are there in order management. What are they?
Richa Aggarwal
- Aug 18th, 2010
There are various types of sales orders in order management which are as follows:-1. Standard Order2. Book and Bill 3. Expense Order4. Demonstration order5. CEU orders, i.e., Customer Evaluation order...
haveluck
- Dec 1st, 2007
3 Types of Sales Order are Available. They are:1.Standard Sales Order2.Mixed Sales Order3.Return Sales OrderIn Standard Sales Order we have1.Back to Back2.Drop ShipmentInternal Sales Order are raised within an Organization
-
How purchase ordered entered in Oracle11i AP Module.
How purchase ordered entered in Oracle11i AP Module.what is the entry system will create for that..
jaalioracle
- Sep 11th, 2010
AT the time of creation of invoice PO matching takes place. If matching is approved then payment is made to supplier.
-
Set Org ID
How to set Org ID?
abhi4apps
- Dec 3rd, 2010
By using fnd_clinet_info.set_org_contextbeginfnd_client_info.set_org_context(org_id)end
-
RFQ Tables
What are RFQ tables? What is the relation between RFQ and Requisition, RFQ and Quotation?
Srinu_d83
- Aug 27th, 2009
Flow of PO module:Requisition |RFQ |Quotation |Purchase orderRequisitionIt is prepared by emp wheneve emp needs the goodsIn this we have 2 typesInternal: within orgExternal: from out...
Oracle Apps Technical Interview Questions
Ans