1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

how to unlock the GL open/close Periods..Lock established during simultaneous requsts

Discussion in 'Oracle Financials' started by naresh5430, May 7, 2014.

  1. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Hi please provide info. on how to resolve this issue.

    While running simultaneous concurrent programs on opening periods,GL has locked the open/close periods

    gllock() 08-MAY-2014 12:20:51
    SHRD0118: Updated 1 record(s) in table: GL_CONCURRENCY_CONTROL
    SHRD0181: glooap - Lock Name = GL_OPEN_POST_1

    >> gludlk() 08-MAY-2014 12:20:51

    << gludlk() 08-MAY-2014 12:20:51

    << gllock() 08-MAY-2014 12:20:51
    SHRD0180: gltmai - Performing action >> Placed EXCL_MODE lock...

    >> glopcs() 08-MAY-2014 12:20:51
    OOAP0010: Please define Calendar Periods before opening them.
     
  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: how to unlock the GL open/close Periods..Lock established during simultaneous req

    Hi,

    Where you tried to open periods?
     
  3. weeangj

    weeangj Active Member

    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    75
    Re: how to unlock the GL open/close Periods..Lock established during simultaneous req

    Hi,

    The error message seem to refer to the calender not being setup, you might want to check
    on that. Might be on the future period.

    Regards
     
  4. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Re: how to unlock the GL open/close Periods..Lock established during simultaneous req

    yes ..What should I do now?
     
  5. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: how to unlock the GL open/close Periods..Lock established during simultaneous req

    Then first define period in calendar then open it...
     
  6. naresh5430

    naresh5430 Active Member

    Messages:
    9
    Likes Received:
    0
    Trophy Points:
    55
    Re: how to unlock the GL open/close Periods..Lock established during simultaneous req

    Donot know how to do it..could u plse provide the navigations
    if I did so,whether the lock will be opened automatically?
     
  7. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Re: how to unlock the GL open/close Periods..Lock established during simultaneous req

    Hi Naresh,

    Go to GL Responsibility

    Navigation
    ----------

    Setup --> Financials --> Calendars --> Accounting

    Here Query your Existing Calendar, then add Period in lines which you want open.