1. Please Correct Revenue (or Receivable or Freight or Tax) Account Assignment A: AutoAccounting is used to determine the accounts when the distribution table is not populated. When AutoInvoice rejects a line with this error, it generally prints the account with the missing segment(s).
Menu: Setup>Transactions>AutoAccounting
Query the account mentioned in the above error and note the setup for that missing segment.
If it is based on:
i) Transaction Type - Menu: Setup>Transaction>Transaction Types,
and verify that all accounts are populated.
ii) Salesperson - Menu: Setup>Transactions>Salespersons, and verify
that all accounts are populated.
iii) Standard Lines - For an Inventory Item Navigate to
Menu: Setup>Transactions>Items>Inventory items, and verify that the 'Sales Account' is populated in the 'Invoicing' alternate region.
For a Memo Line, Navigate to Setup =>Transactions =>Memo Lines, and make sure that 'Revenue Account' is populated.
iv) Taxes – Go to Tax Managers Responsibility
Go to Taxes and query for your tax.
Here go to Tax Accounts and verify all accounts are populated.
Additionally the following can be checked:
Setup of Cross Validation Rules. Run Cross validation Listing Report in GL to identify the cross validation rule stopping the import of this line.
2. Invalid Salesrep Number A: This error is seen in 12.0.5 and log File Shows AR_RAXTRX_SALESREP_INACTIVE.
This is a known issue in 12.0.5.
Please refer Note 727200.1 : R12 RAXTRX Fails With Invalid Salesrep Number And AR_RAXTRX_SALESREP_INACTIVE 3. You must supply payment terms for your non-credit transaction A: Payment term cannot be present for a credit memo. TERM_ID and TERM_NAME must be null if you are trying to import a credit transaction.
4. a) Invalid Warehouse ID (WAREHOUSE_ID)
b) Unable to derive a gl date for your transaction. Please ensure that your transaction is in a gl period which you have defined A:
When you get both these errors at the same time, please check whether your gl period is open for the date seen in the columns GL_DATE, SHIP_DATE_ACTUAL and SALES_ORDER_DATE in the table RA_INTERFACE_LINES_ALL 5. Invalid Warehouse ID (WAREHOUSE_ID) A: Please do the following:
Using appropriate Order Management responsibility...
Setup>System Parameters>Values
Select the appropriate Operating Unit
For Category select Generic Parameters
Scroll down and verify your Item Validation Organization 6. Duplicate Transaction Flexfield A: This error shows up in 2 scenarios:
i) The combination of fields INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2, …, INTERFACE_LINE_ATTRIBUTE15 have duplicate values in the table RA_INTERFACE_LINES_ALL
ii) There is already one transaction in AR with the same Line Transaction Flexfield. The combination of fields INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2, …, INTERFACE_LINE_ATTRIBUTE15 already exists in table RA_CUSTOMER_TRX_LINES_ALL. 7. Cannot get remit to address A: A "Default Value" should be assigned for the Country and State with a blank zip code range. By adding this "default value" will eliminate the user from having to enter every possible Country and State combination that may be used. Also, by using this "default value" items will pass validation without running into an error because the remit-to address is not defined.
You can only have one default remit-to address defined.
Navigation: Setup-->Print-->Remit-to Addresses
Set up the default value for the remit to address.
i) Go to Setup->Print->Remit-To Addresses.
ii) Query up the address that will be the default address
iii) Go to the "Receipts From" section of the form.
iv) Put the cursor in the Country field and click on the LOV.
v) Select the value "Default value"
vi) Put cursor in the State field and click on LOV.
vii) Select the value "Default value"
viii) Save 8. a) Invalid bill to customer id, name ORIG_SYSTEM_BILL_CUSTOMER_ID
b) bill to address id must exist in Oracle Receivables and must be assigned to the bill to customer ORIG_SYSTEM_BILL_ADDRESS_ID A:
This can be done by querying up the customer on the customer standard form
i) Navigation: Customers > Standard
ii) Query up the customer
iii) Click on the address in the alternate region
iv) Place cursor on the correct address
v) Click on the open button, will take you to the business purpose screen
vi) Make sure that there is a usage of bill to already set
vii) Make sure that at least one of the bill to's is active
If this is setup, then please check that the value in the interface table RA_INTERFACE_LINES_ALL for columns ORIG_SYSTEM_BILL_CUSTOMER_ID and ORIG_SYSTEM_BILL_ADDRESS_ID has a value that is seen in columns CUST_ACCT_SITE_ID and CUST_ACCOUNT_ID in the table HZ_CUST_ACCT_SITES_ALL. 9. Invoice lines with the same invoice number have been separated by the grouping process, causing duplicate invoice numbers. A: Here, AutoInvoice is trying to separate your lines into different invoices due to grouping rule settings. For further details, Please refer to the 3rd question of this FAQ. "Why is AutoInvoice splitting one order into two invoices? "
Menu: Setup>Transactions>AutoAccounting
Query the account mentioned in the above error and note the setup for that missing segment.
If it is based on:
i) Transaction Type - Menu: Setup>Transaction>Transaction Types,
and verify that all accounts are populated.
ii) Salesperson - Menu: Setup>Transactions>Salespersons, and verify
that all accounts are populated.
iii) Standard Lines - For an Inventory Item Navigate to
Menu: Setup>Transactions>Items>Inventory items, and verify that the 'Sales Account' is populated in the 'Invoicing' alternate region.
For a Memo Line, Navigate to Setup =>Transactions =>Memo Lines, and make sure that 'Revenue Account' is populated.
iv) Taxes – Go to Tax Managers Responsibility
Go to Taxes and query for your tax.
Here go to Tax Accounts and verify all accounts are populated.
Additionally the following can be checked:
Setup of Cross Validation Rules. Run Cross validation Listing Report in GL to identify the cross validation rule stopping the import of this line.
2. Invalid Salesrep Number A: This error is seen in 12.0.5 and log File Shows AR_RAXTRX_SALESREP_INACTIVE.
This is a known issue in 12.0.5.
Please refer Note 727200.1 : R12 RAXTRX Fails With Invalid Salesrep Number And AR_RAXTRX_SALESREP_INACTIVE 3. You must supply payment terms for your non-credit transaction A: Payment term cannot be present for a credit memo. TERM_ID and TERM_NAME must be null if you are trying to import a credit transaction.
4. a) Invalid Warehouse ID (WAREHOUSE_ID)
b) Unable to derive a gl date for your transaction. Please ensure that your transaction is in a gl period which you have defined A:
When you get both these errors at the same time, please check whether your gl period is open for the date seen in the columns GL_DATE, SHIP_DATE_ACTUAL and SALES_ORDER_DATE in the table RA_INTERFACE_LINES_ALL 5. Invalid Warehouse ID (WAREHOUSE_ID) A: Please do the following:
Using appropriate Order Management responsibility...
Setup>System Parameters>Values
Select the appropriate Operating Unit
For Category select Generic Parameters
Scroll down and verify your Item Validation Organization 6. Duplicate Transaction Flexfield A: This error shows up in 2 scenarios:
i) The combination of fields INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2, …, INTERFACE_LINE_ATTRIBUTE15 have duplicate values in the table RA_INTERFACE_LINES_ALL
ii) There is already one transaction in AR with the same Line Transaction Flexfield. The combination of fields INTERFACE_LINE_CONTEXT, INTERFACE_LINE_ATTRIBUTE1, INTERFACE_LINE_ATTRIBUTE2, …, INTERFACE_LINE_ATTRIBUTE15 already exists in table RA_CUSTOMER_TRX_LINES_ALL. 7. Cannot get remit to address A: A "Default Value" should be assigned for the Country and State with a blank zip code range. By adding this "default value" will eliminate the user from having to enter every possible Country and State combination that may be used. Also, by using this "default value" items will pass validation without running into an error because the remit-to address is not defined.
You can only have one default remit-to address defined.
Navigation: Setup-->Print-->Remit-to Addresses
Set up the default value for the remit to address.
i) Go to Setup->Print->Remit-To Addresses.
ii) Query up the address that will be the default address
iii) Go to the "Receipts From" section of the form.
iv) Put the cursor in the Country field and click on the LOV.
v) Select the value "Default value"
vi) Put cursor in the State field and click on LOV.
vii) Select the value "Default value"
viii) Save 8. a) Invalid bill to customer id, name ORIG_SYSTEM_BILL_CUSTOMER_ID
b) bill to address id must exist in Oracle Receivables and must be assigned to the bill to customer ORIG_SYSTEM_BILL_ADDRESS_ID A:
This can be done by querying up the customer on the customer standard form
i) Navigation: Customers > Standard
ii) Query up the customer
iii) Click on the address in the alternate region
iv) Place cursor on the correct address
v) Click on the open button, will take you to the business purpose screen
vi) Make sure that there is a usage of bill to already set
vii) Make sure that at least one of the bill to's is active
If this is setup, then please check that the value in the interface table RA_INTERFACE_LINES_ALL for columns ORIG_SYSTEM_BILL_CUSTOMER_ID and ORIG_SYSTEM_BILL_ADDRESS_ID has a value that is seen in columns CUST_ACCT_SITE_ID and CUST_ACCOUNT_ID in the table HZ_CUST_ACCT_SITES_ALL. 9. Invoice lines with the same invoice number have been separated by the grouping process, causing duplicate invoice numbers. A: Here, AutoInvoice is trying to separate your lines into different invoices due to grouping rule settings. For further details, Please refer to the 3rd question of this FAQ. "Why is AutoInvoice splitting one order into two invoices? "
0 comments