Previous  Next          Contents  Index  Navigation  Glossary  Library

Key Flexfield Views Examples

The following pages show examples of views created for the Accounting Flexfield, which uses the GL_CODE_COMBINATIONS table. The columns shown in bold print are columns that particularly pertain to the flexfield itself. You should note the differences between the boldfaced columns in the underlying table and those in its view. The key flexfield columns in this table include thirty SEGMENTn columns, the CODE_COMBINATION_ID column, and the CHART_OF_ACCOUNTS_ID column (structure column). DETAIL_POSTING_ALLOWED_FLAG, DETAIL_BUDGETING_ALLOWED_FLAG, and ACCOUNT_TYPE are segment qualifier columns for the flexfield. The flexfield also uses ENABLED_FLAG, SUMMARY_FLAG, START_DATE_ACTIVE, END_DATE_ACTIVE to determine the status of a combination.

Note that the GL_CODE_COMBINATIONS table contains columns for the key flexfield, but it also contains many other columns. LAST_UPDATE_DATE and LAST_UPDATED_BY columns provide information for the Who feature. The ATTRIBUTEn and CONTEXT columns belong to a descriptive flexfield, and the SEGMENT_ ATTRIBUTEn columns belong to a special flexfield used by the Oracle Public Sector Financials products. These other columns all appear in your flexfield view because they are not columns used by the Accounting Flexfield directly.

Our example structure for the Accounting Flexfield contains segments for COMPANY, COST_CENTER, REGION, PRODUCT, ACCOUNT, and SUB_ACCOUNT, so those columns appear in the structure view.

Original Key Flexfield Code Combinations Table

SQL> DESCRIBE GL_CODE_COMBINATIONS
Name                             Null?    Type
------------------------------- -------- ----
CODE_COMBINATION_ID              NOT NULL NUMBER(15)
LAST_UPDATE_DATE                 NOT NULL DATE
LAST_UPDATED_BY                  NOT NULL NUMBER(15)
CHART_OF_ACCOUNTS_ID             NOT NULL NUMBER(15)
DETAIL_POSTING_ALLOWED_FLAG      NOT NULL VARCHAR2(1)
DETAIL_BUDGETING_ALLOWED_FLAG    NOT NULL VARCHAR2(1)
ACCOUNT_TYPE                     NOT NULL VARCHAR2(1)
ENABLED_FLAG                     NOT NULL VARCHAR2(1)
SUMMARY_FLAG                     NOT NULL VARCHAR2(1)
SEGMENT1                                  VARCHAR2(25)
SEGMENT2                                  VARCHAR2(25)
  . . .                                     . . .
SEGMENT29                                 VARCHAR2(25)
SEGMENT30                                 VARCHAR2(25)
DESCRIPTION                               VARCHAR2(240)
TEMPLATE_ID                               NUMBER(15)
ALLOCATION_CREATE_FLAG                    VARCHAR2(1)
START_DATE_ACTIVE                         DATE
END_DATE_ACTIVE                           DATE
ATTRIBUTE1                                VARCHAR2(150)
ATTRIBUTE2                                VARCHAR2(150)
ATTRIBUTE3                                VARCHAR2(150)
ATTRIBUTE4                                VARCHAR2(150)
ATTRIBUTE5                                VARCHAR2(150)
ATTRIBUTE6                                VARCHAR2(150)
ATTRIBUTE7                                VARCHAR2(150)
ATTRIBUTE8                                VARCHAR2(150)
ATTRIBUTE9                                VARCHAR2(150)
ATTRIBUTE10                               VARCHAR2(150)
CONTEXT                                   VARCHAR2(150)
SEGMENT_ATTRIBUTE1                        VARCHAR2(60)
SEGMENT_ATTRIBUTE2                        VARCHAR2(60)
  . . .                                     . . .
SEGMENT_ATTRIBUTE41                       VARCHAR2(60)
SEGMENT_ATTRIBUTE42                       VARCHAR2(60)

View for the Entire Key Flexfield

