My Oracle Support Banner

Columns on the Table RDC01.SVC_ITEM_MASTER_CFA_EXT have Incorrect Number Type (no decimals) (Doc ID 2862444.1)

Last updated on APRIL 13, 2022

Applies to:

Oracle Retail Merchandising System - Version 19.0.1 and later
Information in this document applies to any platform.

Symptoms

Columns on the table RDC01.SVC_ITEM_MASTER_CFA_EXT which the DCA tool uses do not have the correct data type. They have been assigned with 0 scale and so do not support decimals but the base table rms01.ITEM_MASTER_CFA_EXT does support decimals.

As a result of this data which contains decimals, when loaded loses the decimal data and as a result is incorrect.

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.