Doc_number Column length is not consistent across FV tables (Example: FV_BE_INTERFACE) (Doc ID 2232619.1)

Last updated on FEBRUARY 10, 2017

Applies to:

Oracle U.S. Federal Financials - Version 12.2.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.3 version, Federal Setup

ACTUAL BEHAVIOR
---------------
There is a DISCREPANCY in the DOC_NUMBER column size on the following tables. They are not uniform with each other.

FV_BE_TRX_HDRS table has doc_number column of length 30 varchar

Where as fv_be_rpr_transactions , fv_be_interface_history and FV_BE_INTERFACE table's doc_number column is only 20

EXPECTED BEHAVIOR
-----------------------
The Doc_Number column should be the same on all the FV Tables.



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