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):

• Create a segment hierarchy
• Manage the segment hierarchy
• Audit the tree
• Set the tree status to active
• Enable Row and Column Flattening
• Assign the tree code to the segment instance
• Validate and deploy the GL KFF
• Run the BI extension
• (Optional) Secure the segment hierarchy
• [Check if the View Object (VO) has data from Oracle Transactional Business Intelligence (OTBI)](#check-if-the- VO-has-data-from-otbi)

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

Create a segment hierarchy

• Select My Enterprise → Setup and Maintenance → Financial 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 Actions → Create 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 Actions → Create 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 Actions → Add.
  • 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 Actions → Add.
  • 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.

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 Actions → Audit.

Set the tree status to active

• In Manage Account Hierarchies, select Actions → Set Status → Active.

Enable Row and Column Flattening

• In Manage Account Hierarchies, select Actions → Flatten → Column Flattening.
• In Manage Account Hierarchies, select Actions → Flatten → Row 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 Actions → Manage Structure Instances.
  • In Manage Key Flexfield Structure Instances, select Operations Accounting Flex for Structure Name.
  • Select Search.
  • For Operations Accounting Flex, select Actions → Edit.
  • In Edit Key Flexfield Structure Instance: Operations_Accounting_Flex, for Account, select Actions → Edit.
  • 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 Actions → Validate Metadata.
  • For the General Ledger Accounting Flexfield, select Actions → Deploy Flexfield.
  • Select Done.

Run the BI extension

• Select Tools → Scheduled 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 Administration → Issue 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

Copy
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

Copy
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"]}