Before you Begin

This tutorial shows you how to set up budget revisions in Oracle Enterprise Performance Management (EPM) Planning Financials and integrate it with Oracle Enterprise Resource Planning (ERP) Cloud Budgetary Control. The sections build on each other and should be completed sequentially.

Background

With Budget Revisions, planners can make revisions to an approved budget in Oracle Enterprise Performance Management (EPM) Planning Financials.

When you integrate Planning Financials with the Budgetary Control module in Oracle Enterprise Resource Planning (ERP) Cloud, you can view current consumption, check that proposed budget changes do not go below what has already been consumed, and update budget changes to impact funds available. After budget changes are reserved and approved, planners can review the budget revision details in Budgetary Control by drilling down on the current approved budget balances.

You use Data Integration to push data between EPM Planning Financials and Budgetary Control. You can configure and extend these integrations, for example, by applying other mappings as needed to meet your business requirements.

With this integration, the complete planning and revision cycle is integrated between EPM Planning Financials and Budgetary Control:

  • Build your original budget in EPM Planning Financials using the planning and forecasting process, and then push the original budget to Budgetary Control.
  • Create budget revisions and check funds in the adopted budget within EPM Planning Financials to ensure that the budget revisions you are proposing meet the controls set in Budgetary Control.
  • Reserve funds in Budgetary Control within EPM Planning Financials to update budget balance in Budgetary Control.
  • Drill through at the cell level from an approved budget in the Current Approved Budget form in EPM Planning Financials to Budgetary Control to review the budget revision transactions that make up the balance.

In this tutorial, you set up EPM Planning Financials Budget Revisions and integrate it with Oracle ERP Cloud Budgetary Control.

Configuration and Integration Considerations

  • The Budgetary Control module in Oracle ERP Cloud must be enabled before you begin.
  • In Budgetary Control:
    • You must create a control budget with Source Budget Type of EPM Financials module (Not Hyperion Planning) for this integration.
    • The currency must match the currency used in EPM Planning.
    • The calendar may differ from the calendar in EPM Planning. However, you must map calendar dimensions (Year and Period) in Data Integration and set default values for Budget Segments when setting up the Control Budget Structure of a Control Budget.
  • Budget Revisions is available to these Oracle EPM Cloud customers with the Planning Financials module enabled:
    • Legacy Enterprise Planning and Budgeting Cloud Services customers and Planning and Budgeting Cloud Service Plus One (PBCS +1) customers with Financials enabled, when the Essbase version is upgraded to the version that supports Hybrid Essbase and Hybrid Essbase is enabled.
    • EPM Standard Cloud and EPM Enterprise Cloud customers with Module application type when Hybrid Essbase is enabled.
    • Tip:

      If your application is not enabled for Hybrid, you must enable Hybrid before you can enable Budget Revisions.
  • The EPM Planning application must be set to use single currency.

    The currency in EPM Planning Financials must match the currency in Budgetary Control. Only single currency applications are supported.

  • Only monthly, quarterly, and yearly planning is supported. Both 12 month and 13 period calendars are supported. Weekly planning is not supported.
  • You must enable Expense planning.
  • You must use your own chart of accounts in EPM Planning Financials rather than using the provided chart of accounts. Learn more from these tutorials: Configuring Financials to Bring In Your Own Chart of Accounts in Planning and Leveraging Best Practice Planning in Financials using your COA.
  • If you incrementally enable Budget Revisions, and if you have customized the Trend Based Calculation rule, see the Updating Financials Artifacts section in the Administering Planning Modules documentation.
  • If you have detailed data in other EPM Planning modules (Workforce, Projects, or Capital), you must pull this data into EPM Planning Financials before you can integrate the data with Budgetary Control.
  • Create a budget scenario in EPM Planning Financials with the same name as the control budget in Budgetary Control to avoid errors in budget synchronization.
  • Define a Category mapping to map your EPM Planning Financials budget scenario with your Oracle ERP Cloud budget scenario. See the Defining Category Mappings section of the Administering Data Management documentation.
  • Verify that the default Period Mappings in Data Integration includes periods used in your budgets. See the Managing Period Mappings section of the Administering Data Integration documentation.
  • Load EPM Planning Financials budgets to the control budget with lowest level of detail account and calendar. Use summary control budgets to control at summary account and periods.

What Do You Need?

An EPM Cloud Service instance allows you to deploy and use one of the supported business processes. To deploy another business process, you must request another EPM Enterprise Cloud Service instance or remove the current business process.

  • Have Service Administrator access to an EPM Enterprise Cloud Service instance. The instance should not have a business process created.
  • Have Service Administrator access to Oracle ERP Cloud and Budgetary Control.
  • Have access to a ledger you can enable for Budgetary Control.
  • Have access to EPM Planning Financials metadata and data load files that map to your own chart of accounts.

