E8.12 Auto Attach UBE output to the corresponding record

[Rauf]

I need to auto attach the output of a report to the corresponding record. I plan as below:
1. After completing the report, insert record with proper key to F00165
2. Get the file path from View Job Status ( I will use a driver report to call the data report so that I can get the Job Number)
3. Update the record created in step 1 with the file path formatted from step 2.

Is there a better way to accomplish the task ?

 

[GovKambam]

I think that works if you are not purging submitted jobs regularly

 

[Rauf]

So I think my way of doing is the best way

 

[Larry_Jones]

Programmatically move the file from the default Print Queue location as the contents of the print queue folder should be periodically purged.
Don't insert into F00165 until file actually moved.
You should have a network location already where manually attached files go. Use a Media Object Queue location (Defined in P98MOQUE) so you don't need to stuff the complete file path in F00165 - becomes an issue when servers and share names change.

 

[Rauf]

Hi Larry.
Thank you very much.
Previously I have done auto-emailing of UBE output. So I have idea about how to get the full path of the file.
How can I move the file programmatically, is there any vanilla bsfn exist or should I use some .bat file ?

 

[GovKambam]

if remember correctly B34A1010 will do

 

[Larry_Jones]

Take a look at B0500180

PS: Google is your friend

 

[PranikaC]

Nothing works from above ????Infact in whole JDElist there is no solution written for this.

 

[PranikaC]

Strangely it is a simple thing to copy pdf files from one location to another and there is no direct solution given here....

 

[Alex_Pastuhov]

We have a commercial solution for this exact task.

 

[DaveWagoner]

Rauf it might not be too much help for you if you're on 8.12, but Oracle released an Oracle By Example article on running a report, grabbing the output, sending it as message, as well as attaching the output to a sales order line as an attachment, all using orchestration. A how-to for the future maybe?

https://apexapps.oracle.com/pls/apex/f?p=44785:24:0:::24:p24_CONTENT_ID,P24_PREV_PAGE:31574,16