XLABAOPE: Open Period Balances – Unsuccessful

With Oracle GL – Version: 12.1.3

When attempting to Run Open Period Balances  the following error occurs.

Opening SLA Period Balances
There is no record in xla_ledger_options for ledger 3
Unsuccessful

The issue can be reproduced at will with the following steps:
– Open GL Period
– System will run Open Period Balances program
– Open Period balance completes with “Completed / Warning”

This is caused by ‘null’ in EFFECTIVE_PERIOD_NUM column  in  xla_ledger_options table

To resolve the issue apply the patch and pre-requisites for Patch.9524997R12.XLA.B

Sample concurrent logfile with “Completed / Warning” status:

+---------------------------------------------------------------------------+
Subledger Accounting: Version : 12.0.0

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

XLABAOPE module: Open Period Balances
+---------------------------------------------------------------------------+

Current system time is 04-OCT-2011 15:37:37

+---------------------------------------------------------------------------+

**Starts**04-OCT-2011 15:37:37
**Ends**04-OCT-2011 15:37:37
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
p_ledger_id: 2047
p_effective_period_num: 20100012
Opening SLA Period Balances
There is no record in xla_ledger_options for ledger 2047
Unsuccessful
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+


+---------------------------------------------------------------------------+
Executing request completion options...

Output file size: 
0


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 04-OCT-2011 15:37:37

+---------------------------------------------------------------------------+
Advertisements

About this entry