[PO] Owner Can Approve

Whether a preparer can approve the document, e.g. PR/PO depends on setup in Setup -> Purchasing -> Document Types, if "Owner Can Approve" flag is check, preparer can approve by himself. Means, preparer just need to click "Approve... " and "OK" button, the document will be approved (assume approval limit is satisfied).

However, if preparer wants to use hierarchy other than default hierarchy, he/she needs to specified the "Forward To" person to himself. PO will be first changed to " Pre-Approved" status before it get approved eventually.

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

[PO] Position with Status Blank

Create a new position, leave the Status field blank, save. Oracle considers it as Valid or Invalid. Ans: Valid

[WIP] Main Tables for Work In Process (WIP) Job

WIP_DISCRETE_JOBS_V - work order main info

WIP_REQUIREMENT_OPERATIONS - material and resource requirements

Sample codes:

SELECT MSI.SEGMENT1 AS "PART NO", WDJ.WIP_ENTITY_NAME, WRO.WIP_ENTITY_ID, WRO.OPERATION_SEQ_NUM,
WRO.REQUIRED_QUANTITY, WRO.QUANTITY_ISSUED
FROM WIP_REQUIREMENT_OPERATIONS WRO, WIP_DISCRETE_JOBS_V WDJ,
MTL_SYSTEM_ITEMS MSI
WHERE WRO.REQUIRED_QUANTITY-WRO.QUANTITY_ISSUED>0
AND WRO.ORGANIZATION_ID=1234
AND WRO.ORGANIZATION_ID=WDJ.ORGANIZATION_ID
AND WRO.ORGANIZATION_ID=MSI.ORGANIZATION_ID
AND WRO.INVENTORY_ITEM_ID=MSI.INVENTORY_ITEM_ID
AND WRO.WIP_ENTITY_ID=WDJ.WIP_ENTITY_ID
AND WDJ.STATUS_TYPE=3 --Released
AND MSI.SEGMENT1='myItem'

[WIP] Before You Start

To get started with WIP module, you must first setup the WIP parameters (Setup -> Parameters) and setup at least 1 WIP Accounting Class (Setup -> WIP Accounting Classes).