Note:

See the Configuration and Integration Considerations section of this tutorial for a list of other requirements.

Enabling Budgetary Control

Oracle ERP Cloud Budgetary Control:

  • Orchestrates the spending control process by validating if transactions have sufficient funds and if they're subject to spending control.
  • Stores the budget, performs funds check and funds reservation when transactions are submitted or approved.
  • Maintains budgetary control balances for expense accounts, including budget, funds reserved (commitments, obligations, and expenditures), and funds available balances based on the budget calendar and control budget structure (chart of account segments), without any journal entries. Revenue, liability, and equity account types aren't supported.

In this section, you enable budgetary control for a ledger or project in Oracle ERP Cloud.

  1. In Oracle ERP Cloud, on the upper-right, click the arrow to display Settings and Actions.
    Settings and Actions
  2. Click Setup and Maintenance.
  3. In Functional Setup Manager, on the right, click Tasks.
    Tasks
  4. In Tasks, click Search.
    Search
  5. In the Search box, type budgetary control and click Search (Search).
    Searching for enabled budgetary control
  6. From the list, click Budgetary Control Enabled Ledger.
    Budgetary Control Enabled Ledger
  7. In Budgetary Control Enabled Ledger, click Manage Budgetary Control.
    Manage Budgetary Control
  8. In Manage Budgetary Control and Encumbrance Accounting, under Ledger and Business Unit Options, search for your ledger and click Edit (Edit).

    In this example, the Vision City ledger will be edited.

    Example
  9. In Edit Budgetary Control and Encumbrance Accounting, select Enable budgetary control for the ledger and all journal sources and categories.
    Enable budgetary control

    After selecting this option, the page is updated.

    Options after enabling

    You enable budgetary control for ledgers, business units assigned to a ledger, projects, transaction types, and journal sources and categories. The options you select can have critical implications in the way Oracle Fusion Budgetary Control handles your transactions.

    When you enable budgetary control, you must consider these options:

    • Control Budget Filter
    • Fail Budgetary Control for Budget Dates Not in Valid Budget Date Range
    • Default Date Rule
  10. For Control Budget Filter, select Ledger or Project.
  11. For Budgetary Control, select Transaction budget date falls outside of date range across all control budgets.
  12. For Validation Failures, select Transactions without project attributes don't have a matching chart of account based control budget.
  13. Verify your selections.
    Budgetary Control
  14. In Mapping Between Chart of Accounts and Budget Accounts, set default values to chart of account dimensions.

    Here's an example:

    COA Segment Values
  15. On the upper right, click Save and Close.
  16. In Manage Budgetary Control and Encumbrance Accounting, click Save and Close.
  17. In Budgetary Control Enabled Ledger, click Done.

Managing Control Budgets for Integration

You use control budgets to check the spending against a ledger, project, or both, and apply validations during budgetary control. You can specify the segments, budget periods, currency, control level and tolerance.

  1. In the Search box, type manage control budget and click Search (Search).
    Searching for enabled manage control budget
  2. From the list, click Manage Control Budgets.
    Select Manage Control Budget
  3. In Manage Control Budgets, click Create (Create).
  4. In Create Control Budget, enter a Control Budget name.

    In this example, the control budget is named EPM Progress Source Detail.

    Tip:

    Note down the names of the Control Budgets you plan to use in the integration. You will be adding these as Smart List entries later.
    Control Budget name
  5. Select a Budget Calendar.

    In this example, the Vision City Cal budget calendar is selected.

    Budget calendar
  6. Select a budget period.

    In this example, the period ranges from Jan-20 to Dec-21.

    Budget period
  7. For Source Budget Type, make sure that you select EPM Financials module.
    Source Budget Type
  8. When prompted, click Yes.

    Once selected, you cannot change the source budget type.

    Prompt
  9. Accept or rename the Source Budget Name.

    The Source Budget Name defaults to the Control Budget Name.

    Source Budget Name
  10. Select a currency and rate type.

    In this example USD and Corporate are selected.

    Currency selections
  11. Select the ledger you enabled for budgetary control.
    Ledger
  12. Assign a Budget Manager.

    In this example, the Budget Manager also has Service Administrator access.

    Tip:

    Note down this user. You will be using the same user to configure EPM connections later.
    Budget Manager
  13. Select chart of account segments for the Control Budget Structure.
    Segments
  14. On the upper-right, click the arrow next to Save and select Save and Close.
    Save and Close
  15. In Manage Control Budgets, above the name field, search for your control budget.
  16. From the search results, select your control budget row and click Edit (Edit.)
    Edit Control Budget
  17. In Edit Control Budget, click Action and select Prepare for Use.
    Prepare for use
  18. In the warning message, click Yes.
    Warning message
  19. At the confirmation message, click OK.
    Confirmation message
  20. To update the status in Manage Control Budgets, above the name field, search for your control budget.
  21. From the search results, verify that your control budget status displays as In Use, select your control budget row and click Edit (Edit.)
    Edit Control Budget
  22. In Edit Control Budget, hover your mouse cursor over the name. Take note of the Budgetary Control Cube name. You will need this later when setting up data integration.

    Here's an example:

    Cube Information
  23. Click Cancel.
  24. In Manage Control Budgets, click Done.
  25. In Functional Setup Manager (Search), click Done.

