25 Running Global Updates

This chapter contains the following topics:

25.1 Understanding Global Updates

You can apply changes to most transactions in the JD Edwards EnterpriseOne Real Estate Management system by running certain global update programs. For example, assume that a tenant subleases space to another business. In this case, if the rent has not changed and the lease is the same, you can replace the original tenant's address book number with the sublet tenant's address book number, and run a global update program to make the change effective throughout the JD Edwards EnterpriseOne Real Estate Management system. In a different scenario, assume that a tenant wants to move to a larger property. You can preserve the tenant's activity, such as lease history, past payment history, and sales overage, by using a global update program to migrate the information from one property to the other.

Note (Release 9.2 Update):

If you are using balance sheet lessee accounting, be aware that not all global update programs are compatible with updating lessee lease information.

You can perform the Property/Building Relations, Frequency Pattern Update, and Recurring Billing Update for lessee leases using the global update programs.

These global update programs are not applicable for lessee leases:

  • R15903 - Priority Code Reapplication

  • R03B802 - Update A/R from Address Book

  • R15117 - Lease Global Update

See Chapter 23, "Balance Sheet Lessee Accounting (Release 9.2 Update)" for additional information.

25.2 Updating Property and Building Relations

From the Global Updates menu (G15311), select Property/Building Relations.

If you change the project number for a building (business unit), you can run the Property / Building Relations program (R15804) to update the new project number on all of the related records in the Lease Master Detail File table (F15017) and the Unit Master table (F1507).

This update is necessary because the system uses the project number as search and selection criteria on a variety of interactive and batch programs. This update program generates a report that lists the new and the old information and lists the tables that were updated.

(Release 9.2 Update) This program has been updated to enable you to make global updates to the F15017 for non-property assets.

25.3 Updating Priority Codes on Invoices

From the Global Updates menu (G15311), select Priority Code Reapplication.

If you must change the priority assigned to a bill code, you can update this change to the Customer Ledger table (F03B11) by running the Priority Code Reapplication program (R15903). The priority code determines the order in which open invoices should be paid.

This program does not have associated processing options, nor does it provide a report of the priorities that were changed.

25.4 Updating Invoices from the Address Book

When you generate invoices, either manually or automatically from another system, the system writes certain address book information, such as the customer's alpha name, to each record. The JD Edwards EnterpriseOne Accounts Receivable system uses the address book information for many processes, such as printing statements and reports, and for inquiry programs. When address book information changes, you can update the invoice records by running the Update A/R from Address Book program (R03B802).

Depending on the size of the Customer Ledger table (F03B11), you might want to run the R03B802 program during off-peak hours. Run this periodically, especially before running aging reports or printing statements, to ensure that the F03B11 table contains current information. You do not have to run it nightly, because the accuracy of programs such as Credit Analysis Refresh (R03B525) is not dependent upon the address book. However, if you use the Customer Ledger Inquiry program to search by parent number, and parent numbers are changed frequently in JD Edwards EnterpriseOne Address Book, you might want to run the R03B802 program nightly.

The system updates these fields in the Customer Ledger table (F03B11):

  • Payor (PYR), based on the processing option on the Updates tab

    The system retrieves the value for the Payor from the Alternate Payor field (ARPY) in the Customer Master by Line of Business table (F03012). If the Alternate Payor field is blank, the system retrieves the value from the Address Book Number field (AN8).

  • Alpha Name (ALPH) from the Address Book Master table (F0101).

  • Parent Address Number (PA8) from the Address Organization Structure Master table (F0150).

  • Alternate Payee (AN8J), based on the value of the Send Statements To (STTO) field in the Customer Master by Line of Business table.

    The address book number that the system assigns to the Alternate Payee field depends on the value of the Send Statements To field. For example, if you send the statement to the customer (value of C), the system updates the Alternate Payee field with the customer's address book number (AN8). If you send the statement to the parent (value of P), the system updates the Alternate Payee field with the address book number of the parent (PA8) from the Address Organization Structure Master table.

  • Category Codes 1-10 (AC01-AC10), from the Customer Master by Line of Business table.

  • Collection Report Y/N (COLL), from the Customer Master by Line of Business table.

The system updates these fields in the Receipts Header table (F03B13):

  • Alpha Name (ALPH), based on the setting of the processing option, from the Address Book Master table.

  • Parent Address Number (PA8) from the Address Organization Structure Master table.

25.4.1 Running the Update A/R from Address Book Program

Before you run this program, review and set the processing options.

