Oracle Receivables – Version: 11.5.10 to 126.96.36.199 – Release: 11.5 to 11.5
Information in this document applies to any platform.
Checked for relevance on 21-Oct-2009.
EXECUTABLE:RAXTRX – Autoinvoice Import Program
This note has been archived, as it has been consolidated into notes <<111267.1>> and <<1083494.1>>
Transaction are not getting imported from Order Management.
The payment terms, sales credit type and salesperson names are
not getting sent over from Order Management.
Autoinvoice Validation report shows following validation errors:
Errors: 1) You must supply payment terms for your non-credit transaction
Errors: 1)Invalid sales credit type name (SALES_CREDIT_TYPE_NAME) ((Null))
2)Invalid salesrep number (SALESREP_NUMBER) ((Null))
Batch Source setup should be “Id” for Payment Term and Sales information
since data coming from Order Management. These were setup as “Value”.
Since data is coming from Order Management (OM), need to modify Transaction Source Setup
as OM only populates ‘ID’ columns.
Under Receivables responsibility, navigate to Setup, Transactions, Sources
Query Source = <enter Order Management batch source name>
1. Under Accounting tab, make following setting change:
Select Payment Term = ‘ID’
2. Under Sales Credit tab, make following setting changes
Select Salesperson = ID
Select Sales Credit Type = ID
Rerun Autoinvoice and should no longer receive reported validation errors.