Labels

[ALRT] (3) [AR] (2) [BOM] (3) [GL] (2) [GTM] (1) [INV] (18) [MRP] (1) [OM] (27) [PO] (58) [QP] (3) [SYS] (39) [WIP] (4) AGIS (1) OM (1)

Wednesday, January 12, 2011

[SYS] Session Timeout Issues

Try to increase the value for the following profile options.

ICX:Session Timeout - set it to number of minutes before timeout
ICX: Limit time - set it to number of hours before timeout

[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.

[SYS] Item Cost Table

BOM.CST_ITEM_COSTS - table to store item cost

Important Fields:
cost_type_id (1-Froze, 2-Pending)
based_on_rollup_flag (1-Yes, 2-No)

[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.

Monday, January 10, 2011

[PO] Item Not Found During Purchase Requisition (PR) Creation

In a Operation Unit (OU), I have 2 inventory organization (inventory child type), e.g. OrgA & OrgB. I need to raise a PR to purchase ItemC under OrgB. In Item setup, ItemC is created in Inventory Master org, and assigned to OrgB. Purchasable flag has been checked in both Inventory Master and OrgB. When i keyed in the item during PR creation, item not found, why?

The reason being the OrgA was assigned in Financial Options setup (Setup -> Organizations -> Financial Options), Supplier - Purchasing, Inventory Organization field. If OrgA is assigned, only item assigned to OrgA can be found in the LOV.

We can setup Inventory Master org in each OU, then assign the Inventory Master org in the Financial Options. From there, we can choose any items that was created under the Inventory Master org.

[PO] Backend Field for PR

We know that we can view Purchase Requisition (PR) number from PO distribution screen (Line -> Shipment -> Distributions, for standard PO). Which field in the backend table is used to link to PR tables?

Ans: LINE_LOCATION_ID field in APPS.PO_LINE_LOCATIONS_ALL table that links to APPS.PO_REQUISITION_LINES_ALL table