Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Supplier Spend Analysis report fails with error ORA-06503: PL/SQL: Function returned without value

Accepted answer
14
Views
1
Comments
Shailender Ahuja-Oracle
Shailender Ahuja-Oracle Rank 2 - Community Beginner
in Oracle Analytics Cloud and Server

We are trying to run standard report Supplier Spend Analysis report, but as soon as we open the report, it tries to load and fails before we submit the report with error ORA-06503: PL/SQL: Function returned without value ORA-06512: at "FUSION.AP_GEN_SUPPLIER_SPEND_FILE_PKG", line 43 ORA-06512: at line 4.

Even if we submit the report, same error is retrieved.

This package is being called at before report trigger in oracle cloud.

Has anyone faced the same issue before?

Best Answer

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    This being the Oracle Analytics forum, it doesn't cover Fusion PL/SQL packages.
    And there are also not standard reports in OAC/OAS: both products are empty, you define reports, workbooks, analyses as you want, but there is nothing "standard".

    If you are using FDI, the question can be moved to appropriate category.

    If you are using Fusion, consider asking in the Fusion forum: https://community.oracle.com/customerconnect