Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 14 Oracle Analytics Lounge
- 211 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 77 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
What does PK2_VALUE refer to in the table FND_ATTACHED_DOCUMENTS (R12) ?
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,
Answers
-
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
0 -
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,
0 -
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
0