6 Oracle Application Express Integration

Retail Home is capable of accessing data through Oracle Application Express (APEX).

This integration works by creating a REST service in APEX that returns data to be rendered in a Retail Home report. A Retail Home administrator then must configure the report in Retail Home to pull its data from the APEX service. For more information on how to configure Dashboards within Retail Home, see Dashboard Configuration. For more information about how to create REST services through the APEX UI, please refer to the Oracle APEX documentation.

Only certain reports within Retail Home support APEX integration, and the APEX REST service must return data in the correct format expected by the report for the integration to work. This document discusses how to integrate APEX with Retail Home reports.