You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to Expose DM_VERSION_NUMBER in AttachedDocumentsPVO for Invoice Attachment URLs via BICC?

edited Apr 24, 2025 6:44PM in Financial Consolidation and Close 2 comments

We are currently using BICC (BI Cloud Connector) to extract data from the following PVO:
FscmTopModelAM.FinExtractAM.AnalyticsExtractServiceAM.AttachedDocumentsPVO, in order to generate URLs for downloading invoice attachments.

The download URL requires the DM_VERSION_NUMBER (e.g., in the format:
https://<host>/fscmUI/content/conn/FusionAppsContentRepository/uuid/dDocID:12345678)
We've identified that this value comes from the FND_DOCUMENTS_TL table.

While this table is joined in the PVO logic, the DM_VERSION_NUMBER column is not exposed in the PVO output. However, we do see that this column is available in the related BIP logic.

We are seeking guidance on the following:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!