Customer Transaction Interface

                                         AR Customer Transaction Interface:

INSERT INTO ra_interface_lines_all
                    (INTERFACE_LINE_ID " must if not error occured in main program",interface_line_context,
                     interface_line_attribute1,
                     batch_source_name "RA_BATCH_SOURCES_ALL"
                     , set_of_books_id,
                     description, taxable_flag,
                     amount_includes_tax_flag, line_type,
                     currency_code, amount,
                     cust_trx_type_name, term_name,
                     orig_system_bill_customer_id "pARTY_ID",
                     orig_system_bill_address_id "HZ_CUST_ACCT_SITES_ALL.ORIG_SYSTEM_REFERENCE.user_org_id.user_present_using_responsibility",
                     orig_system_bill_customer_ref,
                     orig_system_bill_address_ref,
                     conversion_type, conversion_rate,
                     trx_date, gl_date "MUST_BE_OPEN", trx_number,
                     quantity, unit_selling_price,
                     created_by, creation_date,
                     last_updated_by, last_update_date,
                     last_update_login, org_id,CUST_TRX_TYPE_ID) VALUES
                     (54454544,'CONVERSION',RA_CUST_TRX_LINE_SALESREPS_S.NEXTVAL,'LEGACY',
                     1,'Ar_Defense_Cust1',NULL,'N','LINE','USD',100,'Invoice','IMMEDIATE',
                     1146,4041,NULL,NULL,'User',1,SYSDATE,'25-MAR-2017',NULL,3,
                     200,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,SYSDATE,FND_GLOBAL.LOGIN_ID,204,1)




---------------------------------------------------------------------------------------------------------------------------

         SELECT RECEIPT_METHOD_ID FROM RA_interface_lines_all where INTERFACE_LINE_ID=1296256  
         
        
     
          SELECT * FROM RA_interface_lines_all where INTERFACE_LINE_ID=54454544 
          
          WHERE --INTERFACE_LINE_ATTRIBUTE1='700538'
           batch_source_name='LEGACY' ORDER BY CREATION_DATE DESC
                     
                     
                     SELECT FND_GLOBAL.LOGIN_ID FROM DUAL
                     
                     SELECT FND_PROFILE.VALUE('USER_ID') FROM DUAL
                     
                     SELECT * FROM RA_INTERFACE_ERRORS
          
                     SELECT * FROM DBA_SEQUENCES WHERE SEQUENCE_NAME LIKE 'RA_%'
                     
                     SELECT * FROM RA_BATCH_SOURCES_ALL WHERE NAME LIKE 'CONVERSION'
                     
                     SELECT * FROM GL_LEDGERS WHERE NAME LIKE 'Visi%Op%'
                     
                     SELECT * FROM HZ_PARTIES WHERE PARTY_NAME LIKE 'Department of Defense%'
                     
                     SELECT * FROM HZ_CUST_ACCT_SITES_ALL WHERE CUST_ACCOUNT_ID=1146 and org_id=204
                     
                     SELECT * FROM HZ_CUST_ACCOUNTS WHERE CUST_ACCOUNT_ID=1146
                     
                     SELECT * FROM RA_CUST_TRX_TYPES_ALL-- where CUST_TRX_TYPE_ID=1923
                     
                     SELECT * FROM HZ_LOCATIONS --WHERE LOCATION_ID=4403
                     
                     SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE BILL_TO_CUSTOMER_ID=1146 AND TRX_NUMBER='11064'
                     
                     SELECT * FROM RA_TERMS WHERE NAME LIKE '2/10, Net 30%'
                     
                     SELECT CUST_TRX_TYPE_ID FROM RA_INTERFACE_LINES_ALL
                     

                     SELECT * FROM AR_RECEIPT_METHODS WHERE NAME LIKE 'Automatic Receipts%'  --  1363

--------------------------------------------------------------------------------------------------------

Single Insertion Script :


