Doc_number Column length is not consistent across FV tables (Example: FV_BE_INTERFACE)
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.
On : 12.2.3 version, Federal Setup
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
The Doc_Number column should be the same on all the FV Tables.
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