Default Package name for HCM pl/sql

Question

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?

Gianni Ceresa · Answer

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

Raerae · Answer

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

Mallikarjuna Kuppauru-Oracle · Answer

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