store data file name of sql loader
I have create a concurrent program in Oracle EBS of type SQL*LOADER with the data file as input parameter.
I want to store the name of the data file in the table that needs to be updated for reference/audit reasons.
How can I do this? Is there a variable that I can use in the ctl file which contains the file name or can I use the concurrent request parameter in the ctl file ?
Any help would be appreciated.
Regards,
Jan