SET DEFINE OFF;
Insert into AR.RA_INTERFACE_LINES_ALL
   (INTERFACE_LINE_ID, INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2, INTERFACE_LINE_ATTRIBUTE3, INTERFACE_LINE_ATTRIBUTE4, INTERFACE_LINE_ATTRIBUTE5, INTERFACE_LINE_ATTRIBUTE6, INTERFACE_LINE_ATTRIBUTE7, INTERFACE_LINE_ATTRIBUTE8, 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_BATCH_NAME, ORIG_SYSTEM_BILL_CUSTOMER_REF, ORIG_SYSTEM_BILL_CUSTOMER_ID, ORIG_SYSTEM_BILL_ADDRESS_REF, ORIG_SYSTEM_BILL_ADDRESS_ID, ORIG_SYSTEM_BILL_CONTACT_REF, ORIG_SYSTEM_BILL_CONTACT_ID, ORIG_SYSTEM_SHIP_CUSTOMER_REF, ORIG_SYSTEM_SHIP_CUSTOMER_ID, ORIG_SYSTEM_SHIP_ADDRESS_REF, ORIG_SYSTEM_SHIP_ADDRESS_ID, ORIG_SYSTEM_SHIP_CONTACT_REF, ORIG_SYSTEM_SHIP_CONTACT_ID, ORIG_SYSTEM_SOLD_CUSTOMER_REF, ORIG_SYSTEM_SOLD_CUSTOMER_ID, LINK_TO_LINE_ID, LINK_TO_LINE_CONTEXT, LINK_TO_LINE_ATTRIBUTE1, LINK_TO_LINE_ATTRIBUTE2, LINK_TO_LINE_ATTRIBUTE3, LINK_TO_LINE_ATTRIBUTE4, LINK_TO_LINE_ATTRIBUTE5, LINK_TO_LINE_ATTRIBUTE6, LINK_TO_LINE_ATTRIBUTE7, RECEIPT_METHOD_NAME, RECEIPT_METHOD_ID, CONVERSION_TYPE, CONVERSION_DATE, CONVERSION_RATE, CUSTOMER_TRX_ID, TRX_DATE, GL_DATE, DOCUMENT_NUMBER, TRX_NUMBER, LINE_NUMBER, QUANTITY, QUANTITY_ORDERED, UNIT_SELLING_PRICE, UNIT_STANDARD_PRICE, PRINTING_OPTION, INTERFACE_STATUS, REQUEST_ID, RELATED_BATCH_SOURCE_NAME, RELATED_TRX_NUMBER, RELATED_CUSTOMER_TRX_ID, PREVIOUS_CUSTOMER_TRX_ID, CREDIT_METHOD_FOR_ACCT_RULE, CREDIT_METHOD_FOR_INSTALLMENTS, REASON_CODE, TAX_RATE, TAX_CODE, TAX_PRECEDENCE, EXCEPTION_ID, EXEMPTION_ID, SHIP_DATE_ACTUAL, FOB_POINT, SHIP_VIA, WAYBILL_NUMBER, INVOICING_RULE_NAME, INVOICING_RULE_ID, ACCOUNTING_RULE_NAME, ACCOUNTING_RULE_ID, ACCOUNTING_RULE_DURATION, RULE_START_DATE, PRIMARY_SALESREP_NUMBER, PRIMARY_SALESREP_ID, SALES_ORDER, SALES_ORDER_LINE, SALES_ORDER_DATE, SALES_ORDER_SOURCE, SALES_ORDER_REVISION, PURCHASE_ORDER, PURCHASE_ORDER_REVISION, PURCHASE_ORDER_DATE, AGREEMENT_NAME, AGREEMENT_ID, MEMO_LINE_NAME, MEMO_LINE_ID, INVENTORY_ITEM_ID, MTL_SYSTEM_ITEMS_SEG1, MTL_SYSTEM_ITEMS_SEG2, MTL_SYSTEM_ITEMS_SEG3, MTL_SYSTEM_ITEMS_SEG4, MTL_SYSTEM_ITEMS_SEG5, MTL_SYSTEM_ITEMS_SEG6, MTL_SYSTEM_ITEMS_SEG7, MTL_SYSTEM_ITEMS_SEG8, MTL_SYSTEM_ITEMS_SEG9, MTL_SYSTEM_ITEMS_SEG10, MTL_SYSTEM_ITEMS_SEG11, MTL_SYSTEM_ITEMS_SEG12, MTL_SYSTEM_ITEMS_SEG13, MTL_SYSTEM_ITEMS_SEG14, MTL_SYSTEM_ITEMS_SEG15, MTL_SYSTEM_ITEMS_SEG16, MTL_SYSTEM_ITEMS_SEG17, MTL_SYSTEM_ITEMS_SEG18, MTL_SYSTEM_ITEMS_SEG19, MTL_SYSTEM_ITEMS_SEG20, REFERENCE_LINE_ID, REFERENCE_LINE_CONTEXT, REFERENCE_LINE_ATTRIBUTE1, REFERENCE_LINE_ATTRIBUTE2, REFERENCE_LINE_ATTRIBUTE3, REFERENCE_LINE_ATTRIBUTE4, REFERENCE_LINE_ATTRIBUTE5, REFERENCE_LINE_ATTRIBUTE6, REFERENCE_LINE_ATTRIBUTE7, TERRITORY_ID, TERRITORY_SEGMENT1, TERRITORY_SEGMENT2, TERRITORY_SEGMENT3, TERRITORY_SEGMENT4, TERRITORY_SEGMENT5, TERRITORY_SEGMENT6, TERRITORY_SEGMENT7, TERRITORY_SEGMENT8, TERRITORY_SEGMENT9, TERRITORY_SEGMENT10, TERRITORY_SEGMENT11, TERRITORY_SEGMENT12, TERRITORY_SEGMENT13, TERRITORY_SEGMENT14, TERRITORY_SEGMENT15, TERRITORY_SEGMENT16, TERRITORY_SEGMENT17, TERRITORY_SEGMENT18, TERRITORY_SEGMENT19, TERRITORY_SEGMENT20, ATTRIBUTE_CATEGORY, ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4, ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8, ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, HEADER_ATTRIBUTE_CATEGORY, HEADER_ATTRIBUTE1, HEADER_ATTRIBUTE2, HEADER_ATTRIBUTE3, HEADER_ATTRIBUTE4, HEADER_ATTRIBUTE5, HEADER_ATTRIBUTE6, HEADER_ATTRIBUTE7, HEADER_ATTRIBUTE8, HEADER_ATTRIBUTE9, HEADER_ATTRIBUTE10, HEADER_ATTRIBUTE11, HEADER_ATTRIBUTE12, HEADER_ATTRIBUTE13, HEADER_ATTRIBUTE14, HEADER_ATTRIBUTE15, COMMENTS, INTERNAL_NOTES, INITIAL_CUSTOMER_TRX_ID, USSGL_TRANSACTION_CODE_CONTEXT, USSGL_TRANSACTION_CODE, ACCTD_AMOUNT, CUSTOMER_BANK_ACCOUNT_ID, CUSTOMER_BANK_ACCOUNT_NAME, UOM_CODE, UOM_NAME, DOCUMENT_NUMBER_SEQUENCE_ID, LINK_TO_LINE_ATTRIBUTE10, LINK_TO_LINE_ATTRIBUTE11, LINK_TO_LINE_ATTRIBUTE12, LINK_TO_LINE_ATTRIBUTE13, LINK_TO_LINE_ATTRIBUTE14, LINK_TO_LINE_ATTRIBUTE15, LINK_TO_LINE_ATTRIBUTE8, LINK_TO_LINE_ATTRIBUTE9, REFERENCE_LINE_ATTRIBUTE10, REFERENCE_LINE_ATTRIBUTE11, REFERENCE_LINE_ATTRIBUTE12, REFERENCE_LINE_ATTRIBUTE13, REFERENCE_LINE_ATTRIBUTE14, REFERENCE_LINE_ATTRIBUTE15, REFERENCE_LINE_ATTRIBUTE8, REFERENCE_LINE_ATTRIBUTE9, INTERFACE_LINE_ATTRIBUTE10, INTERFACE_LINE_ATTRIBUTE11, INTERFACE_LINE_ATTRIBUTE12, INTERFACE_LINE_ATTRIBUTE13, INTERFACE_LINE_ATTRIBUTE14, INTERFACE_LINE_ATTRIBUTE15, INTERFACE_LINE_ATTRIBUTE9, VAT_TAX_ID, REASON_CODE_MEANING, LAST_PERIOD_TO_CREDIT, PAYING_CUSTOMER_ID, PAYING_SITE_USE_ID, TAX_EXEMPT_FLAG, TAX_EXEMPT_REASON_CODE, TAX_EXEMPT_REASON_CODE_MEANING, TAX_EXEMPT_NUMBER, SALES_TAX_ID, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, LOCATION_SEGMENT_ID, MOVEMENT_ID, ORG_ID, AMOUNT_INCLUDES_TAX_FLAG, HEADER_GDF_ATTR_CATEGORY, HEADER_GDF_ATTRIBUTE1, HEADER_GDF_ATTRIBUTE2, HEADER_GDF_ATTRIBUTE3, HEADER_GDF_ATTRIBUTE4, HEADER_GDF_ATTRIBUTE5, HEADER_GDF_ATTRIBUTE6, HEADER_GDF_ATTRIBUTE7, HEADER_GDF_ATTRIBUTE8, HEADER_GDF_ATTRIBUTE9, HEADER_GDF_ATTRIBUTE10, HEADER_GDF_ATTRIBUTE11, HEADER_GDF_ATTRIBUTE12, HEADER_GDF_ATTRIBUTE13, HEADER_GDF_ATTRIBUTE14, HEADER_GDF_ATTRIBUTE15, HEADER_GDF_ATTRIBUTE16, HEADER_GDF_ATTRIBUTE17, HEADER_GDF_ATTRIBUTE18, HEADER_GDF_ATTRIBUTE19, HEADER_GDF_ATTRIBUTE20, HEADER_GDF_ATTRIBUTE21, HEADER_GDF_ATTRIBUTE22, HEADER_GDF_ATTRIBUTE23, HEADER_GDF_ATTRIBUTE24, HEADER_GDF_ATTRIBUTE25, HEADER_GDF_ATTRIBUTE26, HEADER_GDF_ATTRIBUTE27, HEADER_GDF_ATTRIBUTE28, HEADER_GDF_ATTRIBUTE29, HEADER_GDF_ATTRIBUTE30, LINE_GDF_ATTR_CATEGORY, LINE_GDF_ATTRIBUTE1, LINE_GDF_ATTRIBUTE2, LINE_GDF_ATTRIBUTE3, LINE_GDF_ATTRIBUTE4, LINE_GDF_ATTRIBUTE5, LINE_GDF_ATTRIBUTE6, LINE_GDF_ATTRIBUTE7, LINE_GDF_ATTRIBUTE8, LINE_GDF_ATTRIBUTE9, LINE_GDF_ATTRIBUTE10, LINE_GDF_ATTRIBUTE11, LINE_GDF_ATTRIBUTE12, LINE_GDF_ATTRIBUTE13, LINE_GDF_ATTRIBUTE14, LINE_GDF_ATTRIBUTE15, LINE_GDF_ATTRIBUTE16, LINE_GDF_ATTRIBUTE17, LINE_GDF_ATTRIBUTE18, LINE_GDF_ATTRIBUTE19, LINE_GDF_ATTRIBUTE20, RESET_TRX_DATE_FLAG, PAYMENT_SERVER_ORDER_NUM, APPROVAL_CODE, ADDRESS_VERIFICATION_CODE, WAREHOUSE_ID, TRANSLATED_DESCRIPTION, CONS_BILLING_NUMBER, PROMISED_COMMITMENT_AMOUNT, PAYMENT_SET_ID, ORIGINAL_GL_DATE, CONTRACT_LINE_ID, CONTRACT_ID, SOURCE_DATA_KEY1, SOURCE_DATA_KEY2, SOURCE_DATA_KEY3, SOURCE_DATA_KEY4, SOURCE_DATA_KEY5, INVOICED_LINE_ACCTG_LEVEL, OVERRIDE_AUTO_ACCOUNTING_FLAG, SOURCE_APPLICATION_ID, SOURCE_EVENT_CLASS_CODE, SOURCE_ENTITY_CODE, SOURCE_TRX_ID, SOURCE_TRX_LINE_ID, SOURCE_TRX_LINE_TYPE, SOURCE_TRX_DETAIL_TAX_LINE_ID, HISTORICAL_FLAG, TAX_REGIME_CODE, TAX, TAX_STATUS_CODE, TAX_RATE_CODE, TAX_JURISDICTION_CODE, TAXABLE_AMOUNT, TAXABLE_FLAG, LEGAL_ENTITY_ID, PARENT_LINE_ID, DEFERRAL_EXCLUSION_FLAG, PAYMENT_TRXN_EXTENSION_ID, RULE_END_DATE, PAYMENT_ATTRIBUTES, APPLICATION_ID, BILLING_DATE, TRX_BUSINESS_CATEGORY, PRODUCT_FISC_CLASSIFICATION, PRODUCT_CATEGORY, PRODUCT_TYPE, LINE_INTENDED_USE, ASSESSABLE_VALUE, DOCUMENT_SUB_TYPE, DEFAULT_TAXATION_COUNTRY, USER_DEFINED_FISC_CLASS, TAXED_UPSTREAM_FLAG, TAX_INVOICE_DATE, TAX_INVOICE_NUMBER, PAYMENT_TYPE_CODE, MANDATE_LAST_TRX_FLAG)
 Values
   (54454544, 'CONVERSION', '700542', NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    'LEGACY', 1, 'LINE', 'Ar_Defense_Cust1', 'USD', 
    100, 'Invoice', 1, 'IMMEDIATE', 5, 
    NULL, NULL, 1146, NULL, 4041, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, 'User', NULL, 1, NULL, 
    TO_DATE('03/21/2018 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), TO_DATE('12/20/2017 00:00:00', 'MM/DD/YYYY HH24:MI:SS'), NULL, NULL, NULL, 
    3, NULL, 200, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    -1, TO_DATE('03/21/2018 11:46:37', 'MM/DD/YYYY HH24:MI:SS'), 1013497, TO_DATE('03/21/2018 11:48:05', 'MM/DD/YYYY HH24:MI:SS'), 5614889, 
    NULL, NULL, 204, 'N', NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL, NULL, NULL, NULL, 
    NULL, NULL);

COMMIT;

                                               Any Queries Mail Me vivekexpertize@gmail.com