Publication Statuses of Custom Subject Areas

This topic covers what happens when you submit a custom subject area for publishing, and what the submission statuses indicate.

After you successfully publish your custom subject area, you can start building reports using Oracle Business Intelligence (BI) Composer based on your published subject area.

What Happens When You Submit for Publishing

When you submit a custom subject area for publishing, two processes occur in the background. The first process is synchronous and creates Oracle Applications Development Framework (Oracle ADF) artifacts. You must wait until this first process is over. The second process is asynchronous and creates centralized metadata repository (RPD) fragments and submits them to the Oracle BI server.

Note: You must refresh the status to know whether the custom subject area is submitted successfully. You may have to refresh the status multiple times, because the creation of Oracle ADF and RPD artifacts may require some time.

A custom subject area can have one of the following statuses:

• Pending: This status indicates either of the following:

  • You saved and closed the configuration process for a custom subject area before submitting it for publishing.

  • A failure occurred in the background processes when creating Oracle ADF and RPD artifacts.

• In Process: This status indicates that the data is in the process of being published to Oracle BI.

  Note: If the in-process status doesn't change to OK, even after multiple refresh attempts, then there could be an error in publishing. If an error occurs, then the details are displayed, as well as information about how to fix problems, where applicable. These error status details allow you to pinpoint and fix problems quickly.

• OK: This status indicates that the custom subject area has been published successfully. You can use Oracle BI Composer to create reports using the objects, attributes, and measures that you have configured in the subject area.