Is the concurrent program completing succesfully ?
Did you try to add debug statements and see whether it is getting printed ?
Can you paste the procedure code here ?
Yes, the concurrent program completing successfully.
Actually, I created another test procedure.
The script is very very simple, but the issue still exists.
The test procedure code as below :
CREATE OR REPLACE PROCEDURE kltw_create_ar_aging_top20(errbuf OUT VARCHAR2,
retcode OUT NUMBER) IS
INSERT INTO kltw_ar_temp02
Still no data in table kltw_ar_temp02 after run the concurrent program.
I guess I find the root cause ?
The table is a global temporary table.
The issue will not happen when the table is a standard table.