Do you see any errors in the log file?
Are there permissions for applmgr to the directory where the file needs to be created by the program?
Enable trace on the concurrent program from concurrent program definition screen and see if you can get more details on where it is failing.
Thank you for your response.
1. No error in the log file, this is the excerpt of the log files:
Start of log messages from FND_FILE
End of log messages from FND_FILE
Executing request completion options...
Output file size:
Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.
Finished executing request completion options.
Concurrent request completed successfully
Current system time is 27-JAN-2017 13:08:58
But the file did not created still.
2. where to check the permission for applmgr?
3. already enable trace on concurrent program and put enable regular trace. now how to check the trace?
really appreciate your help. I already create an SR for this and the SR response is helpless.
Please make sure that the applmgr or user used to start concurrent managers have access to write in the location specified to create file.
Are you doing this via UTL_FILE_DIR or DBA_DIRECTORY? If it is UTL_FILE_DIR, the path will have to be shared on both app and db servers (NFS mount), and the first entry in the UTL_FILE_DIR init.ora parameter.
Hello mdtaylor and @Dragos H.-Oracle,
Thank you for your reply. Yes, the permission is already setting and correct. Because I tried to create the file from the pl/sql procedure and it works.
But, when I tried to create the same file from the request in Oracle, it still failed. Please look in the attachment my step by step,
I really have no idea, what should I do.
Appreciate your help.
Step by Step Conccurent.docx 630.5 K
Connect to sqlplus as apps on the app server and see if it still works. Do not use toad or sql developer.
are you using utl_file_dir or dba_directory?
if it's possible can you upload the entire PL/SQL code?
Also, please make sure that the user who started concurrent managers have enough rights to run UTL_FILE...
you have to give the permissions to run UTL_FILE to user who started the concurrent managers (usually APPLMGR)
grant execute on utl_file to <user>
You should also have the following:
GRANT READ ON DIRECTORY <directory> TO PUBLIC;
GRANT WRITE ON DIRECTORY <directory> TO PUBLIC;
this will grant read/write permissions from PL/SQL to all users...
There is no file
I have reviewed the code and you should do as follows:
do not use a variable to store file directory -> use create or replace directory
eg: create or replace directory dir_temp as '/u01/dbdirect/payment';
!!! THIS IS THE MOST IMPORTANT THING TO DO -> Create link between your directory and directory used in your code...
make sure that the dir_temp is available under dba_directories -> select * from dba_directories where directory_name = 'DIR_TEMP' -> and directory path is correctly set
then you should do like this:
v_dir varchar(100) := 'DIR_TEMP'
and then, this is going to work:
after changes do not forget to recompile the procedure and the package...
Thank you for your feedback. Apologize for late response.
Already change the procedure (as you mentioned above) and check the permission.
The file is created if I run the file in PL/SQL (test the procedure)
But, when I run from Oracle Application > Payables Modules > Run Request: Report PLJBC ,,, no file created.
I already submit SR but since this is not standard Report, they cannot answered it.
Below is the step by step when I attached the procedure and create Concurrent Program, also the updates procedure. Kindly help me whats wrong/ missing in my step?
Thank you in Advanced.
unfortunately i can't find any file here.
Can you please try to re-upload the file?