Set Up General Ledger Key Flexfields for Oracle Cloud ERP

Here are the high-level steps to set up the General Ledger (GL) Key Flexfields (KFFs):

The detailed steps are below, which use the Account segment as an example.

Create a segment hierarchy

  • Select My EnterpriseSetup and MaintenanceFinancial Reporting Structures.
  • In Search Tasks, enter Manage Account Hierarchies and select search (magnifying glass icon).
  • Select the Manage Account Hierarchies task from the search results.

Create a tree

  • Select ActionsCreate Tree. In Manage Account Hierarchies: Specify Definition:
    • Enter the tree Name.
    • Enter the tree Code.
    • Select the Tree Structure.
    • Select Accounting Flexfield Hierarchy. The Data Source Parameters section appears.
    • Select the arrow to the left of Accounting Flexfield Hierarchy Detail Values to expand it.
      • For Bind_ValueSetCode* enter Account.
    • Select the arrow to the left of Accounting Flexfield Hierarchy Parent Values to expand it.
      • For Bind_ValueSetCode* enter Account.
    • Select Next.
    • In the Specify Labels step, select Next.
    • In the Specify Access Rules step, select Submit.

Create a tree version

  • Select ActionsCreate Tree Version. In Manage Account Hierarchies: Specify Definition:
    • Enter the tree version Name.
    • Select an Effective Start Date of one day before today’s date.
    • Select Next.
    • In the Confirmation window that appears to indicate that a new blank tree version has been created successfully, select OK.
    • Select ActionsAdd.
    • In the Add Tree Node window:
      • For Data Source, select Accounting Flexfield Hierarchy Parent Values.
      • In Available Nodes, select 1000 - Total Assets.
      • Select the right arrow (>) to move 1000 - Total Assets to Selected Nodes.
      • Select OK.
    • Select ActionsAdd.
    • In the Add Tree Node window:
      • For Data Source, select Accounting Flexfield Hierarchy Detail Values.
      • In Available Nodes, select 1110 - Cash.
      • Select the right arrow (>) to move 1110 - Cash to Selected Nodes.
      • In Available Nodes, select 1200 - Accounts Receivable Total.
      • Select the right arrow (>) to move 1200 - Accounts Receivable Total to Selected Nodes.
      • Select OK.
    • Select Submit.

Note

You may need to run the Enterprise Scheduler Service (ESS) job Publish Chart of Account Dimension Members and Hierarchies to Balances Cubes in Parallel if you change the value set to be summary.

Manage the segment hierarchy

To manage the segment hierarchy, you need to audit the tree, set the tree status to active, and enable Row and Column Flattening. Here are the details:

Audit the tree

  • In Manage Account Hierarchies, select ActionsAudit.

Set the tree status to active

  • In Manage Account Hierarchies, select ActionsSet StatusActive.

Enable Row and Column Flattening

  • In Manage Account Hierarchies, select ActionsFlattenColumn Flattening.
  • In Manage Account Hierarchies, select ActionsFlattenRow Flattening.

Assign the tree code to the segment instance

  • In Task, select Manage Chart of Accounts Structure Instances.
  • In Manage Chart of Accounts Structure Instances:
    • In Key Flexfield Code, enter GL.
    • Select Search.
    • For the General Ledger Accounting Flexfield, select ActionsManage Structure Instances.
    • In Manage Key Flexfield Structure Instances, select Operations Accounting Flex for Structure Name.
    • Select Search.
    • For Operations Accounting Flex, select ActionsEdit.
    • In Edit Key Flexfield Structure Instance: Operations_Accounting_Flex, for Account, select ActionsEdit.
    • In the Edit Key Flexfield Segment Instance: Account window, select the Account tree name.
    • Select OK.
  • Select Save.
  • In Manage Key Flexfield Structure Instances, select Done.
  • In Manage Chart of Accounts Structure Instances, select Done.

Validate and deploy the GL KFF

  • In Task, select Manage Chart of Accounts Structure Instances.
  • In Manage Chart of Accounts Structure Instances:
    • In Key Flexfield Code, enter GL.
    • Select Search.
    • For the General Ledger Accounting Flexfield, select ActionsValidate Metadata.
    • For the General Ledger Accounting Flexfield, select ActionsDeploy Flexfield.
    • Select Done.

Run the BI extension

  • Select ToolsScheduled Processes.
  • In Overview, select Schedule New Process.
  • In the Schedule New Process window, in Name, select Import Oracle Fusion Data Extensions for Transactional Business Intelligence.
  • Select OK.
  • In the Process Details window:
    • Select ERP.
    • Select Submit.

Secure the segment hierarchy

Optionally secure the segment hierarchy and run the LDAP sync.

Check if the VO has data from OTBI

  • In OTBI, select AdministrationIssue SQL.
  • Enter the following query: select_physical * from "FscmTopModelAM.AccountBIAM.flex_tree_vs_gl_account_vi"
  • Select Issue SQL.

The Incorta GLSegmentHier materialized view uses the following VOs:

  • Fusion_FIN_COMMON.flex_tree_vs_gl_account_vi gcf
  • Fusion_FIN_COMMON.fndtreeversiontlp1 tvt

Here are some sample OTBI issue SQL queries:

Natural account

FscmTopModelAM.AccountBIAM.FLEX_TREE_VS_GL_ACCOUNT_VI
FscmTopModelAM.AccountBIAM.FLEX_TREECODE_VS_GL_ACCOUNT_VI
select_physical * from FscmTopModelAM.AccountBIAM.FLEX_VS_GL_ACCOUNT_VI
select_physical * from "FscmTopModelAM.AccountBIAM.flex_tree_vs_gl_account_vi"

Cost center

select_physical * from "FscmTopModelAM.AccountBIAM.FLEX_VS_FA_COST_CTR_VI"
select_physical * from "FscmTopModelAM.AccountBIAM.FLEX_TREE_VS_FA_COST_CTR_VI"
export const _frontmatter = {"title":"Set Up General Ledger Key Flexfields for Oracle Cloud ERP","locale":"en","version":"latest","slug":"blueprints-oracle-cloud-erp-gl-kffs-on-prem","tags":["blueprints-oracle-cloud-erp","blueprints-all","tools-schema-manager","tools-analyzer"]}