Error - Unable To Save New Entry In Define Budget Transaction Types. Cannot Insert Null Into FV_BE_TRX_SUB_RTPES Error

(Doc ID 2008923.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version or Higher, Federal Setup

Cannot insert null into fv_bE_trx_sub_types error

On the Form "Define Budget Transaction Types", receive following error:
ORA-1400: cannot insert NULL into ("FV"."FV_BE_TRX_SUB_TYPES"."DEFAULT_FLAG")
FRM-40508: ORACLE error: unable to INSERT record.

Workaround: Uncheck "Default" and "Enabled" checkboxes. Save. Re-check "Default" and "Enabled" and save again. Error will not appear.
Also, once the error is bypassed with the workaround, subsequent records can be created without receiving the error as long as the form is not closed. Closing and re-opening the form will result in the same error until the workaround is used.

ERROR
-----------------------
ORA-01400. FRM-40508

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigation: Federal Administrator Responsibility -> Budgets -> Define -> Transaction Types
2. Create Transaction Type Header. Next create Transaction Sub Type. When attempting to save or click on accounts button, the error is received.

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