4Flexfields

This chapter contains the following:

• Overview of Flexfield Use in Analyses

• Configure Key Flexfields for Transactional Business Intelligence

• Configure Descriptive Flexfields for Transactional Business Intelligence

• Configure Extensible Flexfields for Transactional Business Intelligence

• Import Changes to Flexfields Automatically

• Disable Flexfields as BI-Enabled

• Dimensions Supported by Descriptive Flexfields

• SCM Extensible Flexfields for Business Intelligence

Overview of Flexfield Use in Analyses

Flexfields are extensible sets of placeholder fields associated with business objects which can be placed on application pages. You can use flexfields to extend business objects and meet your data management requirements without changing the data model or performing any database programming. To include flexfields you have used for extension for use in analyses, you must enable them for business intelligence.

Extension of analyses using flexfields is available for Oracle Enterprise Resource Planning Cloud and Oracle Human Capital Management Cloud.

Flexfield Types

The following types of flexfields are available and provide a means to modify application features without programming:

• Descriptive

• Extensible

• Key

Depending on the flexfield type, business intelligence enablement is performed differently and has different requirements. Once they are enabled for business intelligence, you can import any changes made to flexfields automatically using an import scheduled process.

Configure Key Flexfields for Transactional Business Intelligence

Enable Key Flexfields for Business Intelligence Reporting

To include flexfields in your analyses, you must enable them for Business Intelligence. Extensibility of analysis using flexfields is used for Enterprise Resource Planning and Human Capital Management. For Customer Relationship Management, the Extensibility Framework supports this.

To designate key flexfields as BI-enabled:

1. In the Setup and Maintenance work area, go to the Manage Key Flexfields task.

2. On the Manage Key Flexfields page, enter your search value in Key Flexfield Code.

3. Click Manage Structure Instances.

4. Enter your search value in Structure Instance Code.

5. Click Edit to display the Edit Key Flexfield Structure Instance dialog box.

6. Select the BI Enabled option, then click OK.

7. For each flexfield segment instance, repeat steps 5 through 6.

8. Click Save.

9. Populate the BI Object Name for each of the segment labels:

   1. Query the Key Flexfield Code in the Manage Key Flexfields window.

   2. From the Actions menu, select Manage Segment Labels.

   3. Populate the BI Object Name for each segment label to be mapped. The BI Object Name for the following qualified segment labels should not be modified:

      Segment Label Code	BI Object Name
      FA_COST_CTR	Dim - Cost Center
      GL_BALANCING	Dim - Balancing Segment
      GL_ACCOUNT	Dim - Natural Account Segment

      Before you deploy a flexfield, you must access the Chart of Accounts Instance and assign the newly created segment label to the appropriate segment in the Chart of Accounts.

   4. Click Deploy Flexfield.

   5. Click Save and Close.

• Considerations for Enabling Key Flexfield Segments for Business Intelligence

• Update Existing Setup Data

Overview of Supported Key Flexfields

Key flexfields are used to store internally defined codes unique to a particular business, specifying part numbers, general ledger accounts, and other business entities.

