Memory Based Snapshot 64-bit Sun MSCNSPWS64 Errors ORA-01012: not logged on (Doc ID 1206715.1)

Last updated on APRIL 27, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.0.4 and later
Information in this document applies to any platform.

Symptoms

Users are running an ASCP plan.  However it fails in MSCNSPWS64 module: Memory Based Snapshot 64 bit Sun with the following error:

ORACLE error 1012 in AFPRSR-Resubmit_Time

Cause: AFPRSR-Resubmit_Time failed due to ORA-01012: not logged on

The SQL statement being executed at the time of the error was: select To_Char(To_Date(Decode(Resubmit_Time,null ,'00:00:00',Res
Routine FDPCLS encountered an error changing request 21089088 status.

Contact your support representative.
APP-FND-01564: ORACLE error 1012 in fetch_lines

Cause: fetch_lines failed due to ORA-01012: not logged on.

The SQL statement being executed at the time of the error was: begin fnd_file_private.outfile_get(:s, :b); end; and was executed from the file &ERRFILE.
ORACLE error 1012 in FDPCLS
Cause: FDPCLS failed due to ORA-01012: not logged on

The SQL statement being executed at the time of the error was: lock TABLE FND_CONCURRENT_REQUESTS IN SHARE UPDATE MODE and was executed from the file /d1/
/.../applmgr/1206/msc/12.0.0/bin/MSCNPS64.exe
Program exited with status 1

 Steps to Reproduce
===============
1.  Run ASCP Plan
2.  Plan fails with ORA-01012

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