Triggers in PeopleSoft

Question

Can we create triggers in PeopleSoft when running Peoplesoft App Engine?

We want to create triggers for some tables based on the selection at the time of App Engine

Thanks in advance

score 2 · Answer 1 · answered Jan 17 '17 at 13:24

Take a look at the %Execute function to execute multiple sql statements or an pl/sql block from an AE program. This way you could create a trigger in an AE Program.

Documentation can be found in the Oracle PeopleBooks here: https://docs.oracle.com/cd/E55243_01/pt854pbr0/eng/pt/tape/langref_UsingApplicationEngineMeta-SQL-0771d9.html#topofpage

score 1 · Answer 2 · answered Aug 10 '20 at 08:58

1

yes you can do that. you can create a trigger on insert on PSPRCSRQST table, you will have process name in prcsname field, capture and do what ever you want

answered Aug 10 '20 at 08:58

Rahul Agrawal

31
3

Triggers in PeopleSoft

2 Answers2