i am inserting invoices in financials from a external (no financials) oracle aplication, the data was inserted in RA_INTERFACE_ALL, but when the final process of invoice creation in financials send this errorS :
APP-00606 "IMPOSSIBLE TO READ VALUE FOR PROFILE OPTION OF AR_TAX_USE_VENDOR"
THE DATABASE IS 7.3, FINANCIALS 10.7
HOW CAN I FIX IT?
EXIST OTHER SOLUTIONS THAN PATCHING?
I am confused about the table you entered info into. The table ra_interface doesn't exist. Was it ra_interface_lines_all?
Make sure there are no triggers on the table you are importing into.
(There are no triggers on ra_interface_lines_all)
Did you check the write up in Oracle Financials Open Interfaces Manual?
Try checking there for some help and information.
I am not sure of your experience with Oracle Applications so please don't take offense to my explaining it to you. Ra_interface_lines_all contains the info for individual invoice lines the totals are conatined in ar_payment_schedules. Depending on what you want to do you need to check the table relationships between (ra_inteface_lines_all, ar_payment_schaedules, po_vendors_all, po_vendor_sites_all).
Po_vendors table contains vendor header info po_vendor_sites_all contains the specific information for each vendor site (address, city, state, zip etc...)