ARGLTP General Ledger Transfer Program Errors Out with UNABLE TO ACQUIRE LOCKS

(Doc ID 1300942.1)

Last updated on JANUARY 15, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
Executable:ARGLTP - General Ledger Transfer Program

Symptoms

You run the ARGLTP General Ledger Transfer Program with these parameters:

Start Date: 2010/12/15
Post Through Date: 2010/12/15

But logfile shows different values:

Start Date: 03-NOV-99915-DEC-201 Post Through Date: 15-DEC-201

General ledger transfer  generating extremely large logfile even when only one gl_date is processed.

General ledger transfer  errors with :
UNABLE TO ACQUIRE LOCKS: cycle 2 Start Date: 19-JAN-20115-DEC-201
ORA-01841: (full) year must be between -4713 and +9999, and not be 0


Here is a sample excerpt of the ARGLTP General Ledger Transfer Program logfile


=====================================================
Parameters passed in:
Start Date: 2010/12/15 00:00:00
Start Date (used): 2010/12/15 00:00:00
Post through Date: 2010/12/15 00:00:00
Post through (used):2010/12/15 00:00:00
GL Posted Date: 2010/12/15 00:00:00
Report Only: N
Post In Summary: N
Run Journal Import: Y
Days per Cycle: 35
Posting Control Id: 752159
Debug Mode On: Y
Set of Books Id: 21
Processing type: ALL
===============================================================


===============================================================
Cycle 1 Start Date: 15-DEC-20115-DEC-201 Post Through Date: 15-DEC-201
---------------------------------------------------------------
Begin to lock records (nowait) for update...
UNABLE TO ACQUIRE LOCKS: cycle 1 Start Date: 15-DEC-20115-DEC-201 Post Through Date: 15-DEC-201
Pre argdat: Start Date: 15-DEC-10 Post Through Date: 15-DEC-10

***** argdat *****

===============================================================
Cycle 2 Start Date: 19-JAN-20115-DEC-201 Post Through Date: 15-DEC-201
---------------------------------------------------------------
Begin to lock records (nowait) for update...
UNABLE TO ACQUIRE LOCKS: cycle 2 Start Date: 19-JAN-20115-DEC-201 Post Through Date: 15-DEC-201
Pre argdat: Start Date: 15-DEC-10 Post Through Date: 15-DEC-10

***** argdat *****

<< this continues til cycle 83369 >>

***** argdat *****

===============================================================
Cycle 83369 Start Date: 03-NOV-99915-DEC-201 Post Through Date: 15-DEC-201
---------------------------------------------------------------
Begin to lock records (nowait) for update...
UNABLE TO ACQUIRE LOCKS: cycle 83369 Start Date: 03-NOV-99915-DEC-201 Post Through Date: 15-DEC-201
Pre argdat: Start Date: 15-DEC-10 Post Through Date: 15-DEC-10

***** argdat *****

Oracle error in function 'argdat'
AR-ARGLTP: -1841 ORA-01841: (full) year must be between -4713 and +9999, and not be 0



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