Skip to Main Content

Oracle Analytics Cloud

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

How to Access PL/SQL Procedure in BIP report in Oracle FUSION

user-drbn7Aug 24 2023

Hi,
I have a BI Publisher Report handed to me by the client that requires Editing. Everything is working fine and I am able to change but there is a package with name ZX_REP_FIN_TAXREGISTER in the report that requires a change.
This package is controlling how parameters are passed and I am required to change the package to allow multi values being passed to it.
While trying Reporting options for the parameter as soon as I try Enable "All" and run it the report errors out with Error: ORA-06502: PL/SQL: numeric or value error: character string buffer too small ORA-06512: at line 3. So next I tried disabling All and only enabling Allow Multiple and select a few then again it error's out.

Requesting assistance to eb able to view the package and edit it

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked by Renae Stout-Oracle on Jul 8 2024
Added on Aug 24 2023
0 comments
1,451 views