15.8.1 Creating Revaluation Rule ESS Job for AFCS

This section provides information on creating an Revaluation Rule ESS job in the AHCS ERP instance.

1. After logging into ERP AHCS instance, on the Home page, navigate to Setup and Maintenance and click Task icon and click Search.
   The Search page is displayed.
2. Search for Define Enterprise Scheduler Job Definitions and Job Sets for Financials and under Task List select Manage Enterprise Scheduler Job Definitions Job Sets for Financial Supply Chain Management, and Related Applications.
3. Under Manage Job Definitions tab, click Add icon.
   The Create Job Definition page is displayed.
4. Enter information in the following fields.

   Table 15-9 Create Job Definition - Field Names and Description

   Field Name	Description or Instruction
   Display Name	Enter the display name as 'Revaluation Rule and Accounts Export for AFCS'.
   Name	Enter the name as 'GIRevalExportAFCS'.
   Path	Enter the path as 'afcs.
   Application	Select the application as 'General Ledger' from the dropdown list.
   Description	Provide the description for job created.
   Job Application Name	Select the job application name as 'FscmEss' from the dropdown list.
   Job Type	Select the job type as 'PlsqlJobType' from the dropdown list.
   Procedure Name	Enter the procedure name as 'GL_REVAL_FILTER_UTILITY.GET_ACCOUNTS'.
   Default Output Format	Select the output format as 'TXT' from the dropdown list.
   Allow Multiple Pending Submissions	Select 'True' from the dropdown list.

5. Select the User Properties tab and click Add icon.
6. Enter information in the following fields.

   Enter information in the User Property fields

   • Name - Enter the name as 'numberofArgs' for the user property that is created.
   • Data Type- Select the 'String' data type from the dropdown list.
   • Default Value- Enter the default value as '3'.
7. Go back to the Revaluation job parameters that must be added. Select Copy from Existing Job Definition
8. Click Add icon to create parameters for the associated job.

   Enter information in the Create Parameter fields

   • Parameters Prompt- Enter the parameter prompt as 'Accounting Date'.
   • Data Type- Select the 'Date or Time' data type from the dropdown list.
   • Page Element- Displays Date picker as default value.
   • Show- Select 'Date only' option.
   • Default Date Format- Select the date format as ''yyyy/MM/dd' from the dropdown list.
   • Default Value- Select the 'System Date' from the dropdown list.
   • Tooltip- Select 'Required' checkbox.
9. Click Save and Create Another button.

   Enter information in the Create Parameter fields for Revaluation.

   • Parameters Prompt- Enter the parameter prompt as 'Revaluation Name'.
   • Data Type- Select as 'String' data type from the dropdown list.
   • Page Element-Select as 'Text box' from the dropdown list.
   • Tooltip- Select 'Required' checkbox.
10. Click Save and Create Another button.

    Enter information in the Create Parameter fields for Ledger.

    • Parameters Prompt- Enter the parameter prompt as 'Ledger Name.
    • Data Type- Select as 'String' data type from the dropdown list.
    • Page Element-Select as 'Text box' from the dropdown list.
    • Tooltip- Select 'Required' checkbox.
11. Click Save and Close button for parameter creation.
12. Click Save and Close in the Create Job Defintion page.
    A confirmation message on saving the created job is displayed.
13. Click Done in the Manage Job Definitions page.
14. Sign out from the ERP AHCS Instance.
15. Sign In as a Security Manager into Oracle Applications Cloud user interface.
16. On the Home page, select Oracle icon and navigate to Security Console option.
    If a warning message on Import user and role application security data process run is displayed, click OK.
17. Navigate to Tools and select Scheduled Processes.
18. Click Schedule New Process and search for the Import user and role application security data job, select and click OK.
19. Refresh the search result in the Overview page.
    The imported security job process details page is displayed.
20. Click Submit and a confirmation message is displayed,
21. Click OK. The Scheduled process is in running status.
22. Sign out from the application and click Confirm.
23. Sign In as a Financials user and navigate to Scheduled Processes.
24. Search for the revaluation job that you created and the process details page is displayed.
25. Enter the Ledger Name, Revaluation Name and the Accounting Date and click Submit.
    A confirmation message is displayed.
26. Click OK. Refresh the Search results page.
    The Revaluation Rule and Export for AFCS ESS job is scheduled successfully.
27. Under Process details of the ESS job, click the Attachment and you can download the scheduled process job details.