Movement Statistics Records Show FINANCIAL_DOCUMENT_FLAG Is MISSING Even Though Intercompany AP Invoices Are Available For Drop Ship Sales Orders (Doc ID 2912763.1)

Last updated on NOVEMBER 30, 2022

Applies to:

Symptoms

Movement Statistics records show FINANCIAL_DOCUMENT_FLAG as MISSING even though the invoices are available in the system. 
All orders are invoiced and closed.
 
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Inventory > Requests > Run ' Movement Statistics Processor' Program for Selling OU1
> Updated MVT_STAT_STATUS from 'NEW' to 'FORDISP 'for all the SO line id where Selling Legal Entity & Shipping Legal Entity in wsh_delivery_details table
2. Run 'Movement Statistics Processor' Program for Shipping OU
> Updated MVT_STAT_STATUS from 'FORDISP' to 'PROCESSED'
3. All transactions data inserted in MTL_MOVEMENT_STATISTICS , But see that for Selling Legal Entity > FINANCIAL_DOCUMENT_FLAG in movement statistics MISSING (Failed)

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.