Tuesday, December 20, 2016

ORACLE FINANCIAL ACCOUNTING HUB (FAH)- PART 2

Objective:
In the last article we got an overview on FAH and in what aspect FAH differs from SLA. In continuation to that article we will discuss in detail the benefits of FAH.

Oracle Financial Accounting Hub (FAH) : Multi Level Drilldown
FAH replaces the legacy accounting systems/programs and provides a rule based accounting engine to generate accounting entries. FAH integrates the Product Systems to Oracle General Ledger (GL). Oracle standard FAH provides linkage from GL to SLA Journals i.e. the standard drilldown works from GL to SLA. Users can drilldown from GL to SLA journal Lines that provides additional sub-ledger details like Event model details, Supporting References, Identifiers and Descriptions etc. These details are useful enough to reconcile the transactions/records between GL and SLA.  Based out of our FAH implementation experiences we felt that the industry and the business users needs more in addition to this FAH standard drilldown from GL to SLA. Users' needs another layer of drilldown to the transaction data wherein they can easily reconcile the GL data with SLA data and then to transaction data. The view to the transaction data enhances Users supports function to reconcile, view the raw data, error handling etc. We've built a custom solution that provides additional drilldown layer in FAH beyond SLA Journal. A custom form was built that present the view of the Transaction Object/Staging Table in FAH (wherein the transaction data is placed for FAH accounting entry generation). This form was linked with the SLA Journal form and with the selection of the SLA Journal line this form provides the number of the transaction object lines in the staging area. This way it links the GL data to SLA and SLA data to Transaction data. It provides multilevel drilldown views.
There could be different types of solutions in FAH like Pass through, Account derivations, Mappings and combinations of these. Based on the solutions the usability and importance of this custom drilldown can be enhanced. This Custom Drilldown not only helps business support functions like Reconciliations, Error & Suspense handling but also provide end to end view of how a product system transaction is transformed to a Journal. When used in conjunction with standard drill down this solution provides multi-dimensional view and presents summarized data view in GL, detailed accounting view and transaction Data view in FAH.  It brings in short and long term benefits to an organization.

Benefits of Using Financial Accounting Hub (FAH)
One of the big benefits of FAH is that instead of the rules of the accounting transformation being buried in code, they are defined in the FAH application and are auditable, easy to change, consistent and transparent. Also you don’t need to maintain multiple different transformations to GL with bespoke code for each system, you are doing it with product which is performant, predictable etc. SLA is also not a separate product, it’s just an engine. But oracle wants to sell it as FAH. FAH is nothing but the "Concept" of integrating the third party with Oracle Ebiz through SLA. So we have reports on FAH and it totally based on the customer requirement and there is no standard FAH reports.
Financials Accounting Hub (FAH) provides an orderly, streamlined process to manage Financial Data of Source Systems. It houses the transformations from business event to accounting generation and then transfer’s balanced entries to GL.
FAH allows you to create detailed, auditable, reconcilable accounting from a variety of source systems. It includes an accounting transformation engine with validations plus accounting and rules repositories. The transformation engine consistently enforces accounting policies. The repositories provide centralized control, detailed audit trails, and simultaneously accommodates diverse corporate, management and reporting requirements.
FAH – What’s not for?
  • Data Extraction
  • Event Creation
  • Calculation Engine for Source System calculations
  • Inbuilt Intelligence for IFRS Accounting or any GAAP Accounting
Is FAH a fit for you? - FAH may be right for you if:
  • Oracle EBS and/or PeopleSoft are not a good fit to replace your proprietary operational (ordering, billing, inventory, purchasing) systems;
  • Detailed financial reporting is required on legacy system attributes not typically a part of the Chart of Accounts;
  • Accounting requirements for legacy systems are complex and subject to change; and/or
  • You are in the financial services (insurance, banking, and brokerage), telecommunications, or distribution industry.
FAH 3
Architecture- Earlier ::
FAH 4
Architecture- Developed Later on ::
FAH 5
Architecture- Current Scenario ::
FAH 6

