OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Cannot open GL opne next period

Home » Applications » Oracle Fusion Apps & E-Business Suite » Cannot open GL opne next period (Oracle 11.5.8 / AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Cannot open GL opne next period [message #630869]

Mon, 05 January 2015 23:40

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 289 times)

Report message to a moderator

Re: Cannot open GL opne next period [message #630874 is a reply to message #630869]

Tue, 06 January 2015 00:16

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

Report message to a moderator

Re: Cannot open GL opne next period [message #631173 is a reply to message #630874]

Fri, 09 January 2015 17:14

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';

Attachment: GL Open Period.jpg
(Size: 71.96KB, Downloaded 256 times)

Report message to a moderator

Re: Cannot open GL opne next period [message #631190 is a reply to message #631173]

Sat, 10 January 2015 01:45

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

Report message to a moderator

Re: Cannot open GL opne next period [message #631241 is a reply to message #631190]

Sun, 11 January 2015 07:33

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 15 20:58:21 CDT 2021