selvaspak

 Profile Answers by selvaspak Questions by 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

 Profile Answers by amit_exl Questions by amit_exl

• Sep 12th, 2008

Common values passed by procedures in variable (ERRBUFF and RETCODE) are:ERRBUFF := SQLERRM;andRETCODE := ERRCODE;Thanks & RegardsAmit Gupta

Answer Question  Select Best Answer

selvaspak

 Profile Answers by selvaspak Questions by selvaspak

• Dec 28th, 2010

In this FMB only all the Standard Libraries are available for APPS like Menu key.

paresh123

 Profile Answers by paresh123 Questions by paresh123

• Mar 7th, 2010

under $AU_TOP/resource/US

Answer Question  Select Best Answer

Once we receive the material what is the entry ... in AP? whether system ll automatically cleared.. or ll we create manually

selvaspak

 Profile Answers by selvaspak Questions by 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

 Profile Answers by amit_exl Questions by amit_exl

• Sep 12th, 2008

1. Invoice:AP Accrual A/C      To Liability2. Invoice Payment:Liability to Cash ClearingThanks & RegardsAmit Gupta

Answer Question  Select Best Answer

selvaspak

 Profile Answers by selvaspak Questions by 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...

Answer Question  Select Best Answer

What is ERS? Use of this Function?

durga.polina

 Profile Answers by durga.polina Questions by 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.

fighter83

 Profile Answers by fighter83 Questions by fighter83

• Feb 27th, 2008

ERS is used in ap not in GL

Answer Question  Select Best Answer

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

 Profile Answers by mejigs Questions by 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

Answer Question  Select Best Answer

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

 Profile Answers by gangadharchandaluri Questions by 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

Answer Question  Select Best Answer

What is PA Module? What are its main use & What are its Steps & Navigations?

Rajasekhar Reddy Adam

• Aug 1st, 2011

Oracle Projects is suite of modules which combines Project Costing Project Billing Project Foundation Project Management Project Resource Management and Project Portfolio Management Oracle ...

Answer Question  Select Best Answer

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

 Profile Answers by Adi_phaniK Questions by 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

Answer Question  Select Best Answer

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.

sridutta

 Profile Answers by sridutta Questions by sridutta

• Dec 8th, 2008

Use select distinct column name from table instead of table name

Answer Question  Select Best Answer

What is the journal entry for Reversal?

Shweta P

• Aug 17th, 2011

Journal entry used to reverse accruals, estimates, errors or temporary adjustments. You can reverse the journal by assigning reversal period or reversal effective date to a journal entry which you...

Answer Question  Select Best Answer

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...

Pullareddy Mukkamalla

• Aug 17th, 2011

Use the value set FND_STANDARD_DATE and in the user parameters defined in the report use the following as input mask against the date field.

RRRR/MM/DD HH24:MI:SS

Answer Question  Select Best Answer

Sunil Kaswan

• Aug 20th, 2011

Steps done in project creation 1.create project i.e. copy from existing projects. go to projects and you can create here , for key members and remaining things you can see the project which you are c...

Answer Question  Select Best Answer

How to join the tables in PO modules?

CP

• Sep 2nd, 2011

Following should work for standard POs "sql SELECT * FROM po_headers_all pha ,po_lines_all pla ,po_line_locations_all plla ,po_distributions_all pda WHER...

Answer Question  Select Best Answer

prashant

• Sep 21st, 2011

P2p PROCURE TO PAY CYCLE

Amit

• Sep 13th, 2011

Hi Soumya, P2P(Procure to pay Cycle): 1. Requisition 2. RFQ(Request for Quotation) 3. Quotation 4. PO(Purchase Order) 5. Receiving 6. Invoicing 7. Validation of Invoice 8. Accounting of Invoice 9. Pay...

Answer Question  Select Best Answer

Hi! Any one can you send me the details and process of item conversion?1.What are the interface tables in item conversion?2.What are the base tables in item conversion?3.what are the validations and what is the standard program in item conv.?

sree

• Oct 1st, 2011

Oracle Apps process of item conversion and interface tables. Interface tables involved in Item Conversion: MTL_SYSTEM_ITEMS_INTERFACE Base Tables: MTL_SYSTEM_ITEMS MTL_PARAMETERS MTL_UNITS_O...

Madhu

• Jul 21st, 2011

BASE TABLE: MTL_SYTEM_ITEMS_B INTERFACE TABLE: MTL_SYSTEM_ITEMS_INTERFACE ERROR_TABLE :MTL_INTERFACE_ERRORS VALIDATIONS: ORGANIZATION IS VALID OR NOT MA...

Answer Question  Select Best Answer

Krishna

• Oct 21st, 2011

There are total 6 Types of Journals 1. Functional Journals, Where functional currency will be used. 2.Foreign Currency journals, where Foreign currency will be used. 3.Reversal Journals, this will be...

Pallavi

• Jul 21st, 2007

Seketon, formula and Standard JE are types of Recurring JE. The JE types are only five:1. Basic JE2. Importing from other subledgers3. Recurring4.Reversal5. Mass Allocation

Answer Question  Select Best Answer

How to define parameters from and to range in oracle apps reports and also at where condition from and to range of numbers

waseem

• Oct 21st, 2011

Based on your requirement like from data and for this take bind parameter while registering in concurrent program in parameter form give range low and high....

whenkat

• Sep 24th, 2011

Based on your requirement...like from_date and to_date for this take bind parameters... while registering in concurrent program...in parameter form...give range low and high....

Answer Question  Select Best Answer

waseem

• Oct 21st, 2011

You need to define independent values set for country and dependent for states on the independent values set(which you created for country).

Amit

• Sep 13th, 2011

Hi Kiran,
You need to define independent Value set for Country and dependent for States, on the independent value set(Which you created for Country). That will solve your issue.
Hope it is clear.
Regards,
Amit

Answer Question  Select Best Answer

How to create India localization setups?

raju

• Dec 3rd, 2011

Hi,

Please share R12 Indian locailzation setup and Procedural documetns to me.

Regards
Raju

raghu.nandana

 Profile Answers by raghu.nandana Questions by raghu.nandana

• Oct 4th, 2008

For this there is a diff module called India localization in that there are separate setup is the based on the tax, local area its depend for ex. in standard when you create an organization in India l...

Answer Question  Select Best Answer