{"id":1809,"date":"2011-04-17T13:30:50","date_gmt":"2011-04-17T08:00:50","guid":{"rendered":"http:\/\/sendyoursmiles.com\/articles\/oracle-attachment-functionality-adding-an-attachment-to-a-form"},"modified":"2014-12-03T09:14:10","modified_gmt":"2014-12-03T09:14:10","slug":"oracle-attachment-functionality-adding-an-attachment-to-a-form","status":"publish","type":"post","link":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form","title":{"rendered":"Oracle Attachment Functionality"},"content":{"rendered":"

About Attachments:<\/span><\/p>\n

\n

Attachment in Oracle Application<\/h3>\n
What is attachment in oracle application?<\/div>\n
The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions.<\/div>\n
Where to find an attachment?<\/div>\n
There is an attachment icon in the oracle application toolbar that indicates whether the Attachments feature is enabled in a form block. When the button is dimmed, the Attachment feature is not available. When the Attachment feature is enabled in a form block, the icon becomes a solid paper clip. The icon switches to a paper clip holding a paper when the Attachment feature is enabled in a form lock and the current record has at least one attachment.<\/div>\n
Attachment types:<\/div>\n
An attached document can be:<\/div>\n
1] Short Text<\/div>\n
Text stored in the database containing less than 2000 characters.<\/div>\n
2] Long Text<\/div>\n
Text stored in the database containing 2000 characters or more.<\/div>\n
3] Image<\/div>\n
An image that Oracle Forms can display, including: bmp, cals, jfif, jpeg, gif, pcd, pcx, pict, ras, and tif.<\/div>\n
4] OLE Object<\/div>\n
An OLE Object that requires other OLE server applications to view, such as Microsoft Word or Microsoft Excel.<\/div>\n
5] Web Page<\/div>\n
A URL reference to a web page which you can view with your web browser.<\/div>\n
Tables Involved:<\/div>\n
For Importing Attachments in oracle application one has to populate following tables.<\/div>\n
1. FND_DOCUMENTS<\/div>\n
2. FND_ATTACHED_DOCUMENTS<\/div>\n
3. FND_DOCUMENTS_TL<\/div>\n
4. FND_DOCUMENT_DATATYPES.<\/div>\n
5. FND_DOCUMENT_CATEGORIES<\/div>\n
6. FND_DOCUMENTS_LONG_TEXT (Long text type attachment).<\/div>\n
7. FND_DOCUMENTS_SHORT_TEXT (Short text type attachment).<\/div>\n
8. FND_DOCUMENTS_LONG_RAW<\/div>\n
9. FND_LOBS (File type attachments).<\/div>\n
FND_DOCUMENTS:<\/div>\n
FND_DOCUMENTS stores language-independent information about a document. For example, each row contains a document identifier, a category identifier, the method of security used for the document (SECURITY_TYPE, where 1=Organization,2=Set of Books, 3=Business unit,4=None), the period in which the document is active, and a flag to indicate whether or not the document can be shared outside of the security type (PUBLISH_FLAG).<\/div>\n
Other specifications in this table include: datatype (DATATYPE_ID, where 1=short text,2=long text, 3=image, 4=OLE object), image type, and storage type (STORAGE_TYPE, where 1=stored in the database, 2=stored in the file system).<\/div>\n
The document can be referenced by many application entities and changed only in the define document form (USAGE_TYPE=S); it can be used as a fill-in-the-blanks document, where each time you use a template, you make a copy of it (USAGE_TYPE=T); or it can be used only one time (USAGE_TYPE=O).Images and OLE Objects cannot be used as templates.<\/div>\n
FND_ATTACHED_DOCUMENTS:<\/div>\n
FND_ATTACHED_DOCUMENTS stores information relating a document to an application entity.\u00a0 For example, a record may link a document to a sales order or an item. Each row contains foreign keys to FND_DOCUMENTS and FND_DOCUMENT_ENTITIES. There is also a flag to indicate whether or not an attachment was created automatically.<\/div>\n
FND_DOCUMENTS_TL:<\/div>\n
FND_DOCUMENTS_TL stores translated information about the documents in FND_DOCUMENTS. Each row includes the document identifier, the language the row is translated to, the description of the document, the file in which the image is stored, and an identifier (MEDIA_ID) of the sub-table in which the document is saved (FND_DOCUMENTS_SHORT_TEXT, FND_DOCUMENTS_LONG_TEXT, or FND_DOCUMENTS_LONG_RAW).<\/div>\n
FND_DOCUMENT_DATATYPES:<\/div>\n
FND_DOCUMENT_DATATYPES stores the document datatypes that are supported. Initial values are: short text, long text, image, and OLE Object (DATATYPE_ID=1, 2, 3, or 4). Customers can add datatypes to handle documents stored outside of Oracle and use non-native Forms applications to view\/edit their documents. The table uses a \u201cduplicate record\u201d model for handling multi-lingual needs. That is, for each category there will be one record with the same CATEGORY_ID and CATEGORY_NAME for each language.<\/div>\n
FND_DOCUMENT_CATEGORIES:<\/div>\n
FND_DOCUMENT_CATEGORIES stores information about the categories in which documents are classified. For example, documents may be considered \u201cBill of Material Comments\u201d, \u201cWIP Job Comments\u201d, etc. Document categories are used to provide a measure of security on documents.\u00a0Each form that enables the attachment feature lists which categories of documents can be viewed in the form. This table uses a \u201cduplicate record\u201d model for handling multi-lingual needs.<\/div>\n
FND_DOCUMENTS_LONG_TEXT:<\/div>\n
FND_DOCUMENTS_LONG_TEXT stores information about long text documents.<\/div>\n
FND_DOCUMENTS_SHORT_TEXT:<\/div>\n
FND_DOCUMENTS_SHORT_TEXT stores information about short text documents.<\/div>\n
FND_DOCUMENTS_LONG_RAW:<\/div>\n
FND_DOCUMENTS_LONG_RAW stores images and OLE Objects, such as Word Documents and Excel spreadsheets, in the database.<\/div>\n
FND_DOCUMENT_ENTITIES:<\/div>\n
FND_DOCUMENT_ENTITIES lists each entity to which attachments can be linked. For example, attachments can be linked to Items, Sales Orders, etc. Since the table uses a \u201cduplicate record\u201d model for handling multi-lingual needs, for each document entity there will be one record with the same DOCUMENT_ENTITY_ID and DATA_OBJECT_CODE for each language.<\/div>\n
Queries:<\/div>\n
1] To find all Long Text attachments:<\/div>\n
<\/div>\n
<\/div>\n
SELECT\r\n        FAD.SEQ_NUM \"Seq Number\",\r\n        FDAT.USER_NAME \"Data Type\",\r\n        FDCT.USER_NAME \"Category User Name\",\r\n        FAD.ATTACHED_DOCUMENT_ID \"Attached Document Id\",\r\n        FDET.USER_ENTITY_NAME \"User Entity\",\r\n        FD.DOCUMENT_ID \"Document Id\",\r\n        FAD.ENTITY_NAME \"Entity Name\",\r\n        FD.MEDIA_ID \"Media Id\",\r\n        FD.URL \"Url\",\r\n        FDT.TITLE \"Title\",\r\n        FDLT.LONG_TEXT \"Attachment Text\"\r\nFROM\r\n        FND_DOCUMENT_DATATYPES FDAT,\r\n        FND_DOCUMENT_ENTITIES_TL FDET,\r\n        FND_DOCUMENTS_TL FDT,\r\n        FND_DOCUMENTS FD,\r\n        FND_DOCUMENT_CATEGORIES_TL FDCT,\r\n        FND_ATTACHED_DOCUMENTS   FAD,\r\n        FND_DOCUMENTS_LONG_TEXT FDLT\r\nWHERE\r\n        FD.DOCUMENT_ID          = FAD.DOCUMENT_ID\r\n        AND FDT.DOCUMENT_ID     = FD.DOCUMENT_ID\r\n        AND FDCT.CATEGORY_ID    = FD.CATEGORY_ID\r\n        AND FD.DATATYPE_ID      = FDAT.DATATYPE_ID\r\n        AND FAD.ENTITY_NAME     = FDET.DATA_OBJECT_CODE\r\n        AND FDLT.MEDIA_ID       = FD.MEDIA_ID\r\n        AND FDAT.NAME           = 'LONG_TEXT';<\/pre>\n
2] To find all Short Text attachments:<\/div>\n
<\/div>\n
SELECT\r\n        FAD.SEQ_NUM \"Seq Number\",\r\n        FDAT.USER_NAME \"Data Type\",\r\n        FDCT.USER_NAME \"Category User Name\",\r\n        FAD.ATTACHED_DOCUMENT_ID \"Attached Document Id\",\r\n        FDET.USER_ENTITY_NAME \"User Entity\",\r\n        FD.DOCUMENT_ID \"Document Id\",\r\n        FAD.ENTITY_NAME \"Entity Name\",\r\n        FD.MEDIA_ID \"Media Id\",\r\n        FD.URL \"Url\",\r\n        FDT.TITLE \"Title\",\r\n        FDST.SHORT_TEXT \"Attachment Text\"\r\nFROM\r\n        FND_DOCUMENT_DATATYPES FDAT,\r\n        FND_DOCUMENT_ENTITIES_TL FDET,\r\n        FND_DOCUMENTS_TL FDT,\r\n        FND_DOCUMENTS FD,\r\n        FND_DOCUMENT_CATEGORIES_TL FDCT,\r\n        FND_ATTACHED_DOCUMENTS   FAD,\r\n        FND_DOCUMENTS_SHORT_TEXT FDST\r\nWHERE\r\n        FD.DOCUMENT_ID          = FAD.DOCUMENT_ID\r\n        AND FDT.DOCUMENT_ID     = FD.DOCUMENT_ID\r\n        AND FDCT.CATEGORY_ID    = FD.CATEGORY_ID\r\n        AND FD.DATATYPE_ID      = FDAT.DATATYPE_ID\r\n        AND FAD.ENTITY_NAME     = FDET.DATA_OBJECT_CODE\r\n        AND FDST.MEDIA_ID       = FD.MEDIA_ID\r\n        AND FDAT.NAME           = 'SHORT_TEXT';<\/pre>\n
Attachment upload through API:<\/div>\n
Attachments can also be uploaded through an oracle provided API called \u00a0FND_ATTACHED_DOCUMENTS_PKG.<\/div>\n
It consist of three procedures<\/div>\n
1)\u00a0 Insert Row<\/div>\n
2)\u00a0 Update Row<\/div>\n
3)\u00a0 Lock Row<\/div>\n
Names of these procedures are self explanatory. insert row is used to insert a new row for attachment data, update row is used to update existing row for a particular row and Lock Row is used to lock a existing row for further modification.<\/div>\n<\/div>\n
Attachment feature enables users to link files like images, word documents, emails, e.t.c to a particular form\/function\/record.<\/p>\n
 <\/p>\n