Use one of these navigations:

  • From the A/R Advanced & Technical Operations menu (G03B31), select Update A/R from Address Book.

  • From the Global Updates menu (G15311), select Update A/R from Address Book.

25.5 Updating Billing Frequency Patterns

If you must change the periods for a particular billing frequency code, you can do so by using the Billing Frequency Information program (P15019).

After you make the change, you must run the Frequency Pattern Update program (R15803) to change the billing records in these tables:

  • Tenant E.P. Class Master (F15012B).

  • Sales Overage Master File (F15013B).

  • Min/Max Rents And Recoveries Master (F15015B).

  • Tenant Escalation Master (F15016B).

  • Recurring Billings Master (F1502B).

25.5.1 Running the Billing Frequency Pattern Update Program

From the Global Updates menu (G15311), select Frequency Pattern Update.

The program does not have associated processing options, nor does it generate a report of the records that the system updates.

25.6 Updating Recurring Billing Records (Release 9.2 Update)

Release 9.2 Update:

This section has been updated to include the Lessee Recurring Billing Update (R151161) and the Estimated Lessee Recurring Billings table (F1502WC). These objects support the global update of recurring billing lines that have an effect on lease liability of Yes (1) or Guaranteed Residual Value (2), and are used in balance sheet lessee accounting processing. If you are not maintaining lessee leases, the system does not use these objects when processing recurring billing global updates.

See Chapter 23, "Balance Sheet Lessee Accounting (Release 9.2 Update)" for additional information.

You can simultaneously change many recurring billing records to indicate increases or decreases in the billing amounts or to change the dates for those records using the recurring billing global update process.

This process is most commonly used to increase rents in the same manner for multiple assets.

If you are using this process to update billing records associated with lessee leases, you can perform only these actions using the global update process:

  • Modify billing amount on selected step only.

  • Add a new last step.

  • Extend the end date of last step.

  • Modify billing amount on selected and future steps.

  • Terminate early by changing end date of last step.

  • Update amount on guaranteed residual value (GRV) records.

  • Update date range on GRV records.

To complete this process, you:

  1. Run the Recurring Billing Global Selection program (R15021) to identify and select bill code lines from the F1502B table for which you want to revise amounts or dates.

    This program creates up to four different batches, each with a different batch number, depending on the records you select. The batches contain records for:

    • Property assets with no effect on lease liability.

    • Non-property assets with no effect on lease liability.

    • Property assets with effect on lease liability set to 1 or 2.

    • Non-property assets with effect on lease liability set to 1 or 2.

    This program also populates the F1502WB and F1502WC worktables with selected records, and assigns batch numbers to those records.

    Finally, this program runs the Recurring Billing Global Update program (R15116) and the Lessee Recurring Billing Update program (R151161) in edit (proof) mode, using the versions you specify in the processing options. You can specify a different program version for each type of batch. All three programs produce reports to identify the updates, batch numbers, and any errors or exceptions that occur.

  2. Review the reports generated by the R15021, R15116 and R151161 to determine if your updates are accurate. Oracle strongly recommends completing this step before you run any programs in update mode.

  3. Run the R15116 and R151161 in update (final) mode for the batch numbers associated with your groups of records.

This graphic illustrates the global update process:

Description of global_update.jpg follows
Description of the illustration ''global_update.jpg''

When you run the R15021, you use data selection and processing options to specify which records in the F1502B table you want to update. You also use processing options to specify which versions of the update programs you want to run. The system then populates worktables with the recurring billing records you have selected for update. Once the worktables are populated, the R15021 automatically runs one or more of these update programs in proof mode (even if the specified version is set to run in update mode), depending on which worktables were populated by the R15021:

  • Recurring Billing Global Update program (R15116)

    The R15021 program creates property records with no effect on lease liability, that meet your selection criteria, in the Estimated EP Recurring Billings worktable (F1502WB). The R15116 then processes those records. If there are no records that meet this criteria, the R15021 does not generate a batch of records in the F1502WB, and therefore, does not run the R15116 program.

  • Lessee Recurring Billing Update (R151161)

    The R15021 program writers up to three batches of records to the Estimated Lessee Recurring Billings worktable (F1502WC). These batches include non-property records with no effect on lease liability, property records with effect on lease liability set to 1 or 2, and non-property records with effect on lease liability set to 1 or 2, and that meet your selection criteria. Processing options on the R15021 specify which versions of the R151161 to run for each batch type. If a specific batch type is not created in the F1502WC, the associated version of the R151161 is not run.

    Additionally, a processing option on the R15021 determines whether you can include records for update if an amortization schedule exists for those records. If you update records that already have amortization schedules, you might be required to remeasure your lease. See Section 23.5, "Changing Lease Terms After Schedule Creation" for additional information.

