2 Replies Latest reply on Sep 18, 2017 3:15 AM by 1567114

    ORACLE error 1861 in FDPSTP (Running a Concurrent Program)

    1567114

      Hello,

       

      I had a Package Defined as :

       

      CREATE OR REPLACE PACKAGE APPS.XXA_TEST_ORACLE_INTG

      AS

        PROCEDURE XXA_JSON_CALL_STG

        (

         errbuf         OUT VARCHAR2,

         retcode        OUT NUMBER,

         p_pass_date   IN DATE

         );

       

        PROCEDURE XXA_ITEM_IMPORT(p_item_date IN DATE);

      END;

      /

       

      I registered a Concurrent program as:

       

       

      But when running the Concurrent program giving Error as:

       

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

       

      **Starts**17-SEP-2017 19:24:29

      ORACLE error 1861 in FDPSTP

       

      Cause: FDPSTP failed due to ORA-01861: literal does not match format string

      ORA-06512: at line 1