Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 27 Vote(s) - 2.81 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Attachment in Oracle e-Business Suite
06-24-2016, 11:58 PM,
#1
Attachment in Oracle e-Business Suite
This week I got two questions on attachment in Oracle e-Business Suite,
Attachment: An attachment is any piece of non-structured data that is linked to more structured application data in order to illustrate or clarify the application data. For example, text files, images, word processing documents, spreadsheets, videos, and Web pages can all be used as attachments.
Q-1: Is bulk upload of attachments (for example passport soft copies, etc) can be done under document of records in Oracle eBS?
Q-2: Can we download/extract attachments from EBS?

Sharing with all of you the outcome based on my search:
The files go into fnd_lobs table as large objects, more info on this you can get from this link: Where are Employee Documents of Record Stored? (Doc ID 552806.1). FND_LOBS stores information about all LOBs managed by the Generic File Manager (GFM). 

How to Download:
Refer MOS note: How to Download Attachment File From fnd_lobs (Doc ID 1457782.1)
We will be using FNDGFU utility

How to Upload:
There is no public API available to upload in DOR, refer MOS note: Is There an API for Uploading Attachments for "Documents Of Record?" (Doc ID 1362126.1)
However there are some methods mentioned in following support notes:
Customer Issues: Is There Any Interface Or API To Import Legacy Customer Attachments? (Doc ID 552182.1)
How To Import Item Attachments Via API or Interface? Sorry, Not Supported... (Doc ID 1516752.1)
How to Load Attachments Via API into Service Requests? (Doc ID 394811.1)
Another good thread on Oracle community discussing the same topic: https://community.oracle.com/thread/2415509?tstart=0
 
Reply
Thanks given by: aklilu.wubshet


Possibly Related Threads…
Thread Author Replies Views Last Post
  Oracle HCM Cloud Interview Questions MM Ifan 1 50,274 06-06-2021, 12:16 AM
Last Post: zaidmd
  Oracle Implementation Project Plan admin 35 140,901 04-29-2021, 06:59 AM
Last Post: Cwahsayz
  Oracle ERP Implementation Project Schedule based on OUM Kashif Manzoor 7 25,562 03-31-2021, 11:45 PM
Last Post: haydara
  Oracle Financials - Data Flow From SLA to GL admin 8 79,320 12-17-2020, 11:26 PM
Last Post: cok3cl
  Oracle Inventory Module End User Training Material James Robert 1 29,385 08-27-2020, 08:59 PM
Last Post: shahid
  Oracle Inventory Miscellaneous Transactions Mark Donald 1 27,964 08-20-2020, 05:34 PM
Last Post: shahid
  Oracle Fusion Financials General Ledger Essentials M Irfan 5 92,157 08-20-2020, 05:32 PM
Last Post: shahid
  Oracle AIM - RD050 Business Requirement Documents admin 10 107,063 06-04-2020, 05:28 AM
Last Post: Shashi
  Oracle AIM - BR100 Documents admin 37 242,983 05-13-2020, 06:53 PM
Last Post: amjad.orafunctional
  AIM Vs OUM - Application Implementation Methodology vs Oracle Unified Methodology Kashif Manzoor 7 43,137 12-11-2019, 10:50 PM
Last Post: abuzeids



Users browsing this thread: 1 Guest(s)
Open Tech Talks Get Oracle Tutorials, Tips! Post a Question!