Designing
Payables Interface
Designing a Payables interface is a very important task of
any Oracle Applications Payables Implementation. Hence it is always required to
create a payables Interface.
Payables Interface has significantly changed from 11i to
R12.
Even though the R12 has Three levels of details on a
payables Invoice which are
Invoice Header
Invoice Line
Invoice
Distribution.
The Payables Interface Still continue to have two level of
details, which are
Invoice Header
Invoice Line.
Below is a Insert script which can be
leveraged for Inserting records in Payables Interface Header Table.
AP_INVOICES_INTERFACE
Payables
Invoice Header Interface Insert
INSERT
INTO
apps.ap_invoices_interface
(
invoice_id,
invoice_type_lookup_code,
invoice_date,
invoice_num,
vendor_id,
vendor_site_id,
invoice_amount,
source,
org_id,
INVOICE_CURRENCY_CODE,
EXCHANGE_RATE_TYPE,
--TERMS_NAME,
DESCRIPTION,
GLOBAL_ATTRIBUTE18,
GLOBAL_ATTRIBUTE19,
GLOBAL_ATTRIBUTE20,
--GROUP_ID,
--PAY_GROUP_LOOKUP_CODE,
GL_DATE
)
VALUES
(
AP.AP_INVOICES_INTERFACE_S.NEXTVAL
,'STANDARD'
,SYSDATE --<invoice date>
,'KTICAP081801'
,24699
--<vendor_id validated against po_vendors.vendor_id>,
,35433
--<vendor_site_id validated against
po_vendor_sites.vendor_site_id>,
,111
--<invoice_amount>
,<SOURCE>
,<ORG_ID>
,'USD'
,'Corporate'
,'KTEST for ICO'
,'Services In Country'
,'01-AUG-2014'
,'18-AUG-2014'
,trunc(Sysdate)
);
Below is a Insert script which can be
leveraged for Inserting records in Payables Interface Header Table. AP_INVOICE_LINES_INTERFACE
Payables
Invoice Lines Interface Insert
INSERT
INTO
APPS.ap_invoice_lines_interface
(
invoice_id
,invoice_line_id
,line_number
,line_type_lookup_code
,amount
,accounting_date
,DESCRIPTION
--,PO_HEADER_ID
--,PO_DISTRIBUTION_ID
--,SHIP_TO_LOCATION_CODE
,DIST_CODE_COMBINATION_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE15
--
,GLOBAL_ATTRIBUTE_CATEGORY
,GLOBAL_ATTRIBUTE18
,GLOBAL_ATTRIBUTE19
,GLOBAL_ATTRIBUTE20
--,PROJECT_ID
--,TASK_ID
--,EXPENDITURE_TYPE
--,EXPENDITURE_ITEM_DATE
--,EXPENDITURE_ORGANIZATION_ID
,ORG_ID
,CONTROL_AMOUNT
,TAX_CLASSIFICATION_CODE
)
VALUES
(
AP.AP_INVOICES_INTERFACE_S.CURRVAL
,AP.AP_INVOICE_LINES_INTERFACE_S.NEXTVAL
,1
,'ITEM'
--<ITEM>/<FREIGHT>/<TAX>
,100
,SYSDATE
,'KT ICO INVOICE DIST DESCRIPTION'
,'2906440' --'<Derive from Code
Combination>'
,<ATTRIBUTE CONTEXT>
,'12-AUG-2014'
,'BIL'
,'987654321'
--,'JE.IL.APXINWKB.GOOD_SERVICES'
,'Services In Country'
,'01-AUG-2014'
,'18-AUG-2014'
,<ORG_ID>
,'11'
,<TAX
CODE>
);
