Mandatory or Optional End of Day Sequence Procedures

The following End of Day procedures are available based on the Cloud Service subscriptions and OPERA Controls active at your property.

Table 13-24 Mandatory or Optional Procedures

Module Name	List Name	Description	Status
artrx.post_ar_finance_charges	Posting AR finance charges	Posts financial charges setup for the AR account type. For more information, see Configuring Accounts Receivable Account Types. (Available when the Finance Charges OPERA Control is active).	Mandatory
artrx.post_ar_fixed_charges	Post AR Fixed Charges	Posts fixed charges setup for the AR account. For more information, see Managing Accounts Receivables Fixed Charges . (Available when the AR - Fixed Charges OPERA Control is active).	Mandatory
dailyrates.addonenight	Add next night record for daily rate code after the daily rate max parameter	Required when the Daily Rates OPERA Control is active.	Optional
dailyrates.deleteonenight	Purge all the rate details for previous night which is not needed for daily rate code	Required when the Daily Rates OPERA Control is active.	Optional
delete_waitlist	Cancel Wailtlist Reservations	Cancels all wait list reservations for the previous business date.	Optional
eod_misc.assign_tax_reg_no	Assign Tax Registration No to In House reservations	Enabled when the Generate Tax Registration Number OPERA Control is active. A registration number is assigned to each Arrival reservation and appears in the Registration Number field in Reservation Stay Details panel. The registration number is sequentially assigned to arrivals.	Mandatory
eod_misc.reset_tax_reg_seq	Reset the Tax Registration sequence number	Resets the Tax Registration sequence number.	Optional
Generate_Export_NA_Data	Generate Data-Export	Generate export files setup for processing during End of Day (Available when the Exports OPERA Control is active).	Optional
hkpkg.update_room_status_proc	Updating Room Statuses	Updates all no show rooms to the room status selected in the  Update Room Status for No Show and Cancelled Reservations OPERA Control. If no status is selected, then the room status of the no show rooms is not changed. If a reservation with an assigned room cancels on the expected day of arrival, the reservation too shall adhere to this set room status.	Mandatory
insert_resv_commissions	Populate the temporary store table for Processing Commissions	Searches for reservations with travel agent commissions attached, and places all commission-able reservations into a temporary table, and calculates commissions.	Optional
night_audit_authorization	Credit Card Authorization	At check in, a property usually seeks credit card authorization for a certain dollar amount (estimate of the amount of charges to be settled upon check out) for each reservation. If stay charges approach the property's initial estimate, this procedure will attempt to authorize a higher credit limit. If the authorization is not given (for whatever reason) an exception report can be produced allowing the property to contact the guest the next day to rectify the situation.	Optional
night_audit_deposit_processing	Batch Deposit Processing	This procedure will check for reservations having deposit requests with a due date that matches the current business date and a credit card payment method and process them. Available with an active OPI integration and the Advanced Deposit Handling OPERA Control is to 0.	Optional
ovos_rotation_api.eod_points_processing	Room Rotation Points Processing	Room rotation point calculation and period reset processes. (Available when the Room Rotation OPERA Control is active).	Mandatory
pms_grgrid.night_allotment_cutoff	Allotment Cutoff	Searches for all block allocations where cutoff date matches the previous business date; all unreserved (non picked up) rooms are released back to general house inventory.	Optional
pms_grgrid.night_allotment_pattern_cutoff	Block Wash Schedule	Processes Block Wash Schedules (Available when the Wash Schedule OPERA Control is active).	Optional
pms_grgrid.turn_bookings_to_actuals	Turn Business Blocks Actual upon Arrival	Updates business blocks that have arrived today to Actual status. Block Status Code must be configured as both Room Status Type = 'ACTUAL' Indicated as 'Allow Pickup'	Optional
POST_ROOM_AND_TAX	Posting Room and Tax	Procedure posts room, tax, package, package profit, and loss transactions to guests that are in house on the current business date.	Mandatory
pr_b_del_msg_on_chkout	Delete Messages	Deletes traces and messages for checked out reservations.	Optional
property_charges_pkg.prop_charges_statistics	Custom Charges Statistics.	Generates customer charges related statistical information.	Optional
rate_strategy_pkg.set_rate_strategy	Execute Rate Strategies	Process rate strategy rules.	Mandatory
refresh_fin_summary.populate_audit_box	Populate Audit Box	Populates Audit box.	Optional
orspms_stay.stage_process_all_na	Process Guest Stay Data	When the Stay Records OPERA Control is active Creates stay records for checked-out reservations to track stays and revenue for profiles. These stay records are the basis for the creation of Membership Transactions, used to calculate member Awards and Tier points for a property with an Oracle Hospitality OPERA Cloud Service, Loyalty subscription or when the Loyalty Membership Configuration OPERA Control is active. Creates Projected Stay Records for checked-in reservations to calculate Stay Projections for profiles based on Membership Point Calculation Rules configuration (currently Stay Projection is available when the Loyalty Membership Configuration OPERA Control is active (and integrated with OPERA Customer Loyalty Tracking Cloud Service) and the Exclude Checked In Reservation from Stay Projections OPERA Control is inactive. For more information, see Viewing Guest Stay Statistics	Optional
refresh_fin_summary.populate_trial_balance	Populating Trial Balance	Populates a summary table of the day's transaction totals for each transaction code, for the Trial Balance report.	Mandatory
refresh_fin_summary.refresh_resv_summary	Creating Guest ledger	Updates the balance for every reservation account.	Mandatory
reservation.no_show	Reservation No Shows	Reclassifies all due in reservations for the previous business date to no show status.	Mandatory
reset_control_seq	Year End Procedure	Resetting of bill numbers during End of Year. Originally developed for Italy but can be used by others.	Optional
sc_activity.generate_activities	Automatic Activity Generation	Generate sales activities according to the Activity Auto Trace rules  (Available when the Auto Traces OPERA Control is active).	Mandatory
synchronize_fo_status	Synchronizing Front Office Statuses	Synchronizes (matches) the number of persons and room status (occupied/vacant) in the room table with the number of persons and room status from the reservations table.	Mandatory
update_invpurgedtl_bucket	A/R Aging	Updates the Accounts Receivable (A/R) invoice aging. (Available when the AR OPERA Control is active).	Optional
update_statistics.update_statistics_main	Generating Reservation Statistics	Calculated reservation statistics; such as, number of rooms, number of guests and revenue.	Mandatory