Error (148,7) On Planned Purchase Orders Page

(Doc ID 2309011.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

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

Symptoms

Once in a while, planning engine generates error message (148, 7) when making updates on planned purchase orders.


ERROR
-----------------------
The analytic log file contains the following error message generated at 11:36:

PSANALYTICSRV.7106 (299) [2017-01-03T11:36:51.763 6702577K@10.136.182.186 ProbInst3](3) File: /vob/peopletools/src/psstateutil/optcatchupcur.cppSQL error. Stmt #: 133 Error Position: 21 Return: 8003 - Invalid SELECT item number
Failed SQL stmt: SELECT PL_SEQ_NBR, BUSINESS_UNIT, SEQ_NBR, PL_PLAN_STATUS, INV_ITEM_ID, VENDOR_SETID, VENDOR_ID, VNDR_LOC, BUYER_ID, CONFIG_CODE, TO_CHAR(CAST((PLAN_RELEASE_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') PLAN_RELEASE_DTTM, TO_CHAR(CAST((DUE_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') DUE_DTTM, PL_PO_LEAD_TIME, QTY_PO, REMAINING_QTY, PLAN_FROZEN_FLG, INCL_QTY_FLG , VERSION, 'N' DELFLAG FROM PS_PL_PLN_PO WHERE PROBINST = 'PLI_PC_OM_KITS' AND VERSION BETWEEN :1 and :2 UNION SELECT PL_SEQ_NBR, BUSINESS_UNIT, SEQ_NBR, PL_PLAN_STATUS, INV_ITEM_ID, VENDOR_SETID, VENDOR_ID, VNDR_LOC, BUYER_ID, CONFIG_CODE, TO_CHAR(CAST((PLAN_RELEASE_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') PLAN_RELEASE_DTTM, TO_CHAR(CAST((DUE_DTTM) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF') DUE_DTTM, PL_PO_LEAD_TIME, QTY_PO, REMAINING_QTY, PLAN_FROZEN_FLG, INCL_QTY_FLG , VERSION, 'Y' DELFLAG FROM PS_PL_PLN_PO_DEL WHERE PROBINST = 'PLI_PC_OM_KITS' AND VERSION BETWEEN :3 and :4 ORDER BY 29

The issue can be reproduced at will with the following steps:
1. Load Planning Instance and start the planning engine
2. Run Material Solver
3. Material Solver workbench, review the planned PO's and update.

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