Total Pageviews

February 8, 2015

2/08/2015 09:24:00 AM


Auto Invoice Master Data Migration:
                          
PRE-REQUISTIES :
1. P_INTERFACE_LINE_CONTEXT + P_INTERFACE_LINE_ATTRIBUTE1 ==> PRIMARY KEY
   FINANCIALS -> FLEXFIELD -> DESCRIPTIVE
   ORACLE RECEIVABLES - LINE TRANSACTION FLEXFIELD
   ADD
   INTERFACE_LINE_CONTEXT
   'Migrated Data' --> Next Screen - Sequence Number - INTERFACE_LINE_ATTRIBUTE1 - 15 Digit
2. AR Setup->Invoice->Transaction Batch (Type - Import)
3. AR Setup->Invoice->Transaction Type

Std Concurrent Program (OPEN INTERFACE):
---------------------------------------------------------
  i) Auto Invoice Master Import Program
    g_itm_trnsfr_dm_trx_type         VARCHAR2(60) := 'TESTTEM TRF DM';
    g_itm_trnsfr_cm_trx_type         VARCHAR2(60) := 'TEST ITEM TRF CM'; 
    g_itm_trnsfr_dm_batch_src        VARCHAR2(60) := 'TEST AUTO SYS';
    g_itm_trnsfr_rect_method         VARCHAR2(60) := 'TEST GlobalAR';

Interface Tables:                       Base Tables:
-----------------                       ------------
i) RA_INTERFACE_LINES_ALL                I) RA_CUSTOMER_TRX_ALL
ii) RA_INTERFACE_DISTRIBUTIONS_ALL       ii) RA_CUSTOMER_TRX_LINES_ALL
iii) RA_INTERFACE_SALESCREDITS_ALL       iii) RA_CUST_TRX_LINE_SALESREPS_ALL
iv) RA_INTERFACE_ERRORS_ALL              iv) RA_CUST_TRX_LINE_GL_DIST_ALL
                                         v) RA_BATCHES_ALL
                                         vi) AR_RECEIVABLE_APPLICATIONS_ALL
                                         vii) AR_PAYMENT_SCHEDULES_ALL
                                         viii) AR_ADJUSTMENTS_ALL
Tables Used:
-----------
RA_CUST_TRX_TYPES
RA_BATCH_SOURCES
AR_RECEIPT_METHODS
Transaction Type:
The transaction type that you assign to a transaction indicates the type of application that is permitted for that transaction: natural application only, or over application
Natural Application: refers to the type of application, either positive or negative, that a transaction requires to become closer to zero. For example, invoices have a positive balance, so to reduce the balance due you need to create a negative application (such as apply a receipt).
Overapplication: indicates whether you can over apply transactions using this type. For example, if you apply a $500 receipt to a $400 invoice, you over apply the invoice and reverse its sign (from positive to negative).
Validations:
i) Generating INTERFACE_LINE_ID From Ra_Customer_Trx_Lines_S Sequence.
ii) Getting Cust_Trx_Type_Id From RA_CUST_TRX_TYPES_ALL.
iii) If CUST_TRX_TYPE_NAME = 'Credit Memo' THEN AMOUNT should be AMOUNT * -1
iv) Getting SalesRep_Id from RA_SALESREPS_ALL table.
v) Getting Customer_Id & Customer_Address_id from RA_CUSTOMERS, RA_ADDRESSES_ALL tables.
vi) Getting Term Id from RA_TERMS table.
vii) Getting Inventory Item Id and Unit of Measurement Code from MTL_SYSTEM_ITEMS_B table.
viii) LINE_TYPE := 'LINE'; and BATCH_SOURCE_NAME := ‘Legacy’;
1) Can changes be made to existing Invoices via Auto Invoice Import Program OR How To Update An Already Created Invoice Through Auto invoice Import Program?
  • Updating An Existing Invoice In Receivables Through Auto Invoice Program Is Not Available.
  • The Auto invoice Program Is Used To Create New Invoices In AR.AutoInvoice process is used to import invoices, credit memos, debit memos, and on-account credits, AR ensure that the data imported is accurate and valid.
Unlike Other Interface Programs, Say Customer Interface Program, Which You Can Use Either To Create New Customers Or Update Existing Customers, The Auto invoice Program Cannot Be Used To Update An Existing Invoice Details

NOT NULL COLUMNS Data:(RA_INTERFACE_LINES_ALL)
----------------------------------------------
(
INTERFACE_LINE_ID,
TRX_DATE,
CURRENCY_CODE,
CONVERSION_TYPE,
CONVERSION_RATE,
BATCH_SOURCE_NAME,               
CUST_TRX_TYPE_NAME,          
CUST_TRX_TYPE_ID,            
ORIG_SYSTEM_BILL_CUSTOMER_ID,
ORIG_SYSTEM_BILL_ADDRESS_ID, 
TERM_NAME,                  
TERM_ID,                      
DESCRIPTION,                
AMOUNT,                     
CREATED_BY,                  
CREATION_DATE,               
LAST_UPDATED_BY,             
LAST_UPDATE_DATE,            
LAST_UPDATE_LOGIN,              
ORG_ID,                
SET_OF_BOOKS_ID,          
LINE_TYPE,                   
PRIMARY_SALESREP_ID,      
GL_DATE,                     
INVENTORY_ITEM_ID,           
UOM_CODE
)

NOT NULL COLUMNS Data:( RA_INTERFACE_DISTRIBUTIONS_ALL)
------------------------------------------------------
(ACCOUNT_CLASS,
AMOUNT,
SEGMENT1,
SEGMENT2,
SEGMENT3,
SEGMENT4,
SEGMENT5,
INTERFACE_LINE_CONTEXT,
INTERFACE_LINE_ATTRIBUTE1,
PERCENT)



 
Related Posts Plugin for WordPress, Blogger...