Thursday, September 1, 2016

Auto Invoice Import

Sample scripts to populate the table for various scenarios:

INSERT INTO ra_interface_lines_all ( interface_line_context , interface_line_attribute1 , interface_line_attribute2 , amount , batch_source_name , conversion_rate , conversion_type , currency_code , cust_trx_type_id , description , gl_date , line_type , orig_system_bill_address_id , orig_system_bill_customer_id , quantity , unit_selling_price , term_id , taxable_flag , amount_includes_tax_flag , set_of_books_id , org_id) VALUES ( 'XAOA' , 'All Oracle Apps 2' , 'ALLORACLEAPPS.COM 2' , 1000.00 , 'AOA Transaction Source' , 1 , 'User' , 'USD' , 3436 , 'All Oracle Apps 2 - ITEM #1' , '10-DEC-2013' , 'LINE' , 11842 , 126871 , 10 , 100.00 , 1228 , 'Y' , 'N' , 1 , 204); COMMIT;

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...