Catalog and/or Item Extract Fails With ORA-20100 ORA-06512: at "APPS.ICX_POR_EXT_UTL (Doc ID 333173.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle iProcurement - Version 11.5.9 to 11.5.10 [Release 11.5]
Information in this document applies to any platform.
This problem can occur on any platform.

Symptoms

When attempting to run either "Catalog Data Extract - Classifications" or "Catalog Data Extract - Items" concurrent request, it  fails with an error.

Due to this issue, users cannot extract Classifications or Catalog Items to iProcurement.

ERROR
-------------------
DECLARE
*
ERROR at line 1:
ORA-20100:
=============================================================================
Unable to write the debug messages to the log file.
FIX:
Ensure that the virtual path assigned to the APPLPTMP environment variable is
valid, writable, and is referenced at the beginning
of the UTL_FILE_DIR database parameter in init.ora.
=============================================================================
ORA-06512: at "APPS.ICX_POR_EXT_UTL", line 225
ORA-20100: File ext_item.log_out creation for FND_FILE failed.
You will find more information on the cause of the error in request log.
ORA-06512: at line 20

STEPS
-------------------
1. Log in and access Core applications.
2. Select Purchasing Responsibility.
3. Navigate to Setup > E Catalog Admin > Loader Values
4. Form will open, submit either or both of these concurrent requests:
          Catalog Data Extract - Classifications
          Catalog Data Extract - Items 
5. Request fails and gives above message.


 

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