My Oracle Support Banner

Will Demantra Shipment Collection Collect The Sales With Missing Ordered_item From Table oe_order_lines_all, Column ordered_item is missing (Doc ID 886643.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle Demantra Demand Management - Version 7.2 and later
Information in this document applies to any platform.


Customer have bunch of of sale orders which are migrated into Oracle using data convention. In
oe_order_lines_all table, ordered_item corresponding these sales order lines are missing but
inventory_item_id is populated and ordered_item_id and ordered_item are null. Will Demantra collection of shipment and booking history still collect these sales order lines?

Customer have bunch of fields with null data in oe_order_lines_all table for those sales
orders migrated from legacy system. Which fields in oe_order_lines_all table the Demantra shipment collection will look for? In other words, which fields in oe_order_lines_all table must be populated for Demantra Shipment collection to collect this particular sales order line?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.