Ra_interface_lines_all Error Table
Contents |
of the four interface tables Receivables uses to temporarily store transaction data from your original system. Each column has important, detailed information you need to know to successfully ar invoice tables in oracle apps r12 run AutoInvoice. AutoInvoice uses the fifth table, RA_INTERFACE_ERRORS_ALL, to store information
Insert Into Ra_interface_lines_all
about interface data that failed validation. Interface Tables RA_INTERFACE_LINES_ALL RA_INTERFACE_SALESCREDITS_ALL RA_INTERFACE_DISTRIBUTIONS_ALL AR_INTERFACE_CONTS_ALL RA_INTERFACE_ERRORS_ALL Table Name: RA_INTERFACE_LINES_ALL This ra_customer_trx_all table description table stores transaction header and line information. AutoInvoice uses Transaction Flexfields to uniquely identify each transaction that you import into Receivables. AutoInvoice always uses the Line Transaction Flexfield
Ra_interface_lines_all Sample Code
structure for both the Link-to and Reference information when importing invoices. For more information, see: Transaction Flexfields, Oracle Receivables User Guide. Important: The following columns of the AutoInvoice interface table RA_INTERFACE_LINES_ALL have become obsolete in R12: CUSTOMER_BANK_ACCOUNT_ID CUSTOMER_BANK_ACCOUNT_NAME PAYMENT_SERVER_ORDER_NUM APPROVAL_CODE Instead of these fields, Autoinvoice requires you to populate the PAYMENT_TRXN_EXTENSION_ID. You can obtain this by calling ap invoice interface tables in oracle apps r12 the IBY_FNDCPT_TRXN_PUB.Create_Transaction_Extension before populating the Autoinvoice tables.
ACCOUNTING_RULE_DURATION Enter the accounting rule duration for this transaction. If LINE_TYPE = 'LINE' or you are passing header freight, and this transaction uses a variable duration accounting rule, you must enter a value in this column. If LINE_TYPE = 'TAX' ', 'CHARGES' or you are passing freight for a specific line, do not enter a value in this column. For credit memos and on-account credits, do not enter a value in this column. Variable Description Validation: Accounting periods must be defined for the duration of the accounting rule in GL_PERIODS and RA_INTERFACE_LINES_ALL.GL_DATE and RA_INTERFACE_LINES_ALL.RULE_START_DATE must be in a period that has a status of 'Open' or 'Future'. The value in this column must be a positive integer. Destination: RA_CUSTOMER_TRX_LINES_ALL.ACCOUNTING_RULE_DURATION ACCOUNTING_RULE_ID Enter the accounting rule ID for this transaction. If LINE_TYPE = 'LINE' or you are passing header freight, this column is optional. For invoice lines with rules, you must enter either a value in this column or in ACCOUNTING_RULEare :------------------------ra_interface_lines_allra_interface_distributions_allra_interface_errors_allConcurrent Program to import data from autoinvoice import program interface tables :-------------------------------------------------------------Autoinvoice Import ProgramScript to Migrate data from Staging table to Interface Table------------------------------------------------------------------------CREATE OR REPLACE https://docs.oracle.com/cd/E18727_01/doc.121/e13512/T447348T383863.htm PROCEDURE xxx_ar_invoice_api (errbuf out varchar2, rectcode out varchar2)ASl_org_id hr_operating_units.organization_id%type;l_sob_id hr_operating_units.set_of_books_id%type;l_cust_trx_type_id ra_cust_trx_types_all.cust_trx_type_id%type;l_gl_id_rev ra_cust_trx_types_all.gl_id_rev%type;l_cust_trx_type_name ra_cust_trx_types_all.name%type;l_currency_code fnd_currencies.currency_code%type;l_term_id ra_terms_tl.term_id%type;l_term_name ra_terms_tl.name%type;l_address_id hz_cust_acct_sites_all.cust_acct_site_id%type;l_customer_id hz_cust_accounts.cust_account_id%type;l_verify_flag char(1);l_error_message varchar2(2500);BEGINBEGINSELECT organization_id, SET_OF_BOOKS_IDINTO l_org_id, l_sob_idFROM hr_operating_unitsWHERE name = 'xxx Operating Unit';EXCEPTIONWHEN OTHERS THENl_verify_flag http://oracleappss.blogspot.com/2008/07/ar-invoice-interface.html := 'N';l_error_message := 'Invalide Operating Unit...';END;BEGINSELECT cust_trx_type_id,name,gl_id_revINTO l_cust_trx_type_id,l_cust_trx_type_name, l_gl_id_revFROM ra_cust_trx_types_allWHERE set_of_books_id = l_sob_idAND org_id = l_org_idAND name = 'xxx-Spares-Inv';EXCEPTIONWHEN OTHERS THENl_verify_flag := 'N';l_error_message := 'Invalide Invoice Type...';END;BEGINselect currency_codeinto l_currency_codefrom fnd_currencieswhere currency_code = 'INR';EXCEPTIONWHEN OTHERS THENl_verify_flag := 'N';l_error_message := 'Invalide Currency Code...';END;BEGINSELECT term_id,nameinto l_term_id,l_term_nameFROM ra_terms_tlWHERE upper(name) = upper('IMMEDIATE');EXCEPTIONWHEN OTHERS THENl_verify_flag := 'N';l_error_message := 'Invalide Terms Name...';END;BEGINSELECT DISTINCT HCAS.cust_acct_site_id,HCA.cust_account_idINTO l_address_id,l_customer_idFROM hz_parties HP,hz_party_sites HPS,hz_cust_accounts HCA,hz_cust_acct_sites_all HCAS,hz_cust_site_uses_all HCSUWHERE HCA.party_id = HP.party_idAND HP.party_id = HPS.party_idAND HCA.cust_account_id = HCAS.cust_account_idAND HCAS.cust_acct_site_id = HCSU.cust_acct_site_idAND HCSU.site_use_code = 'BILL_TO'AND HCSU.primary_flag = 'Y'AND upper (ltrim (rtrim (HP.party_name))) = upper (ltrim (rtrim ('Customer Name')))AND HCAs.o
Receivables General Ledger Oracle Inventory Oracle Projects Script Oracle Technologies ADF SQL-PL/SQL Discoverer Forms Reports OA Framework https://imdjkoch.wordpress.com/tag/ra_interface_lines_all/ SQL*Loader Xml Publisher Oracle Workflow My World About Me My Photography Life Short Story Technology Random Post Travel Posts Comments AR Invoice Interface April 11, 2011 Leave a comment AR Invoice Interface The main three steps for AR Invoice Interface are: 1] Put the data into your staging tables. 2] Calls your in oracle package to validate the data and load into AR Interface tables (RA_INTERFACE_LINES_ALL & RA_INTERFACE_DISTRIBUTIONS_ALL). 3] Then submits a concurrent request for AutoInvoice. If any errors occur it can be found in ra_interface_errors_all table. The concurrent program has 2 stages. First the Master program fires which intern kicks of the Import Program. in oracle apps Once this is completed data is inserted into the following tables. 1) ra_customer_trx_all (Invoice Header Info) 2) ra_customer_trx_lines_all (Invoice Line Level Info) 3) ra_cust_trx_line_gl_dist_all (Accounting Info. One record for each Account Type is inserted into this… ex. Receivable Revenue Tax Freight etc) 4) ar_payment_schedules_all (All Payment related info) Validations: Validation are generally done on the below columns. Batch_source_name Set_of_books_id Orig_sys_batch_name orig_system_bill_customer_ref orig_system_bill_address_ref Line_Type Currency_Code Term_name Transaction_type Interface_line_attribute1-7 Account_class Accounting Flexfields segments 1- AR Transaction Type Validation: Check if the Transaction type provided in data file is defined in AR transaction types (RA_CUST_TRX_TYPES_ALL) 2- Transaction Batch Source Validation: Check if the source provided in data file is defined in AR transaction Batch source (RA_BATCH_SOURCES_ALL). 3- Invoice Currency Validation: Check if the currency provided in data file is defined in AR Currency (FND_CURRENCIES). 4- Customer Validation: Check if the Bill to Customer Number, Ship to Customer Number, Bill to Custom Location, Ship to