1 Reply Latest reply: Sep 18, 2013 8:12 AM by Asif Muhammad RSS

    unable to generate the file report pdf on 29 february 2012 or during any leap year day...

    723f3a91-ab53-495f-84ae-ecc9a6887c90

      hii this is manab......

       

      sir/mam i have face the following error in 29 february 2012 for my overall company report .But i can easily get the

      report of another department on 29feb 2012....but when i try generate the overall report of my comapany then i find the errors

      REP-1401: 'cf_mc_prod_lyrformula': Fatal PL/SQL error occurred.

      ORA-01839: date not valid for month specified

       

       

      The following is the logfile.........

      ...........................................................................................log file................................................................................................................

      HPCL Custom Application: Version : UNKNOWN

       

       

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

       

       

      HPCCMDS module: HPC Modified CMD Report

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

       

       

      Current system time is 04-SEP-2013 11:37:20

       

       

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

       

       

       

       

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

      | Starting concurrent program execution...

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

       

       

      Arguments

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

      P_MILL='NPM'

      P_TRANSACTION_DATE='2012/02/29 00:00:00'

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

       

       

      Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :

      American_America.US7ASCII

       

       

      '.,'

       

       

      REP-1401: 'cf_mc_prod_lyrformula': Fatal PL/SQL error occurred.

      ORA-01839: date not valid for month specified

       

       

       

       

      Report Builder: Release 6.0.8.24.0 - Production on Wed Sep 4 11:37:20 2013

       

       

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

       

       

      Enter Username:

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

      Start of log messages from FND_FILE

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

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

      End of log messages from FND_FILE

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

      Program exited with status 1

      Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 11426643.

       

       

      Review your concurrent request log and/or report output file for more detailed information.

       

       

       

       

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

      Executing request completion options...

       

       

       

       

      Finished executing request completion options.

       

       

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

      Concurrent request completed

      Current system time is 04-SEP-2013 11:59:23

       

       

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

       

       

      kindly give me solution .....i have e-business suite 11i

      internet explorer latest version...