-
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
-
Concurrent program
How many Parameters can pass to Concurrent Program
-
Inventory
How to restrict the item in INV?
-
Once we receive the material what is the entry in Oracle Apps AP
Once we receive the material what is the entry ... in AP? whether system ll automatically cleared.. or ll we create manually
selvaspak
- Dec 28th, 2010
After we received the material through Receipt(Goods Received Notes) then we have to run the "Pay On Receipt AutoInvoice" Concurrent program. for this one child progr...
amit_exl
- Sep 12th, 2008
1. Invoice:AP Accrual A/C To Liability2. Invoice Payment:Liability to Cash ClearingThanks & RegardsAmit Gupta
-
second parameter should depend on first parameter
when i am running my report in apps i have to pass two parameters second parameter should be depend on first parameter. and in first parameter it consist two list of valuesex:1. approve 2. in process when i pass approve in first parameter then second parameter should be enable and when i pass in process second parameter should be disabled. How this can be possible . i would appreciate if u people suggest...
Manivasagam
- Jul 9th, 2014
:$FLEX$.Value_ Set_Name
selvaspak
- Dec 28th, 2010
In this senario we unable to disable the parameter for that what you can do like this In the 2nd parameter value set you have to hardcore in the where caluse like &...
-
What will happen if we dont get template.fmb when developing a form?
selvaspak
- Dec 28th, 2010
We unable to compile the form as well as we unable to retrive the standard functionality of APPS like menu.
rakhi
- Oct 17th, 2007
This form is the starting point of all development involving forms. It contains some special libraries and triggers that render the application using the template form some standard characteristics.H...
-
What are the common values passed by a procedure in varialbles ERRBUF, RETCODE?
selvaspak
- Dec 28th, 2010
ERRBUFF is used for display the error in the log file andRETCODE is used to decide the status of the concurrentthere are 3 types of RETCODE they are:-# 0 : Success# 1 : Warning# 2 : Error
amit_exl
- Sep 12th, 2008
Common values passed by procedures in variable (ERRBUFF and RETCODE) are:ERRBUFF := SQLERRM;andRETCODE := ERRCODE;Thanks & RegardsAmit Gupta
-
What are the Interface and API table for Receipts Conversion In Oracle receivables .
reachratna
- Jan 24th, 2008
AR_PAYMENTS_INTERFACE_ALLAR_INTERIM_CASH_RECEIPTS_ALL and AR_INTERIM_CASH_RCPT_LINES_ALLAR_CASH_RECEIPTS_ALLAR_CASH_RECEIPT_HISTORY_ALLAR_DISTRIBUTIONS_ALLAR_RECEIVABLE_APPLICATIONS_ALLAR_PAYMENT_SCHEDULES_ALL
-
how many types of triggers used in d2k report What r they?
sateeshkonthala
- Nov 21st, 2011
There are eight report triggers. Of these there are five global triggers called the Report Triggers. They are fired in the following order : * Before Parameter Form * After Parameter Form * Before R...
selvaspak
- Dec 31st, 2010
Total 5 Types of Trigger1. Before Parameter Trigger2. After parameter Trigger3. Before Report Trigger4. Between Pages Trigger5. After Report Triggerthe Action are given below1. Before Parameter T...
-
-
What is the difference between procedure and function and package, which is the fastest
JILEY SINGH
- Aug 4th, 2013
Function can be called in select statement but procedure cant be called in select statement. function has return keyword but procedure not
Varun Tiwari
- Jul 4th, 2013
Function Procedure 1. Can be used as column Cant used in select statement in select statement 2. Can be used in where Cant used in where condition c...
-
What can we find TEMPLATE.FMB file ?
-
