How to fetch the fetch the CONTENT ID based on ESS Job request ?

Question

I need to fetch the Content Id (Output file)based on my ESS Job request Id, Join or table query also fine.

Key Tables for Content IDs:-   REVISIONS , FND_DOCUMENTS_TL and FND_ATTACHED_DOCUMENTS.

I am failed to get the link between these…

Please help.

Thanks,

Prasad.

Prasad_G · Answer

Hello Mandeep,

Yes, The output file is placing in content server.

Regards,

Prasad.

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/27989/how-to-fetch-the-fetch-the-content-id-based-on-ess-job-request

Hi Prasad,

Is the ESS job bursting the file to content server?

Thanks.

Prasad_G · Answer

Hello @RVohra ,

Thanks for the above.

seems like the join is not valid/don't see the value in that table.

ON r.dID = TO_NUMBER(erp.value)