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

Aimad Khallouf

Summary

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

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,

Hendrik Schmidt

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

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,

Kavitha_CP-Oracle

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