Memory Based Snapshot 64 Bit Aix Failed With App-Fnd-01564: Oracle Error 20100 In Main (Doc ID 1414119.1)

Last updated on SEPTEMBER 25, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Nov-2013***

Symptoms

 

Users are running and ASCP plan.  However it's failing in MSCNSPWA64 module: Memory Based Snapshot 64 bit AIX fails with:

Error

====

.Loading workday calendar. Please wait . 0:00
Selecting Items 132,615 0:11
before mrflit_flush_items

FILE NAME = /appsPROD39/applcsf/tmp/out/data4/mbpoutput/MSLD_ITEMS.datFlushed all buffers into MRP_SYSTEM_ITEMS 132,615 0:05
CONCURRENT MSC MSCMON "PLAN_ID=4" "REQUEST_ID=624429" "IN_PIPE=mon_ORA$PIPE$04FF042F0001" "OUT_PIPE=snp_ORA$PIPE$04FF042F0001" "SNAPSHOT_MODE=1" "SNAP_STATIC_ENTITIES=1"
Launched concurrent request 624430 for workers
items load complete
APP-FND-01564: ORACLE error 20100 in main

Cause: main failed due to ORA-20100: Error: FND_FILE failure. Unable to create file, o0260310.tmp in the directory, /tmp.    <<< key information - cannot write the temp file to the directory - ran out of disc space allocation in /tmp directory  <<<
You will find more information in the request log.
ORA-06512: at "APPS.FND_FILE", line 417
ORA-06512: at "APPS.FND_FILE", line 526
ORA-06512: at "APPS.MSC_SNAP.

The SQL statement being executed at the time of the error was: begin msc_snapshot_pk . update_items_info ( :err_mesg:err_mesg_ind , : and was executed from the file /data1/R121_64bit_wkrAuto/msc/src/mscnsp.pc.
APP-MRP-22075: An internal error has occurred (main, 1, , )

Steps to Reproduce
=============
1.  Run ASCP Plan
2.  Plan fails with multiple errors during snapshot concurrent request

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