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

Unable to find table name for files uploaded on content server by partner

Accepted answer
1
Views
1
Comments
edited May 14, 2024 11:32AM in Reporting & Analytics for Fusion Service 1 comment

Summary:

My objective is to find Content_id of the file uploaded to content server, i have my vendor uploading text documents on my content server

and the external user/vendor has the role name Content Administrator and this part is successful.

i am trying to get content_id of the uploaded file, i am looking for seeded tables, which will allow me to query content recently uploaded based on the file name

SUPPLIER_NAME_YYYY_MM_DD

format.

i have tried searching with

select FT.TABLE_NAME , FC.COLUMN_NAME

from fnd_columns fc , fnd_tables ft where ft.table_id = fc.table_id and fc.column_name ='CONTENT_ID'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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