Product Area	Key Flexfield	Dimension
Fixed Assets	Category (CAT#)	Dim - Asset Category
Fixed Assets	Location (LOC#)	Dim - Asset Location
General Ledger	Accounting (GL#)	Dim - Balancing Segment Dim - Cost Center Dim - Natural Account
Payroll	Costing	Dim - Costing Segments
Supply Chain Management	Locator	Dim - Inventory Org
Supply Chain Management	Item Category	Dim - Item
Revenue Management	Pricing Dimensions (VRM)	Dim - VRM Segment
Budgetary Control	Budgeting (XCC)	Dim - XCC Segment

Map Non-Qualified Segments to BI Objects

To map non-qualified segments that must be mapped and used in analysis, create a new label and associate a BI object with the label. Associate this new segment label with the segment code.

To map non-qualified segments to BI objects:

1. In the Setup and Maintenance work area, go to the Manage Key Flexfields task.

2. On the Manage Key Flexfields page, search for the appropriate key flexfield code.

3. From the Actions menu, select Manage Segment Labels.

4. Click the Add Row icon.

5. Enter the details for the Segment Label Code, including name, description, and BI Object name. Enter the BI object names carefully and note whether there is a space between Segment and the number.

   This table provides examples of Key Flexfields and associated BI object names.

   Key Flexfield	BI Object Name
   Accounting (GL)	Dim - GL Segment1 through Dim - GL Segment10
   Budgetary Control (XCC)	Dim - XCC Segment1 through Dim - XCC Segment10
   Revenue Management (VRM)	Dim - VRM Segment 1 through Dim - VRM Segment 10

6. Complete the mapping by assigning unique segment labels to the key flexfields.

Set Up the GL Accounting Flexfields

This topic describes the workflow for setting up Accounting key flexfields, but these steps also apply for other key flexfields.

• Understanding Accounting Key Flexfields

• Identifying Accounting Key Flexfields

• Assigning Unique Segment Labels

• Performing Column Flattening

• Designating GL Accounting Segment Instances as BI-Enabled

• Deploying Accounting Key Flexfields

Understanding Accounting Key Flexfields

The Accounting Key Flexfield is used to identify GL accounts.

A chart of accounts segment is a component of the accounting key flexfield. Each segment has a value set attached to it to provide formatting and validation of the set of values used with that segment. The combination of segments creates the account combination used for recording and analyzing financial transactions. You must set up your Chart of Accounts (COA) as part of implementing Oracle Applications Cloud.

Examples of segments that may be found in a chart of accounts structure include Company, Cost Center, Department, Division, Region, Account, Product, Program, and Location.

The Natural Account segment of the General Ledger Accounting Key Flexfield defines the account used in the account combination to record transactions.

The logical segment dimensions in the Oracle BI metadata are Dim - Cost Center, Dim - Balancing Segment, Dim - Natural Account Segment and all Dim - GL Segmentndimensions. These dimension tables are populated from a Tree value object or from a Value Set value object. Which value is used depends on whether a tree was associated with the segment in the Oracle Applications Cloud setup:

• For each segment associated with trees, two value objects are generated (Tree and TreeCode) with the following naming structure:

  FscmTopModelAM.AccountBIAM.FLEX_TREE_VS_segmentlabel_VI &

  FscmTopModelAM.AccountBIAM.FLEX_TREECODE_VS_segmentlabel_VI

• For each segment without trees, one view object is generated with the following naming structure:

  FscmTopModelAM.AccountBIAM.FLEX_VS_ XXX_VI

In addition to the segment dimension tables, the BI Extension process also extends Flex BI Flattened VO; FscmTopModelAM.AccountBIAM.FLEX_BI_Account_VI. This view object has a pair of columns for each segment; segmentlabel_ and segmentlabel_c.

For example, for your Cost Center segment which has the segment label FA_COST_CTR, there are two columns in this view object, named FA_COST_CTR_ and FA_COST_CTR_c.

Identifying Accounting Key Flexfield Segments

Identify and map segments of the chart of accounts.

For each Chart of Accounts (Accounting Key Flexfield) used to analyze Transactional Business Intelligence facts, identify the segments of the chart of accounts. Map them to the Transactional Business Intelligence GL Accounting Segment logical dimensions.

Accounting Key Flexfield Segment	Segment Label	Transactional Business Intelligence GL Accounting Segment Logical Dimension
Balancing	GL_BALANCING	Dim - Balancing Segment
Natural Account	GL_ACCOUNT	Dim - Natural Account Segment
Cost Center	FA_COST_CTR	Dim - Cost Center
Other segments to be equalized across the charts of accounts	Other unique segment label	Dim - GL Segment n where n is an integer from 1 to 10

Assigning Unique Segment Labels

You must assign a unique segment label to the charts of accounts segments that are the balancing segments or the natural account segments. The segments must be also used for specific purposes.

For example, assign the Primary Balancing segment label to the segment used for your company or legal entities. That label provides a correct recording of intercompany transactions and company analysis. You can assign other segment labels when required.

To assign unique segment labels to charts of accounts segments:

1. In the Setup and Maintenance work area, go to the Manage Charts of Accounts task and then navigate to the Manage Chart of Accounts page.

2. In the Search section, enter the GL# for the Key Flexfield Code and click the Search button.

3. In the Search Results section, select Accounting Flexfield and click the Manage Structures button to navigate to Manage Key Flexfield Structures.

4. In the Search section, enter the chart of accounts code or the name for Structure Code or Name and click the Search button.

5. In the Search Results section, select the chart of accounts and click Edit to navigate to the Edit Key Flexfield Structure window

6. Select the Enabled check box to code-enable the Structure code.

7. In the Segments section, select the applicable segments and click Edit to navigate to the Edit Key Flexfield Segment window.

8. Select the Enabled check box to enable the segments.

9. In the Segment Labels section, select the unique segment labels to equalize the segments across the charts of accounts. Click theshuttle to move the segments to the selected list.

10. Click Save and Close to return to the Edit Key Flexfield Structure window.

11. Click Done to return to the Manage Key Flexfields window.

Performing Column Flattening

Column flattening of trees is required in order for OTBI hierarchy analyses to be populated with correct data.

To flatten columns for account hierarchies:

1. In the Setup and Maintenance work area, go to the Manage Trees and Tree Versions task and navigate to the Manage Trees and Tree Versions window.

2. In the Search section, enter GL_ACCT_FLEX for the Tree Structure Code and the involved tree code or name, and click Search.

3. In the Search Results section, select the tree version you want to flatten. If the status of the Tree Version is Draft, to make the Tree Version active, select Actions, then Status, and then Active.

4. (Optional): After the tree version is specified, perform an audit on the Tree Version to ensure its integrity before launching the flattening job. Select Actions and then Audit. See the section on working with Trees in the Developer's Guide.

5. Choose Column Flattening from the Actions menu.

6. Click the Online Flattening button to launch the flattening job immediately. Or, click the Schedule Flattening button to schedule the flattening job according to your requirements.

Designating GL Accounting Segment Instances as BI-Enabled

Specify the applicable chart of accounts segment instances that are BI-enabled to make them available for use in Transactional Business Intelligence.

To specify the chart of accounts segment instances as BI-enabled:

1. In the Search Results section of the Manage Key Flexfields window, select Accounting Flexfield and click the Manage Structure Instances button to navigate to the Manage Key Flexfield Structure Instances window.

2. In the Search section, select the chart of accounts for Structure Name and click the Search button.

3. In the Search Results section, select the structure instance and click Edit to navigate to the Edit Key Flexfield Structure Instance window.

4. Check the Enabled check box to code-enable the structure instance.

5. In the Segment Instances section, select the segment instances and click Edit to update. Each of the segment instances must be selected individually.

6. Select the Business Intelligence enabled check box in the Edit Key Flexfield Segment pop-up window and click OK to return to Edit Key Flexfield Structure Instance window.

7. After you have enabled all applicable segment instances for Business Intelligence, click Save and Close to save the changes and return to the Edit Key Flexfield Structure Instance window.

8. Repeat steps 2 - 6 for each chart of accounts to enable all the applicable segment instances for Business Intelligence.

9. Click Done to return to the Manage Key Flexfields window.

10. After you have configured all the charts of accounts, click the Deploy Flexfield button to deploy the Accounting Flexfield and make the latest definition available for use.

Deploying Accounting Key Flexfields

After you have set up accounting key flexfields, you must deploy them.

Accounting key flexfields have one of the following deployment statuses:

• Edited: The flexfield definition has not been deployed or changes have been made to the structure, the structure instances, or the value sets.

• Patched: The flexfield definition has been modified through an update, but the flexfield has not yet been deployed so the updated definition is not reflected.

• Deployed to Sandbox: The flexfield is deployed and available in a flexfield-enabled sandbox.

• Deployed: The flexfield definition is deployed and available to end users.

• Error: The deployment attempt failed.

To deploy accounting key flexfields:

1. In the Setup and Maintenance work area, go to the Manage Chart of Accounts task.

2. Click Search.

3. Locate the Deployment Status column.

4. Click the icon.

5. Select Edited.

6. Click Deploy Flexfield.

7. Monitor the Deployment Status and when it reaches 100% click OK.

8. Verify that a check mark displays in the Deployment Status column.

9. Click Done.

Configure Descriptive Flexfields for Transactional Business Intelligence

Overview of Transactional Business Intelligence Configuration of Descriptive Flexfields

Configure descriptive flexfields to track unique information not typically found on business forms.

Descriptive flexfields can store several important details on a form without cluttering it. For example, several details may make an asset form heavy and unmanageable. However, the user still needs to access those details and therefore, they must be present on the form. In such cases, descriptive flexfields are convenient to use and are easy to manage.

Descriptive flexfields provide a way for you to add attributes to entities and to define validation and display properties for them. A descriptive flexfield is a logical grouping of attributes (segments) that are mapped to a set of extension columns which are shipped as part of Oracle Applications Cloud tables.

Configure Descriptive Flexfield Segments

If a descriptive flexfield is enabled for Oracle Business Intelligence, you can enable global and context segments for Oracle Business Intelligence, and you can select segment labels. Not all descriptive flexfields are supported for Business Intelligence.

Configuring a Descriptive Flexfield Segment

If a descriptive flexfield is enabled for Oracle Business Intelligence, you can enable global and context segments for Oracle Business Intelligence, and you can select segment labels. Not all descriptive flexfields are supported for Business Intelligence.

To configure available descriptive flexfield segments:

1. In the Setup and Maintenance work area, go to the Manage Descriptive Flexfields task.

2. If the BI Enabled option is cleared, select it.

3. Select the options for deployment of the descriptive flexfields.

Set Descriptive Flexfields as BI-Enabled

If a descriptive flexfield is already defined, you can enable it for use in Business Intelligence reports. Not all descriptive flexfields are supported for Business Intelligence.

Setting a Flexfield as BI-Enabled

1. In the Setup and Maintenance work area, go to the Manage Descriptive Flexfields task.

2. Navigate to the Edit Descriptive Flexfields window.

3. Enter the descriptive flexfield name.

4. Check the BI Enabled option on the desired descriptive flexfields. If the option is unavailable, the flexfield is a non-supported entity.

5. Click OK.

6. Click Save.

Configure Extensible Flexfields for Transactional Business Intelligence

Configure Extensible Flexfields

You can use extensible flexfields to configure more segments.

An extensible flexfield is similar to a descriptive flexfield in that it provides an expansion space that you can use to configure additional attributes (segments) without additional programming. As with descriptive flexfields, each segment is represented in the database as a single column. However, with extensible flexfields, the context values and context-sensitive segments are stored in an extension table.

Categories and Contexts

You can combine and arrange the segments into attribute groups that are tailored to your specific needs. For example, you can group related segments so that they appear together on the page. The attribute groups are referred to as contexts. You can optionally set up an extensible flexfield to enable categorization of contexts.

You can add contexts and segments to extensible flexfields just like the descriptive flexfields. To see the extensible flexfields in analyses, you need to deploy them and then run the BI Extender Essbase scheduled process.

Configuring Extensible Flexfields

To configure extensible flexfields:

1. In the Setup and Maintenance work area, go to the Manage Extensible Flexfield task.

2. Search for the EFF you want to configure, then select it and click the Edit icon.

3. In the Edit Extensible Flexfield dialog, highlight the category Display Name, then select Manage Contexts.

4. In the Manage Context dialog, search for the context that contains the segment you want to configure, highlight it, then click the Edit icon.

5. In the Edit Context dialog, click the Edit icon.

6. Edit the segment, as required, then click Save.

• Flexfield Usages

Set Extensible Flexfields as BI-Enabled

Extensible flexfields are BI enabled if at least one segment in a context is BI enabled.

Setting Extensible Flexfields as BI-Enabled

To set extensible flexfields as BI-enabled:

1. In the Setup and Maintenance work area, go to the Manage Extensible Flexfields task.

2. Enter the extensible flexfield name; for example, Organization Information EFF.

3. Select the applicable extensible flexfield, and then click Edit.

4. Select the applicable Category. The category contexts are populated automatically.

5. Click Manage Contexts

6. In the Edit Context page, select the applicable Context, and then click Edit.

7. Select the applicable Segment, and then click Edit.

8. In the Edit Segment page, select the BI Enabled check box.

9. Click Save.

Overview of the Essbase Rule File and Cubes

Generate the Essbase rule file by running the Create Rules XML File for BI Extender Automation scheduled process.

The Essbase rule file must be generated for all Oracle Essbase cubes mapped in the repository file (RPD).

Job Status Conditions

The process status displays one of these conditions.

• INIT: The process has just begun and is waiting for the extender command line JAR to update the status with more details.

• COMPLETED_NO_EXTENSION_NEEDED: No new Flexfield changes were detected in any of the Oracle Applications Cloud sources; because the RPD is already synchronized with all Flexfield changes, no changes were made in the RPD.

• COMPLETED: The RPD was successfully updated with Flexfield changes and uploaded into the Oracle Business Intelligence server.

• FAILED: Error conditions exist which require manual intervention.

• Submit Scheduled Processes and Process Sets

Import Changes to Flexfields Automatically

Overview of Flexfield Change Import

You can use the Import Oracle Fusion Data Extensions for Transactional Business Intelligence scheduled process to import your flexfield changes.

Use the Import Oracle Fusion Data Extensions for Transactional Business Intelligence scheduled process to automatically import the following types of changes:

• Key Flexfield changes

• Descriptive Flexfield changes

• Extensible Flexfield changes

The Import Oracle Fusion Data Extensions for Transactional Business Intelligence scheduled process imports extensible data, including data in descriptive flexfield segments, key flexfield segments, and General Ledger balances in Essbase cubes.

If you have changes to key flexfields and descriptive flexfields, you can import all the changes in the same scheduled process.

This is an Oracle Applications Cloud scheduled process; it is not related to BI Applications. Detailed information on this process can be found in Oracle Applications Cloud documentation.

Note: We strongly recommend that you backup the Oracle Business Intelligence Enterprise Edition prior to importing any flexfield changes.

Running the process disconnects all users from the server. You should not run this process when maintenance operations or system updates are being performed on the server.

Run the Import Scheduled Process

To import changes, run the Import Oracle Fusion Data Extensions for Transactional Business Intelligence scheduled process.

Running the Job

To run the process:

1. In the Scheduled Processes window, select Search and Select: Name.

2. Select Search and Select: Name.

3. Highlight Import Oracle Fusion Data Extensions for Transactional Business Intelligence.

4. Click OK.

5. Schedule the process.

Process Status Conditions

When the process is finished, the biExtenderCMDUtility.jar writes the status of the process into the JNDI file ess_biExtenderEssJob_jobStatus, which can be viewed in Oracle WebLogic Server.

The process status displays one of the following conditions:

• INIT: The process has just begun and is waiting for the extender command line JAR to update the status with more details.

• COMPLETED_NO_EXTENSION_NEEDED: No new Flexfield changes were detected in any of the Oracle Applications Cloud sources; because the Oracle Business Intelligence is already synchronized with all Flexfield changes, no changes were made in the Oracle Business Intelligence.

• COMPLETED: Oracle Business Intelligence was successfully updated with Flexfield changes and uploaded into the Oracle Business Intelligence Server.

• COMPLETED: PROCESS_ERRORS: Oracle Business Intelligence was updated with the Flexfield changes but with some warnings that require manual intervention.

• FAILED: Error conditions exist that require manual intervention.

Successful Import Process

If the import process is successful, you can perform the following actions:

• Query subject areas by segment dimensions such as Balancing Segment and Cost Center.

• Access DFF attributes for analyses.

• Use the General Ledger - Balances Real Time subject area to query Oracle Essbase cubes.

Disable Flexfields as BI-Enabled

Overview

If you created a flexfield that you no longer want to use or report against, you can disable the flexfield as BI-enabled.

There may be times, such as during development phases, when you try using a flexfield and later determine it is no longer needed.

Note: If you are considering disabling flexfields, keep in mind that any flexfields created in Oracle Applications Cloud must be designated as BI-enabled to be exposed in Transactional Business Intelligence. If you disable a flexfield, it cannot be deployed. Also, error conditions may occur if you disable a descriptive flexfield that has been implemented in BI Applications.

If error conditions arise from disabling flexfields as BI-enabled, troubleshooting the errors can be difficult and time-consuming.

Disable Key Flexfields as BI-Enabled

If you created a flexfield that you no longer want to use or report against, you can disable the flexfield as BI-enabled.

If you are considering disabling key flexfields, keep in mind that any flexfields created in Oracle Applications Cloud must be designated as BI-enabled to be exposed in Transactional Business Intelligence.

Disabling Key Flexfields

To disable key flexfields as BI-enabled:

1. In the Setup and Maintenance work area, go to the Manage Key Flexfields task.

2. Enter your search value in Key Flexfield Code.

3. Click Manage Structure Instances.

4. Enter your search value in Structure Instance Code.

5. Click Edit. The Edit Key Flexfield Structure Instance dialog box displays.

6. In Edit Key Flexfield Segment Instance, deselect the BI Enabled option.

7. Click OK, then Save.

Disable Descriptive Flexfields as BI-Enabled

If you created a flexfield that you no longer want to use or report against, you can disable the flexfield as BI-enabled.

If you are considering disabling descriptive flexfields, keep in mind that any flexfields created in Oracle Applications Cloud must be designated as BI-enabled to be exposed in Transactional Business Intelligence.

Disabling Descriptive Flexfields

To disable descriptive flexfields as BI-enabled:

1. In the Setup and Maintenance work area, go to the Manage Descriptive Flexfields task.

2. Enter the Descriptive Flexfield Name.

3. Deselect the BI Enabled option on the desired descriptive flexfields.

4. Click OK, then Save.

Disable Extensible Flexfields as BI-Enabled

If you created a flexfield that you no longer want to use or report against, you can disable the flexfield as BI-enabled.

If you are considering disabling extensible flexfields, keep in mind that any flexfields created in Oracle Applications Cloud must be designated as BI-enabled to be exposed in Oracle Transactional Business Intelligence.

Disabling Extensible Flexfields

To disable extensible flexfields as BI-enabled:

1. In the Setup and Maintenance work area, go to the Manage Extensible Flexfields task.

2. Enter the extensible flexfield Name; for example, "Organization Information EFF."

3. Select the applicable extensible flexfield and click Edit to navigate to Edit Extensible Flexfield.

4. Select the applicable Category. The category contexts are populated automatically.

5. Click Manage Contexts to navigate to Manage Contexts.

6. Select the applicable Context and click Edit to navigate to Edit Context.

7. Select the applicable Segment and click Edit to navigate to Edit Segment.

8. Deselect the BI Enabled option.

9. Click Save.

Dimensions Supported by Descriptive Flexfields

SCM Descriptive Flexfields for Business Intelligence

This table shows the descriptive flexfields supported in Oracle Fusion Supply Chain Management along with the applicable subject areas, folders, parent folders and logical dimensions.

Descriptive Flexfield Code	Subject Area	Folder	Parent Folder	Dimension Name
CARRIER_ORGANIZATION	Shipping Real Time	Shipping Method		Dim - Shipping Method
CST_ANALYSIS_CODES_B	Costing - Cost Accounting Real Time	Cost Analysis Group		Dim - Cost Analysis Group
CST_ANALYSIS_CODES_B	Costing - Item Cost Real Time	Cost Analysis Group		Dim - Cost Analysis Group
CST_ANALYSIS_GROUPS_B	Costing - Cost Accounting Real Time	Cost Analysis Group		Dim - Cost Analysis Group
CST_ANALYSIS_GROUPS_B	Costing - Item Cost Real Time	Cost Analysis Group		Dim - Cost Analysis Group
CST_COST_BOOKS_B	Costing - COGS and Gross Margin Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_BOOKS_B	Costing - Cost Accounting Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_BOOKS_B	Costing - Item Cost Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_BOOKS_B	Costing - Inventory Valuation Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_ELEMENTS_B	Costing - COGS and Gross Margin Real Time	Cost Element		Dim - Cost Element
CST_COST_ELEMENTS_B	Costing - Cost Accounting Real Time	Cost Element		Dim - Cost Element
CST_COST_ELEMENTS_B	Costing - Item Cost Real Time	Cost Element		Dim - Cost Element
CST_COST_ORG_BOOKS	Costing - COGS and Gross Margin Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_ORG_BOOKS	Costing - Cost Accounting Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_ORG_BOOKS	Costing - Item Cost Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_COST_ORG_BOOKS	Costing - Inventory Valuation Real Time	Cost Organization Book		Dim - Cost Organization Book
CST_ELEMENT_ANALYSIS_GROUPS	Costing - Cost Accounting Real Time	Cost Analysis Group		Dim - Cost Analysis Group
CST_ELEMENT_ANALYSIS_GROUPS	Costing - Item Cost Real Time	Cost Analysis Group		Dim - Cost Analysis Group
CST_VAL_STRUCTURES_B	Costing - COGS and Gross Margin Real Time	Cost Valuation Unit		Dim - Cost Valuation Unit
CST_VAL_STRUCTURES_B	Costing - Cost Accounting Real Time	Cost Valuation Unit
CST_VAL_STRUCTURES_B	Costing - Item Cost Real Time	Cost Valuation Unit
CST_VAL_STRUCTURES_B	Costing - Inventory Valuation Real Time	Inventory Valuation - Onhand	Cost Valuation Unit
CST_VAL_UNITS_B	Costing - COGS and Gross Margin Real Time	Cost Valuation Unit		Dim - Cost Valuation Unit
CST_VAL_UNITS_B	Costing - Cost Accounting Real Time	Cost Valuation Unit
CST_VAL_UNITS_B	Costing - Item Cost Real Time	Cost Valuation Unit
CST_VAL_UNITS_B	Costing - Inventory Valuation Real Time	Inventory Valuation - Onhand	Cost Valuation Unit
DOO_PROCESS_DEFS_ADD_INFO	Distributed Order Orchestration - Fulfillment Lines Real Time	Orchestration Process		Dim - DOO Process
DOO_PROCESS_DEFS_ADD_INFO	Distributed Order Orchestration - Process Instances Real Time	Orchestration Process
DOO_PROCESS_STEPS_ADD_INFO	Distributed Order Orchestration - Fulfillment Lines Real Time	Step
DOO_PROCESS_STEPS_ADD_INFO	Distributed Order Orchestration - Process Instances Real Time	Steps	Step	Dim - Step
DOO_TASK_TYPES_ADD_INFO	Distributed Order Orchestration - Fulfillment Lines Real Time	Task
DOO_TASK_TYPES_ADD_INFO	Distributed Order Orchestration - Process Instances Real Time	Steps	Tasks	Dim - Primary Task
DOO_TASK_TYPES_ADD_INFO	Distributed Order Orchestration - Fulfillment Lines Real Time	Tasks	Task
EGO_CHANGE_LINE				Dim - New Item Request Line Details
EGO_ENGINEERING_CHANGES				Dim - New Item Request Details
EGP_CATEGORY_DFF				Dim - Item
EGP_CATEGORY_SETS_DFF				Dim - Item
EGP_COMPONENT_DFF				Dim - PIM - Components Details
EGP_ITEM_CLASS_DFF				Dim - PIM - Item Class
EGP_ITEM_RELATIONSHIPS_DFF				Dim - Cross Reference Item Details
EGP_ITEM_REVISIONS_DFF				Dim - PIM - Item and Revisions Details
EGP_REFERENCE_DESIGNATOR_DFF				Dim - PIM - Reference Designator
EGP_STRUCTURE_HEADER_DFF				Dim - PIM - Structure Details
EGP_SUBSTITUTE_COMPONENT_DFF				Dim - PIM - Substitute Component
EGP_SYSTEM_ITEMS_DFF				Dim - Item
EGP_TRADING_PARTNER_ITEMS_DFF				Dim - Trading Partner Item Details
GMS_AWARD_HEADERS_DFF				Dim - Award
GMS_AWARD_PERSONNEL_DFF				Dim - Personnel
GMS_AWARD_PROJECTS_DFF				Dim - Award Project
GMS_INSTITUTIONS_DFF				Dim - Award
INV_GRADES	Inventory - Inventory Balance Real Time	Grade		Dim - Inventory Lot
INV_GRADES	Inventory - Inventory Balance Real Time	Lot
INV_GRADES	Inventory - Inventory Transactions Real Time	From Grade		Dim - Inventory Grade
INV_GRADES	Product Genealogy - Genealogy Instance Real Time	Lot Number {Genealogy Instance}
INV_GRADES	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Child}
INV_GRADES	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Parent}
INV_GRADES	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Root Parent}
INV_GRADES	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Child}
INV_GRADES	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Leaf Child}
INV_GRADES	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Parent}		Dim - Inventory Lot Parent
INV_GRADES	Product Genealogy - Genealogy Structure Real Time	Lot Number {Child Genealogy Instance}		Dim - Inventory Lot Child Genealogy Structure
INV_GRADES	Product Genealogy - Genealogy Structure Real Time	Lot Number {Parent Genealogy Instance}
INV_GRADES	Product Genealogy - Genealogy Transaction Real Time	Lot Number {Transaction}
INV_GRADES	Quality Inspection Results Real Time	Lot
INV_GRADES	Shipping Real Time	Shipment Line	Inventory Details
INV_ITEM_LOCATIONS	Costing - Cost Accounting Real Time	Locator		Dim - Storage Location
INV_ITEM_LOCATIONS	Costing - Inventory Valuation Real Time	Storage Location
INV_ITEM_LOCATIONS	Inventory - Inventory Balance Real Time	Locator
INV_ITEM_LOCATIONS	Inventory - Inventory Transactions Real Time	Locator
INV_ITEM_LOCATIONS	Inventory Organization Real Time	Locator
INV_ITEM_LOCATIONS	Receiving - In-Transit Advanced Shipment Notifications Real Time	In-Transit ASN	Locator
INV_ITEM_LOCATIONS	Receiving - In-Transit Interorganization Inventory Transfers Real Time	In-Transit Interorganization Shipment	Locator
INV_ITEM_LOCATIONS	Receiving - In-Transit Shipments Real Time	All In-Transit Shipments	Locator
INV_ITEM_LOCATIONS	Receiving - Transactions Real Time	Receiving Transactions	Locator
INV_ITEM_LOCATIONS	Shipping Real Time	Shipment Line	Locator
INV_LOT_ATTRIBUTES	Distributed Order Orchestration - Fulfillment Lines Real Time	Lot and Serial Details		Dim - Lot Serial Details
INV_LOT_ATTRIBUTES	Inventory - Inventory Balance Real Time	Lot		Dim - Inventory Lot
INV_LOT_ATTRIBUTES	Inventory - Inventory Transactions Real Time	Lot
INV_LOT_ATTRIBUTES	Manufacturing - Actual Production Real Time	Product Lot Attributes Descriptive Flexfields
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Instance Real Time	Lot Number {Genealogy Instance}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Child}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Parent}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Root Parent}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Child}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Leaf Child}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Parent}		Dim - Inventory Lot Parent
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Structure Real Time	Lot Number {Child Genealogy Instance}		Dim - Inventory Lot Child Genealogy Structure
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Structure Real Time	Lot Number {Parent Genealogy Instance}
INV_LOT_ATTRIBUTES	Product Genealogy - Genealogy Transaction Real Time	Lot Number {Transaction}
INV_LOT_ATTRIBUTES	Quality Inspection Results Real Time	Lot
INV_LOT_ATTRIBUTES	Shipping Real Time	Shipment Line	Inventory Details
INV_LOT_NUMBERS	Distributed Order Orchestration - Fulfillment Lines Real Time	Lot and Serial Details		Dim - Lot Serial Details
INV_LOT_NUMBERS	Inventory - Inventory Balance Real Time	Lot		Dim - Inventory Lot
INV_LOT_NUMBERS	Inventory - Inventory Transactions Real Time	Lot
INV_LOT_NUMBERS	Manufacturing - Actual Production Real Time	Product Lot Number Descriptive Flexfields
INV_LOT_NUMBERS	Product Genealogy - Genealogy Instance Real Time	Lot Number {Genealogy Instance}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Child}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Parent}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Object Composition Real Time	Lot Number {Root Parent}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Child}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Leaf Child}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Object Where Used Real Time	Lot Number {Parent}		Dim - Inventory Lot Parent
INV_LOT_NUMBERS	Product Genealogy - Genealogy Structure Real Time	Lot Number {Child Genealogy Instance}		Dim - Inventory Lot Child Genealogy Structure
INV_LOT_NUMBERS	Product Genealogy - Genealogy Structure Real Time	Lot Number {Parent Genealogy Instance}
INV_LOT_NUMBERS	Product Genealogy - Genealogy Transaction Real Time	Lot Number {Transaction}
INV_LOT_NUMBERS	Quality Inspection Results Real Time	Lot
INV_LOT_NUMBERS	Shipping Real Time	Shipment Line	Inventory Details
INV_MATERIAL_TXNS	Inventory - Inventory Transactions Real Time	Inventory Transactions Details		Dim - Inventory Details
INV_ORG_PARAMETERS				Dim - Inventory Org
INV_SECONDARY_INVENTORIES	Costing - Cost Accounting Real Time	Subinventory		Dim - Storage Location
INV_SECONDARY_INVENTORIES	Costing - Inventory Valuation Real Time	Storage Location
INV_SECONDARY_INVENTORIES	Inventory - Inventory Balance Real Time	Subinventory
INV_SECONDARY_INVENTORIES	Inventory - Inventory Supply Real Time	In transit Inventory Supply	Source Subinventory
INV_SECONDARY_INVENTORIES	Inventory - Inventory Supply Real Time	Subinventory
INV_SECONDARY_INVENTORIES	Inventory - Inventory Transactions Real Time	Subinventory
INV_SECONDARY_INVENTORIES	Inventory Organization Real Time	Subinventory
INV_SECONDARY_INVENTORIES	Receiving - Interorganization Receipts Real Time	Interorganization Receipts	Receiving Subinventory
INV_SECONDARY_INVENTORIES	Receiving - Purchase Receipts Real Time	Purchase Receipts	Receiving Subinventory
INV_SECONDARY_INVENTORIES	Receiving - Receipts Real Time	All Receipts	Receiving Subinventory
INV_SECONDARY_INVENTORIES	Receiving - Transactions Real Time	Receiving Transactions	Receiving Subinventory
INV_SECONDARY_INVENTORIES	Receiving - Unordered Receipts Real Time	Current Unordered Receipts	Receiving Subinventory
INV_SECONDARY_INVENTORIES	Shipping Real Time	Shipment Line	Subinventory
INV_SERIAL_ATTRIBUTES	Shipping Real Time	Shipment Line	Serial Number	Dim - Serial Number
INV_SERIAL_ATTRIBUTES	Shipping Real Time	Shipment Line	Serial Number To	Dim - Serial Number To
INV_SERIAL_NUMBERS	Shipping Real Time	Shipment Line	Serial Number	Dim - Serial Number
INV_SERIAL_NUMBERS	Shipping Real Time	Shipment Line	Serial Number To	Dim - Serial Number To
INV_TRANSACTION_REASONS	Receiving - In-Transit Advanced Shipment Notifications Real Time	In-Transit ASN	Transaction Reasons	Dim - Receipt Transaction Reasons
INV_TRANSACTION_REASONS	Receiving - In-Transit Interorganization Inventory Transfers Real Time	In-Transit Interorganization Shipment	Transaction Reasons
INV_TRANSACTION_REASONS	Receiving - In-Transit Shipments Real Time	All In-Transit Shipments	Transaction Reasons
INV_TRANSACTION_REASONS	Receiving - Transactions Real Time	Receiving Transactions	Transaction Reasons
INV_TRANSACTION_TYPES	Inventory - Inventory Transactions Real Time	Transaction Type		Dim - Movement Type
INV_TRANSFER_ORDER_DISTRIBS	Inventory - Inventory Transfer Order Real Time	Transfer Order Distribution Details		Dim - Transfer Order Details
INV_TRANSFER_ORDER_HEADERS	Inventory - Inventory Transfer Order Real Time	Transfer Order Details		Dim - Transfer Order Details
INV_TRANSFER_ORDER_LINES	Inventory - Inventory Transfer Order Real Time	Transfer Order Line Details		Dim - Transfer Order Details
INV_TXN_SOURCE_TYPES	Inventory - Inventory Transactions Real Time	Transaction Source Type		Dim - Inventory Transaction Source Type
PROJECTS_STD_COST_COLLECTION	Costing - Cost Accounting Real Time	Project User Defined Attributes		Dim - Cost Transaction Details
PROJECTS_STD_COST_COLLECTION	Costing - Work Order Costs Real Time	Project User Defined Attributes		Dim - Costing - Work Order Cost Details
PROJECTS_STD_COST_COLLECTION	Distributed Order Orchestration - Fulfillment Lines Real Time	Project User Defined Attributes		Dim - Sales Order Details
PROJECTS_STD_COST_COLLECTION	Inventory - Inventory Transactions Real Time	Project User Defined Attributes		Dim - Inventory Details
PROJECTS_STD_COST_COLLECTION	Inventory - Inventory Transfer Order Real Time	Project User Defined Attributes		Dim - Transfer Order Details
RCV_SHIPMENT_HEADERS	Receiving - In-Transit Advanced Shipment Notifications Real Time	In-Transit ASN	In-Transit ASN Header Details	Dim - Inbound Shipment Details
RCV_SHIPMENT_HEADERS	Receiving - In-Transit Interorganization Inventory Transfers Real Time	In-Transit Interorganization Shipment	In-Transit Interorganization Shipment Header Details
RCV_SHIPMENT_HEADERS	Receiving - In-Transit Shipments Real Time	All In-Transit Shipments	All In-Transit Shipments Header Details
RCV_SHIPMENT_HEADERS	Receiving - Interorganization Receipts Real Time	Interorganization Receipts	Interorganization Receipt Header Details	Dim - Receipt Details
RCV_SHIPMENT_HEADERS	Receiving - Purchase Receipts Real Time	Purchase Receipts	Purchase Receipt Header Details
RCV_SHIPMENT_HEADERS	Receiving - Receipts Real Time	All Receipts	All Receipt Header Details
RCV_SHIPMENT_HEADERS	Receiving - Unordered Receipts Real Time	Current Unordered Receipts	Unordered Receipts Header Details
RCV_SHIPMENT_LINES	Receiving - In-Transit Advanced Shipment Notifications Real Time	In-Transit ASN	In-Transit ASN Header Details
RCV_SHIPMENT_LINES	Receiving - In-Transit Interorganization Inventory Transfers Real Time	In-Transit Interorganization Shipment	In-Transit Interorganization Shipment Line Details	Dim - Inbound Shipment Details
RCV_SHIPMENT_LINES	Receiving - In-Transit Shipments Real Time	All In-Transit Shipments	All In-Transit Shipment Line Details
RCV_SHIPMENT_LINES	Receiving - Interorganization Receipts Real Time	Interorganization Receipts	Interorganization Receipt Line Details	Dim - Receipt Details
RCV_SHIPMENT_LINES	Receiving - Purchase Receipts Real Time	Purchase Receipts	Purchase Receipt Line Details
RCV_SHIPMENT_LINES	Receiving - Receipts Real Time	All Receipts	All Receipt Line Details
RCV_SHIPMENT_LINES	Receiving - Unordered Receipts Real Time	Current Unordered Receipts	Unordered Receipts Line Details
RCV_TRANSACTIONS	Receiving - Transactions Real Time	Receiving Transactions	Receiving Transaction Details	Dim - Receipt Details
WIE_OPERATION_TRANSACTIONS				Dim - Operation Transaction Details
WIE_RESOURCE_TRANSACTIONS				Dim - Resource Transaction Details
WIE_WO_OPERATION_MATERIALS				Dim - Work Order Operation Materials
WIE_WO_OPERATION_OUTPUTS				Dim - Work Order Operation Output Details
WIE_WO_OPERATION_RESOURCE_INSTANCES				Dim - Work Order Operation Resources
WIE_WO_OPERATION_RESOURCES				Dim - Work Order Operation Resources
WIE_WO_OPERATIONS				Dim - Work Order Operations
WIE_WORK_ORDERS				Dim - Work Orders
WIS_EQUIPMENT_RESOURCE_INSTANCES				Dim - Resource Instance
WIS_LABOR_RESOURCE_INSTANCES				Dim - Resource Instance
WIS_WORK_AREAS				Dim - Manufacturing Work Center
WIS_WORK_CENTERS				Dim - Manufacturing Work Center
WSH_CARRIERS	Receiving - In-Transit Advanced Shipment Notifications Real Time	In-Transit ASN	Carrier	Dim - Carrier
WSH_CARRIERS	Receiving - In-Transit Interorganization Inventory Transfers Real Time	In-Transit Interorganization Shipment	Carrier	Dim - Carrier
WSH_CARRIERS	Receiving - In-Transit Shipments Real Time	All In-Transit Shipments	Carrier	Dim - Carrier
WSH_CARRIERS	Receiving - Interorganization Receipts Real Time	Interorganization Receipts	Carrier	Dim - Carrier
WSH_CARRIERS	Receiving - Purchase Receipts Real Time	Purchase Receipts	Carrier	Dim - Carrier
WSH_CARRIERS	Receiving - Receipts Real Time	All Receipts	Carrier	Dim - Carrier
WSH_CARRIERS	Receiving - Unordered Receipts Real Time	Current Unordered Receipts	Carrier	Dim - Carrier
WSH_CARRIERS	Shipping Real Time	Carrier		Dim - Carrier
WSH_DELIVERY_DETAILS	Shipping Real Time	Shipment	Shipment Details	Dim - Sales Pick Details
WSH_NEW_DELIVERIES	Shipping Real Time	Shipment Line	Shipment Line Summary	Dim - Sales Pick Details

