Creating a Custom Date Field with a Calculated Default Value

Steps:

1. Hello, my name is John, and today we are discussing extending  applications using Application Composer.

   Step 1

2. In this demo, I will show you how to create a due date field with a calculated default value of today's date plus one.

   Step 2

3. This is the first of four related demos that show you how to create a custom date field, display it in the UI, and create a validation rule to constrain the values users can enter.

   Step 3

4. In this example, we create a due date for activities performed to solve a customer issue in a trouble ticket.

   The trouble ticket is a custom application  we created in Application Composer and the activity is its child object.

   Step 4

5. To create the due date field, we start by navigating to the Activity child object.

   Step 5

6. To create the field, we select the Fields link.

    

   Click the Fields link.

   Step 6

7. And click the Create button.

    

   Click the Create a custom field button.

   Step 7

8. The clock starts ticking as soon as users create the ticket, so we select the Datetime field type.

    

   Click the Datetime option.

   Step 8

9. Click the OK button.

   Step 9

10. We enter the field name users see in the Display Label field.

    Enter the desired information into the Display Label field. Enter

     a valid value
     e.g.
     "Due"
    .
    Step 10

11. We want the default due date to be today's date plus one, so let's enter the expression.

     

    Click the Expression option.

    Step 11

12. We can use the Expression Builder feature to write our script.

    Click the Expression Builder button.

    Step 12

13. We select the Date category.

     

    Click the Date list item.

    Step 13

14. and the today function.

    Click the today list item.

    Step 14

15. We insert.

    Click the Insert button.

    Step 15

16. Click in the Expression field.

    Step 16

17. And add the plus one.

    Enter the desired information into the Expression field. Enter

     a valid value
     e.g.
     "+1"
    .
    Step 17

18. We are done.

    Click the OK button.

    Step 18

19. Click the Save and Close button.

    Step 19

20. In this demo you learned how to create a due date field with a calculated default value.

    You can find additional learning resources in your Oracle Fusion Help application, as well as in the Oracle Learning Library, and at Oracle University. Thank you.

     

    Step 20

Table of Contents  Start Topic