Reset Data Utility

Note: A password available from Oracle Systems Development is required in order to run this utility. This utility should be used with extreme caution and understanding of its impact.

The Reset Data utility is available to reset transactional data in the OPERA database to the original system input data (SID) provided with the application. Transactional data is the data created as part of everyday system operations performed by hotel staff, as distinct from the data created and managed by system administrators using the OPERA System Configuration features. For example, reset data will delete reservations, folios, commission payment details, housekeeping task assignments, and business blocks, to name only a few of the kinds of front end data that is reset by the utility. However, reset data will not delete information set up as part of System Configuration (called configuration data) such as transaction codes, rate codes, users and user permissions, and property details. A list of the OPERA database tables reset by the reset data utility is shown in the grid on the Reset Data screen. The list of Tables Reset by the Data Reset Utility, below, also shows the tables affected by this utility.

Next, select Utilities > Data > Reset Data and the Reset Data Login screen displays a prompt for the reset data password. The reset data password changes daily and is strictly controlled by Oracle.

Warning! The reset data utility should be used with extreme caution. When you reset data, all data in the OPERA database front end is removed. This feature should be reserved for use for managing databases used for training purposes. It should not be used in a production environment.

Once you have logged in with the reset data password, the Reset Data screen appears and provides the following information.

Schema/Property. Select the option button that corresponds to the scope of the reset to perform.

Note: When you reset the Schema, all profiles are deleted. A reset at the Property level does not delete "schema-level" profile information such as the name, address, and communications details. However, property-specific profile data such as profile notes, profile preferences, profile subscriptions, etc., are removed.

Select the Schema button to reset data for the entire database schema (all properties that use the database). The name of the schema appears in the title bar.
Select the Property button to reset data for a single property defined in the database schema. The default is the property to which you are logged in. Select the down arrow to choose another property. The name of the property selected for reset appears in the title bar.

Table Name. The screen grid shows a list of all OPERA database tables that are reset by the reset data utility. (This list is for your reference only; you cannot select individual tables to be reset.) To check whether a specific table is affected, enter the name of the table in this field and select the Search button. If the table name is found, it will appear in the grid.

The grid lists the database tables that are affected by the reset data utility. This list is for your reference only; you cannot select individual tables to be reset.

Simulation Only. Select this check box to only log entries in the reset_data_jrnl table, but not delete data or truncate tables.

Running the Reset Data Utility

Note: Activity logging for the Reset Data Utility is done in reset_data_jrnl (progress) and in rw_server_log (command line when log_run_report is on).

select * from reset_data_jrnl
select * from rw_server_log where DES_NAME = 'RESET_DATA'

To reset data in all the OPERA database tables listed in the Reset Data screen grid, select the Reset button.

Note: All users must be logged out of all schema properties for this utility to run. A message appears if there are logged in users and you are given the opportunity to either send them a system message advising them to log out, or to kill their sessions.

Messages appear as the utility resets data from the OPERA database tables. Following reset, only front end data provided as part of the original OPERA SID data will remain in these tables.

Note: If a property has an active OPP MHT3 Multi-property Cross Revenues license and has cross-posted transactions with any other property participating in the cross-posting arrangement, resetting data for that property requires that data be reset for the other participating properties as well. When you select the Reset button, a prompt allows you to proceed with resetting data for all participating properties, or cancel the reset action.

Tables Reset by the Reset Data Utility

Note: Because the list of tables that are reset by the reset data utility may change from release to release, it is suggested that you refer to the Reset Data screen grid for a complete up-to-date list of affected tables for your installation.

