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

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

Ashok

• May 19th, 2006

Firstly we need to raise an Invoice...To raise an invoice we need to fill the basic information in the Invoice Fom.Invoice approval can be done hierarchially.This can be done by a Technical Consultant who sets responsibility for approvals only to certain persons.

chinnamba03

 Profile Answers by chinnamba03 Questions by chinnamba03

• May 1st, 2006

Hi..   For Approving an invoice in AP we have to raise one invoice for raising an invoice we have some mandatory fields like supplier, supplier number, Payment terms, distribution sets, date...

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

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

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

Jay

• Jul 5th, 2006

There are 8 templates in Oracle Reports.1.Tabular 2.Group Above 3.Group Left 4.Mailing Label 5.Matrix 6.Matrix with Group 7.Form Like 8.Form LetterCheers!!!!!!!

neeta_mahak

 Profile Answers by neeta_mahak Questions by neeta_mahak

• Apr 13th, 2006

How many templates use for oracle reports in oracl...

Answer Question  Select Best Answer

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

Indra

• Jul 14th, 2006

The necessary step we have to follow to implement Flexfield in forms:1. Create a table through which we are going to create the flex field.2.Registered the table.3.Registered the column of the ta...

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

Suneel

• Aug 4th, 2006

Flex field is collectoin of fields or segments. There are 2 types of Flex feilds.1) Discriptive Flex Feld:- We can extend the functionality of the form without changing the code.2) Key flex field:- It is also known as Intelligent code which stores valid code combinations.

rkanth

• Aug 15th, 2005

A flexfield is a placeholder set of fields that can be configured by customers for use by their organizations. Once configured, the customer-defined fields (label/widget pairs) may appear in either fo...

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

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

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

Item Setup FAQs Once an item is assigned to an organization, is it possible to remove this association at a later time? A. If you have assigned an item to an organization, it can only be deleted from that organization if the item has NOT been transacted. If it has been transacted against you cannot delete the item from the organization. See the Oracle Inventory User's Guide. You can, however,...

Somasundar

• Nov 9th, 2006

Customer merging is done to avoid the Customer DuplicationFor Ex: You can Create Same Customer: ABC Limited as 1) ABC Limited2) ABC LTDSo You can merge ABC LTD to ABC Limited and Maintain ABC Limited going forward

k.R.Selvaraj

• Jun 4th, 2006

Customer  merging is the process to avoide duplicate bill to and ship to addressesregardskr selvaraj

Answer Question  Select Best Answer