Data Type Discrepancy for RTV_ORDER_NO Between RTV_HEAD and RTV_HEAD_CFA_EXT Tables
(Doc ID 2431066.1)
Last updated on AUGUST 02, 2018
Applies to:Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.
There is a difference of type for rtv_order_no between RTV_HEAD table (NUMBER(10)) and RTV_HEAD_CFA_EXT (NUMBER(8)).
Steps to Reproduce
The issue can be reproduced at will with the following steps:
1. Check the Data Type definitions in the RMS schema for the field, rtv_order_no for the tables RTV_HEAD and the RTV_HEAD_CFA_EXT.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!