VPD Not Applying On Shipment Order Release Line Analysis (Doc ID 2741144.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

For financial processing OTM will have bill (child) created in the same domain as the sell shipment. If a case where many child bills are consolidated into a parent bill for billing the total bundle to a customer, there could be a case where the parent bill domain is not created in the same domain
as the child bill. The action of consolidating the child bills into the parent bill, ends up creating the bill in the Parent domain. These Parent Bills must be allocated in order to create the data for reporting.

Due to this the ODI Cursor which selects the data should be changed to not take the domain from the allocation table for populating the F_SHIPMENT_ORD_REL_COST_D table, but rather the domain name from the shipment which the allocation relates to.

F_SHIPMENT_ORD_REL_COST_D.DOMAIN_NAME should map to SHIPMENT.DOMAIN_NAME in ETL

Changes

Cause

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