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.
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
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