Responsys Transaction Exports

The General export, Responsys_TRX_Day, exports reservation sales charge transactions to the Oracle Responsys system. This export can be generated for a transaction date range. Additional filter conditions can be defined in Miscellaneous > File Exports > General > Select the export file type > Edit > Filter Condition. The OPERA Cloud add on OPP_EXP subscription must be activated for General Exports functionality.

The Responsys_TRX_Day export considers transactions where the Transaction Code is flagged revenue_yn=Y.

There are three export file types available in the list of templates within the General exports. To add templates to your property, select the applicable export(s) from the template list. Go to Miscellaneous > File Exports > General > New and select/add the files types to the property.

RESPONSYS_TRX_DAY. You can use this template file type to generate the transaction export manually.
RESPONSYS_TRX. When this template file type is added to the property, the transaction export is automatically scheduled to run during End of Day (EOD). You can review the scheduler job from Miscellaneous > File Exports > Schedules.
RESPONSYS_TRX_AUTO. You can use this template file type to schedule the transaction export from Miscellaneous > File Exports > Schedules.

When the transaction export is generated during End Of Day or from a scheduler job, the export is generated for the previous business date.

Transactions of pseudo room type reservations are not included in this export. The Transaction export is generated in comma separated file format by default; you can change the format to .txt from Miscellaneous > File Exports > General > Select the export file type > Edit > update the file extension formula. The export is delivered to an SFTP server or file system location.

Generating the Responsys_TRX_Day Export

For generating the Responsys_TRX_Day export manually, the export parameter screen should be provided with options to select a past date range. The date range you select is the transaction date range. The From Date field and To Date field should default to the previous business date (OPERA Cloud business date - 1). You can select a different date range (earlier than today's business date). The From Date and To Date selection is mandatory to generate export. The export should not be executed until a valid date range is specified.

Table 8-7 Export Fields

Column	Type and Length	Description
TRANSACTION_DATE	Text (100)	Transaction Date in OPERA Cloud.
TRANSACTION_ID	Text (100)	OPERA Cloud Transaction Numbers.
RESERVATION_ID	Text (100)	OPERA Cloud Reservation Confirmation Numbers.
REVENUE_TYPES	Text (100)	Transaction Group mapped to the Transaction Code of the above Transaction Number.
REVENUE_AMOUNTS	NUMBER	Net Revenue Amounts.
CURRENCY	Text (100)	Currency Code used in Reservation.