15.3.2 Creating Page Processes

Create a page process in Page Designer.

To create a page process:

  1. View the page in Page Designer.
    1. On the Workspace home page, click the App Builder icon.
    2. Select an application.
    3. Select a page.

      Page Designer appears.

  2. In either the Rendering or Processing tab, locate the node where the process will occur. Right-click and select Create Process.
  3. Page Designer indicates what to do next. If there is an error, the Show Messages icon displays in the Page Developer toolbar.
    1. Click the Show Messages icon on the Page Designer toolbar.
      The Messages dialog displays errors that must be addressed.
    2. Select an error to highlight the associated attribute in the Property Editor.

      To learn more about an attribute, select the attribute in the Property Editor and click the Help tab in the central pane.

  4. Identification, Name - Enter the name of the process for easy identification by developers.
  5. Identification, Type - Specify which process type to execute. The Type you select determines what attributes display next.

    Consider the following examples.

    • If Identification, Type is Execute Code:
      • Identification, Type - Select Execute Code.
      • Source, Location - Select where the process executes. Select either Local Database or REST Enabled SQL.
      • Source, Language - Select the language used to execute the entered code.
      • Source, PL/SQL - Enter the PL/SQL code to be executed.
    • If Identification, Type is Generate Text with AI:
      • Identification, Type - Select Generate Text with AI.
      • Generative AI, Configuration - Select the appropriate AI configuration.

        Note:

        Before you can add a page process to generate text with AI, you must complete the steps described in About Including Generative AI in Applications. Failure to create a Generative AI Service or edit the application, AI attributes results in an error.
      • Input Value, Type - Select Item.
      • Input Value, Item - Select the desired item.
      • Use Response, Item - Select the item the response is returned in.

        Tip:

        If you expect larger content back from the Generative AI service as a response, use the Session State Data type as CLOB.
    • If Identification, Type is Invoke API:
      • Identification, Type - Select Invoke API.
      • Invoke, Type - Select whether to call a procedure or function within a PL/SQL package or a standalone one, or an operation defined in a REST Data Source. Options include: PL/SQL Package, PL/SQL Procedure or Function, or REST Source.

        What displays next, depends upon the Invoke, Type you select. Consider the following examples:

        If Invoke, Type is PL/SQL Package:
        • Invoke, Type - Select PL/SQL Package.
        • Invoke, Package - Enter the case-sensitive PL/SQL package name. You can type in the name or pick from the list.
        • Invoke, Procedure or Function - Enter the case-sensitive procedure or function name defined in the selected PL/SQL package. You can type in the name or pick from the list.
        If Invoke, Type is PL/SQL Procedure or Function:
        • Invoke, Type - Select PL/SQL Procedure or Function.
        • Invoke, Procedure or Function - Enter the case-sensitive procedure or function name defined in the selected PL/SQL package. You can type in the name or pick from the list.

        If Invoke, Type is REST Source:

        • Invoke, Type - Select REST Source.
        • Invoke, REST Source - Select the REST Source which contains the Operation to be invoked.
        • Invoke, Operation - Select the Operation to invoke. The select list shows the name, if configured for the REST Operation. Otherwise, its HTTP method and URL pattern will be shown.
  6. Under Execution :
    1. Execution, Sequence - Specify the sequence for this computation. The sequence determines the order of execution.

      If two components have the same sequence value, then they may be executed in a different order when the application is exported and imported into another environment.

    2. Execution, Point - Select the point at which this process is executed.
    3. Execution, Run Process - Select the frequency that this process executes.
  7. Success Message, Success Message - Enter the success message for this process.

    If the process runs and does not generate an error, then this process success message displays in the notification section of the resulting page displayed. If you are branching to another page using a URL redirect, you may need to check the preserve success message attribute.

    To learn more, select the attribute in the Property Editor and click the Help tab in the central pane.

  8. Under Error:
    1. Error, Error Message - Enter the error message for this process.

      This message displays if an unhandled exception is raised. After any error processing stops, a rollback is issued and an error message displays.

    2. Error, Display Location - Select where this process error message displays, when the process fails to complete successfully.

      Option include:

      • Inline in Notification - The process error message displays in the Notification area (defined as part of the page template).
      • On Error Page - Error displays on a separate error page.
  9. Advanced, Static ID - Enter a unique Static ID to identify this component in API calls or refer to it in application export files. If you change the Static ID, dependent components will retain their references, but any existing API calls using the old ID must be updated manually.
  10. Click Save.

Related Topics

Parent topic: Understanding Page Processes