Understanding PeopleSoft Supply Planning Planned Order Numbering

This section discusses the numbering schemes that the system uses to keep planned orders in the planning instance synchronous with numbering schemes in the transaction system.

PeopleSoft Supply Planning retains two sets of order numbers for each planned order. The first number is unique for a planning instance. The second number is unique within the transaction system. Both numbers reside on the transaction system table and planning instance table, one number is a key, the other number is a reference.

Planning Instance Sequence Number

When you run the Load Planning Instance process (PL_LOAD_OPT) with a run type defined as Regenerative, the process sets the planned sequence number equal to the transaction system sequence number when it inserts these orders into the planning instance tables.

After the Load Planning Instance process inserts all of the orders into the planning instance tables, it updates the next available planning sequence number on the Planning Instance table to equal the last planning sequence number used, plus one, and increments this number each time that you add new planned orders to the planning instance tables.

Transaction System Sequence Number

In the planning instance tables, the system populates the transaction sequence number with the sequence number from the transaction system table record. The system populates this field with a zero for new orders created in the planning instance. Because multiple planning instances can post data back to the transaction system, it is possible that the same planning sequence number can exist in more than one planning instance. To keep orders unique in the transaction system, PeopleSoft Supply Planning also assigns a transaction sequence number.

When you run the Post Updates process, the transaction system stores the next available transaction sequence number by order type on the Installation - Planning table (INSTALLATION_PL). Existing planned orders retain the transaction sequence number assigned when they were first added into the transaction system.