Depending on your selection criteria, the R15021 will run one or both of these update programs. For example, if you are selecting billing records for property assets that have no effect on lease liability (records written to the F1502WB), and records that do have an effect on lease liability (records written to the F1502WC), the R15021 will process both update programs using the versions you specify in the processing options.

Both programs produce reports that enable you to review the changes that will be made to the Recurring Billing Records table (F1502B). Each report includes the batch number associated with each set of records in the associated worktable. You will use these batch numbers when you run the update programs in update mode.

For lessor leases, the R15021 uses both the anniversary date of a lease and the effective dates for the recurring billings to select records. You specify date updates that you want to make to your recurring billing records on the Dates and the Select tabs of the processing options. You specify amount updates in the processing options of the R15116.

For lessee leases, the R15021 uses the beginning and ending dates on the recurring billing records to select records. You can also select property assets on the Select tab. You specify date updates that you want to make to your recurring billing records on the Lease Liability tab of the processing options. You cannot use the Start Date Anniversary processing options to select records for lessee leases.You specify amount updates in the processing options of the R151161.

Using the global update process to update recurring billing records provides this flexibility:

  • On a single set of records, you can apply different calculations by running different versions of the R15116 or R151161 programs in edit (proof) mode.

    This action lets you review and compare the results before you commit to a particular update.

  • If you consistently make the same amount increase to a set of records, you can create specific versions of the selection and update programs for that update and maintain only the date control in the versions of the selection program.

    For example, you have a quarterly 1% increase in the rent amount for lease 12345 (a lessor lease), you might create a version of the R15021 and a version of the R15116 called Lease 12345 Quarterly. You can specify all of the details of the update in the versions, and simply change the date each quarter before processing the update.

Important:

The billing frequency for the selection program (R15021) must be the same as the frequency for the update programs (R15116 and R151161). Otherwise, different frequencies could be involved in the same calculation and the results would not be correct, such as if monthly billings were calculated with an annual increase.

This is important because:

  • In the calculation, a flat amount is applied to the selected records, regardless of the billing frequency.

  • The billing frequency controls how the calculated amounts are expressed.

    Monthly billings are expressed as monthly amounts, annual billings as annual amounts, and so on. However, the totals on the report do not consider any difference in the billing frequency.

If exceptions occur during record selection, the R15021 produces an exception report that identifies records that would be omitted from the update, along with an explanation.

The system honors specific conditions for each type of record to determine whether a bill code line is included in the selection.

This list includes the conditions for records with no effect on lease liability:

  • The new begin date cannot occur on or after the suspend date if the bill code line is suspended.

  • The bill code line cannot be associated with a non-billable lease unless the processing options are set to allow it.

  • The original (current) end date cannot be blank if the new begin date is not specified in the processing options.

  • The original begin and end dates cannot be blank if the new begin and end dates are not specified in the processing options, and non-billable lease are not allowed.

This list includes the conditions for records with an effect on lease liability:

  • The billing records must be active. Inactive records are automatically excluded.

  • The Effective Date or New End Date cannot occur on or after the suspended date if the billing record is suspended.

  • When using the Effective Date to update a billing record, the Effective Date must be within the date range of the billing record.

    The one exception to this rule is if the Billing Step to Update processing option is set to 1 to update both the selected billing step and all future steps. In this case, the updated future billing steps will have date ranges greater than the Effective Date.

  • When using the New End Date processing option to update a billing record, the billing record must belong to the last billing step.

  • The Lessee Accounting Journal Entry Through Date for the billing record's unit or asset must be less than the Effective Date or New End Date.

  • When using both the Effective Date and New End Date processing options to update billing records for the last billing step, both updates from the two dates must be successful or all records for the billing step will be excluded from the select batch.

    In this scenario, the updates could not be completed for all selected records in the last billing step, so the entire billing step is excluded in order to preserve the date integrity of the billing step. To resolve this situation, process the two updates separately.

This list includes the conditions for records with effect on lease liability set to GRV:

  • The billing records must be active.

  • If only using an Effective Date, the suspend date must be greater than the Effective Date.

  • If only using a New End Date, the suspend date must be greater than the New End Date.

  • To change the amount, the Effective Date must be equal to the begin and end date of the record.

  • The New End Date PO is automatically applied to GRV records. No further conditions exist. However, by changing the date of a GRV record, the record is also eligible for a change in amount by the R151161, if needed.

