Home » Applications » Oracle Fusion Apps & E-Business Suite » Cannot open GL opne next period (Oracle 11.5.8 / AIX)
Cannot open GL opne next period [message #630869] Mon, 05 January 2015 23:40 Go to next message
james3328
Messages: 4
Registered: December 2014
Junior Member
All other modules (AP, AR, PO, INV ...) can be opened period. only GL open next period doesn't work. Even though I click " open next period ", it still hang there.
  • Attachment: GL.jpg
    (Size: 256.46KB, Downloaded 1298 times)
Re: Cannot open GL opne next period [message #630874 is a reply to message #630869] Tue, 06 January 2015 00:16 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
How much time is it like that?
Is the ledger calender ends on Dec and starts with Jan?
In that case opening period has to calculate too many things in the balances. It might take time.
If possible, check with your DBA what is happened at the database level for this concurrent program.
It is not a good idea to terminate a concurrent program just like that.

By
Vamsi
Re: Cannot open GL opne next period [message #631173 is a reply to message #630874] Fri, 09 January 2015 17:14 Go to previous messageGo to next message
james3328
Messages: 4
Registered: December 2014
Junior Member
I have ran below command. What is the meaning of this result? please see upload file.

select * from GL_CONCURRENCY_CONTROL where concurrency_class='OPEN_PERIOD';
Re: Cannot open GL opne next period [message #631190 is a reply to message #631173] Sat, 10 January 2015 01:45 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
I really doubt this is relevant to your issue.
Moreover from ETRM, this table is for internal deadlock issues.
Also the last_update_date is 2014.

By
Vamsi
Re: Cannot open GL opne next period [message #631241 is a reply to message #631190] Sun, 11 January 2015 07:33 Go to previous message
james3328
Messages: 4
Registered: December 2014
Junior Member
Hello Vamsi,

How can I solve this deadlock issue?
As I know if "concurrency_entity_id is not = -1, it is something wrong. Should I just delete it and re-open the next period again?


Thank you
James

Previous Topic: Oracle Sourcing Difference between RFQ and Auction
Next Topic: Assignment Time Information
Goto Forum:
  


Current Time: Thu Mar 28 03:47:45 CDT 2024