How Sales Order Attachement can transfer or Copy to corresponding Dropship Purchase Order?

Hello..

Recently We migrated a Business Processes from Legacy JDE system to Oracle 11.5.10.x.

Business is using Drop shipments and had a requirement like the Sales Order attachment is created in Sales order form and it should be retrieved from PO form.

11.5.10.X version of Oracle we don't have this functionality as a standard process, upon further investigation & research i found this workaround.. But that will require Set up changes and Custom Code to implement  and to achieve this requirement.

Here is the following set up:

Choose the Application Object Library Resp > Attachment > Attachment Functions

1) In the attachment function search "Purchase Orders"(User Name) function.

2) Go to blocks, select block "PO_HEADERS".

3) Click on Entities;

Add a new entity "OM Order Header" with Display Method as "Main Entity".

·         In the      privileges make Query as "Always" and rest all as "Never".

·         In the primary key fields, put      "PO_HEADERS.ATTRIBUTE3" and save it.

NOTE: This means that in the "PO_HEADERS" , need to see the documents attached in "OM Order Header" and the primary key of "OM Order Header" in sales order form and purchase order form should match. In sales order its "ORDERS.HEADER_ID" and the corresponding field in purchase order is "PO_HEADERS.ATTRIBUTE3")

You can use any attribute till the time same is available.

We have to write some custom code to ensure the Attribute is getting populated with the Order_header_id.  Oracle will not populate this filed.

n  I remember I gather this info from oracle support. You feel helpful, pls leave a tiny comment that boosts my motive of sharing.