You can run the R15021 as many times as needed to ensure that you have selected the correct records for update, and that the reports created by the update programs in edit mode accurately reflect the changes that you want to make. The reports also indicate the records that cannot be updated, based on the thresholds that are specified in the processing options of the update programs.

Once the reports are accurate, you can then process the update programs (R15116 and R151161) in update mode.

Running Update Programs in Update Mode to Update Recurring Billing Records

When you run the R15116 and R151161 programs in update mode, the system calculates the new recurring billing information for one or more leases, updates the related bill code lines in the Recurring Billings Master table, and suspends the lines being replaced.

To run these programs in update mode, you must:

  • Set the Update Recurring Billings processing option to 1 (Update recurring billing records).

  • Enter the batch number for the associated batch in the Batch Number processing option.

    You can find the batch numbers on the header and footer of the reports that were created when you selected your records for processing. Note that the batch numbers are different for each set of records you want to process.

When running the R15116 in update mode, the system retrieves information from the Estimated EP Recurring Billings table (F1502WB) and performs these steps in sequential order to calculate the amount update:

  1. Determines whether the type of square footage to be used is rentable or usable.

  2. Retrieves the original (current) billing amount.

    If the method of increase involves the amount per square foot, the system divides the original amount by the appropriate square footage from the Lease Master tables.

  3. Applies the method of increase to the original amount, which results in the new gross billing amount; for example:

    • For percent, the original amount is multiplied by the specified percent.

    • For amount or amount per square foot, the specified amount is added to the original amount.

    • For new amount or new amount per square foot, the original amount is replaced by the specified amount.

  4. Applies the rounding controls to the new amount.

  5. Processes the new rounded amount against the original amount to determine the calculated change. For example:

    • If the threshold is a percent, the original amount is divided by the rounded amount.

    • If the threshold is an amount, the original amount is subtracted from the rounded amount.

    • Compares the calculated change with the threshold.

      If the change is greater than or equal to the threshold, the rounded amount is accepted for the new billing amount. This step prevents updates with insignificant amounts.

  6. Writes the new records to the Recurring Billings Master table, and suspends the original recurring billing records on the day before the change becomes effective.

When you run the R151161 in update mode, the system retrieves information from the Estimated Lessee Recurring Billings table (F1502WC), and performs these steps in sequential order to calculate the update amount:

  1. Determines whether the specified method of increase is compatible with the asset associated with the billing record.

    For example, you can not use a per square foot update method for non-property assets.

  2. Retrieves the original (current) billing amount.

    If the method of increase involves the amount per square foot, the system divides the original amount by the appropriate square footage from the Lease Master tables.

  3. Applies the method of increase to the original amount, which results in the new gross billing amount; for example:

    • For percent, the original amount is multiplied by the specified percent.

    • For amount or amount per square foot, the specified amount is added to the original amount.

    • For new amount or new amount per square foot, the original amount is replaced by the specified amount.

  4. Applies the rounding controls to the new amount.

  5. Processes the new rounded amount against the original amount to determine the calculated change. For example:

    • If the threshold is a percent, the original amount is divided by the rounded amount.

    • If the threshold is an amount, the original amount is subtracted from the rounded amount.

    • Compares the calculated change with the threshold.

      If the change is greater than or equal to the threshold, the rounded amount is accepted for the new billing amount. This step prevents updates with insignificant amounts.

  6. For records with effect on lease liability set to Yes or GRV, writes the new records to the Recurring Billings Master table, and suspends the original recurring billing records on the original record's begin date.

    For records with effect on lease liability set to No, writes the new records to the Recurring Billings Master table, and suspends the original recurring billing records on the day before the change becomes effective.

  7. If any of the changes that are made to the recurring billing records require the associated lease to be remeasured, the system updates the Recalculate Lease Liability field on the lease detail. You must complete the remeasurement or early termination process for the lease before you can continue processing balance sheet lessee accounting information for the lease. See Section 23.5, "Changing Lease Terms After Schedule Creation" for additional information.

Resetting Records Updated by the Global Update their Previous State

Occasionally, you might find that you accidentally process a global update batch in final mode before you intend to. Or, you might determine after the update is complete that the updates are inaccurate. Depending on the type of batch, you can reset the records in the F1502B to their original state before the update was processed.

The reset feature is available only for these types of global update batches:

  • Batches that include property assets with no effect on lease liability, which are updated by the R15116.

  • Batches that include non-property assets with no effect on lease liability, which are updated by the R151161.

You use a processing option on the R15116 and R151161 to specify that you want to run the programs in reset mode, and to specify the batch number you want to reset. Reset mode deletes the new records that were created by the last run of the global update, and updates the records to the state they were in before the update was performed.

