15.8.5 Use and Execute the Revaluation Process

Ensure Revaluation Preparation pipeline is executed before executing this pipeline.

Note:

The accounting entries data service and Balance computation task will not consider data source for processing.
Based on the Revaluation rule fetched from the ERP:
  • Revaluation processing in BCE is carried out
  • Offset accounts are assigned

Note:

More than one Balance Revaluation Management Ledger process should not be simultaneously executed with the same set of runtime parameters. Refer below table for the list of runtime parameters supported.

Note:

When Revaluation Type parameter in Balance Revaluation Management Ledger Process is selected as "Revised Balances":
  • Ensure that Revaluation Rules in ERP are not modified intraday.
  • Ensure that the exchange rates used for revaluation are not modified intraday.
  • Ensure that for a given Extraction Date-Ledger-Revaluation Rule Name combination, the remaining input parameters are not changed between multiple intraday executions.
If any of the above conditions are not or cannot be met, for accurate results of revaluation, please select Revaluation Type parameter as "All Balances" in Balance Revaluation Management Ledger Process.
Key Points to Consider:
  • Revaluation should only be performed for rules completely configured in the Financials Cloud service instance that AFCS is deployed with.
  • Revaluation should be invoked with the Rule Name exactly as configured in the Financials Cloud service instance that AFCS is deployed with.
  • Revaluation should be invoked with the following parameters: Ledger, Rule Name, Effective Date, As of Date, Rate Date, Rate Version and Revaluation Type.
  • Not more than one revaluation rule for a given ledger should be executed at the same time - as in, if there are three rules for Ledger A, rule 1, rule 2 and rule 3 should be executed strictly in sequence. Not more than one rule per ledger should be executed at any point in time.
  • Revaluation may optionally be invoked with a list of Rule Names relevant to a given ledger.
  • When invoked with a set of Rule Names the rules will be executed in the sequence they are listed.
  • Note that Financials Cloud does not stop revaluation rules for a ledger being configured with overlaps in ranges of code combinations to be revalued.
  • Revaluation may also be executed specifically for balance information that has been revised since immediately prior execution. When attempting this, the following should be observed:
    • Given that this is that amount to re-execution, invocation to achieve this should be with identical run-time parameters.
    • The run-time parameter 'Revaluation Type' should be set to 'Revised Balance'.
    • All other guidelines for invocation of revaluation also apply when executed solely for balance information that has been revised since immediately prior execution".
Ensure that you Resave Hierarchies and then proceed with the use and execution of the Balance Computation Management Ledger Process.
To create and execute the Revaluation Process (Balance Revaluation Management Ledger Process) in the Process Orchestration, do the following:
  1. To access the Balance Revaluation (Balance Revaluation Management Ledger Process) Pipeline, on the Home Page, select the Process Orchestration.
    The Process Modeller Page is displayed.
  2. On the Process Modeller Page, search and select the Balance Revaluation Management Ledger process.
    The Process Flow Page is displayed. This Process Flow is designed on the Drawing Canvas using the Transition, Activity, and Widgets Components available in the floating tool bar. The Balance Computation Widget is used for each GL Type Activity such as Assets, Liabilities, Expenses, Revenue, Gains, Losses, Contra Asset, Contra Liability, and Owner’s Equity set in the Balance Revaluation Settings Section. The Activities are repeated in the Run for each General Ledger Type and are executed in parallel.
  3. To view the details of any Activity, double-click on the Activity and the details related to its Activity, Transition, and Notification are displayed. GL Type for the GenerateOffsets Task need to be NULL or blank. On the drawing canvas, you can select and see the Definition, Data Fields, and Application Rule details.
  4. To execute the Run, you can select the Run Parameter Values using the Execution Button on the Process Page or on the Process Modeller Page.
  5. Go to the Process Modeller Page to execute the Run. Click the Menu Button corresponding to the Balance Revaluation Management Ledger Run process that needs to be executed. Click Execution icon.
    The Execution Page is displayed.
  6. On the Execution Page, to execute the Run with parameters, select With Parameters in the Execution Type List. Select or enter the required values for each field as follows:

    Table 15-11 Balance Revaluation Management Ledger Process - Execution Page Field Names and Description

    Field Name Description or Instruction
    Rate Date Use the Calendar button to select the currency date.
    Extraction Date Use the Calendar Button to select the Extraction Date or As of Date for the pipeline.
    Revaluation Type Select the appropriate option from the available list.
    • All Balances: This type processes all the available Balance computation runs for a specific date.
    • Revised Balances: This type processes only the latest available Balance computation run for a specific date.
    Ledger Name Select the Ledger pertaining to the ERP_CC_ID (Code Combination ID) that has undergone revaluation in the ERP system.

    Note:

    Do not select "All" option.

    Note:

    Do not select multiple ledgers.
    Legal Entity Use the Link button to select atleast one Legal Entity from the Available Values List, move it to the Selected Values List, and click OK.

    Note: Do not select "All" option.

    Note: Do not select "All" option.

    Note: Balance Revaluation Management Ledger process does not support Legal Entity or Data Source as filters. Select a valid Legal Entity for executing and processing data for all Legal Entities.

    Revaluation Rule Name Enter the revaluation rule name as same present in the ERP system.

    Note:

    You can enter multiple rules for execution using commas as separators. Do not use spaces or other delimiters to ensure rules are processed sequentially.
    Rate Version Enter the required exchange rate version.
  7. To save the details and execute the Run, click Execute. The Run Execution begins.

    Note:

    The execution of the Run Pipeline is triggered using the selected As of Date.

    See the Managing Processes Section for more details about the Processes.

  8. To verify the Run Execution of the Balance Revaluation Management Ledger Process, do the following:
    1. To open the Process Monitor Page, on the Process Modeller Page, click the Process Monitor Button or select Process Flow Monitor on the Process Menu on the Process Modeller Page.
    2. The Process Monitor Page is displayed listing all the Run Instances corresponding to the Balance Revaluation Management Ledger Process. On the Process Monitor Page, search by the Process ID, or by the Process Name Balance Revaluation Management Ledger, and select the Process Instance for the required Run Pipeline (Process) that was executed.
  9. The Process Flow Page is displayed with the Run Execution Status on each Node of the Balance Computation Management Ledger Process.
  10. To verify the Run Execution Logs, do the following:
    1. On the Process Monitor Page, click the required Process Instance for which you need to verify the Execution Logs.
    2. To see the Execution Status details of a Node, double-click on that Node. The Execution Status details Page is displayed. Click Execution Logs.
    The Log Viewer Page is displayed, which lists all the Logs related to the Process Instance. To see an elaborated information of a log entry, click the Show More Button. Click outside the Log Viewer Page to close it.