SCM Extensible Flexfields for Business Intelligence

This topic lists the extensible flexfields supported in Oracle Fusion Supply Chain Management (SCM):

Extensible Flexfield	Location in Oracle Fusion SCM	Folder in Oracle BI
EGO_ITEM_EFF	Manage Items	Product Management - Change Order Approvals Real Time > Item > Main Product Management - Change Order Line Real Time > Item > Main Product Management - Change Order Real Time > Item > Main Product Management - Components Real Time > Item > Main Product Management - Cross Reference Item Real Time > Item > Main Product Management - Item Revisions Real Time > Item > Main Product Management - Item Supplier Uploads Real Time > Item > Main Product Management - New Item Request Approvals Real Time > Item > Main Product Management - New Item Request Line Real Time > Item > Main Product Management - New Item Request Real Time > Item > Main Product Management - Related Item Real Time > Item > Main Product Management - Source System Item Real Time > Item > Main Product Management - Structures Real Time > Item > Main Product Management - Structures and Components Real Time: Parent Assembly Attributes > Item > Main and Component Assembly Attributes > Item > Main Product Management - Trading Partner Item Real Time > Item > Main Product Management - Where Used Real Time: Where Used Item Attributes > Item > Main, Item Attributes > Item > Main, and Parent of Where Used Item Attributes > Item > Main
PROJECTS_STD_COST_COLLECTION	Manage Project Standard Cost Collection	Order Management - Fulfillment Lines Real Time > Project Details