Table Name	Description
ACTIVITY$LINK	Stores the relationships between activities and contacts, accounts, and business blocks.
AGENCY_TEMP	Internal.
AGENT_STAT_DAILY	Stores statistical information about travel agents on a daily basis.
ALLOTMENT_ACTION	Records the changes of block bookings, for each property.
ALLOTMENT_CHANGES	Stores the history of the allotment_detail table.
ALLOTMENT_CHANGES_NET	Records the Change log information for a Block per stay date.
ALLOTMENT$DETAIL	Stores details of each block booking, for each property.
ALLOTMENT$HEADER	Stores block booking information, for each property.
ALLOTMENT_PRODUCTS	Stores the products attached to block bookings, for each property.
ALLOTMENT_RATES	Stores rate codes belonging to unique Contract/Business Block ID.
ALLOTMENT_RESTRICTIONS	Stores allotment restriction details.
ALLOTMENT_ROOMTYPE_PRIORITIES	Stores the room type priorities of a block booking, for each property.
ALLOTMENT_SNAPSHOT	Stores the snapshots of the block room grids.
ALLOTMENT_TRACES	Stores traces attached to block bookings, for each property.
AR$_ACCOUNT	Stores the AR account setup, for each property.
AR$_MAILING_HISTORY	Stores AR Reminders sent to the AR Accounts.
AR$_NOTES	Stores notes related to the AR Account code.
AR$_STMT_HISTORY	For each property, stores information regarding statements sent to A/R accounts and is used to allow for resending the statements.
AR$_TRACES	Stores AR Trace information for the AR Accounts.
AR_ACTION	For each property, stores user log information regarding changes/events made to an A/R account.
AR_CREDIT_CARD_SETTLE	For each property, stores records for bundled transactions for credit card invoices in Accounts Receivable.
AR_CREDIT_TRNS_LIST	For each property, stores information regarding transactions created from credit card invoices.
AR_INVOICE_HEADER	For each property, stores all transactions related to A/R.
AR_NOFAX_RECORDS	Stores records from A/R batch statements where the field Fax_No is null, for each property.
AUDIT_BOX	Summary of transactions for a day to match the receipts with the postings for that day.
AUTHORIZER$_LIMITS_DETAILS	Detailed routing information for each authorizer.
AUTHORIZER$_LIMITS_HEADER	Routing instructions defined for an authorizer.
AWARD_REQUESTS	Stores award details for each guest, for each property.
BATCH_REQUESTS	Keeps track of the reports that would get printed during night audit.
BOOK$BILLING	Billing instructions per Block.
BOOK$NOTES	Multiple notes for the Block header.
BOOK$OWNER	Owners of the Block header.
BOOKING$LINK	Business Block header relationships.
BOOK$PROFILE_LINK	Table linking Business Blocks to Business Profiles.
BUSINESS$PROFILE_FORECAST_DTLS	Potential Forecast details.
BUSINESS$PROFILE_LINK	Table linking Account and Business Profile.
BUSINESS$PROFILE_NOTES	Notes for a Business Potential.
BUSINESS$PROFILE_OWNER	Owner of the Business Potential.
BUSINESS$PROFILE_REVENUE	Revenue for a Business Potential.
BUSINESS_EVENTS	Stores the Business events information.
BUSINESS$PROFILE	Information about Business Potential.
CHECK_REGISTER	Stores all details for each check in each account.
COMMISSION_PAYMENTS	Stores payment information of commission payments paid to travel agents and sources.
COMMISSION_PROCESS_ACTION	Records changes made within the commission handling module.
COMMISSION_RESV_DATA	Gathers and stores commissionable data from all reservations that have checked out prior to that business day.
COMPANY_STAT_DAILY	Stores statistical information about companies on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
COMPUTED_COMMISSIONS	Stores computed values for commissions for all travel agents and sources.
CONCURRENT_STATUS	Stores the information of when the last job has been processed.
CONFIGURATION_ACTION	Stores the journaling information for OPERA's system configuration.
CONTACT_STAT_DAILY	Statistical information about reservation contacts.
CR_CARD_SETTLE	Stores the credit card settlement information of credit cards to be settled.
CUSTOM_FACILITY_CODES_SCHEDULE	Stores the custom facility details.
CUSTOM_FACILITY_TASK_SCHEDULE	Stores the custom facility task details.
DAILY_EL_LOG_TEMP	Records changes in rate code, room type, adults, children, market code, origin of booking, for the days of the reservation when a change happens.
EMP_NON_AVAIL	Stores (for each employee) non-availability details such as vacation request dates, leave, jury duty, military leave.
EMP_SCHEDULE	Stores the scheduled hours of each employee for each date .The data for this table is derived from EMP_AVAIL, EMP_NON_AVAIL, EMP_DETAILS, and EMP_WORK_CATEGORIES.
ERROR_LOG	Logs error conditions and error messages raised by night audit procedures.
EVENT$CHANGES	Event Changes information.
EVENT$CHANGELOG	Stores the Event Change Log
EVENT$CHANGELOG_DETAILS	Stores the Event Change Log Details
EVENT$ITEM	Booked Items for an Event.
EVENT$ITEM_DEPARTMENT	Responsible departments for booked items.
EVENT$ITEMGROUP	Multiple items grouped into a single price for items.
EVENT$LINK	Internal.
EVENT$MENU_DETAILS	Booked Menu Definition that contains the Menu items.
EVENT$MENU	Booked menus for an Event.
EVENT$MENUITEM_DEPARTMENT	Responsible Department for the booked Menu Items.
EVENT$MENU_REVENUE	Revenue Type Summary of Booked Menus.
EVENT$NOTES	Event Notes.
EVENT$RESERVATION	Event Reservation Info.
EVENT$RESERVATION_SHARE	Attendees for a shared Event.
EVENT$STATUS_CHANGES	Changes to the Event Status.
EXCEPTION_LOG	Internal.
FACILITY_SCHEDULE_DATES	Stores the Facility Schedule dates details.
FB$AGENDA	Meeting Agenda records linked to Business Blocks.
FB$AGENDA_NOTES	Meeting Agenda Notes.
FB$AGENDA_RESOURCE	All Resources associated with a meeting agenda.
FB$AGENDA_REVENUE	Revenue associated with a meeting agenda split by revenue type.
FIN$_TRAN_ACTION	Logs actions performed in the Cashiering module of OPERA PMS.
FIN_TRAN_DETAIL	Stores rate code descriptions in multiple languages for the respective guests.
FINANCIAL_TRANSACTIONS	All transactions related to cashiering.
FINANCIAL_TRANSACTIONS_JRNL	Journal entries of changes made to Financial Transactions tables.
FIXED_CHARGES	Stores the fixed charges that are to be paid by each guest.
FOLIOS	Stores all Bill Numbers and Window Numbers per reservation. This table lets you determine the reservation for which the fixed bill or window is used for.
FOLIO$_TAX	Summary of revenue information per bill.
FORECAST_DATA_LOAD_STATUS	Shows the status of data load during synchronization of forecast tables through scripts especially during situations when forecast data gets out of sync with transaction data.
FORECAST_PROCESSOR_FAILURES	Records which the forecast processor failed to process.
FORECAST_PROCESSOR_STATUS	Stores the records processed by the forecast processor dequeues from the forecast queue.
GAMING$_TRIP	Player data for each trip from the PTS system.
GEM$EVENT	Events.
GEM$EVENTGROUP	Multiple groups defined per Business Block.
GEM$EVENT_PKG	Gem event pkg.
GEM$EVENT_PKG_REVENUE	Gem event details.
GEM$EVENT_REVENUE	Event Revenues containing summarized Revenue Types.
GL_NUMBERS	Represents the operating company's General Ledger Chart of Accounts numbers.
GROUP_STAT_DAILY	Stores statistical information about groups on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
GUEST$_ENROLLMENT	Stores guest enrollment details.
GUEST$_LOOKUP	Stores guest membership details.
GUEST_CHECK_DETAILS	Stores all checks sent by POS terminals.
GUEST_ENROLLMENT_PREF	Stores all guest enrollment preferences to be transmitted to the CRS along with guest enrollment records.
GUEST_LOOKUP	Stores the guest enrollment information stored in the central reservation system.
GUEST_LOOKUP_PREF	Stores the guest enrollment preference information stored in the central reservation system.
GUEST_RSV_MESSAGES	Stores messages for guests attached to specific reservations.
GUEST_RSV_TRACES	Stores traces for guests attached to specific reservations.
GUEST_TRACES	Stores traces for guests.
HK_DAILY_TASK_ROOM	Stores room information linked with daily housekeeping tasks.
IFC_ACT_TABLE	Communication between OPERA and Interfaces.
IFC_DATA	Stores inquiries from the MICROS 8700 POS terminal.
IFC_WAKE	Stores wake up call data for date for each room.
IFC_WAKE_JRNL	Stores the user activity for each wake up call created.
INVENTORY_CONTROL_ACTION	Stores the actions for overbooking and sell limits for business events.
LABOR_USED	Labor info that was used while working on the work orders.
LEAD$	Leads for Business Block.
LOCATORS	Stores the locator information for the guest.
MARKET_STAT_DAILY	Summary table. Stores statistical information about markets on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
MEAL_VOUCHERS_TEMP	Stores meal vouchers that will be printed by the system.
MEETING_ROOM$INVENTORY	Meeting Room Inventory details.
MEETING_ROOM$WAITLIST	Waitlisted Function Spaces.
MEMBERSHIPS	Stores the membership information for each profile.
NA_FINREPORT_STATUS	Stores the status (Filed, Printed, Filed/Printed) of the financial reports ran during the night audit.
NA_PARAMETERS	Stores the parameters for a night audit.
NA_REPORT_PARAMETERS	Stores the parameters for the reports.
NAME$NOTES	Notes for all types of profiles.
NAME$PREFERENCES	Preferences for each profile at each property.
NAME$_CREDIT_CARD	Credit cards for a particular profile for past stays.
NAME_KEYWORDS	Profile keywords.
NAME_POTENTIALS	Potential Information of Guest Statistics.
NAME_RESORT	Profile attributes which are property specific.
NAME_VIRTUAL#	Virtual Numbers allocated permanently to guest profiles.
NIGHT_AUDIT_CHECK	Night audit procedures completed for guests.
NIGHT_AUDIT_JURNAL	Stores the procedures run and their status (e.g., completed or failed) for each business date.
NIGHT_AUDIT_JURNAL_DETAILS	Logs the errors that occurred during night audit.
NO_TO_SELL_LOG_TEMP	Internal table. Used in Business events module.
PARTS_USED	Parts used for work orders to be fixed.
PAYMENT_APPLICATION	Stores payments to one invoice or to multiple invoices.
PAYMENT_TAX	Tax Invoices and information relating to tax payments.
PAYMENT_TAX_JRNL	Tax Invoices and information relating to tax payments.
PMS_FORECAST_QUEUE_TABLE	Forecast Processor Queue Table.
PMS_MEMBERS	Required for the installation wizard form for extracting inventory.
POLICE_IFC	Reservation records for Police Interface.
POLICE_IFC_JRNL	Changes made to reservation records for Police Interface.
PROFILE_ACTION	Stores the action log for each profile.
PROFILE_STAT_DAILY	Stores statistical information about individuals on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
RATE_ACTION	Stores the user activity log for the Rate module. Each column dependent upon the action that takes place.
RATE_CODE_STAT_DAILY	Summary table. Stores statistical information about rate codes on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
RATE_DAILY_SOLD	Stores the number of rooms sold on a daily basis for each room type and each rate code.
RATE_STRATEGY	Stores the rate strategies defined to be run during the night audit to reflect the changes in rate codes and rate sets.
REPORT_TABLE	Temporary storage of report output data.
REP_MANAGER	Data for the Managers Report.
REQUEST	Stores all the report requests sent via Concurrent Manager.
REQUEST_PARAMETERS	Stores all the parameters related to requests.
REQUEST_STATUS	Stores the list of possible completion statuses for concurrent manager requests.
REQ_FOR_PUBL_ITEMS	Internal.
RESERVATION_ACTION	Stores user log information regarding changes/events made to reservations, for each property.
RESERVATION_ALERTS	Alert messages for reservations.
RESERVATION_BALANCES	Stores the reservation balance for all in-house guests and guests checked out within the last month, for each property.
RESERVATION_CANCEL_POLICY	Stores the cancellation policy.
RESERVATION_COMMENT	Stores reservation comments for each reservation, for each property.
RESERVATION_CONF_LETTER	Stores information regarding each confirmation letter sent for each reservation per company, guest, group, source, or travel agent, for each property.
RESERVATION_DAILY_ELEMENTS	Stores room resource information (room, room type) for each date for each reservation in a daily format, including some information that can be different on different days during the stay of the guest (e.g., rate code, market code, etc.), for each property.
RESERVATION_DAILY_ELEMENT_NAME	Implements the many-to-many relationship between the RESERVATION_NAME table and RESERVATION_DAILY_ELEMENTS table. Stores information regarding the number of adults, children, and the rate amount for each reservation for each date, for each property.
RESERVATION_DEPOSIT_SCHEDULE	Stores information regarding each reservation's requested deposit schedule, for each property.
RESERVATION_HEADER	Stores the reservation heading information for each reservation at each property.
RESERVATION$_HISTORY	Stores all information pertaining to reservation history records that have been imported from a previous system and all manual reservation history records that are created through the user interface, for each property.
RESERVATION_LINKAGE_CNR	Stores the linkage information between reservations associated with connected suites functionality.
RESERVATION_NAME	Stores one record per reservation, for each property.
RESERVATION_NAME_JRNL	Stores the old information prior to the updates to the RESERVATION_NAME table, for each property.
RESERVATION_OVERRIDES	Stores reservation override details.
RESERVATION_PACE	Transaction data for reservation pace report.
RESERVATION$_PAYMENT_METHODS	Reservation Payment details.
RESERVATION_PRODUCTS	Stores the package elements a reservation additionally purchases or those package elements which are included by a rate code but deselected in the reservation, for each property.
RESERVATION_PROMOTIONS	Stores the promotions for a reservation, for each property.
RESERVATION_RECEIPTS	Stores (for each reservation) the approval amounts, approval code, etc., related to credit card authorizations, for each property.
RESERVATION_RECEIPTS_JRNL	Stores the old information prior to the updates to the RESERVATION_RECEIPTS table, for each property.
RESERVATION_REGRETS	Stores the turnaway information for each attempt to make a reservation, for each property.
RESERVATION$_RESTRICTIONS	Rate restrictions for the property.
RESERVATION_SPECIAL_REQUESTS	Stores special requests for each reservation, for each property.
RESERVATION_STAT_DAILY	Detailed Reservation statistical Information.
RESERVATION_STAT_DAILY_DUMMY	Temporary storage of reservation_stat_daily.
RESERVATION_STAT_DAY_SUM	Summary reservation statistical information.
RESERVATION_SUMMARY	Stores for each reservation, block, and housekeeping event its forecast data.
RESERVATION_VIRTUAL#	Stores the virtual numbers allocated to each reservation, for each property.
RESORT_CALENDAR_EVENTS	Stores the event codes for the property.
RESORT_CALENDAR_EVENT_DATES	Stores the dates of the events for the property.
RESORT_HK_DAILY_TASK	Stores housekeeping daily task information to be performed by housekeeping personnel.
RESORT_HK_DAILY_TASK_EMP	Stores all the employees assigned to a task. The task sequence number identifies the task for which the employee was assigned.
RESORT_HK_EMPLOYEE_POINTS	Stores earned housekeeping points by date per property.
RESOURCE$NOTES	Notes for Event resources.
ROOM_MAINTENANCE	Stores room maintenance information for each room in each property.
ROOM_REPAIRS	Stores out of order and out of service information for each room at each property.
ROOM_CATEGORY_STATISTICS	Statistical Information about room types on a daily basis.
ROOM_STATISTICS	Used in the housekeeping module for verification of synchronization between housekeeping and front desk for each room at each property for each date.
SC$ATTACHMENT	Attachments in Sales & Catering.
SH_ENROLLMENT_STATISTICS	Stores statistical information for each enrolled guest and is populated during the Guest Lookup process from CRS.
SOURCE_PROF_STAT_DAILY	Stores statistical information about profile sources on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
SOURCE_STAT_DAILY	Summary table. Stores statistical information about origin of booking sources on a daily basis, for each property. (The Column Descriptions for this table are the same as for the table AGENT_STAT_DAILY).
STAT_DATA_ELEMENTS	Stores reservation data elements for OPERA Statistics.
SUMMARY_REFRESH_LOG	Stores the refresh time of the summary table updates (the 'Last Run Date' of night audit procedures), for each property.
TEMP_ADDON_CALCULATIONS	Stores information required for the generated transaction.
TEMP_NA_REPORTS	Stores the report module IDs that need to be printed during Night Audit.
TEMP$_REG_CARDS	Stores registration card information.
TEMP_ROOM_CAT	Stores room categories for inventory calculations.
TEMP_ROOM_CLASS	Stores room classes for inventory calculations.
TMP_RESERVATION_PERSON_LIST	Used by the get_share_info function in the Reservation module.
TMP_TAXCALC	Stores the revenue information while populating forecast tables. This is purely a temporary table.
TRIAL_BALANCE	Stores the summarized transactions for that business date during night audit.
TRX$_CODES_ACTION	Stores the actions taken on the transaction codes.
TRX$_CODES_COMP_XREF	Gaming link table to cross reference what transactions can be comped.
TRX$_CODES_JRNL	Stores journal entries of changes made to the TRX$_CODES table.
TRX_ROUTING_INSTRUCTIONS	Stores the details of routing instructions.
UPDATE_MARKET_CODE_EXCEPTIONS	Stores all exceptions for market code changes locked at time of change.
US_1099	Stores data for the IRS Forms 1099 and 8300.
US_1099_PERIODS	Stores the periods for the data in US_1099 table.
WORKORDER_PAGER	Linked table of work_orders and sent_to_page.
WORK_ORDERS	Work orders created.
WORK_ORDERS_RESV	Work order table for each reservation.
YM_NAME_ADJUSTMENTS	Stores the Information of Adjustment codes attached to each Profile for the Yield Management functionality.
YM_RATE_SET_ADJUSTMENTS	Stores the Information of Adjustment codes attached to each rate set for the Yield Management functionality.