Writing text output of a PL/SQL concurrent program
Hi,
I have a requirement in Oracle EBS 12.2.3 where I need to generate the output of a PL/SQL program as a text file. I did try to do it as a BI Publisher report but due to the huge volume of data for a date range that did not work.
I tried FND_FILE.PUT_LINE, but apparently the complete number of lines are not fetched in the concurrent program output file.
Can someone suggest how to generate the text output of around 100k rows or more ?
Regards
D