Publication Statuses of Custom Subject Areas
After you create a custom subject area, you must publish it so that it's available for use in BI Composer. A custom subject area can have a few different publication statuses. Let's look at each one.
What Happens When You Submit for Publishing
But first, let's understand the publication process. 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.
If you're working on multiple custom subject areas at once, then be sure to publish them one at a time. The first custom subject area might publish successfully, but subsequent custom subject areas could result in publish failures.
Publication Statuses
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. Use these error status details to pinpoint and fix problems quickly. -
OK: This status indicates that the custom subject area has been published successfully. You can use BI Composer to create reports using the objects, attributes, and measures that you have configured in the subject area.