[INV] Manufacturers' Part Number

Define New Manufacturer
Items -> Manufacturers' Part Numbers -> By Manufacturers

Assign Manufacturer Part Number
Items -> Manufacturers' Part Numbers -> By Items

System does not allow duplicate Manufacturer Name defined, it is controlled at form level. Manufacturer Part Numbers are defined in Master level, it does not link to the Inventory Child organization.

Table: APPS.MTL_MANUFACTURERS, APPS.MTL_MFG_PART_NUMBERS_ALL_V

Some Constraints:
- For the same Manufacturer and Item, we cannot define same Manufacturer Part again. But if the same Manufacturer Part was defined for another Manufacturer for the same Item, it allows. E.g.
Manufacturer Part Item
A P1 I1
A P1 I1 => NOT ALLOWED
B P1 I1 => ALLOWED

- Manufacturer Name (30 chr) does not link to Vendor Name (240 chr).

[MRP] Planning Active

Excerpt from Oarcle Online Help for Define Sourcing Rules:
7. Enter an allocation percentage for each shipping organization. Allocation percentage includes the number of planned orders issued to the part for the entire the planning horizon. Your total allocation may not exceed 100.

If the allocation percentage for all the shipping organizations included within a range of effectivity dates equals 100, Planning Active is checked. If the sourcing rule is not planning active, the planning process will not use the rule to assign planned orders.

Note: You cannot set the allocation percentage to less than or greater than 100 for sourcing rules that are already assigned in assignment sets.

The Planning Active field is not editable by design. FYI, I tested the last note "Note: You cannot set...", it is not true.

[INV] Locator Control in Subinventories is Disabled

Locator Control in Subinventories form is disabled. However, selection still can be done, any change of value will prompts "FRM-40200: Field is protected against update".

To enable that, we need to set the Organization Parameters, Inventory Information to have Locator Control equals "Determined at Subinventory level".

[PO] Auto Create Purchase Order

Question: How to do set up for automatic creation of PO from approved purchase requisition. I don't want to do through Autocreate option.

Answer: You can trigger workflow PO_AUTOCREATE_DOC.start_WF_process to create PO from your approved PR. If you want this to happen immediately after PR got approved, modify the PO Requisition Approval workflow. Go to Main Requisition Approval process (Internal Name: MAIN_REQAPPRV_PROCESS), add a function at the end of the workflow.

[PO] Zero in Price

Does system allow to have "0"(zero) in item price? Ans: Yes

[PO] Adding PR to Existing PO Line with Different Price

New price will not take effect if you add in to existing PO line.