Creating the Application

In this section, you create a Module-based Planning application in Oracle EPM Enterprise Cloud.

  1. In Oracle EPM Cloud, under Planning, click SELECT.
    Select Planning
  2. Under Create a new application, click START.
    Create a new application
  3. In General properties, enter a Name and Description, and select Modules as the Application Type.

    Here's an example:

    Property Value
    Name ProgBud
    Description Progress Budgets
    Application Type Modules

    General properties
  4. Click Next.
  5. Select Time Period properties.

    In this example, the default time period, 12 Months is selected, alongside the following properties:

    Property Value
    Start and End Year 2018 and 2024
    First Month of Fiscal Year July
    Fiscal Year Start Date Same Calendar Year
    Weekly Distribution Even Distribution

    Time Period

    Note:

    Only monthly, quarterly, and yearly planning is supported. Both 12 month and 13 period calendars are supported. Weekly planning is not supported.

  6. For Currency settings, make sure to clear the checkbox for Multicurrency.
    Currency settings

    Note:

    Budget Revisions requires that the application is single currency.
  7. Accept all other default selections and click Next.
  8. Review the application properties you selected and click Create.
    Application settings

    The application creation status takes a moment to complete.

    Application creation process

    When the application creation process completes, an information message displays.

    You can click OK to proceed to the home page, or click Configure to proceed to the Configure page for modules.

    Information message
  9. Click OK.

Applying Display Preferences

In this section, you set display preferences in EPM Planning.

Enabling the Redwood Experience

  1. On the home page, click Tools, then Appearance.
    Redwood
  2. In Appearance, select Enable Redwood Appearance.
  3. For Display Business Process Name, select No.
    Appearance
  4. Click Save.

    After saving, the application displays in the Redwood theme.

    Redwood experience applied

Specifying Application Settings

  1. Click Navigator (Navigator), and under Application, click Settings.
    Go to Application Settings
  2. In Application Settings, under Number Formatting, set the Thousands Separator to Comma.
    Thousands Separator
  3. Under System Settings, select Display Users' Full Names.
    System Settings
  4. Click Save.
  5. At the information message, click OK.
    Information message

Setting User Preferences

  1. Click Navigator (Navigator), and under Tools, click User Preferences.
    Go to Application Settings
  2. On the left, click Display.
    Display
  3. In Display, under Number Formatting, verify that the Thousands Separator is set to Comma.
    Thousands Separator
  4. Under Other Options, for Date Format, select yyyy-MM-dd.

    Note:

    You must set the date format to yyyy-MM-dd.
    Date Format
  5. Click Save.
  6. At the information message, click OK.
    Information message

Renaming Dimensions (Optional)

Note:

This task may be optional in your production instance.

To make sure that the dimensions map between Oracle ERP Cloud and Planning Financials, you can modify dimension names in EPM Planning Financials before enabling features. In this section, you rename Entity to Department.

Tip:

Alternatively, you can map dimensions in Data Integration.
  1. Click Navigator (Navigator), and under Application, click Overview.
    Go to Application Settings
  2. In Application Overview, click Dimensions.
  3. From the Cube dropdown list, select All.
    Cube dropdown
  4. From the list of dimensions, click Entity.
    Entity
  5. Click the Edit Dimension Properties (Edit Dimension Properties) vertical tab.
    Go to Edit Member Properties
  6. Rename Entity to Department.
    Renaming Entity

    Renamed to Department
  7. Click Done.
  8. Verify that Department is now listed as a dimension.
    Department

    Tip:

    After making metadata changes, you must refresh the database to commit changes to the application. However, in this case, you will be enabling features in Financials which refreshes the database during the enablement process.

