INVENTORY

[INV] Item Reservation History Report

Is there such a report in OM or Inventory? Ans: No. It is categorized an enhancement request. Refer Note 842548.1

[INV] Where did the Onhand Quantity Gone?

Onhand shows 12400, Available is 9400, no reservation for this item, where did the 3000 qty gone?

Ans: Check Pending Transactions

[INV] APP-PO-14736: You cannot source from and deliver to the same subinventories

IR Creation

I have Requisitions Preferences as follows.

Destination Type: Inventory

Organization: A1

Location: A1Location

Subinventory: A1Sub

Source: Inventory

Organization: A2

Click Apply. Exit Requisitions form.

Open Requisitions form, select Type as Internal Requisition, tab. The above Preferences will be defaulted.

Enter the item code at line level, APP-PO-14736 error prompted, my source organization is overwritten to A1, source subinventory has the value of A1Sub. Why?

Checked Item and Item Transaction Defaults, nothing special was found. Finally, drilled down to Subinventories level. For A1Sub subinventory, there existItem Subinventories link. For the item code i entered, the Sourcing Organization is A1 and Subinventory is A1Sub. These value get defaulted to sourcing org and subinv after item code was entered (with field exit) in Requisitions form. As the result, sourcing subinv and deliver-to subinv is the same, which leads to above error.

Solution:

• Remove this Item Subinventories defaulting, or
• Manual correct the sourcing org and subinv at Requisitions form level, or
• Change to another Destination Subinventory

[INV] Item Cross References in Item Search

We have setup different Cross Reference Types for OM usage. Each type was defined in different inventory organization.

Now, in Production instance I do not have access to view the assignment (Items->Cross References was excluded). How can I check it?

Front End:

Use Item Search (Items->Item Search). Enter the inventory org, make sure the Show value is Cross References. Enter the Cross Reference Type andValue, click Find. We can see the assignment in the next screen.

Back End:

select cross_reference_type type, cross_reference selling_sku,
inv_item_concat_segs stocking_sku, description
from apps.MTL_CROSS_REFERENCES_V where cross_reference_type='ABC_XREF' and
cross_reference in
('ABCD');

[INV] Copy Item Template

Setup -> Items -> Templates

First enter a new template name at Item Template form, then go Tool -> Copy Template. Select the template name that you want to copy from.

Note that you can't copy item template from 1 inventory org to another. You can only copy item template within the same inventory organization. If source Item Template has no organization tied to it, it can be copied to any organizations.

[INV] FRM-40200: Field is protected against update

Tried to query consigned transactions in "Find Material Transactions" form. Choose "Consumption Advice " with value "Error", above error encountered.

"Consumption Advice" field is not selectable, unless Transaction Types field has values " Transfer to Consigned" or "Transfer to Regular".

 

[INV] Pending Transactions

For inventory pending transactions, you can use a single responsibility to view all Inventory Organization, even though the Inventory Org. is under another OU which is registered under another responsibility.

 

[INV] Which OU is an Inventory Organization falled Under?

In Inventory responsibility, navigate Setup -> Organizations -> Organizations , query the organization name, click Others button, choose Accounting Information. You can see the assignment for Set of Books , Legal Entity and Operating Unit.