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!

Conc Program Warning when parameters not given

Discussion in 'Oracle Apps Technical' started by jagadekara, Feb 14, 2014.

  1. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi All,
    One of my friend running a concurrent program. If he give values to all parameters then the program completed normal. but when he ran the program with out values to those parameters, the program end with Warning status.
    All are optional parameters, He used nvl for all parameters.

    So can any one know about this?
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi

    Can you provide a logfile of that concureent Program?

    Regds
    Samba
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Thanks for reply,

    Here is the logfile...

    +---------------------------------------------------------------------------+
    XXXX Project Accounting: Version : UNKNOWN

    Copyright (c) 1989, 1998, Oracle Corporation. All rights reserved.

    XXX module: XXST Customer Invoice Review Report
    +---------------------------------------------------------------------------+

    Current system time is 14-FEB-2014 23:33:15

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


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

    Arguments
    ------------
    P_GL_DATE='2011/12/27 00:00:00'
    P_INV_CREATION_DATE='2011/12/27 00:00:00'
    ------------

    APPLLCSP Environment Variable set to :

    XML_REPORTS_XENVIRONMENT is :
    /appscode1/product/adev/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

    XENVIRONMENT is set to /appscode1/product/adev/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb


    Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
    American_America.UTF8

    '.,'


    Report Builder: Release 6.0.8.28.0 - Production on Thu Feb 14 23:33:15 2014

    (c) Copyright 1998 Oracle Corporation. All rights reserved.

    Enter Username:
    +---------------------------------------------------------------------------+
    Start of log messages from FND_FILE
    +---------------------------------------------------------------------------+
    +---------------------------------------------------------------------------+
    End of log messages from FND_FILE
    +---------------------------------------------------------------------------+


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

    +------------- 1) PUBLISH -------------+
    Beginning post-processing of request 42502538 on node CE08U8590 at 14-FEB-2014 23:33:15.
    Post-processing of request 42502538 failed at 14-FEB-2014 23:33:15 with the error message:
    One or more post-processing actions failed. Consult the OPP service log for details.
    +--------------------------------------+

    +------------- 2) PRINT -------------+
    Not printing the output of this request because post-processing failed.
    +--------------------------------------+


    Finished executing request completion options.

    +---------------------------------------------------------------------------+
    Concurrent request completed
    Current system time is 14-FEB-2014 23:33:15

    +---------------------------------------------------------------------------+
     
  4. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Any update on this?

    I tried many ways but i am not succeeded.
     
  5. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi Jagadekar,


    Run the concurrent program without providing any values to paramters then give that request's log file .

    Is it XMLP Report??



    Regds
    Samba
     
  6. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi,

    This problem solved. We used one lexical parameter in that report. In that, instead of giving 'And 1=1' we just gave '1=1'. so It goes to warning.