-
-
Oracle Apps Error REP-0613 : Value Does Not Match
Hi,while running reports in oracle applications ,i also Defined a Value Set With parameters. Moreover i have defined The Correct Mask for the date field in the properties of report & i got the following errors:APPLLCSP Environment Variable set to:Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are:American_America.UTF8'.,'ERR REP-0613 : Value Does Not Match Mask 'DD-MON-RR'ORA-018161...
-
-
Distinct Value in Value Set
How to get distinct value for any column in value set.E.g Table is emp, to Type value set for job then in lov it has to display distinct job.
Bhaskar Bethi
- Aug 12th, 2011
select PERIOD_YEAR
from gl_periods
where rowid in (select max(rowid) from gl_periods group by
PERIOD_YEAR )
order by PERIOD_YEAR
Follow the same with required table.
-
How to submit concurrent program through pl/sql?
Junaid Usman
- Aug 4th, 2011
"oracle8 ---- Junaid Usman (JBS) DECLARE l_request_id NUMBER(30); begin FND_GLOBAL.APPS_INITIALIZE(user_id => 7938, resp_id => 52342, ...
Adi_phaniK
- Oct 2nd, 2009
If you want to run a concurrent request in application through PL/SQL code, then you can used an inbuilt funtion in Apps. Fnd_request.submit_Request
-
Project Accounting Module
What is PA Module? What are its main use & What are its Steps & Navigations?
-
How to handle errors in Customer interface ?
Mr.KUK
- Jul 13th, 2011
Insert the customer details viz., name, country, ship to address, bill to address etc into ra_customer_interface_all table. Then run the customer interface program to import the customers.
gangadharchandaluri
- Jun 16th, 2006
Hi,Take the error code which you have encountered in the interface table and check it in AR document where u can find the list of customer error codes and their description.You can act on the error code accordingly.ThanksGanga
-
Open Return Orders conversion from 11i to Oracle R12
whether any one worked on sales order conversion and i want to know the process to do this and i am having some concerns in data mapping...Please assist on this...Regards,ravindra.
-
Open Return Sales Order conversion from 11i to R12
I am going to work on open return sales order conversion with line category is "Awaiting Return" and first time i am doing this conversions...Could you please any one tell me the process and if you guys having any sample codes,please mail me to raviapps84@gmail.com...Thanks in AdvanceRavi
-
Receiving items with less then PO price
After we raise a PO and the po is approved and we do receiving but at the time of receiving if the price of the item is less then the PO price do we update the price in receipt and can anyone give the steps.
mejigs
- Apr 5th, 2011
Hi,While receiving if Invoice received is different than PO price, Standard Purchase price variance (PPV) report can be used to report the difference. Optionally you can revise PO (it will create a new revision for PO) and get approvals before receiving it.Thanks,Jigisha
-
GL - ERS Function
What is ERS? Use of this Function?
durga.polina
- Mar 23rd, 2011
ERS Belongs to AP Module.Pay on Receipt also known as ERS(Evaluated Receipt Settlement) or Self-Billing, is an Oracle Purchasing Concurrent Program, which automatically creates invoices in Payables and matches them with purchase orders for the received amount.
-
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...
-
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
-
What can we find TEMPLATE.FMB file ?
-
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
-
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...
-
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
-
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.
-
-
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
Oracle Apps Technical Interview Questions
Ans