Processing Scenarios
When you run the process (including trial runs), the interim table is populated with the variance amounts before the journal entry (JE) or the summary table is populated.
An interim row is created for each Project/Account/Organization combination that will have their own JE line, regardless of whether variance is negative of positive.
In addition, whenever the variance process is run, the system checks the variance log to see if the process has been run for the FY/PD/SPD. The following are the possible conditions in the processing scenario:
- Condition 1: PPV has not been run previously for the FY/PD/SPD. In this case, new rows are entered into the interim table with variance amounts for the corresponding FY/PD/SPD and various Project/Account/Org combinations.
- Condition 2: PPV has been previously run and journal entries have been generated for that FY/PD/SPD, but not posted. In this case, existing rows are cleared from the interim table. New rows are then reinserted with updated variance amounts for the corresponding FY/PD/SPD and various Project/Account/Org combinations.
- Condition 3: PPV has been previously run, journal entries have been generated for that FY/PD/SPD, one or more of which have been posted. In this case, a comparison will be made between the updated variance amounts and existing variance amounts in the PPV_VAR_SUM row for the corresponding FY/PD/SPD and various Project/Account/Organization combinations. The following scenarios also occur:
- (a) If there is a difference (positive or negative), a new row will be added to the interim table for a variance amount equal to the difference.
- (b) If there is no existing row in PPV_VAR_SUM, then a new row will be added to the interim table for the total variance amount.
- (c) If a row exists in PPV_VAR_SUM, but no variance amounts exist at all for the corresponding FY/PD/SPD and Project/Account/Organization combinations, a new row must be added to the interim table to negate the effect of that existing row. If existing row is positive, the new row will be a negative variance amount in order to reduce the previously saved variance amount back to zero (0).