PL_CYCLE Process Executes Cycle Steps Twice And Fails When Run Under 2 Diff IDs (Doc ID 2271884.1)

Last updated on MAY 30, 2017

Applies to:

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

Symptoms

Users noticed that when they run the PL_CYCLE app engine in Supply Planning for same run control ID under 2 different User IDs. The process tries to run all steps in Planning cycle twice and then fails with unique constraint error since it now tries to insert duplicate data for different user but same run control ID.

ERROR
-----------------------
Optimization Table Load process finished at 2016-09-23-11.32.28.000000 (15120,151)
Optimization Table Load process started at 2016-09-23-11.32.28.000000 (15120,150)
Shutting down Planning Instance:GUEST_MASTER at 2016-09-23-11.32.28.000000 (15120,770)
Deleting Static Data... 2016-09-23-11.32.38.000000 (15120,155)

File: /vob/peopletools/src/psappeng/aedebug.hSQL error. Stmt #: 1723 Error Position: 0 Return: 805 - ORA-00001: unique constraint (SYSADM.PS_PL_METHOD_TAO5) violated
Failed SQL stmt: INSERT INTO PS_PL_METHOD_TAO5 (PROCESS_INSTANCE , BUSINESS_UNIT , INV_ITEM_ID , CM_METHOD) SELECT 74547 , A.BUSINESS_UNIT , A.INV_ITEM_ID , B.CM_METHOD FROM PS_PL_BU_ITEMS A , PS_CM_ITEM_LED_VW B WHERE A.PROBINST = 'GUEST_MASTER' AND A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.INV_ITEM_ID = B.INV_ITEM_ID AND B.DEFAULT_LEDGER_GRP = 'Y' AND B.PRIMARY_LEDGER = 'Y'

Process 74547 ABENDED at Step PL_LOAD_OPT.InStatic.UMethod (SQL) -- RC = 805 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 11.33.34 2016-09-23





The issue can be reproduced at will with the following steps:
1. Login as VP1
2. Create a new run control ID for LPI (TEST-LPI)
3. Run LPI
4. Create a new runcontrol id for Planning Cycle ( TEST-CYCLE)
5. Run the Planning Cycle process which ran to success.
6. Logout and Login as VP2.
7. Create a run control TEST-LPI for LPI
8. Create TEST-LPI for Planning cycle job
9. Use TEST-LPI (Load Planning instance run control) for the cycle job
10. Run the Planning Cycle job.
11. Check the process and it ran to success.


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