Movement Statistics exception CUSTOMER_VAT_NUMBER (Doc ID 577273.1)

Last updated on NOVEMBER 30, 2015

Applies to:

Oracle Inventory Management - Version 11.5.10 and later
Information in this document applies to any platform.
INVSMDRB.pls
INVTTMVT.fmb

Symptoms

Movement Statistics Exception Report has returned a "Missing/Incorrect Trading Partner VAT Number" error (movement 5020).

User then populates a VAT number against the corresponding Customer Bill To site and returns to Movement Statistics records. User tries to validate movement record using Tool>Validate option but error message remains.

There is no field on the Movement Detail form to populate the Trading Partner VAT Number. How can these exceptions be resolved ?

Table MTL_MOVEMENT_STATISTICS includes a column: CUSTOMER_VAT_NUMBER which is populated by the Movement Statistics Processor with the value in the 'Tax Registration Number' field on the customer's Account Bill-to Site. If a user has failed to enter a 'Tax Registration Number' value on the bill to site, the column will be null for any movement created for that customer Bill-to. The user would then need to correct the movement record and would normally do so using the
Inventory Superuser>Transactions>Movement Statistics form. However there is no field on that form which allows the user to update the null value for a movement record. How does a user maintain/correct information held in this table?

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms