Owners Statement Export Data Definition (EXP_OWNERS_STATEMENT)

The Owners Statement Export is automatically generated and transmitted to the application server during the Night Audit procedure in OPERA. This export can be manually run by selecting Miscellaneous>File Export>General or Configuration>External>Export Files. This export file is available on-demand, to allow for external and local resources to produce more up to the minute information in case of an emergency. The file transfer from OPERA t the database is completed by using the OPERA OXI_HUB Interface, with an HTTP address that is setup for the actual export file itself (see Export Files for details).

Views Used by This Export

Owners Export View: EXP_OWNERS_STATEMENT

Pre-Export Procedure

<None>

Post Export Procedure

exp_create_data.delete_report_table(exp_create_data.get_last_report_id)

Parameter Form

EXP_OVOS

Input Parameters

From Date. Start date for the export.

To Date. End date for the export.

Filter Conditions

export_id = exp_create_data.get_last_report_id

File Name Formula

'VOS'||to_char(pms_p.business_date,'rrddd')

File Extension Formula

'VOS'

EXP_OWNER_STATEMENT File Header and Detail Data

See the Owner Statement Export File Header and Detail Data

See Also

• Export Files