ORACLE FINANCIAL ACCOUNTING HUB (FAH) BASICS


Objective:
This training article is intended to discuss basics of Oracle Financial Accounting Hub. It is to be noted that Financial Services Accounting Hub (FSAH) is now called as Financials Accounting Hub (FAH). This article gives an overview on FAH and in what aspect FAH differs from SLA. In subsequent article we will discuss in detail the benefits of FAH.

What is Financial Accounting Hub
The Financials Accounting Hub (FAH) is a tool designed for non-Oracle Subledgers (Third Party) to leverage Oracle's Subledger Accounting engine and ultimately transfer the Journals to an Oracle General Ledger. The Financials Accounting Hub uses accounting events to generate journals. Accounting Events have financial impact. Using this tool implementers determine how the events should be accounted. The Oracle Financial Accounting Hub (FAH) helps in creating a centralized, auditable accounting system for external and/or legacy systems. FAH has a configurable rules engine and configurable rules repository (user-defined) that keeps the definition and maintenance of accounting rules in one place. FAH acts as the accounting engine for any subledger (Oracle or non-Oracle), create adjusting journal entries, provide drill back from General Ledger (GL) to FAH, validate and transform source data, and fully leverage GL setups (open/close period, COA structure, segment values, cross validation rules, calendar, functional currency) to ultimately provide users with an efficient and compliant financial system.

How Financial Accounting Hub works
Oracle standard FAH provides linkage from GL to SLA Journals i.e. the standard drilldown that works from GL to SLA. Users can drilldown from GL to SLA journal Lines that provides additional sub-ledger details like Event model details, Supporting References, Identifiers and Descriptions etc. These details are useful enough to reconcile the transactions/records between GL and SLA.  A custom solution van be build that provides additional drilldown layer in FAH beyond SLA Journal and a custom form presents the view of the Transaction Object/Staging Table in FAH (wherein the transaction data is placed for FAH accounting entry generation). This form can be linked with the SLA Journal form and with the selection of the SLA Journal line, form provides the number of the transaction object lines in the staging area. This way it links the GL data to SLA and SLA data to Transaction data and provides multilevel drilldown views.
There could be different types of solutions in FAH like Pass through, Account derivations, Mappings and combinations of these. Based on the solutions the usability and importance of this custom drilldown can be enhanced. This Custom Drilldown not only helps business support functions like Reconciliations, Error & Suspense handling but also provide end to end view of how a product system transaction is transformed to a Journal. When used in conjunction with standard drill down this solution provides multi-dimensional view and presents summarized data view in GL, detailed accounting view and transaction Data view in FAH.  It brings in short and long term benefits to an organization.

What is the difference between FAH and SLA
FAH 1
From a technology perspective, there is zero difference. XLA is the technical label for the FAH/SLA solution. XLA is the common framework which handles all accounting feeds into the E-Business Suite General Ledger. Therefore, technically XLA = SLA = FAH.
The technology leveraged by FAH and SLA is exactly the same and the difference is within the way user are allowed to use the technology. SLA offers seeded Event Models (including Event Class Options) and Application Accounting Definitions for E-Business Suite subledger applications. With SLA users can build customized Subledger Accounting Methods (including customized JLTs, ADRs, JLDs, AADs,) for E-Business Suite subledger applications, while they are not allowed to make any changes to the seeded Event Models / Event Class Options. In case you do come across a requirement in this last area (e.g. an additional Source is needed), then Custom Source functionality can be used for that.
FAH requires an additional license, and basically FAH is standalone SLA: you get the SLA technology but you don’t get any seeded building blocks, because FAH is intended to create accounting based on data which resides in external (non-E-Business Suite) applications. So with FAH you create the Event Model(s) and AAD(s) for external applications entirely from scratch.
Summary: SLA deals with the E-Business Suite subledger applications, while FAH deals with external applications.
Subledger Accounting (SLA):
  • Deals with the E-Business Suite subledger applications (AR, AP, etc.).
  • Seeded event models which cannot be changed (extensions can be build using Custom Sources).
  • Seeded accounting methods which can be customized (copied and modified) at will.
  • Integral part of E-Business Suite Financials (R12 onwards).
