My Oracle Support Banner

Fusion Applications BI Publisher : Custom Database Package is not accessible from BI Publisher Event Trigger dialog (Doc ID 2036078.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Fusion Global Human Resources - Version 11.1.8.0.0 and later
Oracle Fusion Application Toolkit - Version 11.1.8.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.1.8.0.0 version, Technology Management - BI & Reporting

ACTUAL BEHAVIOR
---------------
When building a custom data model we are looking to make calls to a custom database package which we have added to the XXHR schema. The appropriate grants and synonyms have been created to provide access via FUSION_RUNTIME schema but the 'Available Functions' dialog shows no packages or functions for the ApplicationDB_HCM datasource.

EXPECTED BEHAVIOR
-----------------------
We would expect to see a list of the available packages and functions from the target datasource which could then be selected for use in the data model.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. create a custom database package and issue execute grants to FUSION_RUNTIME
2. create a synonym in the FUSION schema providing access to the XXXHR.
3. create a new BI Publisher datamodel and set the datasource as ApplicationDB_HCM
4. set the custom XXHR. as the default package for the data model
5. create a beforereport EventTrigger and check the AvailableFunctions dialog, it will list no packages or functions

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use the custom package in their report development preventing the desired report creation

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.