User Not Able To Create An Child Work Order In Service Procurement

(Doc ID 2316443.1)

Last updated on OCTOBER 11, 2017

Applies to:

PeopleSoft Enterprise SCM Services Procurement - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Work Orders - Create

Can't create a child workorder Due to Services SEQNUM count crossed more than 999.

The issue can be reproduced at will with the following steps:
1. When we see the other SPRO records which are using the field SEQNBR (LENGTH - 5) example (RECORD Name: SPF_WO_SERVICE1).
2. Unlikely the record SPF_REQ_STATUS contains the field SEQNUM(Length :3)
3. We have work order with larger no of services (1000+ services) which causing the issue while extending the child work order from the parent one. Since the field SEQNUM already reached the value of 999 and its unable to create an child work order.


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