Results 1 to 6 of 6

Thread: error in reports while running in apps

  1. #1
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    error in reports while running in apps

    Hi, while running reports in oracle applications ,i also defined a value set with parameters. Moreover i have defined the correct mask for the date field in the properties of report & i got the following errors: appllcsp environment variable set to:current nls_lang and nls_numeric_characters environment variables are: american_america.utf8 '.,' err rep-0613 : value does not match mask 'dd-mon-rr' ora-018161 :literal does not match format string program exited with status 3 can any body solve my problem. Cause: program terminated,returning status code 3.


  2. #2
    Junior Member
    Join Date
    Aug 2007
    Answers
    2

    Re: error in reports while running in apps

    Hi please try this
    Give intial mask for date as like this ' DD-MON-RR HH24:MI:SS'.
    Tell me... after trying this


  3. #3
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    Re: error in reports while running in apps

    Quote Originally Posted by shravanam View Post
    Hi please try this
    Give intial mask for date as like this ' DD-MON-RR HH24:MI:SS'.
    Tell me... after trying this


    thanks shravanam ,
    I tried it ,but no use the same error comes.i think the problem lies in declaring the value set.i have to declare the data type for the date field as standard date only instead of date data type.if u know anything ,pls do tell me.


  4. #4
    Junior Member
    Join Date
    Aug 2007
    Answers
    2

    Re: error in reports while running in apps

    Forgotten to ask you which value set u r using? I think u r using FND_DATE VALUE SET. If thats so change that one to FND_STANDARD_DATE or else create a custom value set and attach it to that parameter


  5. #5
    Junior Member
    Join Date
    Oct 2007
    Answers
    10

    Re: error in reports while running in apps

    hi shravanam,
    iam using fnd_standard_date only,becoz whenever i select fnd_date the system urges me to select fnd_standard_date only.so, i have selected fnd_standard_date only.


  6. #6
    Junior Member
    Join Date
    Jan 2008
    Answers
    1

    Re: error in reports while running in apps

    Quote Originally Posted by syedrafi123 View Post
    Hi, while running reports in oracle applications ,i also defined a value set with parameters. Moreover i have defined the correct mask for the date field in the properties of report & i got the following errors: appllcsp environment variable set to:current nls_lang and nls_numeric_characters environment variables are: american_america.utf8 '.,' err rep-0613 : value does not match mask 'dd-mon-rr' ora-018161 :literal does not match format string program exited with status 3 can any body solve my problem. Cause: program terminated,returning status code 3.
    Did you get any update on this?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact