Monday, October 23, 2017

How To Identify If A Sales Order Is Created Via the Form or Order Import?

By checking the ORDER_SOURCE_ID at the header level(OE_ORDER_HEADERS_ALL table) we can come to know whether the order is entered via the Sales Order Form or imported via the Order Import Concurrent Process.

If the order is created online the value for order_source_id should be '0'.


No comments:

Post a Comment

Query to get Parent and Child Accounts in Oracle APPS R12

SELECT ffv1.flex_value parent_account       ,ffvt1.description parent_account_desc   ,ffv2.flex_value child_account   ,ffvt2.description...