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

Prasad_G

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.

RVohra

@Prasad_G , Welcome to the Oracle Analytics Community!

I am not sure if above tables will be able to get you the Content ID. Please explore ess_request_history and ess_request_property and see if it works for you.

RVohra

In addition to above, I believe revisions can be linked using following join condition

SELECT
erh.*, erp.*,r.*
FROM ess_request_history erh
JOIN ess_request_property erp
ON erh.requestid = erp.requestid
JOIN revisions r
ON r.dID = TO_NUMBER(erp.value)

Please explore these tables and update here if it works for you.

Prasad_G

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)

MandeepGupta

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

Hello Mandeep,

Yes, The output file is placing in content server.

Regards,

Prasad.