Vaibhav Alur

• Jul 5th, 2006

The Parent_invoice_id column of the ap_invoice_distributions_all will give you the main invoice# to which this CM/DM has been matched to.

Answer Question  Select Best Answer

skumar7777

 Profile Answers by skumar7777 Questions by skumar7777

• Nov 20th, 2005

Use Past Due Invoice Report.

Answer Question  Select Best Answer

geethika

• Nov 6th, 2005

accounting rules detrmine the period in which the revenues were genereated against the transactions. Rules that Receivables AutoInvoice uses to specify revenue recognition schedules for your tran...

Answer Question  Select Best Answer

Neeraja

• Apr 13th, 2006

Invoicing Rule determine when to recognise the receivable for transactions. There are 2 types invoicing rules:Bill in arrears and Bill in advance.Bill in Arrears recognise receivables at the end of the revenue recognistion schedule. Bill in advance recognise receivables as soon as invoice generated.

Answer Question  Select Best Answer

Prasad Patkar

• Apr 20th, 2006

It is a program that imports invoices,credit memos, debit memos, on account credits from other system to Receivables.

Answer Question  Select Best Answer

Suneel

• Aug 4th, 2006

Concurrent Program is nothing but an instance of execution file along with parameters and incompatable.

Answer Question  Select Best Answer

Sridhar

• Jul 27th, 2006

Order EnteredOrder BookedDispatch EligibleDispatchedPick Release EligiblePick ReleasedShip ConfirmInvoicedPosted in GL

Answer Question  Select Best Answer

Record group are used with LOVs to hold sql query for your list of values. The record group can contain static data as well it can access data from database tables thru sql queries.   

Suneel

• Aug 4th, 2006

Record Group is an object. It is a collection of records fetched based on SELECT statement. It is of three types:1. Static2. Query based 3. Non-query based

Answer Question  Select Best Answer

An autonomous transaction is an independent transaction started by another transaction, the main transaction. Autonomous transactions let you suspend the main transaction, do SQL operations, commit or roll back those operations, then resume the main transaction.Once started, an autonomous transaction is fully independent. It shares no locks, resources, or commit-dependencies with the main transaction....

Pawan Ahuja

• Aug 28th, 2006

Hi to all,autonomous transaction is transaction that is used for independentle commitedbasically it is used in triggers ,procedures,create or replace procedure ins_recpragma autonomous_transactionbegi...

Answer Question  Select Best Answer

Temporary tables are used in Interface programs to hold the intermediate data. The data is loaded into temporary tables first and then, after validating through the PL/SQL programs, the data is loaded into the interface tables.

Manisha

• Jun 11th, 2006

Interface Table are used to transfer data  automatically from legacy System to APPS(e.g. AP/GL).  Before running Standard Import program data should be stored in Interface Tables.

Answer Question  Select Best Answer

Key Flexfield: #unique identifier, storing key information# Used for entering and displaying key information.For example Oracle General uses a key Flexfield called Accounting Flexfield to uniquely identifies a general account.Descriptive Flexfield: # To Capture additional information. # to provide expansion space on your form With the help of [] . [] Represents descriptive Flexfield.

Krishna Adurthy

• Jan 3rd, 2006

Key Flex Field:KFF is  a Mandatory field which is already driving the functionality and it is the field where atleast first segment is made mandatory.KFF willbe filled in segmentsKFF Is mandatory...

Answer Question  Select Best Answer

API - Application Program Interface is a PL/SQL call made to the application to create business transactions or events. This is an alternative to using the interface tables in applications to insert and process transactions. You can find the APIs from the database by querying the all_objects table for name like '%_PUB'eg: AR_ADJUST_PUB in AR to create adjustments

Hitesh

• Mar 13th, 2006

In Addition to Following :In ALL_OBJECTS Query for OBJECT_TYPE = 'PACKAGE'%PUB Are Public API's, in Short wrapper Over %PKG APIs.

Answer Question  Select Best Answer

Manisha

• Jun 9th, 2006

For TDS Credit Memo Generation make sure that TDS Type, TDS %age and TAxable amount is entered.

Answer Question  Select Best Answer

Shanks

• Jun 21st, 2006

 Hi,  For the setup of Credit Cards, we have to initally set Credit Card Programs and Code Sets Window.  We are setting credit card programs for our enterprise's credit card and procure...

Answer Question  Select Best Answer

RAJENDER SINGH

• Aug 22nd, 2006

For any Organization or company which is dealt with Business of any kind and the same business process would be studied for mapping into Oracle 11i Software.Rajender singh, Hyderabad

Answer Question  Select Best Answer

how do you test the CRP in Implementation

Triggers are used in forms for event handling. You can write PL/SQL code in triggers to respond to a particular event occurred in your forms like when user presses a button or when he commits the form.The different type of triggers available in forms are :· Key-triggers· Navigational-triggers· Transaction-triggers· Message-triggers· Error-triggers· Query based-triggers