My Oracle Support Banner

Movement Statistics Processor Does Not Default Customer_Vat_Number In Mtl_movement_statistics When Defined At Customer Site Level (Doc ID 3028243.1)

Last updated on JUNE 11, 2024

Applies to:

Oracle Supply Chain Globalization - Version 12.2.12 and later
Information in this document applies to any platform.

Symptoms

Movement Statistics Processor doesn't populate CUSTOMER_VAT_NUMBER in mtl_movement_statistics table.
TAX_REFERENCE is filled for customer site (tax profile).
 
STEPS
1. Define Customer VAT number at customer site level as Default Reporting Registration Number.
2. Customer -> Site -> Tax Profile -> Default Reporting Registration Number

Alternatively, this can be done via:
3. Tax Managers -> Parties -> Party Tax Profiles > Party Type = Third Party Site
4. Update Tax Profile for the Site -> Tax Registrations -> Default Reporting Registration Number

5. Create and ship SO for this customer and site combination from a warehouse not in the same country as the customer.
6. Run Movement Statistics Processor for this transaction.  >  VAT number field is not populated in Movement statistics table .

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
Cause
Solution
References


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