Movement Statistics Processor Doesn't Fill CUSTOMER_VAT_NUMBER In Mtl_movement_statistics
(Doc ID 2500789.1)
Last updated on JUNE 27, 2023
Applies to:
Oracle Inventory Management - Version 12.2.7 and laterInformation in this document applies to any platform.
Symptoms
ACTUAL BEHAVIOR
Users have observed that Movement Statistics Processor doesn't populate CUSTOMER_VAT_NUMBER in mtl_movement_statistics table.
TAX_REFERENCE is filled for customer site (tax profile) .
EXPECTED BEHAVIOR
Users expect to receive a fix for the current records where CUSTOMER_VAT_NUMBER is not populated.
STEPS
The issue can be seen with SQL like this:
select
mms.CUSTOMER_VAT_NUMBER ,mms.*
from
mtl_movement_statistics mms
where 1=1
--and mms.movement_amount = mms.stat_ext_value
and mms.DOCUMENT_SOURCE_TYPE = 'SO'
order by mms.MOVEMENT_ID
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |