Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forum› Oracle Analytics Forum

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
21
Views
1
Comments
Shailender Ahuja-Oracle
Shailender Ahuja-Oracle Rank 2 - Community Beginner
in Oracle Analytics Forum

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