24.5.1 Creating a Legacy Classic Calendar


Legacy calendars are legacy application components. Although Oracle still supports legacy components, Oracle recommends creating new calendars. In the current release, calendar is based on the FullCalendar jQuery library.


When creating a Legacy Calendar by running the Create Page Wizard, you must manually create an On Demand page process to enable drag and drop functionality.

To create a Legacy Calendar by running the Create Page Wizard:


To learn more about an attribute, see field-level Help.

  1. On the Workspace home page, click the App Builder icon.
  2. Select an application.
  3. Click Create Page.
  4. For Create a Page:
    1. User Interface - Select a user interface for the page.
    2. Select Legacy Page.
    3. Click Next.
  5. Select Legacy Calendar and click Next.

    The Create Calendar Page Wizard appears.

  6. For Page Attributes:
    1. Page Number -If you identify a new page number, the wizard creates a new page. If you identify an existing page number, the wizard adds the component to that page.
    2. Page Name - Enter a title for the page to be created.
    3. Page Mode - Select a page mode. See field-level Help for more information.
    4. Region Template - Select a region template for the new calendar region. The template controls the appearance of the region.
    5. Region Name - Enter a name for the region to contain the calendar.
    6. Display Type - Determines the behavior of the calendar. Options include:
      • Standard - Submits the page along with the associated request.

      • Partial Page Refresh - Only refreshes the Calendar region.


      Once the calendar is created, the display type cannot be changed. To change the display type, you must delete the calendar and then re-create it.

    7. Breadcrumb - Select whether to use a breadcrumb navigation control on your page, and which breadcrumb navigation control you want to use.
    8. Click Next.
  7. For Navigation Menu, specify the type of navigation to include on this page and click Next. The navigation options (for example, navigation menu or tabs) depends upon the current application theme.
  8. For Source, select if the calendar source is a table or SQL query.

    If the Calendar source is Table:

    1. Owner - Select the database schema that owns the table from which you are creating a calendar.
    2. Table/View Name - Specify the table to be used in the calendar.
    3. Click Next.

    If the Calendar source is SQL Query:

    1. SQL Query - Enter the SQL SELECT statement to be used by the calendar. The SQL SELECT statement must include at least two columns, of which one must be a DATE column.

      For examples, See field-level Help for more information.

    2. Click Next.
  9. For Calendar Attributes:
    1. Date Column - Specify which column is used as the date to place an entry on the calendar.
    2. Display Column - Specify the column to be displayed on the calendar.
    3. Date Format - Specify how you want to represent dates on your calendar. Options include:
      • Date Only - Results display in a monthly and list calendar.

      • Date and Time - Results display in a monthly, weekly, daily, and list calendar.

    4. Custom Date Range - Identify whether to include custom start and end dates. Use this option to enable more than one month to be represented on a monthly calendar.
    5. Click Next.

    Next, define Link Details for calendar entries. The Link Target determines where users are redirected to if they select a calendar entry.

  10. For Link Details:
    1. Page - Identifies the currently selected page.
    2. Link Target - Identify whether a calendar entry should have a link target. When a calendar entry is selected, the user is redirected to the link target. The selected Link Target determines what additional attributes display.

      See field-level Help for more information.

    3. Open Link in - Specify the location where the URL or Page should be opened.
    4. Click Next.
  11. On Process Option:
    1. Page - Identifies the page number.
    2. Table / View Name - Identifies the name of the table on which the Form is based on.
    3. Cancel Button Label - Enter the label for the Cancel button.
    4. Show Create Button - Indicate whether users should have insert capability using the form.
    5. Create Button Label - Enter the label for the Create button.
    6. Show Save Button - Indicate whether users should have update capability using the form.
    7. Save Button Label - Enter the label for the Save button.
    8. Show Delete Button - Indicate whether users should have delete capability using the form.
    9. Delete Button Label - Enter the label for the Delete button.
  12. Click Next.
  13. On Confirm :

    Verify the attributes and confirm your selections.

  14. Click Create.