View Name: GL_CODE_COMBINATIONS_KFV
Name                            Null?    Type
------------------------------- -------- ----
ALLOCATION_CREATE_FLAG                   VARCHAR2(1)
ATTRIBUTE1                               VARCHAR2(150)
ATTRIBUTE10                              VARCHAR2(150)
ATTRIBUTE2                               VARCHAR2(150)
ATTRIBUTE3                               VARCHAR2(150)
ATTRIBUTE4                               VARCHAR2(150)
ATTRIBUTE5                               VARCHAR2(150)
ATTRIBUTE6                               VARCHAR2(150)
ATTRIBUTE7                               VARCHAR2(150)
ATTRIBUTE8                               VARCHAR2(150)
ATTRIBUTE9                               VARCHAR2(150)
CHART_OF_ACCOUNTS_ID            NOT NULL NUMBER(22)
CODE_COMBINATION_ID             NOT NULL NUMBER(22)
CONCATENATED_SEGMENTS                    VARCHAR2(155)
PADDED_CONCATENATED_SEGMENTS             VARCHAR2(155)
CONTEXT                                  VARCHAR2(150)
DESCRIPTION                              VARCHAR2(240)
DETAIL_BUDGETING_ALLOWED        NOT NULL VARCHAR2(1)
DETAIL_POSTING_ALLOWED          NOT NULL VARCHAR2(1)
ENABLED_FLAG                    NOT NULL VARCHAR2(1)
END_DATE_ACTIVE                          DATE
GL_ACCOUNT_TYPE                 NOT NULL VARCHAR2(1)
LAST_UPDATED_BY                 NOT NULL NUMBER(22)
LAST_UPDATE_DATE                NOT NULL DATE
ROW_ID                                   ROWID
SEGMENT_ATTRIBUTE1                       VARCHAR2(60)
SEGMENT_ATTRIBUTE2                       VARCHAR2(60)
  . . .                                     . . .
SEGMENT_ATTRIBUTE41                      VARCHAR2(60)
SEGMENT_ATTRIBUTE42                      VARCHAR2(60)
START_DATE_ACTIVE                        DATE
SUMMARY_FLAG                    NOT NULL VARCHAR2(1)
TEMPLATE_ID                              NUMBER(22)

View for a Key Flexfield Structure

View Name: GL_AFF_STD_VIEW
Name                            Null?    Type
------------------------------- -------- ----
ACCOUNT                                  VARCHAR2(25)
ALLOCATION_CREATE_FLAG                   VARCHAR2(1)
ATTRIBUTE1                               VARCHAR2(150)
ATTRIBUTE10                              VARCHAR2(150)
ATTRIBUTE2                               VARCHAR2(150)
ATTRIBUTE3                               VARCHAR2(150)
ATTRIBUTE4                               VARCHAR2(150)
ATTRIBUTE5                               VARCHAR2(150)
ATTRIBUTE6                               VARCHAR2(150)
ATTRIBUTE7                               VARCHAR2(150)
ATTRIBUTE8                               VARCHAR2(150)
ATTRIBUTE9                               VARCHAR2(150)
CODE_COMBINATION_ID             NOT NULL NUMBER(22)
COMPANY                                  VARCHAR2(25)
CONTEXT                                  VARCHAR2(150)
COST_CENTER                              VARCHAR2(25)
DESCRIPTION                              VARCHAR2(240)
DETAIL_BUDGETING_ALLOWED        NOT NULL VARCHAR2(1)
DETAIL_POSTING_ALLOWED          NOT NULL VARCHAR2(1)
ENABLED_FLAG                    NOT NULL VARCHAR2(1)
END_DATE_ACTIVE                          DATE
GL_ACCOUNT_TYPE                 NOT NULL VARCHAR2(1)
LAST_UPDATED_BY                 NOT NULL NUMBER(22)
LAST_UPDATE_DATE                NOT NULL DATE
PRODUCT                                  VARCHAR2(25)
REGION                                   VARCHAR2(25)
ROW_ID                                   ROWID
SEGMENT_ATTRIBUTE1                       VARCHAR2(60)
SEGMENT_ATTRIBUTE2                       VARCHAR2(60)
  . . .                                     . . .
SEGMENT_ATTRIBUTE41                      VARCHAR2(60)
SEGMENT_ATTRIBUTE42                      VARCHAR2(60)
START_DATE_ACTIVE                        DATE
SUB_ACCOUNT                              VARCHAR2(25)
SUMMARY_FLAG                    NOT NULL VARCHAR2(1)
TEMPLATE_ID                              NUMBER(22)

See Also

Overview of Reporting on Flexfields Data

Overview of Flexfield Views

Key Flexfield Concatenated Segment View

Key Flexfield Structure View

Creating a Flexfield View

Segment Naming Conventions

Using Flexfield Views to Write a Report

Oracle Reports 2.5 Flexfield Support API

         Previous  Next          Contents  Index  Navigation  Glossary  Library