Work Order (WO) Resource Sequence Missing For OutSide Processing (OSP) WorkOrder (Doc ID 2110358.1)

Last updated on FEBRUARY 15, 2019

Applies to:

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:

1. Create Work Order from eAM Self Service Page or Form
2. Enter the OSP Resource for Operation
3. Release the WO
4. PR created and edit the PR using iProcurement to update the Price and supplier info
5. Submit for Approval
6. Create PO using Autocreate from approved PR
7. 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.