Introduction:
Oracle Receivables – Version 12 and later
Information in this document applies to any platform.
Cause of the issue:
Getting an error when running Autoinvoice
Error:
Invalid Warehouse ID (WAREHOUSE_ID) (xxx)
Expect the lines to get imported correctly.
Invalid value in the interface tables. (RA_INTERFACE_LINES_ALL)
Invalid Warehouse ID (WAREHOUSE_ID).
This problem exists in all organizations. Warehouse is valid from Order Management responsibility, but it does not appear in Receivables responsibility
How do we solve:
To fix the issue and make all valid warehouses available in AR, please validate the following setups:
1) Check the Receivables responsibility having the access to warehouse.
Navigation: Setup >Transactions > Define item
It will show warehouse details having access to the Receivables responsibility.
2) If you do not find a value in previous step, correct your setup using appropriate Inventory
responsibility:
Navigation: Setup > Organizations > Organization Access.
Associate the warehouse which is missing with the Receivables responsibility.
Save the changes.
Now go back to Receivables responsibility and check if you are able to access warehouse or not as mentioned in step1.
3) Also check the profile options HR: Security Profile is set properly:
Make sure that your OM and AR responsibilities have the same HR security profile settings.
Conclusion:
In order to avoid this error, Provide the Organization access to the responsibility and Set the Right profile options.
