Is it possible to view the code for FUSION.AP_APINVAGE_XMLP_PKG?

Question

Ran the Supplier Balance Aging Report and encountered this error:

ORA-06510: PL/SQL: unhandled user-defined exception ORA-06512: at "FUSION.AP_APINVAGE_XMLP_PKG", line 797 ORA-06512: at line 4

MandeepGupta · Answer

https://community.oracle.com/products/oracleanalytics/discussion/23866/is-it-possible-to-view-the-code-for-fusion-ap-apinvage-xmlp-pkg

You can't view the package as such. Only option is to raise an SR with support and see if you can get some information around it.

Thanks.

Mallikarjuna Kuppauru-Oracle · Answer

Hi @Czarina Morales

I would suggest you to follow below -

1. Execute the report from Scheduled Process and view the parameters required.

2. Once the report ends review the output section for the report and download the XML data.

3. The XML data will show all the parameters passed and their values.

4. Use that parameters directly in the execution for the report in OTBI

5. Run successfully.

Regards,

Arjun