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

Last updated on JULY 29, 2016

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:

  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 434738
REQUISITION_HEADER_ID 626859
ITEM_DESCRIPTION SERVICING WORKS,EXTERNAL SERVICE  
SOURCE_TYPE_CODE VENDOR
ITEM_ID 125211
DESTINATION_TYPE_CODE SHOP FLOOR
DESTINATION_ORGANIZATION_ID 1346
WIP_ENTITY_ID 598334
WIP_OPERATION_SEQ_NUM 10
WIP_RESOURCE_SEQ_NUM ORG_ID 998

In po_req_distributions_all
DISTRIBUTION_ID 515136
REQUISITION_LINE_ID 434738  
 
In po_distributions_all
PO_DISTRIBUTION_ID 716133
PO_HEADER_ID 662007
PO_LINE_ID 710768
LINE_LOCATION_ID 730252
REQ_DISTRIBUTION_ID 515136
DESTINATION_TYPE_CODE SHOP FLOOR
DESTINATION_ORGANIZATION_ID 1346
WIP_ENTITY_ID 598334
WIP_OPERATION_SEQ_NUM 10
WIP_RESOURCE_SEQ_NUM ORG_ID 998

WIP_RESOURCE_SEQ_NUM is blank in requisition line  and  PO distribution
 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms