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!

GL period open status "Error"

Discussion in 'Oracle Financials' started by nsk1971, Apr 2, 2012.

  1. nsk1971

    nsk1971 Active Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    100
    Dear Guru's,

    While opening the GL Period, the status is shown as completed with error. (in Red Color).. Could u please explain how to solve this issue..

    Thanks in advance.

    Shankar Ganesh
     
  2. Ramji

    Ramji Forum Guru

    Messages:
    534
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Shankar Ganesh,

    Simples!!!!!!!!! Get the log file of the request and upload to your post. I will take a look and tell you how to go about it.
    Ramji
     
  3. nsk1971

    nsk1971 Active Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    100
    Dear Ramji,

    These are the log file details which mentioned below for your reference.


    +---------------------------------------------------------------------------+
    General Ledger: Version : 11.5.0 - Development

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

    GLOOAP module: Open Period
    +---------------------------------------------------------------------------+

    Current system time is 17-APR-2012 15:33:50

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


    >> main() 17-APR-2012 15:33:50
    Set_of_books_id = 1
    Chart_of_accounts_id = 101
    Application_id = 101
    execution_mode = P
    User_name = OPERATIONS
    Request_id = 2727418
    Login_id = 2484702
    SHRD0181: glooap() - request_data_value =

    >> gllock() 17-APR-2012 15:33:50
    SHRD0118: Updated 1 record(s) in table: GL_CONCURRENCY_CONTROL
    SHRD0181: glooap - Lock Name = GL_OPEN_POST_1

    >> gludlk() 17-APR-2012 15:33:51

    << gludlk() 17-APR-2012 15:33:51

    << gllock() 17-APR-2012 15:33:51
    SHRD0180: gltmai - Performing action >> Placed EXCL_MODE lock...

    >> glopcs() 17-APR-2012 15:33:51
    OOAP0010: Please define Calendar Periods before opening them.

    <x glopcs() 17-APR-2012 15:33:51
    *****************************************************
    sqlcaid: sqlabc: 0 sqlcode: 1403 sqlerrml: 25
    sqlerrmc:
    ORA-01403: no data found

    sqlerrp: sqlerrd: 0 0 0 0 0 538976288
    sqlwarn: sqltext:
    *****************************************************

    oracaid: oracabc: 0
    oracchf: 0 oradbgf: 0 orahchf: 0 orastxtf: 0 orastxtl: 0
    orastxtc:

    orasfnmc: oraslnr: 0 orasfnml: 0
    orahoc: 100 ormoc: 6 oracoc: 5
    oranor: 0 oranpr: 8 oranex: 8

    SHRD0015: glopcs failed:
    SHRD0033: Error Status: 0
    SHRD0103: Function warning number: -1
    *****************************************************
    SHRD0044: Process logging off database and exiting ...

    <x gluccf() 17-APR-2012 15:33:51


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


    Output is not being printed because:
    The print option has been disabled for this report.


    Finished executing request completion options.
    Concurrent program returned no reason for failure.

    +---------------------------------------------------------------------------+
    Exceptions posted by this request:
    Concurrent Request for "Open Period" has completed with error.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 17-APR-2012 15:33:52

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


    Thanks and Regards.

    Shankar Ganesh
     
  4. Ramji

    Ramji Forum Guru

    Messages:
    534
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    My Friend,

    Query the Calendar and define new periods. Open the latest period and start processing. Once done update us. You can open a bottle of wine after getting a bottle. Else its a waste of time.
    cheers
    Ramji
     
  5. nsk1971

    nsk1971 Active Member

    Messages:
    26
    Likes Received:
    0
    Trophy Points:
    100
    Dear Ramji,

    I queried the Accounting Calender, and define new periods, while validating the request, it is completed with warning (yellow color).

    I have given below the log details:

    +---------------------------------------------------------------------------+
    General Ledger: Version : 11.5.0 - Development

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

    GLXCLVAL module: Other - Calendar Validation Report
    +---------------------------------------------------------------------------+

    Current system time is 17-APR-2012 16:05:47

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


    +-----------------------------
    | Starting concurrent program execution...
    +-----------------------------

    Arguments
    ------------
    P_SET_OF_BOOKS_ID='1'
    P_PERIOD_SET='ALL'

    ------------

    APPLLCSP Environment Variable set to :

    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.UTF8

    ''''

    LOG :
    Report: e:\oracle\visappl\gl\11.5.0\reports\US\GLXCLVAL.rdf
    Logged onto server:
    Username:


    LOG :
    Logged onto server:
    Username: APPS





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


    Output is not being printed because:
    The print option has been disabled for this report.


    Finished executing request completion options.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 17-APR-2012 16:05:56

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

    Thanks and Regards.

    Shankar Ganesh
     
  6. Ramji

    Ramji Forum Guru

    Messages:
    534
    Likes Received:
    177
    Trophy Points:
    1,505
    Location:
    Nomad
    Dear Shankar Ganesh,

    Are you able to process transactions in the latest open period. I do not think this message will make any difference. Warning messages for environment variables is absolutely fine.
    cheers
    Ramji
     
  7. rnacario

    rnacario Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    Metro Manila Philippines
    While opening the GL Period, the status is shown as completed with error. anyone can help me to solve this error

    please find attached file

    thank you
     

    Attached Files: