My Oracle Support Banner

R12:EDI: E-Commerce Gateway EDI Import Fails With ORA-29280 Invalid Directory Path (Doc ID 2666162.1)

Last updated on MAY 06, 2020

Applies to:

Oracle EDI Gateway - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2]
Information in this document applies to any platform.

Symptoms

When trying to import an Accounts Payable (AP) Invoice using e-Commerce Gateway (EDI), the process is failing with the following error as seen from the "ECEINI: IN: Invoice (810/INVOIC)" log file:


  Program Error: UTL_FILE. File location or file name was invalid.
  Program level EC_INBOUND_STAGE.LOAD_DATA: Please check the log file, correct the problem, and try again.
  SQL error message ORA-29280: invalid directory path.

It is confirmed that the directory exists by executing the following (as an example):

select * from all_directories where directory_path = '/d01/app/sharedadmin/PRJ1/xxcus/EDI-In';

OWNER    DIRECTORY_NAME         DIRECTORY_PATH                                        ORIGIN_CON_ID                           

SYS         XXGEN_EDI_IN              /d01/app/sharedadmin/PRJ1/xxcus/EDI-In         0

Cause

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
Symptoms
Cause
Solution
References


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