+2I’m currently looking into if it is possible to take periodic backup of custom events.
The idea is to dump the Custom Events to disk, then use commit them to a git repository. If someone breaks a custom event, we can then easily go back to an earlier version.
I can read stored procedures and such from the database as SQL files, now I’d like to read out the events as well.
But I do not know where to look (or if this is the best approach).
Best answer by knepiosko
select * from fnd_event_tab;
select * from fnd_event_action_tab;
Hi @HenningNT,
You can store custom objects including custom fields, menus etc. and of course CUSTOM EVENTS in an Application Configuration Package.
Navigate to window “Application Configuration Package”, add the basic package details and add the necessary custom objects and export.
Hope this helps!
Best Regards,
Bhagya
+2select * from fnd_event_tab;
select * from fnd_event_action_tab;
Cool, thanks!
Is there a way to filter out only the custom events we’ve made in-house?
+2select * from fnd_event_tab;
select * from fnd_event_action_tab;
Cool, thanks!
Is there a way to filter out only the custom events we’ve made in-house?
Like this, maybe?
select * from fnd_event_tab where event_type = 'CUSTOM'
+22If your intention is to version control, the best approach is to add the custom events + actions to Application Configuration Packages and export them as
I think this is the method call which suppose to export the ACP content.
App_Config_Package_API.Export_Package(packageExport_, packageId_, exportVersion_, exportComment_);
Cheers!
Damith
+2If your intention is to version control, the best approach is to add the custom events + actions to Application Configuration Packages and export them as
I think this is the method call which suppose to export the ACP content.
App_Config_Package_API.Export_Package(packageExport_, packageId_, exportVersion_, exportComment_);
Cheers!
Damith
Interesting!
Forgive my ignorance, how do you call App_Config_Package_API.Export_Package, and where does the output go?
+22You can call this from PLSQL and output is a CLOB IFS message formatted XML of ACP header and items.
With some coding, you should be able to extract the XMLs from the clob.
Here’s an example call to export the ACP content
Cheers!
Damith
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
