Oracle Financial Services Accounting Hub Implementation Guide

Scalability

Accounting Representations

Introduction to Events and Sources

Event Model

Sources and Source Data

Overview of the Financial Services Accounting Hub

Financial Services Accounting Hub Uptake Process

Summary Listing of Uptake Steps

Analysis

Definition and Build

Accounting Program Integration

Implement and Test

Security

Upgrade Strategy

Roles in the Uptake and Use of the Financial Services Accounting Hub

Application Analyst

Implementer

User

Secondary or Reporting Ledger Historical Upgrade

Initial Balances for Supporting References

Analysis of Accounting Events

Creating Subledger Journal Entries from Accounting Events

Identifying Accounting Events

Financial Significance of Accounting Events

Identifying the Life Cycle

Ability to Record the Full Accounting Implications of Accounting Events

Requirements for Valid Accounting Events

Accounting Event Attributes

Event Type

Transaction Identifiers

Event Status

Event Date

Transaction Context Values

Security Context Values

Accounting Event Analysis - Additional Notes

Accounting Event Order

Third Party Merge

Audit Trail and Business Event Restrictions

Draft and Final Accounting

Transactions with Multiple Events

Valuation Methods and the Financial Services Accounting Hub

Transaction Objects Analysis

Transaction Objects Overview

How Sources Are Used in the Financial Services Accounting Hub

Transaction Objects Data Model

Types of Sources

Transaction Objects

Transaction Objects Types

Transaction Object Columns

Multiple Transaction Objects of the Same Type

Population of Transaction Objects

Reference Objects

Create Sources and Assignments

Transaction Objects Guidelines

Introduction to Transaction Objects Guidelines

Accounting Attributes Guideline

Distribution Identifiers Guideline

Multiperiod Accounting Guideline

Monetary Amounts Guideline

Gains and Losses Guideline

Foreign Currency Amounts Guideline

Reporting Currency Amounts Guideline

Corrections for Rounding Guideline

Related Transactions, Lines, and Distributions Guideline

Independence from Accounting Method Guideline

Balanced Debits and Credits Guideline

Granularity of Transaction Objects Lines Guideline

Third Party Control Accounts Guideline

Translated Sources, Lookup Types, and Value Sets Guideline

Consistency Guideline

Tax References Guideline

Flexfields Guideline

Accounting Flexfield Derivation Mechanisms Guideline

Accounting Options Guideline

Internal Identifiers Guideline

System Sources Guideline

Accounting Reversals Guideline

Accounting Reversals

Accrual Reversals

Line Accounting Reversals

Transaction Accounting Reversals

Accounting Reversal Examples

Upgrade Case Scenario for Accounting Reversals

Accounting Reversal Upgrade Case Example

Transaction Objects Example for Payables

Seeding Event Information Using Accounting Methods Builder

Seeding Event Information Using Accounting Methods Builder (AMB) Overview

Event Setup Steps

Introduction to Event Entities, Event Classes, and Event Types

Registering Subledger Applications

Drilldown API Details

Event Entities

Defining Accounting Event Entities

Event Classes

Event Types

Event Class Predecessors

Defining Event Class Predecessors

Process Categories

Create and Assign Sources

Create and Assign Sources Overview

Defining Accounting Event Class Options

To Set Up Accounting Event Class Options

Create and Assign Sources Program

Create and Validate Mode

Validate Only Mode

Revise Source Definitions and Assign Accounting Attributes

Revise Source Definitions and Assign Accounting Attributes Overview

Revise Source Definitions and Assign Accounting Attributes

Standards for Source Names and Descriptions

Source Names

Source Descriptions

Manually Defining/Revising Sources

To Manually Define/Revise Sources in Accounting Methods Builder

Assigning Sources

To Assign Sources in the AMB

To Assign Accounting Attributes in the AMB

Financial Services Accounting Hub Seed Data

Financial Services Accounting Hub Seed Data Overview

Subledger Application Setups

Seeding Calls to Subledger Event Capture Routines

Seeding Calls to Subledger Event Capture Routines Overview

Procedures to Seed Event Capture Routines

Perform Event Setups in Accounting Methods Builder (AMB)

Write Product Specific Cover Routines

Integrate Event APIs with Subledger Applications

Overview of Event APIs

Get Event Information

Create Events

Update Events

Delete Events

Update Transaction Number

Event API Details

Get Event Information APIs

Create Event APIs

Update Event APIs

Delete Event APIs

Common Parameters

PL/SQL Data Types

Constants

Accounting Program and Period Close Integration

Accounting Program Workflow Business Events for Custom Integration

Technical Implementation Steps and Conventions

Timing and Position of Workflow Business Events

Parameter Specifications

Application Subscription to Workflow Business Events

Locking

Transaction Control Statements

Exception Handling

Default Subscription to Postaccounting Workflow Business Event

Accounting Program Specifications

Accounting Program Submission

Period Close Exceptions Report API

Gapless Event Creation and Processing

Gapless Event Creation and Processing Overview

Gapless Event Creation and Processing

Gapless Process Steps

Event Updates and Deletes

Financial Services Accounting Hub Security

Financial Services Accounting Hub Security Overview

Transaction Security

Transaction Security Overview

Transaction Security Implementation

Flexfield Security Rules

Data Access Set Security

Data Access Set

Data Access Set Security for Journal Entry Creation

Data Access Set Security for Inquiries and Reports

Manual Subledger Journal Entries API

Manual Subledger Journal Entries API Overview

Technical Overview

XLA_JOURNAL_ENTRIES_PUB_PKG

Global Constants

Published Journal Entries APIs

Drilldown

Drilldown Overview

Drill-down API Details

Drilldown Accounting from Transaction Workbench to Accounting Events

Specification

View Accounting from Transaction Workbench to Subledger Journal Entry Lines

Specification

Drilldown from General Ledger to Subledger Journal Entry Lines

Financial Services Accounting Hub Repository Specification

Financial Services Accounting Hub Repository Data Model

Accessing the Financial Services Accounting Hub Repository

Retrieve Journal Entries for a Transaction

Retrieve Journal Entries for an Event

Retrieve Journal Entries for a Ledger

Retrieve Journal Entries Using Distribution Links

Calculation of Accounted and Gain or Loss Amounts

Calculation of Accounted and Gain or Loss Amounts Overview

Calculation of Accounted Amounts

Calculation of Gain or Loss Amounts

The Accounting Program Process Flow for Gain or Loss Amount Calculation

Transaction Account Builder

Transaction Account Builder Overview

Transaction Account Builder Components

Account Validation and Dynamic Insertion

Transaction Account Builder Setup Process

Step 1: Define Sources

Step 2: Define Transaction Account Types

Step 3: Generate TAB API Objects

Step 4: Create Account Derivation Rules (Optional)

Step 5: Create Transaction Account Definitions (Optional)

Step 6: Modify Application Setup to Support TAB

Step 7: Call the Transaction Account Builder API

Step 8: Using the Transaction Accounts in the Accounting Methods Builder (Optional)

Application Accounting Definitions Loader

Application Accounting Definitions (AAD) Loader Overview

Version Control Overview

Installation, Patching, and Migration

Application Accounting Definitions Data Delivery

Import Application Accounting Definitions

Export Application Accounting Definitions

Application Accounting Definitions Migration

Applications Accounting Definitions Concurrent Development

Index

Oracle Financial Services Accounting Hub Implementation Guide

Contents