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!

Concurrent Program Error

Discussion in 'Oracle Apps Technical' started by kiran.marla, Nov 8, 2013.

  1. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi ,

    When I submit a program from front end, the program ends with error leaving the attached log file.

    This occurred for so many times for 2 concurrent programs..

    Anybody faced this problem and figured it out ???
     

    Attached Files:

  2. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Kiran,
    Which parameters you gave while running that program?
     
  3. jagadekara

    jagadekara Forum Guru

    Messages:
    1,126
    Likes Received:
    145
    Trophy Points:
    1,805
    Location:
    Pulivendula
    Hi Kiran, If you go through that package(jai_ap_tds_processing_pkg) then you will find below info in package body.

    R12RUP03-ST1: INDIA - PROCESS TDS PAYMENTS GIVES ERROR MESSAGE WHILE SUBMITTING

    Probelem - After execution of Concurrent India TDS Payments , some concurrent execution
    error was coming - FDPSTP failed due to ORA-01861: literal does not match format string

    Solution - This problem was due to procedure process_tds_payments , Argument pd_tds_payment_from_date ,
    pd_tds_payment_to_date parameter was of date type , whcih we made it as varchar2 and
    create two variable with name ld_tds_payment_to_date ,ld_tds_payment_from_date

    replae all pd_tds_payment_from_date , pd_tds_payment_to_date with
    ld_tds_payment_from_date , ld_tds_payment_to_date with

    Hope this will help you....
     
  4. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    Thanks and I will let here know once I am done....
     
  5. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    I followed the steps as said in discussion... but the same error is coming.... trying other alternatives... will let know once I am done...
     
  6. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Jagadekara,

    As you said, Issue was with the date. Input date is of format RRRR/MM/DD HH24:MI:SS. and in the cursor given the parameter data type as date (DD-MON-RR) which is not compatible.

    so i made parameter data type as varchar2, and converted varchar2 data type to date data type using to_date in the program wherever necessary...

    Hence problem solved...

    Thanks Jagadekara...
     
  7. siva551

    siva551 Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    hi kiran could u plz send me the code of concurrent programs
     
  8. kiran.marla

    kiran.marla Forum Genius

    Messages:
    403
    Likes Received:
    52
    Trophy Points:
    505
    Location:
    Khammam
    Hi Siva,
    What program do you need ???
     
  9. siva551

    siva551 Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    75
    hi,
    i need the concurrent program code which u have done