BI Publisher (MOSC)

MOSC Banner

BIP 11g Functions not appearing for DB Default Package in event trigger

edited Oct 17, 2011 1:15AM in BI Publisher (MOSC) 14 commentsAnswered ✓
Hi Kevin!
I'm baaaaack!  LOL

I'm attempting to utilize my first Event Trigger in BIP (11.1.1.5), but I am unable to see my function in the Event Trigger screen.

I have the following defined:

In Oracle, created package:

CREATE OR REPLACE PACKAGE APPS.ALKS_PO_PLACEMENT_METRIC_PKG AUTHID CURRENT_USER
AS

PROCEDURE POPULATE_TABLE_PROC(P_AGENT_ID IN NUMBER, P_START_DATE DATE);

FUNCTION TEST_FUNC RETURN NUMBER;

END ALKS_PO_PLACEMENT_METRIC_PKG;


Also, created the package body.


In BIP, I added ALKS_PO_PLACEMENT_METRIC_PKG as the Oracle DB Default Package in the Data Model

Navigate to event Triggers,

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center