BI Publisher (MOSC)

MOSC Banner

Not able to add parameter to data model if package/trigger is used

edited May 28, 2025 12:59PM in BI Publisher (MOSC) 3 commentsAnswered

I am creating data model for BIP report.

I need to run Event triggers using this package - FA_FAWHTIF_XMLP_PKG.beforereport

This gives me the table variable which holds data - &l_fa_whatif_rep_t

However I need to add some addition parameters to better filter data in my report. I don't know why I am not able to add any new other parameters in my data model.

For the package/trigger these two parameters are required P_BOOK and P_REQUEST_ID. there are other 4 optional parameters also used by package (FA_FAWHTIF_XMLP_PKG.beforereport) which I can add but lets say I like to add parameter P_TEST it does not work and report gives error.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS BI Publisher Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center