Payroll Results Real Time - Gross amount by Organization (does not produce results)

Andrew Mc

Summary:

Using Payroll Results Real Time SA I have built a basic report to pull the total gross amount for a specific date range, by organization name. The report runs without issue when pulling a small sample of employees, however when running it for all employees (for one month date range) it runs indefinitely and does not produce results. I have tried removing a number of fields as well as trying to schedule it for a smaller time frame (original ask was to pull 12 months by month/year and quarter) but the report isn't running for just a single month.

I've also used the suggestions provided, but still not able to produce results: OTBI Unable To Run Report From Payroll Run Results Real Time In BI Analysis (Doc ID 2178851.1)

Content (please ensure you mask any confidential information):

The fields I have included:
Organization Name
Gross Amount
Occupational Classification

Ideally would also include:
Paid Month/Year
Quarter

Prefix added as suggested:
OBIS_ORACLEDB_HINTS_FOR_TOP_SELECT='OPT_PARAM(''_optimizer_mjc_enabled'',''false'') OPT_PARAM(''_optimizer_cartesian_enabled'',''false'') OPT_PARAM(''_optimizer_skip_scan_enabled'',''false'') OPT_PARAM(''_complex_view_merging'',''false'') OPT_PARAM(''_push_join_predicate'',''false'') OPT_PARAM(''_optimizer_push_pred_cost_based'',''false'')',PREFERRED_CURRENCY='User Preferred Currency 1',QUERY_SRC_CD='Report';

Catalog File attached for reference

Gross Amount by Market.zip

Does anyone have any suggestions to pull data from Payroll Results Real Time? As it feels like we have always struggled to get data from this SA.

Thank you,

Andrew

Andrew Mc

Does anyone have any guidance on getting Payroll Results Real Time SA for OTBI, or ultimately, do we have to build these reports in BIP?