Transfer To GL Failed with ORA-01400: cannot insert NULL into (GL.GL_INTERFACE.SET_OF_BOOKS_ID") (Doc ID 1333959.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

Transfer to GL fails with

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01400: cannot insert NULL into ("GL"."GL_INTERFACE"."SET_OF_BOOKS_ID")
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_TRGL_PKG", line 1528
ORA-06512: at line 2

SQL_NO 3030
TABLE_NAME pay_trgl_pkg.trans_pay_costs_mt
APP-PAY-06881: Error ORA-01400: cannot insert NULL into ("GL"."GL_INTERFACE"."SET_OF_BOOKS_ID")
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1120
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_TRGL_PKG", line 1528
ORA-06512: at line 2
has occurred in table pay_trgl_pkg.trans_pay_costs_mt at location 3030

 

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