TRANSGL - Transfer to GL Of Costing Of Payments, Errors: ORA-01008: Not All Variables Bound (Doc ID 738225.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Payroll - Version 11.5.10.2 to 12.1.2 [Release 11.5 to 12.1]
Information in this document applies to any platform.
ConcurrentProgram:TRANSGL - Transfer to GL



This note provides a brief overview of


Symptoms

Problem Statement:

Find that when executing the Transfer to GL process that it fails with the following error:


HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-01008: not all variables bound
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_TRGL_PKG", line 1219
ORA-06512: at line 2

SQL_NO 3030
TABLE_NAME pay_trgl_pkg.trans_pay_costs_mt
APP-PAY-06881: Error ORA-01008: not all variables bound
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_TRGL_PKG", line 1219
ORA-06512: at line 2 has occurred in table pay_trgl_pkg.trans_pay_costs_mt at location 3030

Cause: an oracle error has occurred. The failure was reported on table pay_trgl_pkg.trans_pay_costs_mt at location 3030 with the error text ORA-01008: not all variables bound
ORA-06512: at "SYS.DBMS_SYS_SQL", line 1204
ORA-06512: at "SYS.DBMS_SQL", line 323
ORA-06512: at "APPS.PAY_TRGL_PKG", line 1219
ORA-06512: at line 2


.

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