Enabling Financials with Budget Revisions

EPM Planning Financials provides components that you can enable incrementally to best meet your business needs. When you enable Budget Revisions:

  • A new navigation flow is added in EPM Planning Financials to create budget revisions.
  • New forms are added.
  • New trends are added for trend-based planning to make adjustments to your current budget.
  • Existing forms are updated to include the Budget Revision members and appropriate Approved Budget, Actual, and Encumbrance data.
  • Valid intersections are added to limit the information shown on forms to be the appropriate combinations.
  • Metadata is added to the application.
  • A Smart List, Control Budget Name, is created.
  • A new Connection type, Fusion Budgetary Control, is added in Connections.
  • Rules are added.

In this section, you enable Expense Planning (Expenses) and Budget Revisions in Financials. You can, optionally, enable other Financial features as you go through the steps in this section or at a later time.

  1. From the cards on top, click Configure.
    Configure card
  2. On the Configure page, select Financials from the dropdown list.
    Configure page

    The Configure page for Financials is displayed.

    Configure page for Financials
  3. On the Configure page for Financials, click Enable Features.
  4. In Enable Features, select Expense.

    Caution:

    You must use your own chart of accounts in EPM Planning Financials rather than using the provided chart of accounts.

    Learn more from these tutorials: Configuring Financials to Bring In Your Own Chart of Accounts in Planning and Leveraging Best Practice Planning in Financials using your COA.
    Select Expense
  5. Scroll down and select Budget Revisions. With Budgetary Control enabled, select the additional options you need.
    • Import Balances from Budgetary Control—Enables integration of encumbrance accounting, allowing you to track encumbrance balance. Creates a Scenario dimension member called OEP_Consumed, as well as associated trends for revising budgets. You can use this option to import any encumbrance, obligation, or commitment balances from Budgetary Control into EPM Planning Financials.
    • Update Budget Changes in Budgetary Control—Enables Funds Reserve to Budgetary Control to update budget balances and funds available in Budgetary Control from EPM Planning Financials.
    • Review Budgetary Control Impact Before Approving Budget Changes—Enables Funds Check to Budgetary Control within EPM Planning Financials before a budget is approved.
    • Number of active revisions—Specify the number of active budget revisions you can have, up to 30 active revisions. (This number is also limited by the total number of members in the Version dimension.) Note that when you reserve funds, the revision is cleared so EPM Planning Financials can reuse it. You can change this number later if you need to increase or decrease it.
    • Revision number prefix—Specify a prefix to add to the system-generated revision numbers. This revision number is the unique identifier of the revision in Budgetary Control.
    Budget revision options

    Note:

    If you select only Budget Revisions, EPM Planning Financials provides metadata required to perform budget revisions. This option allows planners to create, populate, and share revisions.
  6. Scroll down to Map/Rename dimensions, enable custom dimensions, associate it with a feature, and set one of the dimensions as the primary dimension for display, along with the Entity dimension, on forms.

    Here's an example:

    Primary Custom Dimension

    Note:

    When enabling Budget Revisions:
    • You must associate the custom dimensions with Financials features. Select the edit button next to the custom dimension and select Budget Revision.
    • Select Budget Revisions Primary Dimension for one of the custom dimensions to make it the primary dimension for display, along with the Entity dimension, on forms.
      • Only one dimension can be selected as the primary dimension.
      • The selected dimension appears on the rows instead of on the page on forms.
      • If you don’t select a primary dimension, then all of the dimensions show up on the page on forms.
      • If you select a primary dimension, and then select a different primary dimension, the first selection is deselected.
    • Do not rename the Plan Element dimension.
