Designing
Accounts Receivables Interface
Designing a Receivables interface is a very important task
of any Oracle Applications Receivables Implementation. Hence it is always
required to create a Receivables Interface.
In Oracle Application R12 the Receivables Invoice Interface has
two level of details, which are
AR Invoice transaction
Lines
Transaction
lines can be used for populating the Majority of details in the AR invoice
interfaces. And hence this is the most important table to insert the data in.
AR invoice
Transaction Distribution
Though the Distributions are used for deriving the accounting
of an AR transaction, and this can directly be done using the AR Auto
accounting rules, data can be inserted in this table for Recevables and Revenue
Accounting if Accounting required on lines is more complex than Auto Accounting
rules and cannot be managed there.
Below is a Insert script which can be
leveraged for Inserting records in AR Invoice transaction Lines
RA_INTERFACE_LINES_ALL
AR Invoice transaction
Lines Interface Insert
INSERT INTO
Apps.ra_interface_lines_all
(
INTERFACE_LINE_ID,
INTERFACE_LINE_CONTEXT,
--INTERFACE_LINE_ATTRIBUTE1,
--INTERFACE_LINE_ATTRIBUTE2,
INTERFACE_LINE_ATTRIBUTE3,
BATCH_SOURCE_NAME,
SET_OF_BOOKS_ID,
LINE_TYPE,
DESCRIPTION,
CURRENCY_CODE,
AMOUNT,
CUST_TRX_TYPE_NAME,
CUST_TRX_TYPE_ID,
--TERM_NAME,
TERM_ID,
ORIG_SYSTEM_BILL_CUSTOMER_ID,
ORIG_SYSTEM_BILL_ADDRESS_ID,
CONVERSION_TYPE,
CONVERSION_DATE,
CONVERSION_RATE,
TRX_DATE,
TRX_NUMBER,
--
LINE_NUMBER,
UOM_CODE,
UOM_NAME,
ORG_ID
)
VALUES
(
AR.RA_CUSTOMER_TRX_LINES_S.NEXTVAL,
<INTERFACE
ATTRIBUTE CONTEXT 9IF ANY),
'GL|98765432|8',
<AR
INVOICE SOURCE>,
1002,
'LINE',
'KTEST FOR
NBL IC AR INV 090208- with DIST',
'USD',
111,
<AR
TRANSSACTION TYPE>,
11920,
--NA
4,
<CUSTOMER
ID>,
<CUTOMER
SITE ID>,
'User',
TRUNC(SYSDATE),
1,
TRUNC(SYSDATE),
<AR
INVOICE NUMBER>,
--NA
'EA',
'EA',
<ORG_ID>
);
Below is a Insert script which can be
leveraged for Inserting records in AR Invoice transaction Distribution
RA_INTERFACE_DISTRIBUTIONS_ALL
AR Invoice transaction
Distribution Interface Insert
INSERT INTO
Apps.RA_INTERFACE_DISTRIBUTIONS_ALL
(
INTERFACE_DISTRIBUTION_ID,
INTERFACE_LINE_ID,
INTERFACE_LINE_CONTEXT,
INTERFACE_LINE_ATTRIBUTE3,
ACCOUNT_CLASS
,AMOUNT
,PERCENT
,CODE_COMBINATION_ID
,SEGMENT1
,SEGMENT2
,SEGMENT3
,SEGMENT4
,SEGMENT5
,SEGMENT6
,SEGMENT7
,ORG_ID
)
VALUES
(
AR.RA_CUST_TRX_LINE_GL_DIST_S.NEXTVAL,
AR.RA_CUSTOMER_TRX_LINES_S.CURRVAL,
<ATTRIBUTE
CONTEXT if required>,
'GL|98765432|8',
'REV' (DEFINE THE
DISTRIBUTION TYPE “REV” FOR Revenue and “REC” for receivables)
,111
,100
,20798 <code
combination id derived on the basis of Code> this is over written if you
pop[ulate the actual segment values.>
,'<SEGMENT1>'
, <SEGMENT2>
, <SEGMENT3>
, <SEGMENT4>
, <SEGMENT5>
, <SEGMENT6>
, <SEGMENT7>
,ORG_ID
);
