BI Publisher (MOSC)

MOSC Banner

SQL Script error: ORA-06553: PLS-306

edited Sep 30, 2019 10:36AM in BI Publisher (MOSC) 4 commentsAnswered ✓

Hi ,

I have problem with print invoice documents.

Problem with script:

ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_PRINT_TEMPLATE_NAME'

SELECT DISTINCT
       DECODE (
          :P_BURSTING,
          'Y', TO_CHAR (rct.customer_trx_id),
          'N', DECODE (
                  :P_EXECUTION_REPORT,
                  'Y', 'EXECUTION_REPORT',
                  'N', NVL (
                          JE_PRINT_COMMERCIAL_DOCS_PKG.get_print_template_code (
                             :P_PRINT_TEMPLATES_SET),
                          NVL (
                             JE_PRINT_COMMERCIAL_DOCS_PKG.get_print_template (
                                rct.customer_trx_id),
                             NULL)),
                  NULL),
          NULL)
          "KEY",
       DECODE (
          :P_BURSTING,
          'Y', :P_TEMPLATE,
          'N', DECODE (:P_EXECUTION_REPORT,
                       'Y','Execution Report',

                       'N', NVL (
          :P_PRINT_TEMPLATES_SET,
          JE_PRINT_COMMERCIAL_DOCS_PKG.get_print_template_name (

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center