What does PK2_VALUE refer to in the table FND_ATTACHED_DOCUMENTS (R12) ?

Question

Summary

Content

Hi gents,

I have a question regarding the table FND_ATTACHED_DOCUMENTS from the R12. To which table the column PK2_VALUE refers to ?

What I already know is that PK1_VALUE in the context of POs can refer to PO_HEADERS_ALL, PO_LINES_ALL, ... depending on the value of ENTITY_NAME. However, I can't figure out what kind of foreign key is the PK2_VALUE.

I do need this because I think that UCM genrates a new line in the FND_ATTACHED_DOCUMENTS each time we upload a file attachment and since we can have many files attached to the same PO line for example, how can I determine the correct versions of the files that are phusically attached to this PO line especially if many of them have been deleted? so I suspect the PK2_VALUE to hold a crucial information about this question.

Thanks for your help

Reagrds,

Kavitha_CP-Oracle · Answer

Hi,

your query needs to be addressed by PO team , we understand that you are creating sql for BIP. but the information you are requesting has to be addressed by PO team

The PK stands for primary key in table FND_ATTACHED_DOCUMENTS table. The values in the PK columns are supposed to uniquely identify an entry in a table.

which working with document attachments each product will use these columns for respective tables

so Po team can explain about this field in table PO_HEADERS_ALL, PO_LINES_ALL

Regards,

Kavitha

Hendrik Schmidt · Answer

Hi,

This is the BI Publisher Community. But Your question is about HCM /Oracle Application?

Perhaps following helps

https://docs.oracle.com/cd/E51367_01/commonops_gs/OEDMA/FND_ATTACHED_DOCUMENTS_tbl.htm

else please move the tread to ..

Human Resource Management (HRMS)

Human Capital Management (HCM)

regards

Aimad Khallouf · Answer

Hi Hendrik,

Thank you for the reply. My question is related to BI Publisher, I am writing an SQL script to retrieve some information about file attachments regarding Purchase Orders.

Regards,