\"1809_oracle_attachments-1\"<\/p>\n
\"1809_oracle_attachments-2\"<\/p>\n
\"1809_oracle_attachments-3\"<\/p>\n
\"1809_oracle_attachments-4\"<\/p>\n
\"1809_oracle_attachments-5\"<\/p>\n
\"1809_oracle_attachments-6\"<\/p>\n
\"1809_oracle_attachments-7\"<\/p>\n
\"1809_oracle_attachments-8\"<\/p>\n
\"1809_oracle_attachments-9\"<\/p>\n
\"1809_oracle_attachments-10\"<\/p>\n
\"1809_oracle_attachments-11\"<\/p>\n
\"1809_oracle_attachments-12\"<\/p>\n
\"1809_oracle_attachments-13\"<\/p>\n","protected":false},"excerpt":{"rendered":"
About Attachments: Attachment in Oracle Application What is attachment in oracle application? The attachments feature in oracle application enables users to link unstructured data, such as images, word-processing documents, spreadsheets, or text to their application data. For example, users can link images to items or video to operations as operation instructions. Where to find an […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-1809","post","type-post","status-publish","format-standard","hentry","category-sysadmin-and-aol"],"yoast_head":"\nOracle apps Attachment Functionality<\/title>\n<meta name=\"description\" content=\"Attachment feature enables users to link files like images, word files, emails, e.t.c to a particular form\/function\/record.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Prudhvi\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"6 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#article\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form\"},\"author\":{\"name\":\"Prudhvi\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\"},\"headline\":\"Oracle Attachment Functionality\",\"datePublished\":\"2011-04-17T08:00:50+00:00\",\"dateModified\":\"2014-12-03T09:14:10+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form\"},\"wordCount\":938,\"commentCount\":9,\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg\",\"articleSection\":[\"Sysadmin and AOL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form\",\"url\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form\",\"name\":\"Oracle apps Attachment Functionality\",\"isPartOf\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage\"},\"thumbnailUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg\",\"datePublished\":\"2011-04-17T08:00:50+00:00\",\"dateModified\":\"2014-12-03T09:14:10+00:00\",\"description\":\"Attachment feature enables users to link files like images, word files, emails, e.t.c to a particular form\/function\/record.\",\"breadcrumb\":{\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage\",\"url\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg\",\"contentUrl\":\"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/erpschools.com\/erps\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Oracle Attachment Functionality\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/erpschools.com\/erps\/#website\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"name\":\"erpSchools\",\"description\":\"Oracle Apps\",\"publisher\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/erpschools.com\/erps\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/erpschools.com\/erps\/#organization\",\"name\":\"erpSchools\",\"url\":\"https:\/\/erpschools.com\/erps\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"contentUrl\":\"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png\",\"width\":250,\"height\":60,\"caption\":\"erpSchools\"},\"image\":{\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/facebook.com\/erpschools\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512\",\"name\":\"Prudhvi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g\",\"caption\":\"Prudhvi\"},\"sameAs\":[\"http:\/\/www.erpschools.com\"],\"url\":\"https:\/\/erpschools.com\/erps\/author\/prudhvi\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Oracle apps Attachment Functionality","description":"Attachment feature enables users to link files like images, word files, emails, e.t.c to a particular form\/function\/record.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form","twitter_misc":{"Written by":"Prudhvi","Est. reading time":"6 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#article","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form"},"author":{"name":"Prudhvi","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512"},"headline":"Oracle Attachment Functionality","datePublished":"2011-04-17T08:00:50+00:00","dateModified":"2014-12-03T09:14:10+00:00","mainEntityOfPage":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form"},"wordCount":938,"commentCount":9,"publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"image":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg","articleSection":["Sysadmin and AOL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#respond"]}]},{"@type":"WebPage","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form","url":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form","name":"Oracle apps Attachment Functionality","isPartOf":{"@id":"https:\/\/erpschools.com\/erps\/#website"},"primaryImageOfPage":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage"},"image":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage"},"thumbnailUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg","datePublished":"2011-04-17T08:00:50+00:00","dateModified":"2014-12-03T09:14:10+00:00","description":"Attachment feature enables users to link files like images, word files, emails, e.t.c to a particular form\/function\/record.","breadcrumb":{"@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#primaryimage","url":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg","contentUrl":"http:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/1809_oracle_attachments-1.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/erpschools.com\/erps\/sysadmin-and-aol\/oracle-attachment-functionality-adding-an-attachment-to-a-form#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/erpschools.com\/erps"},{"@type":"ListItem","position":2,"name":"Oracle Attachment Functionality"}]},{"@type":"WebSite","@id":"https:\/\/erpschools.com\/erps\/#website","url":"https:\/\/erpschools.com\/erps\/","name":"erpSchools","description":"Oracle Apps","publisher":{"@id":"https:\/\/erpschools.com\/erps\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/erpschools.com\/erps\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/erpschools.com\/erps\/#organization","name":"erpSchools","url":"https:\/\/erpschools.com\/erps\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/","url":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","contentUrl":"https:\/\/erpschools.com\/erps\/wp-content\/uploads\/img\/erps_logo7.png","width":250,"height":60,"caption":"erpSchools"},"image":{"@id":"https:\/\/erpschools.com\/erps\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/facebook.com\/erpschools"]},{"@type":"Person","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/dbed9bb7fb66aa7a700fc565da024512","name":"Prudhvi","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/erpschools.com\/erps\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/488cec3605845b95cb20e60c67a8f5c7e74b65a305525c8006315d524f120db9?s=96&d=blank&r=g","caption":"Prudhvi"},"sameAs":["http:\/\/www.erpschools.com"],"url":"https:\/\/erpschools.com\/erps\/author\/prudhvi"}]}},"_links":{"self":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1809","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/comments?post=1809"}],"version-history":[{"count":0,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/posts\/1809\/revisions"}],"wp:attachment":[{"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/media?parent=1809"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/categories?post=1809"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/erpschools.com\/erps\/wp-json\/wp\/v2\/tags?post=1809"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}