Custom dimensions
  • Optional: Select other features you want to enable. Keep in mind that, with Budget Revisions, you must use your own chart of accounts in EPM Planning Financials rather than using the provided chart of accounts.
  • On the top right, click Enable.
  • At the confirmation message, click Yes.
    Confirmation message

    The enablement process takes a moment to complete.

    Enablement process
  • At the information message, click OK.
    Information message
  • Sign out and sign back into Planning.
  • Configuring Financials

    In this section, you complete configuration tasks for Financials.

    Note:

    If you configured features other than those explicitly covered in the previous section, make sure to complete post configuration tasks required for those features. For more information, see the Administering Planning Modules documentation.

    Setting the Timeframe and Granularity for Plans

    1. From the home page, click Application, then Configure.
      Application Configure
    2. On the Configure page, select Financials from the dropdown list.
      Configure page

      The Configure page for Financials is displayed.

      Configure page for Financials
    3. Click Planning and Forecast Preparation.
    4. On the left, select the Current Fiscal Year, Period, and Plan Start Year of your plan.

      Here's an example:

      Duration
    5. On the right, select the planning frequency.

      In this example, all four (4) years are set to Monthly.

      Planning Frequency
    6. Click Save.
    7. At the validation message, click OK.
      Validation message
    8. Click Close.

    Configuring Budget Revisions Descriptive Information (Optional)

    In EPM Planning Financials, you use Budget Revisions Descriptive Information to create custom fields for Budget Revisions. These fields are added to the Budget Revisions forms so users can add more details for revisions. Adding metadata using this configuration task ensures that members are added in the correct location in the Account dimension hierarchy.

    In Oracle ERP Cloud, you add Budget Revision Attributes in the Manage Descriptive Flexfield task. See the Adding Budget Revision Attributes section in the Oracle Financials Cloud documentation.

    In this section, you configure Budget Revisions Descriptive Information in EPM Planning Financials.

    Note:

    This task may be optional in your production instance.
    1. On the Configure Page for Financials, click Budget Revisions Descriptive Information.
      Budget Revisions Descriptive Information
    2. In the Budget Revisions Descriptive Information dialog, verify that Component is set to Header Descriptive Details.
      Component
    3. Click Actions and select Add.
      Adding descriptive information

      A new row is added to the dialog.

      New line
    4. Enter a member name and set member properties.

      In this example, Reference is added. It will later be mapped as an attribute.

      Reference
    5. Click Save.
    6. At the information message, click OK.
      Information message
    7. From the Component dropdown list, select Line Descriptive Details.
      Component
    8. Click Actions, and select Add.
    9. In the added row, enter a member name and set member properties.

      In this example, Line Code is added.

      Line member
    10. Click Save.
    11. At the information message, click OK.
    12. Click Close.

    Importing Metadata

    The dimension members must match between EPM Planning Financials and Oracle ERP Cloud Budgetary Control. You must use your own chart of accounts in EPM Planning Financials rather than using the provided chart of accounts.

    Learn more from these tutorials: Configuring Financials to Bring In Your Own Chart of Accounts in Planning and Leveraging Best Practice Planning in Financials using your COA.

    In this section, you import dimension members into EPM Planning Financials.

    1. Click Navigator (Navigator), and under Application, click Overview.
      Go to Overview
    2. Click Dimensions.
      Dimensions
    3. On the right, click Import.
      Import
    4. For each of your metadata files, click Choose File. Then, select and open the file.
      Choose File

      Note:

      Depending on your browser, the button label may display Choose File or Browse.

      Here's an example:

      Attached data files
    5. On the upper-right, click Import.
      Import

      Caution:

      Make sure that your metadata files are valid prior to importing.

      For more information, see the Importing Metadata section in the Administering Planning documentation.
    6. In Options, select Refresh Database if Import Metadata is successful and click OK.
      Options
    7. In the information message, click OK.
      Information message
    8. On the upper-right, click Refresh until the Last Validate/Import columns displays an updated status of the job.

      Here's an example:

      Updated job status
    9. Click Completed to view the Import and Export job status details.
    10. When finished reviewing, click Close.
    11. In Import Metadata, click Close.
    12. In the next Import Metadata page, click Close.

    Adding Entries to the Control Budget Name Smart List

    When you enable Budget Revisions, a Smart List, Control Budget Name, is created. In this section, you add Smart List entries to define each of the control budgets that you want to integrate. This provides options in the user interface that allow users to create budget revisions for a specific control budget.

    1. Click Navigator (Navigator), and under Create and Manage, click Smart Lists.
      Go to Smart Lists
    2. In Smart Lists, select ControlBudgetName and click Edit (Edit).
      Smart lists
    3. In Edit Smart Lists, click the Entries tab.
      Entries
    4. In Entries, click Add (Add).
      Adding Smart List Entries
    5. In the new row, enter a name and label for a control budget that you want to integrate.

      In this example, an entry for the EPM Progress Source Detail ERP control budget is added.

      New entry

      Tip:

      The Smart List entries provide options in the user interface that allow users to create budget revisions for a specific control budget.
    6. If you need to add more control budgets as entries, repeat steps 4 through 5.
    7. Click Save.

    Assigning Values to User Variables

    User variables act as filters in forms, enabling planners to focus only on certain members. In this section, you set values for user variables.

    1. Click Navigator (Navigator), and under Tools, click User Preferences.
      Go to Application Settings
    2. On the left click User Variables.
      User Variables
    3. For each variable, click its Member Selector (Member Selector) to select a member as the variable's value.

      Here's an example:

      Members assigned
    4. Click Save.
    5. At the information message, click OK.
      Information message

    Assigning Access Permissions to Rules

    EPM Planning Financials includes rules used to calculate and push data for budget revisions.

    Aside from the standard Financials rules, the following rules are added when you enable budget revisions:

    Rule Name Description
    Prepare for Revisions After planning and forecasting is complete and the budget is pushed to Budgetary Control, run this rule to copy data from the original budget to an adopted budget in EPM Planning Financials.

    Run this rule only once before beginning revisions for the current year.

    This rule copies data from the original budget using the scenario and version you select, for the periods and years you select.

    Running this rule also enables drill through from EPM Planning Financials to a control budget in Budgetary Control.
    Create and Populate Revision After running Prepare for Revisions, this rule creates a revision header and optionally populates it with a percentage of the current approved amount.
    Share Revision Shares the revision with other planners to contribute to the revision cycle.
    Funds Check Makes a call to Budgetary Control to check funds and validate that the budget revision meets the controls set in Budgetary Control.
    Funds Reserve Once the budget revision is ready, the funds check is successful, and optionally the budget revision is approved if you are using the approval process, reserve funds in the Budgetary Control control budget associated with the revision.

    The budget revision is pushed to Budgetary Control, invoking the funds reservation process in Budgetary Control, reserving funds for any updated cell values.

    Also clears the revision.
    Clear Revision Manually clears a revision if you decide not to proceed with funds reservation.
    Get Funds Results When you run the Funds Check rule, if there are a large number of cells being checked and you don't see results right away, run Get Funds Results to check when the batch job is complete and then review results.

    In this section, you set access permissions to Budget Revisions rules.

    Assigning Permissions in the Rules Card

    1. Click Navigator (Navigator), and click Rules.
      Go to Rules
    2. For Prepare Revisions, click Permission (Permission) and select Assign Permission.
      Set Permission
    3. In Assign Permission, click Permissions.
      Assign Permission
    4. Click Add User/Group.
      Add User/Group
    5. Select a user you want to provision.
      Users

      Tip:

      You can assign permissions to a group in the Groups tab.
    6. Click OK.
    7. Click Close.
    8. In Permissions, verify that the user you selected is assigned Launch permission.
      Launch permissions
    9. Click Save.
    10. Click Cancel.
    11. Perform steps 2 through 10 to assign permissions to:
      • Create and Populate Revision
      • Share Revision

    Assigning Permissions in Rules Security

    1. Click Navigator (Navigator), and under Create and Manage, click Rules Security.
      Go to Rules Security
    2. In Business Rules Folders, select Clear Revision (OFS_Clear Revision) and click Assign access (Assign Access).
      Assigning access
    3. In Users, click Add Access (Add Access).
      Add Access
    4. Select a user and, for Type of Access, select Launch.
      Selecting a user and assigning access
    5. Click Add.
    6. At the information message, click OK.
      Information message
    7. Click Close.
    8. In Assign Access for OFS_Clear Vision, verify that the user is listed with access rights assigned.
      Assigned access to a user

      Tip:

      You can assign rules Launch permissions to Groups.
    9. Click Close.
    10. Perform steps 2 through 9 to assign access permissions to:
      • Funds Reserve
      • Funds Check
      • Get Funds Results

    Setting Up Data Integrations

    About Integrations Between Budget Revisions and Oracle ERP Cloud Budgetary Control

    You use Data Integration to drive the integration of budget revisions between EPM Planning Financials and Budgetary Control.

    Data Integration provides out of box solutions that enable EPM Planning Financials customers to map EPM Planning Financials dimensions to the dimensions in the Budgetary Control data model. After the setup is done in both EPM Planning Financials and in Data Integration, planners push data to Budgetary Control from within EPM Planning Financials.

    Here are the data integration tasks you complete in this section:

    General tasks:

    1. Register Oracle ERP Cloud as a source system.
    2. Register your Planning Application with OEP_FS as an input cube.
    3. Register Budgetary Control as a data source, specify the connection to use, and then import into Budgetary Control balance Essbase cubes into Data Integration.
    4. Register the Planning Budget Revision Data Source, which stores the preparations or revisions made to the budget and then is loaded to Budgetary Control.

    For each Budgetary Control Cube that you want to integrate, complete the following:

    1. Register a Budget Adjustment Request Application and associate it with a Budgetary Control Cube.
    2. Map Custom Budget Revision Attributes.
    3. Create the Integration between Planning Budget Revision and Budget Adjustment Request.
    4. Define dimension mappings with an import format. You also add Target Expressions to target dimensions.
    5. Define integration options.

    Control Budgets can share Budgetary Control Cubes if they use the same chart of accounts and calendar.

    Registering the Oracle ERP Cloud Source System

    1. Click Navigator (Navigator), and under Application, click Data Exchange.
      Go to Data Exchange
    2. Verify that you are on Data Integration.
      Data Integration
    3. Click Actions and select Applications.
      Go to Applications
    4. Click Configure Connections (Configure Connections).
      Go to Configure Connections
    5. In Connections, click the down-arrow next to Add (Add), and select Oracle ERP Cloud.
      Adding an ERP Cloud Connection
    6. In Create Connection, enter the source system connection details.

      Here's an example:

      Connection details
    7. Click Test Connection.

      Testing the connection takes a quick moment to complete.

      Testing status

      When the connection is successful, a status message is displayed on the upper-right.

      Connection successful
    8. Click OK.

      After saving the connection, it is listed on the Connections page.

      Connection listed
    9. On the upper-right, click Return (Return).

    Registering the OEP_FS Input Cube

    1. In Applications, click Add (Add).
    2. In Create Application, select:
      • Category: EPM Local
      • Application: <your EPM Planning application>
      • Cubes: Input Cubes - OEP_FS

      Here's an example:

      OEP_FS Application details
    3. Click OK.

      After saving, the application is listed on the page.

      Application listed

    Registering Budgetary Control as a Data Source and Importing Applications

    1. In Applications, click Add (Add).
    2. In Create Application, select:

      Here's an example:

      Budgetary Control application details
    3. Click Import Applications.
      Import Applications job submitted
    4. On the upper-right, click Close (Close).
    5. Click Actions and select Applications.
    6. In Applications, verify that additional applications were imported. Locate the Budgetary Control Cube name identified in step 22 of Managing Control Budgets for Integration.

      Here's an example:

      Imported applications

      Clicking Import Applications brings over Budgetary Control balance Essbase dimensionality into Data Integration as Budgetary Control target applications. A control budget dimension member within each Budgetary Control target application represents a control budget in Budgetary Control used to load and write back data from and to the Oracle Enterprise Performance Management Cloud.

    Registering the Planning Budget Revision Data Source

    1. In Applications, click Add (Add).
    2. In Create Application, select:
      PBR Details
    3. Click OK.

      When saved, this type of application is appended with a "BAR" in the application name. Here's an example:

      PBR application registered

    Registering a Budget Adjustment Request Application

    1. In Applications, click Add (Add).
    2. In Create Application, select:
      BAR Details
    3. Click OK.

      When saved, this type of application is appended with a "BAR" in the application name. Here's an example:

      PBR application registered

    Mapping Custom Budget Revision Attributes

    1. In Applications, click the Budget Adjustment Request application you just created.
    2. Click Options.
      Click Options
    3. In fields that start with Attribute , map any additional attributes.

      In this example, Reference is mapped to Attribute Char 1 and Line Code is mapped to Attribute Number 1. Both attributes were added in the Configuring Budget Revisions Descriptive Information section of this tutorial.

      Reference

      Line Code
    4. Click Save.
    5. Click Return (Return).
    6. Click Close (Close).

    Creating the Integration between Planning Budget Revision and Budget Adjustment Request

    1. In Data Integration, click Create Integration (Create Integration).
    2. Enter a name and location.

      Tip:

      The integration and location name can be the same.

      Here's an example:

      Naming the integration and location

      Note:

      Note down all integration names. You will be adding them as parameters when defining connections later.
    3. Click the down-arrow next to Source and select the data source you defined with the type Planning Budget Revision.

      Here's an example:

      Selecting a source

    4. Click the down-arrow next to Target and select the application you defined with type Budget Adjustment Request.

      Here's an example:

      Selecting a target
    5. Verify or select a Category.

      The Category refers to your budget scenario.

    6. Expand Location Attributes.
      Expand Location Attributes
    7. For Functional Currency, enter your default currency.

      In this example, USD is the default currency.

      Selecting a functional currency
    8. Click Save and Continue.

    Mapping Planning Budget Revision and Budget Adjustment Request Dimensions

    1. In Map Dimensions, verify that the Import Format name defaults to the integration name.
      Import format
    2. For Type, select Delimited - All Data Type.
      Data Type
    3. Verify or select a delimiter.
    4. Click Save.
    5. Select dimension mappings between the source (EPM Planning Financials) and target (Oracle ERP Cloud Control Budget).

      Tip:

      Add Target Expressions to each of the Budgetary Control dimensions that do not directly map with EPM Planning Financial dimensions.

      Target Expressions are used to transform the source value read from the source to the target dimension values to be loaded to target application.

      Add target expression

      Common expressions include:
      • Copysource - uses or copies the same member name from EPM Planning Financials in Budgetary Control
      • LTrim- removes the prefix used in EPM Planning Financials.
      • RTrim - removes the suffix used in EPM Planning Financials
      • Constant - assigns a constant value for an extra dimension in Budgetary Control.

      Here's an example:

      Mapped dimensions
    6. Click Save and Continue.

    Defining Budget Adjustment Integration Options

    1. In Map Members, click Save and Continue.

      You should be in Options.

    2. Next to Filters, click Options.
      Options tab
    3. Under General Options, accept defaults or select the following:
      • Category (Budget Scenario).
      • Period mapping type.

      Here's an example:

      General options
    4. Tip:

      Make sure that the default Period Mapping in Data Integration includes the period used in your budgets. See the Managing Period Mappings section of the Administering Data Integration documentation.
    5. Under Target Options, accept defaults or select the following:
      • Funds Action
      • Amounts Mode
      • Transaction Type
      • Online Mode

      Here's an example:

      Target options
    6. Click the down-arrow next to Save and select Save and Close.
      Save and Close

    Managing EPM Connections

    In this section, you create connections to facilitate user access and data movement between Planning Financials and Budgetary control.

    Setting Up a Connection for Funds Checking

    In this section, you set up a connection to Budgetary Control for Funds Check to validate budget revisions and for Funds Reserve.

    1. Click Navigator (Navigator), and under Tools, click Connections.
      Go to Connections
    2. In Manage Connections, click Create.
    3. From the available providers, click Fusion Budgetary Control.
      Fusion Budgetary Control
    4. Enter EPMXCCFUNDS as the name, and optionally add a description.
    5. Enter your Oracle ERP URL based on the following example:
      https://<ERP Service Connection Name>/fscmRestApi/resources/11.13.18.05/budgetaryControlBudgetTransactions
    6. Enter the name of the user who is assigned as a Budget Manager and has data access to the Budgetary Control budgets with which you want to integrate.
      URL
    7. Click Save and Close.

      After saving, the connection is listed on the Manage Connections page.

      Connection listed

    Setting Up a Connection to View Budgetary Control Result

    In this section, you set up a connection to Budgetary Control to view Budgetary Control results.

    1. In Manage Connections, click Create.
    2. From the available providers, click Fusion Budgetary Control.
      Fusion Budgetary Control
    3. Enter EPMXCCVFR as the name, and optionally add a description.
      EPMXCCVFR
    4. Enter your Oracle ERP URL based on the following example:
      https://<ERP Service Connection>/fscmRestApi/ resources/11.13.18.05/budgetaryControlResultsBudgetTransactions
    5. Enter the name of the user who is assigned as a Budget Manager and has data access to the Budgetary Control budgets with which you want to integrate.

      Tip:

      The user must have Service Administrator access to Budgetary Control.
      URL
    6. Click Save and Close.

      After saving, the connection is listed on the Manage Connections page.

      Connection listed

    Setting Up a Connection for Data Integration

    In this section, you create a connection to Data Management and Data Integration to invoke integration jobs.

      1. In Manage Connections, click Create.
      2. From the available providers, click Fusion Budgetary Control.
        Fusion Budgetary Control
      3. Enter EPMXCCDMINTEGRATION as the name, and optionally add a description.
        EPMXCCDMINTEGRATION
      4. Enter your Oracle EPM Planning URL based on the following example:
        https://EPM Service connection Name/aif/rest.
      5. Enter user credentials.

        Tip:

        Enter the EPM Service Administrator user name, in the format domain.userName, and password. In Oracle Cloud Infrastructure environments, you can omit the domain.
        URL
      6. Click Show Advanced Options.
      7. For each combination of the integration name used in Data Integration and control budget, add a parameter to link.
        • For Name, enter the Control Budget name.
        • For Value, enter the integration name.
        Parameters

        Tip:

        For Control Budgets that share the same Budgetary Control Cube, you can enter the same Data Integration Name in the Value field.
      8. Click Save and Close.

        After saving, the connection is listed on the Manage Connections page.

        Connection listed

    Optional Tasks Before Starting the Planning Cycle

    Here is a list of tasks that you may want to consider before starting the planning and forecast cycle:

    After you complete the required and optional tasks, you can start the planning and forecasting cycle.

    Learn More