R12: AP: Encumbrance Accounting Failed with ORA-01400 in GL_BC_PACKETS.SERIAL_ID
(Doc ID 2735182.1)
Last updated on DECEMBER 09, 2020
Applies to:Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
Encumbrance accounting fails. An FND Log shows the following error:
BCTRL -> Invoking populate_bc_pkts()
BCTRL -> ORA-01400: cannot insert NULL into ("GL"."GL_BC_PACKETS"."SERIAL_ID")
BCTRL -> populate_bc_pkts() failed.
BCTRL -> ERROR: FATAL.
BCTRL -> p_return_code -> T
BCTRL -> Return false
ERROR: PSA_FUNDS_CHECKER_PKG.budgetary_control failed
"-: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:
An internal error has occurred in the program xla_je_validation_pkg.budgetary_control. PSA_FUNDS_CHECK_PKG.budgetary_control failed."
"Error. = ORA-20001: -: XLA-95103: An internal error occurred. Please inform your system administrator or support representative that:
Another way to confirm this issue is with the following script:
select * from dba_tab_columns where table_name like 'GL_BC_PACKETS%'
order by owner, table_Name, column_id;
OWNER TABLE_NAME COLUMN_NAME COLUMN_ID
======= =========== ============= ==========
GL GL_BC_PACKETS SERIAL_ID 86
GL GL_BC_PACKETS# SERIAL_ID 81 <----This should match gl_bc_packets
GL GL_BC_PACKETS_HISTS SERIAL_ID 86
GL GL_BC_PACKETS_HISTS# SERIAL_ID 81 <----This should match gl_bc_packets_hist
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