1 Reply Latest reply on Mar 19, 2015 5:54 PM by Hussein Sawwan-Oracle

    ORACLE error 6550 in FDPSTP

    Naveen Prasad

      So we have a scheduled concurrent program that's been working w/o any errors until lately. I'm passing only one parameter to the database procedure. From the requests completed where it erred out, (View Details) it shows that value for that parameter followed by a large number of commas. Here's the snapshot from the View Log and a screen shot of the View Details. We haven't done any updates to the Database package, the Concurrent program definition or the executable. Any ideas? The error is clear from below, but the cause isn't.

       

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

      Payables: Version : 12.0.0

       

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

       

      SMC_IVALUA_OK_TO_PAY module: SMC IVALUA - OK TO PAY

       

      Current system time is 18-MAR-2015 18:45:00

       

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

       

      **Starts**18-MAR-2015 18:45:00

      ORACLE error 6550 in FDPSTP

       

      Cause: FDPSTP failed due to ORA-06550: line 1, column 7:

      PLS-00306: wrong number or types of arguments in call to 'SMC_OK_TO_PAY'

      ORA-06550: line 1, column 7:

      PL/SQL: Statement ignored

       

      .+---------------------------------------------------------------------------+

       

      The SQL statement being executed at th

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

      Start of log messages from FND_FILE

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

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

      End of log messages from FND_FILE

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

      Successfully resubmitted concurrent program SMC_IVALUA_OK_TO_PAY with request ID 17819860 to start at 19-MAR-2015 18:45:00 (ROUTINE=AFPSRS)

       

       

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

      Executing request completion options...

       

      Output file size:

      0

       

      +------------- 1) PRINT -------------+

      Disabling requested Output Post Processing. Nothing to process. The output of the request is zero byte.

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

       

      +------------- 2) NOTIFY -------------+

      Sending notification to HZ_PARTY:256729.

      Notification ID is 1470184.

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

       

      +------------- 3) NOTIFY -------------+

      Sending notification to HZ_PARTY:168543.

      Notification ID is 1470185.

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

       

       

      Finished executing request completion options.

       

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

      Exceptions posted by this request:

      Concurrent Request for "SMC IVALUA - OK TO PAY" has completed with error.

       

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

      Concurrent request completed

      Current system time is 18-MAR-2015 18:45:02

       

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

      Prod Error Snapshot.jpg

       

      Thanks, Naveen!