Autoinvoice: Invalid Warehouse ID

 

Setup Issue.

Rules are transferred to RA_INTERFACE_LINES_ALL, so Accounting Rules and Invoices rules assigned to Transaction Types on the ORDER level

Responsibility:  Order Management
Navigation:  Setup > Transaction Types > Define
On the Finance Tab : Invoicing Rule and Accounting Rule Defined

Responsibility:  Receivables
Navigation:  Setup > Transactions > Sources
Go To:  Accounting Information tab
Invoicing Rule and Accounting Rule are set to 'None.'

This means that AutoInvoice will not import this information into Receivables. 
However, AutoInvoice might still validate the data and could reject the containing line(s) if that data is invalid.

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.

Define Release Rules Form Has No Values in LOV for the Warehouse Field

To implement the solution, please execute the following steps:

1) Enable the database trigger as follows:
SQL> alter trigger <TRIGGERNAME> enable;
alter trigger HR_LOCATIONS_ALL_WHO enable;

2) Once the HR_LOCATIONS_ALL_WHO trigger is enabled, update the existing locations
in some way so that they will get processed again.

3) Run the import shipping locations program with the following parameters:
Map Regions: Yes
Location: Both
Number of Instances: 1

4) Navigate: Shipping > Setup > Picking > Define rules form.
    a) Enter a rule name and effective date
    b) Go to Inventory tab, and select the LOV of warehouse field.
    c) The LOV should now have the list of warehouses (locations)