Hi Community,
I want to trigger PDF report print job from Oracle side. I try to write one procedure but it doesn’t work. Could you help me Please ?
Thank you
Hi Community,
I want to trigger PDF report print job from Oracle side. I try to write one procedure but it doesn’t work. Could you help me Please ?
Thank you
Hello
In general, please copy the code directly in order for anybody to easily read-through and give feedback.
However, I just skimmed through your screenshot, and clearly saw that you’ve not created a new Archive instance (Archive_API.New_Instance
), which will surely fail the Print Job creation (Print_job_api.Print
) because there’s no related Print job contents (Print_Job_Contents_API.New_Instance
) created.
A successful report print should first create a new Print Job object, and an archive instance, and a job content in order to execute the print.
I’d suggest you to follow the below flow to get the job done.
This should get you the successful report print (with related archive and print manager records).
Hope this helps.
/Manulak
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.