EDI Purchase Order Outbound (850/ORDERS) Is Failing With ORA-29280 Invalid Directory Path (Doc ID 1551967.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

In Oracle e-Commerce Gateway, Release 12.1.3, the "ECEPOO module: OUT: Purchase Order (850/ORDERS)" ends with errors.


Error

ORACLE error 29280 in FDPSTP

Cause: FDPSTP failed due to ORA-29280: invalid directory path
ORA-06512: at "SYS.UTL_FILE", line 41
ORA-06512: at "SYS.UTL_FILE", line 478
ORA-06512: at "APPS.ECE_POO_TRANSACTION", line 240
ORA-20001:
ORA-06512: at line 1


+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
Enter ECE_POO.Extract_POO_Outbound->08-MAY-2013 14:53:50
  cOutput_Path: ==>deoa3i
  cOutput_Filename: ==>POO0336.dat
  cPO_Number_From: ==>
  cPO_Number_To: ==>
  cCDate_From: ==>
  cCDate_To: ==>
  cPC_Type: ==>
  cVendor_Name: ==>
  cVendor_Site_Code: ==>
  v_debug_mode: ==>3
  iRun_id: ==>20337



When submitted with the Log Level for POO parameter set to "3", the additional errors are displayed at the bottom of the request log file:

  Program level POOB-10-1430: Please check the log file, correct the problem, and try again.
  SQL error message ORA-29280: invalid directory path.
  Program level POO-10-1040: Please check the log file, correct the problem, and try again.
  SQL error message ORA-20001: .




Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. In Oracle Purchasing, create and approve a new purchase order for a supplier/site that is enabled for EDI POO transaction.
2. In e-Commerce Gateway, submit the 850 Purchase Order Outbound transaction. The program completes with the errors.


Business Impact

Due to this issue, users cannot communicate purchase orders to suppliers via EDI.



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