3 Replies Latest reply on Feb 20, 2019 3:21 AM by Kanda-Oracle

Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications. Requirement - retreive all of the ECO attachments from Oracle EBIZ version 11i

3851087 Feb 18, 2019 2:54 PM

· Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications.

· Requirement - retrieve all of the ECO attachments from Oracle EBIZ version 11i

How can I identify the total size of all ECO attachments/documents in the FND_ATTACHED_DOCS_FORM_VL - the SQL select statement is: select DISTINCT FILE_NAME from FND_ATTACHED_DOCS_FORM_VL WHERE ENTITY_NAME = 'ENG_ENGINEERING_CHANGES'

1. Re: Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications. Requirement - retreive all of the ECO attachments from Oracle EBIZ version 11i

Kanda-Oracle Feb 19, 2019 5:02 AM (in response to 3851087)

can you refer

How To Find The PO Attachment Document ID For A Purchase Order (Doc ID 334366.1)

are you looking for similar document for ECO.

Thanks!
Like Show 1 Likes(1)

Actions
2. Re: Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications. Requirement - retreive all of the ECO attachments from Oracle EBIZ version 11i

3851087 Feb 19, 2019 3:06 PM (in response to Kanda-Oracle)
H Kanda

Thank you very much for your reply! Yes please, this type of document for ECOs will be very helpful. I am not certain if it will solve the following requirements:

Provide the total size (in KBs) for of all of 4,893 the attachments/documents
Retrieve soft copies of every document in order to achieve, printing is not required

Marc
Like Show 0 Likes(0)

Actions
3. Re: Oracle EBIZ user - designs, manufactures and sells electrical and electronic products for non-residential and residential construction, industrial and utility applications. Requirement - retreive all of the ECO attachments from Oracle EBIZ version 11i

Kanda-Oracle Feb 20, 2019 3:21 AM (in response to 3851087)

Hi Marc

Let me check meanwhile You may try to tweak the query with Entity Name & Function Name for ECO.

Thanks!
Like Show 0 Likes(0)

Actions

Go to original post