Custom PLSQL Extension

The Custom PL/SQL Extension module includes the following enhancements:

  • Starter Kit packaging has been streamlined. The Starter Kit ZIP now includes only files required for installation; archive.sh and Object Extractor runtime/archive utilities have been removed.
  • Logging and console output have been improved to provide clearer installation and processing status.
  • The process for creating and deploying custom PL/SQL objects has been simplified. Uploading a project through Archive Summary is no longer required.
    • SQL Editor Studio: Introduced SQL Editor Studio for the CUSTOM schema, enabling users to create and compile Custom PL/SQL objects directly.
    • Custom Object Bundles: Group custom functions and views into logical bundles. Use Scheduler batches to execute a selected function from a bundle. Saving a bundle grants SELECT access on its mapped views to the PBSMDD and OFSAA_ANALYTICS_PUB schemas, enabling the views to be queried through Analytics SQL Query Browser.
    • From this release onwards, new Scheduler Component ‘Execute Custom PLSQL’ must be used, earlier component has been renamed to ‘deprecated Execute Custom PLSQL’.

Improves user experience and speeds up creation of custom objects.

Steps to enable and configure

User must have below roles to use use this feature:

  • SQL Query Studio Customer Schema Admin Role (RLCASQACUSTONADMIN)
  • Customer Object Bundle Author Role (RL_CUSTOM_PLSQL_BUND)
  • Customer PLSQL Configuration Rolev(RL_CUSTOM_PLSQL_CONF)

Key resources

https://docs.oracle.com/en/industries/financial-services/ofs-analytical-applications/profitability-balance-sheet-base/index.html