interface
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
interface
can anyone help me out ????
what are the standard APIs and interfaces in finanacials
what are the standard APIs and interfaces in finanacials
Hi,
we have the following API's
1. Payables open Interface Consists of two tables, ap_invoices_interfaces and ap_invoice_lines_interface.
2. AR has Six Major API
a) Inbound Billing Transactions
b)Inbound Customer Records
c)Inbound Bank Receipts
d)Outbound update to the GL
e)Inbound Sales Tax Rates
f)Tax Vendor Extension
Ex. ra_customer_interface, ra_customer_banks_interface, ar_tax_interface, ar_payments_interface for importing bank receipts which uses the Auto Lcokbox API's etc
3. FA -
FA_MASS_ADDITIONS helps to work the mass additions posting program to work properly, we need not give any values to this Interface.
fa_Budeget_interface
and the INV interface
INV interface is the used to transfer the Physical Inventory data that are collected.
4. Cash Management - the bank statement open interface helps to enter the bank statement file to the cash management.
there is one more open interface for Forecasting in cash management. Ths interface collects these externally generated cash flow amounts and includes them in the cash forecasts.
ce_statement_headers_int_all, ce_statement_lines_interface
5.Purchasing Open Interface allows u to load and validate electronic catalogs and supply agreements.
Requisitions Open Interface
Purchasing Documents Open Interface
Receiving Open Interface
Purchase Order Change APIs
Cancel PO API
Custom Pricing API
There are many more interfaces in the Inventory and Order Management Modules
we have the following API's
1. Payables open Interface Consists of two tables, ap_invoices_interfaces and ap_invoice_lines_interface.
2. AR has Six Major API
a) Inbound Billing Transactions
b)Inbound Customer Records
c)Inbound Bank Receipts
d)Outbound update to the GL
e)Inbound Sales Tax Rates
f)Tax Vendor Extension
Ex. ra_customer_interface, ra_customer_banks_interface, ar_tax_interface, ar_payments_interface for importing bank receipts which uses the Auto Lcokbox API's etc
3. FA -
FA_MASS_ADDITIONS helps to work the mass additions posting program to work properly, we need not give any values to this Interface.
fa_Budeget_interface
and the INV interface
INV interface is the used to transfer the Physical Inventory data that are collected.
4. Cash Management - the bank statement open interface helps to enter the bank statement file to the cash management.
there is one more open interface for Forecasting in cash management. Ths interface collects these externally generated cash flow amounts and includes them in the cash forecasts.
ce_statement_headers_int_all, ce_statement_lines_interface
5.Purchasing Open Interface allows u to load and validate electronic catalogs and supply agreements.
Requisitions Open Interface
Purchasing Documents Open Interface
Receiving Open Interface
Purchase Order Change APIs
Cancel PO API
Custom Pricing API
There are many more interfaces in the Inventory and Order Management Modules
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
-
- Posts: 12
- Joined: Wed Feb 28, 2007 12:40 pm
- Location: India
Hi,
ok let me say about the Payables Open Interface Import.
The Paybles Open Interface helps to load large numbers of invoices into Oracle Payables from an external systems/ other systems.
To import invoices through the open interface, you must populate the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables.
Once the import process is complete, the data from the interface tables will be in the AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL tables.
To Enter an invoice through the invoice workbench there are some required fields you must enter, therefore it is logical that these required fields are in the interface tables that must be populated in order for the import to complete successfully.
The minimum amount of data that is required for the
<font color="blue"><b>AP_INVOICES_INTERFACE</b></font id="blue"> table is:
1. invoice_id
2. invoice_num
3. invoice_amount
4. source
5. supplier information
Invoice_Id is the primary key for AP_INVOICES_INTERFACE table which is generated if the invoice is created in the applications and will not be
imported into the AP_INVOICES_ALL table.
The invoice_num must be unique for the particular
supplier site associated with the invoice.
like wise you have to get all the source and supplier informations like (Sup. Name, Number, Site, site ID and PO number if any from PO)
After Loading the data thru the Payables Open Interface Import program, Once all invoices are imported, submit the Payables
Open Interface Purge, which will delete all the records from the interface tables.
ok let me say about the Payables Open Interface Import.
The Paybles Open Interface helps to load large numbers of invoices into Oracle Payables from an external systems/ other systems.
To import invoices through the open interface, you must populate the AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE tables.
Once the import process is complete, the data from the interface tables will be in the AP_INVOICES_ALL and AP_INVOICE_DISTRIBUTIONS_ALL tables.
To Enter an invoice through the invoice workbench there are some required fields you must enter, therefore it is logical that these required fields are in the interface tables that must be populated in order for the import to complete successfully.
The minimum amount of data that is required for the
<font color="blue"><b>AP_INVOICES_INTERFACE</b></font id="blue"> table is:
1. invoice_id
2. invoice_num
3. invoice_amount
4. source
5. supplier information
Invoice_Id is the primary key for AP_INVOICES_INTERFACE table which is generated if the invoice is created in the applications and will not be
imported into the AP_INVOICES_ALL table.
The invoice_num must be unique for the particular
supplier site associated with the invoice.
like wise you have to get all the source and supplier informations like (Sup. Name, Number, Site, site ID and PO number if any from PO)
After Loading the data thru the Payables Open Interface Import program, Once all invoices are imported, submit the Payables
Open Interface Purge, which will delete all the records from the interface tables.
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Who is online
Users browsing this forum: Google [Bot] and 25 guests