Financials Accounting Hub (FAH):
  • Deals with external (i.e. non-E-Business Suite) applications.
  • No seeded event models – event models need to be built from scratch.
  • No seeded accounting rules – accounting rules need to be built from scratch.
  • Requires purchasing a separate license.
The accounting hub is intended to use the Subledger Accounting (SLA), which is a rules based accounting generation process to create the accounting for transactions from a custom application and then SLA will interface that to the GL Interface table, (or often interface it to a PeopleSoft GL.). You do not build custom logic, you define rules in the SLA UI for the accounting transformations.
FAH is an uptake of SLA. It is basically standalone Subledger Accounting (SLA), it allows you to use Oracle SLA and GL to perform the accounting for third party applications. Using Accounting Method Builder (AMB) Tool, SLA standard application accounting definitions are copied and modified to map SLA application accounting definition with Source Application Accounting Events, Accounting events of source application is mapped and stored in the SLA tables. External/Source Application’s accounting event’s for, accounting attributes and transactions supporting references are kept in FAH transactions objects.  When user submits accounting program,
  1. Accounting program fetches the applicable accounting events which are eligible for processing from SLA Tables.
  2. Load FAH transactions objects and apply modified application accounting definitions on sources of FAH Transactions Objects.
  3. SLA journal entries are created and stored in the SLA Tables.
  4. SLA journal entries are transferred to GL using standard Oracle Transfer to GL Program.
Using FAH, you can drill down from GL to FAH and FAH to External Source/Legacy Application like/similar to drill down from GL to Standard Oracle Subledger (AP, AR etc.)  Using FAH, you can get the balances in GL by source/external application’s transactions. Therefore reconciliation becomes easy between the external application and Standard Oracle GL. FAH keeps the source transaction’s accounting attributes and key transactions references. Therefore it is used to keep the audit trail.







FAH 2



Monday, December 19, 2016

Query to find Application Short Name of a module


The following query lists all the applications related information. This query can be used to find the APPLICATION_SHORT_NAME of a module (eg. Payables, Receivables, Order Management, etc.) that are often used for downloading FNDLOAD LDT files, adding responsibility to a user and many more.

You can uncomment the FAT.APPLICATION_NAME condition (very bottom line of the query) to learn about a particular module. In this case, I used "Payables".


-------------------------------------------------------------------------------
-- Query to find all APPLICATION (module) information
-------------------------------------------------------------------------------
SELECT fa.application_id           "Application ID",
       fat.application_name        "Application Name",
       fa.application_short_name   "Application Short Name",
       fa.basepath                 "Basepath"
  FROM fnd_application     fa,
       fnd_application_tl  fat
 WHERE fa.application_id = fat.application_id
   AND fat.language      = USERENV('LANG')
   -- AND fat.application_name = 'Payables'  -- <change it>
 ORDER BY fat.application_name;
 

