Creating the FCM_OFMA Table for Financial Close Management for Oracle Databases Only

If you are planning to use the Financial Close Management dashboards, you must create the FCM_OFMA table.

The FCM_OFMA table is used in the database to create a sequence of work days for combining results in the FCC_PRIOR_PERIOD_ANALYSIS, to a maximum of 1001 days. This table is only visible in the database, not the RPD file.

Caution!

Only Oracle databases are supported for this release.

For additional information about creating tables, see the Oracle® Fusion Middleware Connectivity and Knowledge Modules Guide for Oracle Data Integrator.

Caution!

If you copy the script from the document PDF, the script may run on to the next page. Ensure that you capture all lines for the selected script, and that you DO NOT capture the document footer or page number when copying, as shown in the screen capture below; otherwise, the script will fail:

When copying the script from the document PDF, ensure you capture all lines in the script, and do not capture the document footer and page number.

To create the FCM_OFMA table:

Using SQL Developer, connect to the Financial Close Management database.

Create the table, as follows:

Create table FCM_OFMA (WORKDAYS number(4));
DECLARE
v_Counter BINARY_INTEGER := -500;
  BEGIN
   WHILE v_Counter <= 500 LOOP
    INSERT INTO FCM_OFMA (WORKDAYS) VALUES (v_Counter);
v_Counter := v_Counter + 1;
   END LOOP;
  END;