Oracle Analytics Publisher

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Default Package name for HCM pl/sql

Received Response
42
Views
3
Comments
Raerae
Raerae Rank 1 - Community Starter

I want to add an event trigger based on an pl/sql function on the HCM table in BI data model. Where can I find the package names?

Answers

  • Mallikarjuna Kuppauru-Oracle
    Mallikarjuna Kuppauru-Oracle Rank 8 - Analytics Strategist

    Hi @Raerae

    By default default package filed is Null. But you can set using below -

    data model Properties pane, enter the Oracle DB Default Package that contains the PL/SQL function signature to execute when the trigger fires

    or

    https://docs.oracle.com/middleware/12211/bip/BIPDM/GUID-BBCC37B1-40CD-43C0-BD8C-2BE095F49EAC.htm#BIPDM332

    You can follow above navigation to see the available package and select the required and move to right side box.

    Regards

    Arjun

  • Raerae
    Raerae Rank 1 - Community Starter
    edited June 10

    Your answer does not answer my question but only points me to how to add event triggers from a package. I want a list of pl/sql functions from HCM that can be added as triggers. From what i have learnt so far, oracle does not allow us to define pl/sql functions on the hcm tables so I wanted to know if there are seeded functions that triggers when an hcm table changes so that i can use it in my bi report model

  • Your question seems to be more on the HCM data model, tables and operations there inside than Publisher as a product.

    You maybe want to consider asking in a HCM forum for that: https://community.oracle.com/customerconnect