Search 800 + Posts

Feb 28, 2010

Duplicate data on Oracle oe_drop_ship_sources

This Post is about Oracle Apps Drop Ship Sales Order.

Why I have duplicate data in oe_drop_ship_sources.answer is simple, for a drop ship sales order when I book Sales Order in Oracle Apps, Oracle workflow for order line progress to p\Purchasing - deferred activity.once we execute the WBP it insert the data into Oracle Requisition Interface Table ( to Create Requisition and Purchase Order).NOW
1. Some how if user rewind the order line workflow to an activity before purchasing -deferred and delete the data from Req interface .in such cases workflow when got progressed to purchasing -deferred,it will again insert data in oe drop ship sources.

- Posted using BlogPress