Receivables Billing History Extract - Unable to add custom parameter in BIP Data model — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Receivables Billing History Extract - Unable to add custom parameter in BIP Data model

edited Jun 6, 2025 6:43AM in Receivables & Collections 2 comments

Hello Experts,

We have a requirement to add an extra parameter (Customer class) to the seeded report - Billing History Report.

Data Model Path - /Shared Folders/Financials/Receivables/Billing/Data Models/BillingHistoryExtractDm

Once the custom parameter is added, running the data model in preview mode gives below error

ORA-06550: line 2, column 24: PLS-00302: component 'NEW_PARAMETER_21' must be declared ORA-06550: line 2, column 1: PL/SQL: Statement ignored https://docs.oracle.com/error-help/db/ora-06550/

The reason for this error seems to be the event triggers that are invoking a PL SQL procedure, which in feeding the where clause.

Please advice how to modify this report to add an extra custom parameter

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!