My Oracle Support Banner

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

Last updated on FEBRUARY 20, 2019

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

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.