APPLICATION SHORT NAME
APPLICATION NAME
FNDApplication Object Library
SYSADMINSystem Administration
AUApplication Utilities
ADApplications DBA
SQLGLGeneral Ledger
OFAAssets
ALRAlert
RGApplication Report Generator
CSService
ECe-Commerce Gateway
SQLAPPayables
POPurchasing
ARReceivables
QAQuality
CECash Management
PAProjects
ASSales Foundation
CNIncentive Compensation
OEOrder Entry
INVInventory
ANSales Analysis
ODQData Query
AXGlobal Accounting Engine
AKCommon Modules-AK
MFGManufacturing
BOMBills of Material
ENGEngineering
MRPMaster Scheduling/MRP
CRPCapacity
WIPWork in Process
CZConfigurator
PERHuman Resources
PAYPayroll
FFFastFormula
DTDateTrack
SSPSSP
MSCAdvanced Supply Chain Planning
BENAdvanced Benefits
OTALearning Management
JAAsia/Pacific Localizations
JEEuropean Localizations
JGRegional Localizations
JLLatin America Localizations
CHVSupplier Scheduling
ICXOracle iProcurement
AHMHosting Manager(Obsolete)
CSTCost Management
RLARelease Management Integration Kit (Obsolete)
VEHAutomotive Integration Kit (Obsolete)
HXTTime and Labor
AZApplication Implementation
PJMProject Manufacturing
FLMFlow Manufacturing
RHXAdvanced Planning Foundation(obsolete)
GHRUS Federal Human Resources
DEMDemo Order Entry (AOL Class)
CLRCulinary Application
CCTTelephony Manager
BISApplications BIS
ADSApplications Demonstration Services
CUSTOMCustom Development
ADS_DEVADS Development
XTRTreasury
PNProperty Manager
WMSWarehouse Management
WPSManufacturing Scheduling
FIIFinancial Intelligence
POAPurchasing Intelligence
HRIHuman Resources Intelligence
OKCContracts Core
CSCCustomer Care
CSDDepot Repair
ITAInformation Technology Audit
CDROracle Clinical Data Repository
DUMMY_GMOObsolete Process Operations
CLJJapan Consulting Localizations
RRCRetail Core
CLLLAD Consulting Localizations
RRSSite Management
CLEEMEA Consulting Localizations
CSFField Service
CSSSupport (obsolete)
OKSService Contracts
MEControlled Availability Product(Obsolete)
BIMMarketing Intelligence
BICCustomer Intelligence (obsolete)
IESScripting
AMVMarketing Encyclopedia System
ASTTeleSales
ASFSales Online
CSPSpares Management
OKXContracts Integration
AMSMarketing
XNMMarketing for Communications (Obsolete)
XNCSales for Communications (Obsolete)
XNSService for Communications (obsolete)
XNPNumber Portability
XDPProvisioning
FPTBanking Center (obsolete)
IEOInteraction Center Technology
GMAProcess Manufacturing Systems
GMIProcess Manufacturing Inventory
GMDProcess Manufacturing Product Development
GMEProcess Manufacturing Process Execution
GMPProcess Manufacturing Process Planning
GMFProcess Manufacturing Financials
GMLProcess Manufacturing Logistics
GRProcess Manufacturing Regulatory Management
PMIProcess Manufacturing Intelligence
XLASubledger Accounting
ONTOrder Management
QPAdvanced Pricing
RLMRelease Management
VEAAutomotive
WSHShipping Execution
IBAiMarketing (Obsolete)
IBEiStore
IBUiSupport
IBYPayments
IBPBill Presentment & Payment
BILSales Intelligence
BIXInteraction Center Intelligence
IEMEmail Center
OZPTrade Planning (Obsolete)
OZFTrade Management
OZSiClaims (Obsolete)
ASGCRM Gateway for Mobile Devices
JTFCRM Foundation
IEXCollections
IEUUniversal Work Queue
ASOOrder Capture
MSOConstraint Based Optimization
OKEProject Contracts
IPACapital Resource Logistics – Projects
CUINetwork Logistics – Inventory
CUPNetwork Logistics – Purchasing
CUFCapital Resource Logistics – Financials
CUSNetwork Logistics
CUNNetwork Logistics – NATS (obsolete)
CUACapital Resource Logistics – Assets
WSMShop Floor Management
SHTApplications Shared Technology
ECXXML Gateway
FRMReport Manager
EAASEM Exchange (obsolete)
BSCBalanced Scorecard
ABMActivity Based Management (Obsolete)
EVMValue Based Management
FEMEnterprise Performance Foundation
POMExchange
MWAMobile Applications
OPIOperations Intelligence
ISCSupply Chain Intelligence
CSRScheduler
IEBInteraction Blending
MSDDemand Planning
HXCTime and Labor Engine
PQHPublic Sector HR
PQPPublic Sector Payroll
PSBPublic Sector Budgeting
GMSGrants Accounting
PSPLabor Distribution
IGWGrants Proposal
IGSStudent System
IGFFinancial Aid
IGCContract Commitment
PSAPublic Sector Financials
FVFederal Financials
ENIProduct Intelligence
PVPartner Management
ASLSales Offline
CUEBilling Connect (obsolete)
EAMEnterprise Asset Management
FTETransportation Execution
IGIPublic Sector Financials International
ITGInternet Procurement Enterprise Connector
OKRContracts for Rights (Obsolete)
IPDProduct Development (obsolete)
MSRInventory Optimization
PRGCProgress Custom
POSiSupplier Portal
BNEWeb Applications Desktop Integrator
ASPOracle Sales for Handhelds
BIVService Intelligence
CSIInstall Base
CSLField Service/Laptop
CUGCitizen Interaction Center
IMTiMeeting (obsolete)
OKIContracts Intelligence
IECAdvanced Outbound Telephony
CSEAsset Tracking
OKOContracts for Sales (Obsolete)
JTSCRM Self Service Administration
JTMMobile Application Foundation
AHLComplex Maintenance Repair and Overhaul
IMCCustomers Online
OKBContracts for Subscriptions (Obsolete)
XNIInstall Base Intelligence (Obsolete)
QRMRisk Management
PONSourcing
OKLLease and Finance Management
IBCContent Manager
AMFFulfillment Services (Obsolete)
QOTQuoting
CSMField Service/Palm
DOMDocument Managment and Collaboration
EGOAdvanced Product Catalog
DDDCADView-3D
PJIProject Intelligence
XNBOracle Telecommunications Billing Integrator
ZFAFinancial Analyzer
ZSASales Analyzer
CLNSupply Chain Trading Connector for RosettaNet
EDRE-Records
PRPProposals
OUCUniversity Curriculum
TESTtest
PSRPublic Sector Receivables
CSNCall Center
CLAAPAC Consulting Localizations
AMWInternal Controls Manager
XDOXML Publisher
WMAManufacturing Mobile Applications
ISXiSettlement
MIVMedia Interactive
OAMOracle Applications Manager
BIEeCommerce Intelligence
BINCommunications Intelligence
CUCRevenue Accounting
CURMass Market Receivables for Comms
IBTiAuction
XNAService Assurance for Communications
XNTTeleBusiness for Telecom/Utilities
MQAMobile Quality Applications
CTBClinical Transaction Base
IETCall Center Connectors
IEVIVR Integrator
IEPPredictive
HCPHealthcare Intelligence
HCAHealthcare
PBRBudgeting and Planning
IAMDigital Asset Management
OKTRoyalty Management
GNIGenealogy Intelligence
CPGCCPG – CDOA
HCCiHCConnect
HCNiHCIntegrate
AMEApprovals Management
OKPContracts for Procurement (Obsolete)
HCTHealthcare Terminology Server
MIAMobile Applications for Inventory Management
GMWProcess Manufacturing Portal
BIYSystems Intelligence
PFTOracle Profitability Manager
RMGRisk Manager
FTPTransfer Pricing
DNADevelopment
BLCUtility Billing
PTXPatch Tracking System
EMSEnvironment Management System
RCMRegulatory Capital Manager (obsolete)
JMFSupply Chain Localizations
IRCiRecruitment
GMOManufacturing Execution System for Process Manufacturing
IPMOracle Imaging Process Management
IBWOracle Web Analytics
XLELegal Entity Configurator
ASNSales
MSTTransportation Planning
FUNFinancials Common Modules
GCSFinancial Consolidation Hub
ZXE-Business Tax
LNSLoans
IAiAssets
FPAProject Portfolio Analysis
ZPBEnterprise Planning and Budgeting
BANKINGBanking
COREBANKCore Banking
INSTITBANKInstitutional Banking
IZUOracle E-Business Suite Diagnostics
DPPOracle Price Protection
MTHOracle Manufacturing Operations Center
QPROracle Deal Management
DDRDemand Signal Repository
INLOracle Landed Cost Management

How to improve blog performance

Improving the performance of a blog can involve a variety of strategies, including optimizing the website's technical infrastructure, im...