EBS-PS: Error while defining PS plan - ORA-01403: no data found, FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06508.

(Doc ID 1319051.1)

Last updated on DECEMBER 06, 2017

Applies to:

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

Symptoms

ISSUE
EBS-PS - Getting Error message while defining PS plan

ERROR MESSAGE
ORA-01403: no data found

--------------------------------------------------------------
FRM-40735: PRE-FORM trigger raised unhandled exception ORA-06508.

Form does not open.



Steps to Reproduce
1) Installed PS,
2) Generated missing forms files,
3) Created APS partitions,
4) Defined instance,
5) Assigned organization access,
6) Ran collection plan and ODS Load including MDS.
7) Use "Names" menu option to define a plan. System prompts to select an org. Select the org for which the MDS was loaded.
System returns error message:

EXPECTED OUTCOME
There should be no error while defining PS plan

CONFIGURATION
EBS-PS 11.5.10.2

Workaround
none available

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