Work Order (WO) Resource Sequence Missing For OutSide Processing (OSP) WorkOrder
(Doc ID 2110358.1)
Last updated on MARCH 26, 2020
Applies to:
Oracle iProcurement - Version 12.1.3 to 12.2.4 [Release 12.1 to 12.2]Information in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
Purchase Requisitions created from Out Side Processing(OSP) WorkOrder (WO) has Resource Sequence missing if editing the Purchase Requisitions using iProcurement
Initially customer found Resource Seq number when PR is created from OSP WO.
However after editing and approving the Resource Sequence is missing.
This customer noticed after creating the PO using AutoCreate.
EXPECTED BEHAVIOR
Expect Resource Sequence to not be missing
STEPS TO REPLICATE
The issue can be reproduced at will with the following steps:
- Create Work Order from eAM Self Service Page or Form
- Enter the OSP Resource for Operation
- Release the WO
- PR created and edit the PR using iProcurement to update the Price and supplier info
- Submit for Approval
- Create PO using Autocreate from approved PR
- Go to Distributions and check for OSP resource sequence number blank
More information
In po_requisition_lines_all table see
REQUISITION_LINE_ID ######
REQUISITION_HEADER_ID ######
ITEM_DESCRIPTION SERVICING WORKS,EXTERNAL SERVICE
SOURCE_TYPE_CODE VENDOR
ITEM_ID ######
DESTINATION_TYPE_CODE SHOP FLOOR
DESTINATION_ORGANIZATION_ID ######
WIP_ENTITY_ID ######
WIP_OPERATION_SEQ_NUM ######
WIP_RESOURCE_SEQ_NUM ORG_ID ######
In po_req_distributions_all
DISTRIBUTION_ID ######
REQUISITION_LINE_ID ######
In po_distributions_all
PO_DISTRIBUTION_ID ######
PO_HEADER_ID ######
PO_LINE_ID ######
LINE_LOCATION_ID ######
REQ_DISTRIBUTION_ID ######
DESTINATION_TYPE_CODE SHOP FLOOR
DESTINATION_ORGANIZATION_ID ######
WIP_ENTITY_ID ######
WIP_OPERATION_SEQ_NUM ######
WIP_RESOURCE_SEQ_NUM ORG_ID ######
WIP_RESOURCE_SEQ_NUM is blank in requisition line and PO distribution
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |