EBS Customizations (MOSC)

MOSC Banner

error finding file located on the db server in EBS R12

edited Apr 8, 2016 10:11AM in EBS Customizations (MOSC) 5 commentsAnswered ✓

Hi,

I am following an example from a book to copy an output file from the db server and email to specified email address using a HOST concurrent program.

I've created a directory XXHR_XML_OUT on the DB server.

SELECT *
      FROM   dba_directories
      WHERE  directory_name = 'XXHR_XML_OUT';

when concurrent program runs, it is creating the file XXHR_FILE_1003_20160301_131414.xml which i can see in /usr/tmp direcotry on the db server.

However, its failing to email and throwing error (Specified file does not exist, please specify a valid filename.)

Email Subject : Email from EBS
Email Address : email@gmail.com

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center