The programs generate reports that indicate which records were reset and which records were omitted from the process.

Note:

The reset feature is not available for records that have an effect on lease liability, as resetting these records could cause issues with the associated amortization schedules. If you determine that the update you processed for these batches was incorrect, you can manually update the records to correct them, or you can process another global update to change the records as needed. Depending on the changes you make, you might be required to remeasure your lease.

25.6.1 Running the Recurring Billing Global Selection Program

Before you run this program, review and set the processing options.

From the Global Updates menu (G15311), select Recurring Billing Global Selection.

25.6.2 Running the Recurring Billing Global Update Program (R15116)

Before you run this program, review and set the processing options.

From the Global Updates menu (G15311), select Recurring Billing Global Update.

25.6.3 Running the Lessee Recurring Billing Update Program (R151161)

Before you run this program, review and set the processing options.

From the Global Updates menu (G15311), select Lessee Recurring Billing Update.

25.7 Updating Leases Globally

The Lease Global Update program (R15117) enables you to change specific lease-related values for the records in selected tables.

These are examples of situations for which this program is useful:

  • Maintaining the history for leases that have been moved to different units, such as when an appraisal results in the units being renumbered.

  • Changing the number of a tenant or the name of an alternate payee.

  • Recording when an internal building number or company changes.

Use the processing options to specify which fields and tables to update. This program uses information stored in the Lease Master Header table (F1501B).

(Release 9.2 Update) The processing options for this program have been updated to enable users to specify that they want to update the F1513B table (Straight-line Rent Revisions) when this program is processed in final mode. The addition of this processing option enables users to keep straight-line rent records in sync with records in related tables if the unit or building on the lease is updated.

You can update the following information:

  • Building number

    When you update the building number (business unit), the system does not change the company number in the tables. You cannot use the same business unit for multiple companies.

    You can use the Old Building Number and Old Unit Number processing options on the Options tab to limit the update to a single building and unit in situations in which multiple buildings and units are associated with the lease. If these options are blank, the system selects all of the buildings and units in the lease for processing.

  • Unit

  • Tenant

    When the system updates tenant numbers, the alternate payee does not change to the alternate payee for the new tenant. To make this change, you must also update the alternate payee in the Alternate Payee processing option on the Field Updates tab.

  • Alternate Payee

  • Alternate Payment Source

  • Manager

  • Occupant

  • Salesman

  • DBA (Doing Business As)

  • Lease Status

  • Payment Terms

25.7.1 Alternate Tax Rate/Area Assignments in Global Updates

The Lease Global Update program enables you to change the building, tenant, and other information in many of the tables used in the JD Edwards EnterpriseOne Real Estate Management system. The program, however, does not enable changes to the tax rate/area for the records in the tables.

The tax rate/areas assigned to transactions in the JD Edwards EnterpriseOne Real Estate Management system are determined, in part, by the building and tenant associated with the leases in the system. If you enable the alternate tax rate/area assignment functionality for the company of the building and work in a program that retrieves a tax rate/area based on the lease, tenant, and building, the system retrieves the alternate tax rate/area that you defined for the building and tenant. Because a change to the tenant or building during a global update can affect the tax rate/area assigned to a record, and changing the tax rate/area for a record is not allowed during a global update, the Lease Global Update program performs additional validations for tables that include the tax rate/area when the company of the building is set up to retrieve an alternate tax rate/area.

This list indicates the tables that you can update using the Lease Global Update program and which include the tax rate/area:

  • F15012B - Expense Participation Master.

  • F15013B - Sales Overage Master.

  • F15016B - Tenant Escalation Master.

  • F1502B - Recurring Billing Master.

  • F1511B - Tenant/Lease Billing Detail.

  • F1511HB - Tenant Billing Detail History.

  • F03B11 - Accounts Receivable Ledger.

  • F0411 - Accounts Payable Ledger.

When you set the processing options in the Lease Global Update program to update the building or tenant in the tables listed above, the Lease Global Update program determines whether the new values for the building or tenant are associated with a different tax rate/area than the tax rate/area already assigned in the tables. If the tax rate/area is the same for the existing and to-be-updated record, then the system allows the change to the table for the record. If the new tax rate/area associated with the new tenant or building is different from the existing tax rate/area saved to the table, then the system issues an error message and does not enable the change to the tenant or building for the record. If a validation fails, the process ends.

25.7.2 Running the Lease Global Update Program

Before you run this program, review and set the processing options.

From the Global Updates menu (G15311), select Lease Global Update.