AFCS Reporting Presentation Layer - BCE And Results Subject Area - Missing Entities And Attributes (Doc ID 2978502.1)

Last updated on OCTOBER 06, 2023

Applies to:

Goal

Additional table and attributes are required in reporting subject areas as mentioned below:

1. Required TABLE:

General Ledger Type in RESULTS subject Area

2. Required COLUMNS in Subject area BCE and RESULTS:

BCE Channel Numeric Identifier Channel Dimension
BCE General Ledger Numeric Identifier General Ledger
BCE General Ledger Book Code General Ledger
BCE Data Source Code General Ledger
BCE General Ledger Account Class Code General Ledger
BCE Difference Auto Approved Flag General Ledger
BCE Intra Group Flag General Ledger
BCE Inter Branch General Ledger Flag General Ledger
BCE Fixed Asset Flag General Ledger
BCE General Ledger Account Code General Ledger
BCE Consolidation Flag General Ledger
BCE Local Currency Code Legal Entity
BCE Data Source Code Legal Entity
BCE Legal Entity Identifier Code Legal Entity
BCE Data Source Code Organization Unit
RESULTS Channel Category Code Channel
RESULTS Channel Category Code Description Channel
RESULTS Data Source Code Channel
RESULTS General Ledger Numeric Identifier General Ledger Account
RESULTS General Ledger Description General Ledger Account
RESULTS General Ledger Account Code General Ledger Account
RESULTS Consolidation Flag General Ledger Account
RESULTS General Ledger Book Code General Ledger Account
RESULTS Data Source Code General Ledger Account
RESULTS General Ledger Account Class Code General Ledger Account
RESULTS Difference Auto Approved Flag General Ledger Account
RESULTS Intra Group Flag General Ledger Account
RESULTS Inter Branch General Ledger Flag General Ledger Account
RESULTS Fixed Asset Flag General Ledger Account
RESULTS Underlying Instrument Code Instrument Contract
RESULTS Instrument Type Instrument Contract
RESULTS Issue Date Instrument Contract
RESULTS Country Code Instrument Contract
RESULTS Maturity Date Instrument Contract
RESULTS Account or Contract Closed Flag Instrument Contract
RESULTS Accounting Standard Code Ledger
RESULTS Common Chart Of Account Code Ledger
RESULTS Consolidation Flag Ledger
RESULTS Data Source Code Ledger
RESULTS Financial Reporting Jurisdiction Ledger
RESULTS Fiscal Period Code Ledger
RESULTS Functional Currency Code Ledger
RESULTS Ledger Numeric Identifier Ledger
RESULTS Fiscal Period Code Legal Entity
RESULTS Local Currency Code Legal Entity
RESULTS Organization Unit Identifier Legal Entity
RESULTS Data Source Code Legal Entity
RESULTS Legal Entity Identifier Code Legal Entity
RESULTS Legal Entity Description Legal Entity
RESULTS Location Status Flag Location
RESULTS Location Numeric Identifier Location
RESULTS Data Source Code Organization Unit
RESULTS Data Source Code Product

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.