My Oracle Support Banner

FAQ on Errors During PS Launch Process (Doc ID 1550018.1)

Last updated on APRIL 15, 2020

Applies to:

Oracle Production Scheduling - Version 11.5.10 and later
Information in this document applies to any platform.

Purpose

 The purpose of the FAQ's is to provide users on how to address the errors during PS launch process

Questions and Answers

To view full details, sign in with your My Oracle Support account.

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


In this Document
Purpose
Questions and Answers
 Question 1:  Why PS launch fails with an error "Exception caught: Failed to save model to database: /refresh/target/EbiPSModel.xml.gz (No such file or directory)"
 Question 2: Why opening PS workbench fails with an error "Cannot run program "C:\Users\CCG\AppData\Local\Temp\PS\windows\install.exe":CreateProcess error=740. The requested operation requires elevation"
 Question 3:  Why PS Launch fails with an error ""Exception caught: Failed to run SQL statement for extraction: ORA-01400: cannot insert NULL into ("MSC"."MSC_INT_SALES_ORDER_DETAIL"."OI__LINE_ITEM_NAME")"
 Question 4:  Why PS Launch fails with an error "Failed to run SQL statement for extraction:ORA-00001: unique constraint (MSC.MSC_PURCHASE_ORDER_PK) violated"
 Question 5:  Why PS Launch fails with an error "Failed to run SQL statement for extraction:ORA-00001: unique constraint (MSC.MSC_ITEM_PK) violated"
 Question 6:  Why PS Launch fails with an error "SCP Directory path is /opt/oracle/apps/PDEVX/apps/apps_st/appl/msc/12.0.0/bin/PS
java.lang.NullPointerException"
 Question 7:  Why PS Launch fails with an error "Failed to run SQL statement for extraction: ORA-00001: unique constraint (MSC.MSC_CALENDAR_TV_PK) violated?"
 Question 8:  Why PS Launch fails with an error "Exit code: 1 - java.lang.RuntimeException: Failed to run script on server"
 Question 9: Why Launch PS Plan end with an error ORA-00001: unique constraint (MSC.MSC_WORK_ORDER_OPERATION_PK) violated?
 Question 10:  How to find the error table name which is causing the Unique Constraint Error ?
 Question 11:   Launching PS ends with an error - Failed to run script on server: /u002/UAT/fs1/EBSapps/appl/msc/12.0.0/bin/PS/runPS /u002/UAT/fs_ne/inst/UAT_fedc28100/logs/appl/conc 7034 -gzip
 Question 12: Launch PS plan ends in an error - Failure populating reference tables. Exception message: ERROR AT:INSERT INTO msc_int_11_tv
 Question 13: Launch PS plan ends in an error(s) - Exception caught: Failed to run SQL statement for extraction: ORA-00904: "OI__CONSUMPTION_TIME_UNIT": invalid identifier
Exception caught: Failed to run SQL statement for extraction: ORA-00904: "OI__VISIT_STATUS": invalid identifier
 Question 14: Launch PS plan ends in an error 'Unique constraint (MSC.MSC_SALES_ORDER_PK) violated'
 Question 15: Launch PS Plan ends in an error "Exception caught: Failed to set next operation code: SQL string is not Query"
 Question 16: Launch PS Plan ends in an error "ORA-00001: unique constraint (MSC.MSC_ITEM_GROUP_PK) violated"
 Question 17: Launch PS Plan ends in an erro "ORA-00001: unique constraint (MSC.MSC_CONSUMED_ITEM_BOM_PK) violated"
 Question 18: Launch PS Plan ends in an error 'ORA-00001: unique constraint (MSC.MSC_BRANCH_ROUTING_TV_PK) violated'
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.