Home

User Manual: Product Name

1. 3 Select the relevant dimensions from the Filters section 4 Click the Add icon against the selected dimension 5 Select the filter to be applied on each dimension A 2 Reconciliation Definition Name Description GL Hierarchy amp Filter Hierarchy Product Branch A 2 Product Audit Trail amp Audit Trail Settings GL Parameters Product Process Filter Element Browser Webpage Dialog a amp Search iM 2 Hierarchy Hierarchical Available Hierarchies Product Asset sale with recourse Vehicle Loans Bid bonds Bank Notes and Coins Balances with Banks Credit Card ABS Eligible Servicer Cash Advance Facility Branded Cards Consumer Credit Credit Card Outstanding wap Credit Default Swap Firstto default credit swaps Credit Defaul Credit Enhancement Facility 4 Credit Enhancing tA Strin Bank notes and Coins in Foreign Currency Selected Hierarchies m a 1to2 of 2 Oto 0 of 0 m Oracle Financial Services Software Confidential Restricted 48 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Product Processor PP Parameters GL Level Reconciliation If GL Level is selected in the Settings window Settings Select amp Filter PP Entity Na
2. Product Processor Name Select the respective PP names from the list of PPs in this field These are logical names displayed in the drop down list Product Processor table The PP table is auto populated depending on the PP name selected Product Processor Data Set Select the respective PP dataset in this field a Customer Id Column Select the Customer ID column in this field a Exposure Id Column Select the exposure ID or account ID column Extraction Date Column Select the extraction date or FIC MIS Date column Note None of the exposure IDs should start with GL since the adjustment entry which is passed for each execution begins with GL The bank will have to provide the balances at the same GL Hierarchy level both in the source GL data side as well as in the particular Product Processor entity ies In the GL Column Mapping and Balance Column Selection section click the Add icon to map the relevant GL column and Balance column Multiple selections are permitted General Ledger GL Source Settings Section The following columns are displayed in this window GL Source Name The logical table name of the selected GL is displayed here GL Table The physical table name of the selected GL table is displayed here GL Book GL Book represents a complete set of GL accounts for a legal entity and consolidation type This is stored in the same source system GL Data Set The group of GL tables whose i
3. Check Dependencies To generate a report on the hierarchies that utilize a selected Dimension Member select a single Dimension Member and click the Check Dependencies icon The Check Dependencies icon is only enabled when a single Dimension Member has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the Dimension Member s you have selected Note OFSAA Infrastructure will not allow you to delete any Dimension Member that is utilized within a hierarchy Dimension Members Summary Grid The following columns categorize each Dimension Member in the summary grid Code Displays the Dimension Member s code value Name Displays the Dimension Member s short name Performing a mouse over on a Dimension Member Name displays the Dimension Member s description Is Leaf Displays the Dimension Member s Is Leaf property Members may be declared to be either leaf members or rollup members When building a hierarchy in OFSAAI leaf members are those dimension members that have no descendent dimension members In building a dimension member set you must have at least some rollup members Is Leaf No before you can construct a multilevel hierarchy Your business data is normally expressed at the leaf level For example an individual mortgage instrument record would belong to a leaf level cost center for a leaf level principal balance general ledger accou
4. If Target ledger Structure is different than STG GL_DATA a Place the cursor on the tables in OFSAA Tree View right click and select New This will create a new table Rename it to the required table name b Expand the table by clicking icon to view the columns mapped against the tables c Place the cursor on the columns mapped against the tables right click and select New It will add new column to that table Rename it to the required column name d Repeat the above mentioned steps to add multiple tables and columns e Navigate to Logical View and provide the logical table name and logical column names to the added columns If Target ledger Structure is same as STG_GL_DATA In OFSAA tree view you can see Tables b Navigate to STG_GL_DATA in OFSAA tree view right click and select Go to Diagram c Press CTRL C to copy and then CTRL V to paste to create a new table with same name as STG_GL_DATA Rename the table name in both the Physical View and Logical View d Rename the constraints and index names on newly added table Save the newly added tables as xml file By selecting save as type to XML Types xml Select option AllFusion Repository Format in dialog box Click OK to generate a new xml file Copy that xml file to server for fast processing Under ftpshare lt lt infodom gt gt erwin erwinX ML Navigate to the OFSAAT UI and login Select an appropriate infodom and navigate to Unifi
5. Adjustment Entry Floor If the GL PP difference is less than the Adjustment Entry Floor specified in the definition then the calculated difference is not eligible for adjustment and an entry will not be logged in Adjustment Entry table Auto Approval The user gives rights to a certain party to authorize or reject an adjustment entry or a correction entry Contra GL Account An entity introduced by the application to store the second effects of entries passed while reconciling a Product Processor with its associated GL Correction Entry An entry passed by the user in the Product Processor to rectify the difference reported in the GL Reconciliation Global Threshold Global Threshold is applied at an execution level where all the reconciliation differences for an execution are added and checked across the absolute sum of source balance Inherit to Child This feature is used to find child legal entities under the hierarchy node of Legal Entity that is selected at the definition level If this feature is used while defining the GL Reconciliation rule then all child nodes will participate in the reconciliation process Reconciliation Difference Reconciliation difference refers to the difference in the balance between the GL and its associated PP Reversal Entry An automatic entry passed by the application to the extent of the correction amount whenever the adjustments are being corrected Threshold A tolerance level to be set
6. amp Filter Hierarchy amp No Element Selected Hierarchy Member GL Book Enter the GL Book in this field Balance Type Select the reconciliation period from the drop down list GL Type Select the GL Type from the drop down list such as Asset Revenue and so on Note Selection of GL type is limited to the selection of the GL hierarchy GL Hierarchy Click the Hierarchy icon to select the GL Hierarchy Hierarchies mapped to the selected GL type is displayed in this list To add Reconciliation Dimension click the Add icon in the Filters section The Filter Browser window appears Select the dimension from the hierarchy list and click OK Click Save to save the changes made else click Cancel Oracle Financial Services Software Confidential Restricted 43 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Target Ledger Parameters Settings Source Ledger Parameters Target Ledger Parameters Dimensions amp Ledger Entity Ledger Entity Name Threshold Specification Negative Correction Threshold Positive Correction Threshold Stage General Ledger Data Flex v Percentage vw Threshold Amount Currency R Filter BS Oto dof amp No Element Selected 0 to0 of 0 In this window enter the following details Ledger Entity Name Select the name of the entity that holds ledger data from the drop down list Threshold specifica
7. cece cece cece noes 102 ANNEXURE E OPTIMIZATION OF GL RECONCILIATION PROCESSING PGE sicicticarsdc acs tscetasedavcuvetnnarcince totic a a a 103 ANNEXURE F GENERATING DOWNLOAD SPECIFICATIONS 1 cece cece cece ees 104 ANNEXURE G MAP LEVEL RECON PARENT NODE SELECTION ccececeeees 105 ANNEXURE H ADJUSTMENT ENTRY TEMPLATE ecreis 106 ANNEXURE I GL NODES CONFIGURATION eeseesssssssessoesscossocesosesosesosssossosesocesosesosssosssoseso 107 Oracle Financial Software Services Confidential Restricted jii User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 GEOSAN o E E TOA Oracle Financial Software Services Confidential Restricted iv User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Oracle Financial Services Analytical Applications Reconciliation Framework User Guide Release 8 0 1 0 0 Part No E64180 01 Copyright 2015 Oracle and or its affiliates All rights reserved Primary Author Vineeta Mishra Sindhu Koppara and Meera Menon Contributor Prashant Agrawal Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD O
8. Correction Entry a window is displayed showing all of the Correction entries to be passed By selecting a Correction entry and by using search criteria you can control the set of Attributes that are displayed When you Edit or View a Correction Entry a detail page is displayed Navigation within the Correction Entry Window When you first navigate to the Correction Entry window the Correction Entries are presented in a summary grid The Correction Entry window has two sections e Search Correction Entry Status Search Section Among other properties each attribute possesses a Run Execution ID a Definition Name and GL Date You may search on any of these properties in the Search section 2 Search EG Run Execution ID GL Date 7 Definition Name lisa Correction Entry Status Section The Correction Entry Status section presents a grid containing all of the Correction Entries that meet your search criteria This grid also offers several icons that allow you to perform different functions when a Correction Entry is selected To select a Correction Entry click a check box in the first column of the grid e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed parameters of a Correction Entry on a read only basis The View icon is only enabled when a single Attribute has been selected Edit Selecting a single row out of the grid enables the Edit icon C
9. User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Global Parameter Maintenance i Reconciliation Framework gt Setup gt Global Parameter Maintenance Search Ee Legal Entity Name a Global Parameters 1to 14 of 14 E Legal Entity Name Financial Year Setup Created By Creation Date Modified By Modified Date Bank Global 12 31 GLUSER 01 24 2013 Bank UK 12 31 GLUSER 02 06 2013 Bank India 12 31 GLUSER 02 06 2013 Bank Australia 12 31 GLUSER 02 04 2013 Bank USA 12 31 GLUSER 01 31 2013 Bank of Australia 12 31 GLUSER 01 22 2013 Bank of United States of America 1231 GLUSER 01721 2013 Bank of European Union 12 31 GLUSER 0172482013 Bank Americas 12 31 GLUSER 01 24 2013 Bank APAC 12 31 GLUSER 01 24 2013 Bank Europe 12 31 GLUSER 01 24 2013 Bank India 12 31 GLUSER 01 24 2013 Bank Canada 12 31 GLUSER 01 24 2013 C Bank France 12 31 GLUSER 01 24 2013 GLUSER 02 01 2013 Navigation within the Summary and Details Page When you first navigate to the Attributes Summary window the attributes associated with your first dimension are presented in a summary grid The Attributes Summary window has two sections Search Global Parameters Search Section You can search for a specific legal entity name by selecting the legal entity and clicking the Search icon at a Search Legal Entity Name Bank Gl
10. categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL level reconciliation values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs Negative Correction Threshold Specify the Negative Correction Threshold value These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL Level Recon values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs You also have the option of adding filters to the optional dimensions product business unit and so on defined in the Global Setting window Comparison between the GL source system and PPs is based on the filters set on these dimensions Refer to the following steps to add filters 1 Click the Add icon in the Filters section as highlighted in the previous figure 2 Select the Hierarchies on which relevan
11. Adjustment Posted to Product Processor Other 2 Target Entity Details Product Processors Reconciliation Amount Column Target Entity Default Values Allocation GL Column Stage Cards Total Outstanding Balance Month End Stage Cards Select Allocation Amount Column Allocation Ratio Total Outstanding Balance Month End In the Allocation tab the following fields have to be selected Adjustment Allocation For Auto Reconciliation the Adjustment Allocation is by default considered to be Automatic Adjustment Posted to Select the Target table where the adjustments are to be posted that is if the adjustment entry is to be posted to the PP selected in the Product Processor Parameter window then select Product Processor or else select Others Allocation amount being posted to Oracle Financial Services Software Confidential Restricted 57 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 the external table is the same as what would have got posted to the original Product Processor table e Target Entity Details As per the selections made in the preceding two fields the fields in the Target Entity section is disabled or enabled accordingly Refer to the following cases for more details Case 1 If Target table is Product Processor Default Values is the only column to be updated Default Values are the mandatory columns to be updated for populatin
12. Dependencies To generate a report on the OFSAA rules that utilize a selected Hierarchy select a single Hierarchy and click the Check Dependencies icon The Check Dependencies icon is only enabled when a single Hierarchy has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the Hierarchy or Hierarchies you have selected Note OFSAA Infrastructure will not allow you to delete any Hierarchy that is utilized by another OFSAA rule Hierarchies Summary Grid The following columns categorize each Dimension Member in the summary grid Name Displays the Hierarchy s Name Performing a mouse over on a Hierarchy s Name displays the Hierarchy s Description Display Level Display Level is the default level at which a hierarchy is displayed by the application when you open it Created By Created By displays the name of the user who created a Hierarchy If a Hierarchy is saved as read only then only the user who created the rule i e the owner may modify the rule Oracle Financial Services Software Confidential Restricted 30 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Creation Date Displays the date and time at which a Hierarchy was created Last Modification Date Displays the date and time at which a Hierarchy was last modified Navigation within the Detail Screen When you Add Edit Cop
13. E OA 71 CORRECTION ENTRY AUTHORIZATION 0 lt sscscececscsccorsnevecscsctovensceceaserscsnsetosesecsceatensavasecerenvcecensertesneatovanecsenvecsavnsetevenraccenees 73 SUMMGLY ona Detalls Page tee eat anes terse E pilen cesta thes ants nae atabia uae reaa sain a aed ea aie Ala er tends 73 OBJECT MIGRATION FOR GL RECONCILIATION RULES ccc ececccceccccsccccsccccecs 76 ASSUIMIPTIONS AND PREREQUISITES aorin le toes wea to a tures eee le teat a edited ea te eae test ane auth uted feale utea teens 76 PT RES RENEE E AET E AEREE A le oe nse AN PEREA NENEA Seale pts goes nah isan ed ET outa aloe nasa nue E 76 DEFINITIONS IN TARGET ENVIRONMENT 34 cues accuse an a E aos E nace ewalsa caddy nan AA O ENE ETEN 76 GL RECONCILIATION OBJECT MIGRATION cccecsccececscececcscccececcccececececcncececeaeacececesesececsseaeacececececececeesaececeseceaceceeeeuaeaces 77 Exporting Opjects FFOMSOUICE CNVITONIICN terore re ek aah een a heed ads 77 Importing Objects to Target environ MEN cise ia Tao nsec dewa es mee ARE OO Be eee AOO hoes 78 USEN AS E aroa a AE 78 METADATA BROWSER MDB Jeece er ac ada c e oe a a a a O E E TE ROS 80 AEE D e E EE TEETE A EA E AAE EE EA T AEE E ET OAE ENNE 81 FORMAT TOFOLOW IN MDB uona a a a a a a a A a Or ace a a a a 81 OFS ANALYTICAL APPLICATIONS RECONCILIATION FRAMEWORK DASHBOARDS AND REPORTS esseesseescsssosssccssossscossosesocssosesocesocssosssossocesocesoessosesooesocesoes 82 OVERVIEW OF OFS ANALYTICAL A
14. GL Code Displays the GL code for which this reconciliation is identified This is applicable for GL Level Reconciliation only Currency Displays the currency of the adjustment entry amount Legal Entity Displays the Legal Entity in which the reconciliation difference is found and subsequent adjustment entry is to be passed Correction Entry Specification Section The only editable field in this section is the Approver Comments field Enter these comments and then click Approve or Reject button If a correction entry is rejected then it is allocated back to the Correction Entry window Note e When a correction entry is passed the adjustment entry amount is reduced to the extent of the correction entry amount thus the reconciliation difference Correction amount Adjustment amount e Exposure Id used to make correction should not include GL keyword e The signage of Adjustment Amount and Correction Amount needs to be same and the correction shouldn t be approved if the signage differs in Correction Entry Approval Oracle Financial Services Software Confidential Restricted 75 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Object Migration for GL Reconciliation Rules Object migration for GL Reconciliation rules provides flexibility to the user to migrate GL Reconciliation definitions through an offline process In this process the user can move one or more
15. In the following example Corporate Parent has been selected to be a sibling to Company C 1 e to be inserted at the same level within the hierarchy as Company C Oracle Financial Services Software Confidential Restricted 36 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 COMPANY B Ciera Utha Soench Hm Eia BRBaae G Show Hierarchy Show Results All Urge i COMPANY A i COMPANY B i COMPANY C i Comorate Parent Orphan Branch Add Leaf For the Add Leaf option the Add Member dialog presents all leaf members that have not already been assigned elsewhere The leaf value or values you select is placed in the hierarchy one level beneath the node you originally selected Oracle Financial Services Software Confidential Restricted 37 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 ed RAs aM Show Hierarchy Show Results F All Orgs COMPANY A a COMPANY B COMPANY C i Corporate Parent i E recule Finance Human Resouces 3 Urohan Branch In the example above Executive Finance and Human Resources have been selected to be children of the Corporate Parent rollup node Level Properties Selecting the Level Properties option invokes the Level Properties dialog Within this dialog you may provide names and descriptions for each of the le
16. Paeqein Product EF EERS Business Unit t Product Branch t Business Unit Customer Class Branch Org Unit Customer Class gt Org Unit Ok Cancel Allocation Map Level Reconciliation if Map Level Reconciliation is selected in the Setting window Settings GL Parameters Product Processor PP Parameters Dimensions Allocation Adjustment Allocation Automatic Manual Adjustment Posted to Product Processor Other amp Target Entity Details Product Processors Reconciliation Amount Column Target Entity Default Values Allocation Amount Column Allocation Ratio In the Allocation tab the following fields have to be selected Adjustment Allocation If you want the application to pass automated adjustment entries then select Automatic or else select Manual Adjustment Posted to Select the Target table where the adjustments are to be posted that is if the adjustment entry is to be posted to PP selected in the Product Processor Parameter window then select Product Processor or else select Others Target Entity Details As per the selections made in the preceding two fields the fields in the Target Entity section is disabled or enabled accordingly Refer to the following cases for more details Case 1 If Adjustment Allocation is Automatic and Target table is Product Processor Default Values is the only column to be updated Default Values are the mandatory columns to be updated
17. Parameters role should be mapped to that relevant user profile This window consists of two sections Run Details and Run Execution Parameters Run Details Section This section displays the name of the Run which 1s a read only value amp se Run Details Reconciliation Difference Calculation Run Name Run Execution Parameters Section In this section you can update the following Global Threshold Global Threshold is applied over and above the mapping level threshold If this threshold is breached during execution then you have the choice to select continue or you may stop the execution process Global Threshold is compared with cumulative percentage difference across all reconciliation definition being executed in a Run Execution on Threshold Breach In this field you have the choice of selecting Continue or No If Continue is selected and the GL reconciliation difference breaches the global threshold level then the Execution will continue If No is selected then the Execution is discontinued If this parameter is No and threshold breach is at definition level then execution will skip posting the adjustment entry and proceed to find the next difference Auto Approval If Auto Approval is selected as Yes then it will directly be updated in the Adjustment Entry Authorization window This field can be edited only by the authorizer The default selection is No Before proceeding further to ensure that you do not los
18. UNIT ON DIM _BUSINESS_UNIT V_BUSINESS_ UNIT CODE Oracle Financial Services Software Confidential Restricted 99 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Vil viil 1X STG_GL_DATA V_BUSINESS_UNIT_CODE AND DIM BUSINESS _UNIT f _latest_record_indicator yY LEFT OUTER JOIN DIM CUSTOMER TYPE ON DIM CUSTOMER TYPE V_CUST_CLASS_ CODE STG_GL_ DATA V_CLASS_CODE AND DIM CUSTOMER _TYPE f latest_record_indicator yY LEFT OUTER JOIN DIM_ORG_UNIT ON DIM _ORG_UNIT V_ORG _UNIT_CODE STG_GL_ DATA V_ORG_UNIT_CODE AND DIM ORG UNIT f latest record _indicator Y LEFT OUTER JOIN DIM GEOGRAPHY ON DIM GEKOGRAPHY V_ACCT BRANCH CODE STG_GL_DATA V_BRANCH CODE AND DIM GEOGRAPHY f latest_record_indicator yY LEFT OUTER JOIN DIM PRODUCT ON DIM _PRODUCT V_PROD_ CODE STG_GL_ DATA V_PROD_ CODE AND DIM PRODUCT f latest_record_indicator Y Click Save Navigate to Unified Metadata Manager and click Business Hierarchy under Business Metadata Management Add two new Hierarchies on new Ledger Account Dimension for GL Code and for GL Type and shown in the following figures GL Code Example Long Deecrpoon Business Hierarchy Gedinttion Husinose Hierarchy hoes Usar iv Fea User errr ta i Hadihead F LAs diii Hy Edil husiness Hierarchy LA Oracle Financial Services Software Confidential Restricted 100 User Guide Oracle Financial
19. a Cancel operation Paste as Child Paste as Sibling and Cancel are disabled Delete Node amp UnDelete To move a dimension member back into the Orphans Branch click a member and then select the Delete option Once you have performed a Delete operation the member selected for deletion appears with a strikethrough font The following example shows the deletion of the Human Resources dimension member Oracle Financial Services Software Confidential Restricted 39 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 on Mv oro gt EEO S show Hierarchy Show Results AllOrgs i COMPANY A 1 COMPANY B i COMPANY C i Huge Piece eee 1 Lomorate an Add Sibling Exec Finan Level Properties Uiphan Brani Cut Delete Node N ma ERARA s Show Hierarchy Show Results Al Orgs 1 i COMPANY COMPANY amp i COMPANY C i EI Note After having deleted the Human Resources member it may be restored to its original condition by executing an UnDelete operation Member Properties Display Click the separator bar at the extreme right hand side of the Hierarchy Display Grid to invoke the Member Property display The Member Property display shows all of the properties of the currently selected dimension member the member selected within the hierarchy While the Member Property display is open you may use your Up arrow Down arrow Left arrow or Ri
20. a grid containing all of the attributes that meet your search criteria The Dimension Attributes summary grid offers several icons that allow you to perform different functions when an attribute is selected amp Dimension Attributes BS p r a r i E Numeric Code Name amp Data Type Required Seeded 5030 Difference Auto Approve Flag String No No 5024 General Ledger Account String No Yes 5029 General Ledger Book Code string No No 5025 General Ledger Name String No No S026 General Ledger Type String No No 5026 Intra Group String No No 5027 Parent General Ledger Account String No No To select an attribute click a check box in the first column of the grid More than one attribute can be selected at a time but this may disable some of the icons Clicking a check box a second time clears an attribute You may Select or deselect all of the attributes in the summary grid by clicking the check box in the upper left hand corner of the summary grid directly to the left of the code column header Oracle Financial Services Software Confidential Restricted 23 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Add Clicking the Add icon begins the process of building a new attribute The Add icon is disabled if any row in the grid has been selected View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed d
21. and Reports Overview of OFS Analytical Applications Reconciliation Framework Reports and Dashboards OFS Analytical Applications Reconciliation Framework integrates the results generated by the OFS Analytical Applications Reconciliation Framework with Oracle Business Intelligence It provides you with a reporting cum information framework which can be used for generating reports and viewing information relevant to computations and other aspects of the OFS Analytical Applications Reconciliation Framework Application It serves as a single regulatory and management reporting solution OFS Analytical Applications Reconciliation Framework leverages the capabilities of Oracle Business Intelligence Enterprise Edition to provide out of the box reporting of your OFS Analytical Applications Reconciliation Framework Application results Through OBIEE you have access to a robust reporting engine for managing all of your business intelligence needs The key elements are Tabular and pivot table reporting e Drill across capability Dashboard publishing e Export options such as Excel PowerPoint and PDF Accessing the Standard Reports and Dashboards You can access the standard dashboards and reports by accessing the OBIEE end user URL and logging in to the application When you sign on to the application you are directed to the Home Page which will show basic summary reports At the top right hand corner of the window click the dashboards drop dow
22. executed o Time of Execution Displays the time when the Run was executed Oracle Financial Services Software Confidential Restricted 64 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Posting Adjustment Entry The Data Entry window pertains to posting of adjustment entry after updating details of the entries The Data Entry section consists of the following window Adjustment Entry In the Review window the adjustment entry which is submitted for authorization is approved or rejected The Review section consists of the following window Adjustment Entry Authorization Adjustment Entry All GL reconciliation differences identified after execution and not auto approved are displayed in this window The adjustment entry allocation depends upon the details provided in the Reconciliation Management window Summary and Details Page Upon initially navigating to Data Entry gt Adjustment Entry a window is displayed showing all the Adjustment entries awaiting approval approved or rejected by the Authorizer By selecting an Adjustment Entry and by using search criteria you can icon the set of adjustment entries that are displayed When you click the edit or view icons the details page is displayed Navigation within the Adjustment Entry Window When you first navigate to the Adjustment Entry window the Adjustment entries associated with your first dimension are present
23. exposure ID there are two options provided e A Simple Search wherein you have the option to input the minimum and maximum adjusted amount All the Exposure IDs that fall in that range are displayed Advanced Search wherein you can search for Exposure IDs based on the dimensions mapped to the Exposure Select the Reconciliation Dimension Add icon to add more reconciliation dimensions in the Search section Adjustment Entry Specification The Adjustment Exposure IDs mapped to the selected PPs are displayed in this section The following fields are displayed in this section Adjustment Exposure ID The column mapped to a PP to which adjustment entry is passed is displayed here Adjusted Amount Displays the amount by which the reconciliation difference need to be adjusted e Status If an Adjustment entry is approved or rejected the relevant status message is displayed here GL Code Displays the GL code for which this reconciliation is identified This is applicable for GL Level Reconciliation only e GAAP Code The GAAP code based on which the reconciliation is defined and executed is displayed here Currency Displays the currency of the adjustment entry amount Legal Entity Displays the Legal Entity in which the reconciliation difference is found and subsequent adjustment entry is to be passed Default Value Specification The default value of each exposure ID can be nullified in the Default Value Specifi
24. gt 6 For three definitions OBJECTS tag is lt OBJECTS TargetFolder GLRECONSEG gt lt OBJECT Code 1 1 Type 3100 gt lt OBJECT Code 1 2 Type 3100 gt lt OBJECT Code 2 1 Type 3100 gt lt OBJECTS gt 7 Execute MIGRATION_HOME bin ObjectMigration sh after providing executable permissions 8 lt A file FILE_NAME dmp rules dmp is created in MIGRATION_HOME metadata archive Oracle Financial Services Software Confidential Restricted 77 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Move this file to MIGRATION_HOME metadata restore folder You can copy the file in the target environment by creating restore folder under metadata directory if not available 9 Exporting definitions from source environment is done successfully Importing Objects to Target environment Follow the below procedure to import object to target environment 1 Repeat 1 3 steps as followed in export mode In Mode tag mention IMPORT 2 In OBJECT CODE property mention 1 1 Note Everything that is exported is imported You cannot choose only certain definitions to move 3 Format for OBJECTS Tag is lt OBJECTS TargetFolder GLRECONSEG gt lt OBJECT Code 1 1 Type 3100 gt lt OBJECTS gt 4 Execute MIGRATION_HOME bin ObjectMigration sh after providing executable permissions 5 Check GLReconLogger log for logs It provides details such as number of
25. icon Run Name Select the Run Name which was being used to run the definition s in Run Management Summary screen Execution ID All successful Run executions with the status as complete in the Run Execution Summary window is populated here Select the appropriate Run Execution ID from the drop down This report is used to view the sum of Source Balance Target Balance and Reconciliation Difference across Legal Entity GAAP Code Currency Organization Unit Customer Class Business Unit Geography along with GL Hierarchy and Product Hierarchy ORACLE Business Intelligence Search All gt Advanced Administration Help Sign Out Reconciliation Framework Analytics Home Catalog Favorites Dashboards i New B Open SignedInAs weblogic Home Threshold Breach Reconciliation Execution Audit Trial Drill Down z v Extraction Date 12 31 2010 G Run Name seect Value T Execution p seed Vale Apply Reset v v Reconciliation Difference Drill Down Report Legal Entity GAAP Code Currency GL Hierarchy Product Hierarchy Organization unit Customer Class Business Unit Geography Source Balance Target Balance Reconciliation Difference Bank Shiv5 Australia GAAP Australian Dollar LEBAM A 1000 C 1111 gt Product Hierarchy Total AU Household _ Investment Banking au 17 3 00 6 00 3 00 IN Retail Loans Small Busi
26. must map the fields to the corresponding columns in the destination entity STG_GL MASTER STG_GL_DATA and other PP corresponding to the flat file definition This can be achieved in OFSAAI through the following menu option Click Unified Metadata Manager then click Data Integrator Framework then click Warehouse Designer and then click File Extracts After mapping the fields the data in the ASCII flat file must be uploaded through a batch process that can be defined and executed from the following menu option Click Operations then click Batch Scheduler and then click Batch Maintenance Excel File Alternatively you may upload the GL Master data using the following menu option Oracle Financial Services Software Confidential Restricted 11 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Click Unified Metadata Manager then click Data Entry Forms and Queries and then click Excel Upload Choose this option when you have moderate quantities of data that is available in an excel file format Direct User Input To input the GL codes through screens is explained in detail in the Chapter Setup REVELEUS_PARAMETER_MASTER Manual mapping of GL codes which differ across general ledger entity and Product Processor entity applicable for a General Ledger GL to Product Processor PP reconciliation are done the table REVELEUS_PARAMETER_MASTER Case 1 If GL codes for GL t
27. provides two features Migration of all definitions at once Pass ALL as an input in the OBJECTMIGRATION xml and all the definitions is moved to your target environment The state of the moved definitions in target environment is discussed in the next section Migration of selected definitions Put map ID and version number of each of the definitions you want to move in OBJECTMIGRATION xml file How to pass this input is discussed in How to use the Utility section Definitions in Target Environment 1 2 All definitions in the source environment are divided into two categories Map name matches with some of the definitions in the target environment All the definitions whose Map name exists is given the same map ID and appropriate version number highest available is given to the moved definitions Map name is new and does not exist in target environment Oracle Financial Services Software Confidential Restricted 76 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 All the definitions whose map name doesn t exist is grouped according to their map name or Map ID and each of the group members is given a new map ID that is the lowest available in the same order as these definitions are in Source environment Each members of the group has different version number For more information see Use Case of GL Recon Command Line Utility GL Reconciliation Object Migrati
28. row in the grid has been selected Oracle Financial Services Software Confidential Restricted 15 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the details of the dimension on a read only basis The View icon is only enabled when a single dimension has been selected e Select Dimensions This icon enables you to define the mapping of the GL source entity and PP entity table with the corresponding dimension columns a Reconciliation Framework Setup a Global Settings eg Global Parameter Maintenance b AMHM Maintenance Reconciliation Management Ledger to Ledger T General Ledger to Product Processor k Run Management Data Entry Ey Review Reconciliation Framework gt Setup gt Global Settings Product Processor PP Source Settings Product Processor Name Stage Cards Stage Loan Contracts gt General Ledger GL Source Settings GL Source System Name GL Table Stage General Ledger Data STG_GL_DATA Dimensions Mandatory Dimension Settings Legal Entity Legal Entity Currency Currency GAAP Code GAAP Code o Reconciliation Dimension Settings Product Org Unit Branch Global Settings Product Processor Table STG_CARDS STG_LOAN_CONTRACTS GL Book Name Book9 Book8 Book7 Book6 Book
29. the Approve or Reject buttons accordingly If Reject is selected then the entry is allocated back to the Adjustment Entry window Oracle Financial Services Software Confidential Restricted 70 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Posting Correction Entry The Data Entry window pertains to posting of Correction Entry after updating details of the entries The Data Entry section consists of the following window Correction Entry In the Review window the Correction Entry which is submitted for authorization is approved or rejected The Review section consists of the following window Correction Entry Authorization Correction Entry Window Upon browsing through the reconciliation differences you are expected to investigate and determine the reasons for a GL reconciliation difference If you have identified the account or contract that is responsible for the difference then you can rectify the difference by posting a Correction Entry on that account If not a new account can be created for posting the Correction Entry A Correction Entry alters the balance of the identified account within the PPs When an account is corrected simultaneously a contra entry is posted into the corresponding Contra GL Account The adjustment entry which has been approved is passed on to the Correction Entry window Summary and Details Page Upon initially navigating to Data Entry gt
30. to be assigned amp Dimension Dimension General Ledger Account Attribute Details Section Name Description Attribute Details Numeric Code 50341 EF fSL001 New GL Attribute Code When adding a new attribute you must select a code value to which you want your new attribute to be assigned Code values for each attribute belonging to a dimension must be unique but you are otherwise free to pick any numeric value you wish You may also click the generate code shortcut key to automatically generate a new Code value You must supply a code value before you can save a new attribute definition and you may not change a code value once an attribute definition has been saved Name Used to name or re name your attribute You must supply a name or a new name if you wish to re name your attribute before you can save an attribute definition Description Used to store a longer description of your attribute Attribute Properties Section Attribute Properties Data Type Date Dimension Required Attribute Yes No Defauk value Data Type Select a Data Type for your attribute For attributes that have already been saved you may not modify Data Type Date Number and String Data Types If you have selected the Date Number or String Data Type then the Dimension drop down list box is disabled Dimension Data Type If you have selected the Dimension Data Type then the Dimens
31. which has identified a reconciliation difference is displayed here Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the adjustment entry is to be passed is displayed here GL Date The date of execution of the Run is displayed here Reconciliation Amount The reconciliation difference for GL PP reconciliation is displayed here Submission Pending The adjustment amount pending for submission is displayed here Approval Pending if the adjustment amount is pending for approval then that amount is displayed here Approved The total amount approved by the authorizer is displayed Rejected The total amount rejected by the authorizer is displayed here Version number The number of times the adjustment entry details are modified is displayed here Navigation within the Details Page When you click Edit or View the Adjustment Entry details page is displayed Run Execution ID Definition Name A A Adjustment Entry amp Adjustment Entry Details GL Date Version Number amp Product Processor Selection 1 to 1 of 1 Product Processor Amount Column Stage Cards Outstanding Principal Balance Month End amp Search Basic Search Amount Minimum Amount Maximum Amount Advanced Search Dimension 1to3of3 Legal Entity Currency GAAP Code amp Adjustment Entry Specification K2 1to 1 of 1 Adjustment Exposure ID Adjusted Amount Status GL Code GAAP Cod
32. 5 Book 4 Book 3 Book 2 Book28 Book27 Book26 Book25 Book 24 Book23 Book22 Book21 Book20 Boo k EET B Product Processor Data Set Previous 1 Next Cards Dataset Loan Dataset B 7 GL Code Column Previous 1 Next GL Data Set m gt GL Dataset GL Code E Previous 1 Next F Previous 1 2 Next Product Processor PP Source Settings Section The following columns are displayed in this screen Product Processor Name The logical table name of the Product Processor PP is displayed Product Process Table The physical table name of the PP table is displayed here Product Processor Data Set The group of PP tables whose inter relationship is defined by specifying a join condition between the various tables is displayed here Navigation within Product Processor PP Source Settings When you click the Add View or Edit icon the following screen is displayed Product Processor Name Product Processor Data Set Customer ID Column amp GL Code Column Selection A 2 Balance Column Selection amp Product Processor PP Source Settings Product Processor Table Exposure ID Column Extraction Date Column 0 tod of 0 0 to 0 of 0 Oracle Financial Services Software Confidential Restricted 16 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0
33. 7 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Wh Reconciliation Correction Report Map Name LE1_Check_1 i Map Version 2 i Reconciliation Correction Value Display Actual v GL Name Currency Reconciliation Difference Approved Adjustment Amount Approved Correction Amount Submitted Correction Amount Rejected Correction Amount LE1 GL2PP S 1001 USD 33 000 33 000 33 000 0 0 Refresh Print Export Amount in Absolute Reconciliation Correction Detailed Report Map Name LE1_Check_1 iw Map Version 2 iw GL Name LE1 GL2PP S 1001 iw i a s Approved Submitted Rejected Product a Smid Currency n inmana Product mere meena Geography Sree Correction Correction Correction toana A Processor Amount Amount Amount Balance Column LE1 GL2PP Bank USA US Dollar United States 33 000 33 000 0 0 STG_CARDS n_eop_prin_bal 1001 of America GAAP Return Refresh Print Export Create Bookmark Link Dashboard Threshold Breach Threshold Breach Summary Report Level Not Applicable Filters Report Description This report displays in a nutshell the threshold parameters of the selected Run Execution ID The following parameters are reported e Global Threshold Global Threshold displayed here indicates the point of reconciliation difference greater than which execution process may stop or c
34. All Orgs dimension member has been selected to serve as the root node for the hierarchy Note that in this context the Show Members column only lists rollup members a leaf member may not serve as the root of a hierarchy When you click OK the Add Member dialog closes and the original hierarchy display is modified to show your selected root member B amp u Show Hierarchy Show Results All Ungs Orphan Branch At this point the process of adding additional dimension members leaves and rollup nodes is the same for existing hierarchies as it is for new hierarchies Editing Hierarchies Inserting New Members into a Rollup Node Select a rollup node member and then right mouse click This action will display a number of choices including Add Child Add Sibling and Add leaf The following example continues from the above description of creating a new organizational unit hierarchy Oracle Financial Services Software Confidential Restricted 34 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 ARRAS amp H8 B show Hierarchy Show Results All rge O0 Add Child Add Leaf Level Properties Delete Node In this current example we have selected a rollup node member which serves as the root member of the hierarchy Because OFSAA Infrastructure does not support hierarchies with multiple tops you may not add a sibling member i e a
35. Applications Reconciliation Framework Release 8 0 1 0 0 number indicates the number of times the reconciliation was edited at the reconciliation definition stage Reconciliation Difference Value Display If the Reconciliation Difference is to be displayed in Actual format select Actual or else select Percentage Report Description This tabular report is displayed if Adjustment Allocation is selected as Yes while defining reconciliation This report displays in a nutshell the correction amount passed The following parameters are displayed GL Name The name of the specific GL entity code of the selected Map Name is displayed Currency Displays the currency in which the Adjustment Entry is processed Reconciliation Difference The net reconciliation difference is displayed here Approved Adjustment Amount The Adjustment Entry amount approved and populated in the Correction Entry window is displayed here Approved Correction Amount The correction amount authorized by the approver is displayed here Submitted Correction Amount The correction amount submitted from the Correction Entry window however waiting to be approved by authorizer is displayed here Rejected Correction Amount The correction amount rejected by the authorizer from the Correction Entry Approval window is displayed here Drill through Report Name Reconciliation Correction Detailed Report Description Navigation Path Click GL Name in the Reconciliation Correction R
36. Choose the type of Upload as New Upload 4 Enter the Erwin XML File Path 5 Click Upload to upload the model The most important activity to commence working on the application is configuration of data Data can be divided into two categories Setup Table Stage Table A setup table is a set of data that is static and does not change on regular intervals This is a set of seeded data which refers to the initial data that is provided with the application Stage table data consists of Product Processors and a set of other stage tables for which you can refer to the download specifications document The seeded tables of Currency and GAAP Codes can be edited to add specific currencies and GAAP codes in use The Download Specifications document provides information on the columns to be populated within each table Additional Information STG_GLCODE_MAP While uploading data into STG_GLCODE_MAP ensure the following If a new set of data is to be added in the table STG _GLCODE_ MAP then ensure that this data is added to the existing set of records as incremental data for the batch to be executed successfully Once new data is uploaded all subsequent executions will refer to the new mapping Execution based on old GL code mapping is not permitted NOTE For a General Ledger to Product Processor Reconciliation the column V_TARGET_BOOK_CODE must be null For a General Ledger to General Ledger Reconciliation the column V TARGET BOOK CODE mus
37. Contracts dll Previous 1 Next Legal Entity Currency Dimension Column Name Previous 1 Next v_h_code Legal Entity Code v_W_code_flex Legal Entity Code vW_h_code sap Legal Entity Code Dimension Column Name Previous 1 Next vW_h_code Legal Entity Code W_hr_code Legal Entity Code Adding a Dimension You can also add optional dimensions in the Reconciliation Dimension Settings section by clicking the Add icon Oracle Financial Services Software Confidential Restricted 19 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 ath x Search in Hierarchy Hierarchical AVaillable Dimensions Selected Dimensions L Dimensi Product 5 i i IMENSIONS Org Unit Product Branch Org Unit Customer Class 1 Branch Business Unit Customer Class gt Business Unit Th d Ok Cancel GL Parameter Maintenance In this window parameters such as Financial Year Closure for a specific Legal Entity can be defined Upon navigating to Setup gt Global Parameter Maintenance a summary page is displayed showing all of the legal entities defined Select a legal entity or use the search criteria to control the set of legal entities that are displayed When you Add Edit View or Delete a legal entity a detail page is displayed Oracle Financial Services Software Confidential Restricted 20
38. Creation Date The date on which the reconciliation was created is displayed here Define a Ledger to Ledger Reconciliation To add a Ledger to Ledger reconciliation refer to the following steps 1 Select Ledger to Ledger under Reconciliation Management in the LHS of the window 2 Click Add icon in the menu bar of the Ledger to Ledger window The following window with four tabs is displayed Oracle Financial Services Software Confidential Restricted 42 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Settings Source Ledger Parameters Target Ledger Parameters Dimensions Reconciliation Management oe E Settings Source Ledger Parameters Target Ledger Parameters Carmensions 3 Enter the Name and Description of the Reconciliation to be created Settings In this window enter the following details Legal Entity Select the Legal Entity from the available hierarchy list Check the check box Inherit to Child Consolidation Type Select the Consolidation Type from the drop down list as Solo or Consolidated Note Only one Parent Legal Entity should be part of the definition Source Ledger Parameters In this window enter the details as follows amp Reconciliation Definition Name Description Settings Source Ledger Parameters Target Ledger Parameters Dimensions GL Book Select v Balance Type Select GL Type Select v GL Hierarchy
39. GL Level Recon or Map Level Recon Note Only one Parent Legal Entity should be part of the definition GL Parameters amp Reconciliation Definition Name Description Settings GL Parameters Product Processor PP Parameters Dimensions Allocation GL Hierarchy amp Filter lt D sl Hierarchy amp No Element Selected I Hierarchy Member In this window update the following GL Hierarchy Click the Hierarchy icon to select the GL Hierarchy Hierarchies mapped to the selected GL type in the Global settings window is displayed here You also have the option of adding filters to the optional dimensions product business unit and so on defined in the Global Setting window Comparison between the GL source system and PPs is based on the filters set on these dimensions Refer to the following steps to add filters 1 Click the Add icon in the Filters section as highlighted in the previous figure 2 Select the Hierarchies on which relevant filter are to be set as shown in the following figure Oracle Financial Services Software Confidential Restricted 47 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 x Sea ron Hierarchy Hierarchical Available Hierarchies f Hierarchy e Product Org Unit Branch GAAP Code Customer Class Currency L Business Unit iMi Selected Hierarchies 2 Product
40. General Ledger Data Flex v_lv_code_flex v_ccy_code_flex V_gaap_code_flex v_prod_code_flex v_org_unit_code_flex v_branch_code_flex v_class_code v_business_unit_code Stage General Ledger Data Sap v_lv_code_sap v_ccy_code_sap V_gaap_code_sap v_prod_code_sap V_org_unit_code_sap v_branch_code_sap v_class_code v_business_unit_code Product Processor Stage Cards v_h_code jan Previous 1 Next v_ccy_code v_gaap_code v_prod_code v_org_unit_code v_branch_code v_class_code v_business_unit_code Stage Loan Contracts v_h_code v_ccy_code v_gaap_code v_prod_code V_ORG_UNIT_CODE v_branch_code v_class_code v_business_unit_code Selecting a Dimension When you click the Select Dimension icon in this section mapping between the corresponding GL source entities to the selected dimension column name can be defined by clicking the Hierarchy icon You can also define the mapping between the PP source entity and the selected dimension column name Only the three mandatory dimensions should be selected against each For example only legal entity dimension should be selected against legal entity and any other dimension should not be selected You are expected to select a valid Legal Entity GAAP and Currency hierarchy while configuring mandatory dimensions through Global Settings GL Source Stage General Ledger Data Stage General Ledger Data Flex Stage General Ledger Data Sap El Product Processor Stage Cards Stage Loan
41. Information Delivery ie Advanced Analytics Infrastructure HEF Reconciliation Framework Ey Enterprise Financial Performance Analyt Oracle Financial Services Software Confidential Restricted 80 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Settings in MDB There is an MD_TYPE whose seeded number is 6600 against which class_name com ofs erm gl MDBBrowser is present In the same table for column INCLUDE ensure the flag is mentioned as N In order to run it the flag should be Y In the UNIX LINUX command line session go to FIC_DB_HOME bin Execute MDBPublishExecution sh lt INFODOMS Alternatively use the seeded Batch lt Infodom gt _MDB to publish the GL Definitions to Metadata Browser 10 184 151 89 PuTTY All GL definitions are synced with Metadata browser once the page is refreshed Format to follow in MDB Under the Rules tab all the definitions are listed by their map name and version number The map name is appended with an underscore followed by the version number For example if map name is GL ABC and version number is 3 then MDB Browser will show as GL ABC_3 on the LHS Oracle Financial Services Software Confidential Restricted 81 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 OFS Analytical Applications Reconciliation Framework Dashboards
42. L is not captured in the reconciliation Auto Definition Auto definition does not require you to provide GL Hierarchy GL Book and Dimensions Auto definition is possible only for GL level reconciliation where reconciliation is done on the basis of primary GL book and selected GL type For auto reconciliation the consolidation type is solo and aggregate only In auto definition for a combination of legal entities and consolidation type any one GL book should mandatorily updated with Flag Y indicating a Primary GL entity All others should be updated with a Flag N GL Book is considered to be unique across legal entity and consolidation type GL Level Reconciliation In GL level reconciliation the difference between GL system and transaction processing Product Processors systems at each reconciliation dimension node level within a GL code is identified In case of manual reconciliation definition unique GL codes are identified from the GL side In case of auto definition unique GL codes are identified based on the primary GL Book for the legal entity and consolidation type GL Level Reconciliation definition is applied at legal entity level either solo or consolidated If it is at solo level then exposures originating in the legal entity are selected If it is at consolidated level then exposures originating in the selected legal entity as well as its child entities with or without intra group exposures depending on GL structure are sele
43. L Reconciliation PP Default Values This table stores the default values that must be used for mandatory columns Setup within the PP in the event an adjustment entry is to be posted into the corresponding PPs Product Processor s It receives for every processing period the account level information across DL various products GL Adjustment Entries This table stores the information with regard to the adjustment entries after the Processing differences have been found out GL Correction Entries This table stores the information with regard to the correction entries after the Processing adjustment entries have been approved GL Execution Master This table stores the information of each execution GL Threshold Breaches This table stores the breaches from the thresholds as specified in the GL Global Processing Parameters and the GL Mapping Master if any GL Recon Audit Trail This table stores a trace of all add modify or delete operations performed Log eM negisrmea es GL Execution Info At the time of batch execution this table gets updated and it checks if the Processing mapping which has been chosen for GL Reconciliation pertains to the entity which has been selected Dynamic SQL error log This table stores the processing specific dynamic SQL queries as well as Error Log details if any Fact Reconciliation Difference This table stores the results of executing a defined reconciliation that is it stores Processing the re
44. Oracle Financial Services Analytical Applications Reconciliation Framework User Guide Release 8 0 1 0 0 September 2015 ORACLE FINANCIAL SERVICES User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Contents PREFACE rrene e nene OEN TTO E E EARE AE REEE 1 INTENDED AUDIENCE oraire E T ET I EN OO E 1 DOCUMENTATION ACCES SIBI CITY erisin a E A A S Meee eu ae Dacae vaabereleetaceu aie 1 ACCESS TO ORACLE SUPPORT apinan oE rAr senaelvacsobedual cevactinte E censebnetoeeduet sen neetiadeeluutaeuse Uvetobs dust sen setinvadoatunt ee 1 SIROCTORE anen E E E law spear waa aed rae tm eee eee 1 RELATED INFORMATION SOURCES vcctensen desis EE EE EE OEN EE AE E O E 2 INTRODUC TION wsssstissseussesscswscunaiaaudeasbavecewsceaaauaudena mama dewabenaananioan sama bemaaaganencens aneeaceacenceeeacensseeonesaaezeets 3 FEATURES OF OFSAA RECONCILIATION FRAMEWORK sicessson ven cuscdvenseacccendcdege wee eraes ceceercneac coum atece ime EEA E EEE 3 PRO CESS i EOW criei a EE NS a a e a T 5 OVERVIEW Sarrerei aT E E E NN 5 REY TERMS AND CONCEPTS nascetuc atthe r A r E E 6 CORSOWOGUION Type miren it aA EA T E E A E TRTE 6 MOE CTO CIO TEE TEE E ETEA EA TE E T tance 7 Manual keconciliation Demon nrerin erer an aO A T E EE ONTA E TOETS 7 A to DeRNON gcn a A a N T a a a a 8 GPC V CTR CCON GI OND ees aa a O 8 Map Level kecon OTON orcs ca aiie a ONE E Gov oadion easedeetnes Table van ohiev neste RET 8 OMIMONIICONS s
45. PPLICATIONS RECONCILIATION FRAMEWORK REPORTS AND DASHBOARDS scecececsececececeececes 82 ACCESSING THE STANDARD REPORTS AND DASHBOARDS ccececsccecececececsccccccececscncecececeacececececeacecececsaceceeeseueacecececeeeceseseuss 82 REPORT DESCRIP MONS sicediecune eal catcem duet cert Sas one acta ba tinacie a a Meenas ple eine alteencaul oe Galician a eis pace ecg ate E A ane ela axoataien 83 DOSNDOGIG HOME sainn ar re aa ada av nah eae andehiaTbidaeiaia Oa 83 D shboadrd Threshold Bredase Bisse a ead RSE ase was eens ee ie pee cakes 88 Dashboard Reconciliation Execution Audit Trail cccccecceccececcececcececcecscscscscscsecscsecscsscscseescscescsetscectsascsasces 90 PGS OGIO DIE DOWD ial Hoew sac essai ade a eaten dale sas aii sass Raw ten dia ah a abi erent R 91 ADDING CUSTOM RECONCILIATION DIMENSIONS IN DETAILED RECONCILIATION RE POR icosoese seas seivares nese reaearcunsbe desc oede huss Seas babesasteis gabe sabstensnaseieotseeeeees 92 ANNEXURE A ENITTY DETAILS occsssscccrcsscccsssssrssorsssrssosss sssr ESKE REE ASAA Aaaaoi iiS 93 ANNEXURE B ADJUSTMENT AUTO APPROVAL CONCEPT eeenseeeseseesssessesesssessssesssessseoss 94 ANNEXURE C DATA MODEL AND METADATA EXTENSIONS ccceccecsccccsccccecs 97 STEPS TO CONFIGURE AN ADDITIONAL TABLE IN THE APPLICATION cccececececsccccscecececcccscececececececeeeecscecessueececeeeeeacececeeeueuces 97 ANNEXURE D PROCEDURE TO ADD OPTIONAL DIMENSIONS
46. Product processor GL PP reconciliation If you have only one of these columns to be reconciled always then you can map only that column and pick the respective balance type in the recon definition Dimension Section The Dimension Section consists of two sections Mandatory Dimensions and Optional Reconciliation Dimensions Legal Entity Currency and GAAP Code are mandatory dimensions and must be selected to proceed with GL Reconciliation executions Note It is assumed that mandatory reconciliation dimensions are present in all of the bank s GL source systems Optional dimension list can potentially include any number of common dimensions between a GL and a Product Processor Following optional reconciliation dimensions are supported in this version Product e Business Unit Customer Class e Organization Unit Geography Navigation within Dimension Viewing a Dimension When you click the View icon in this section the corresponding mappings of the GL source entity with the selected dimension columns is displayed on a read only basis Oracle Financial Services Software Confidential Restricted 18 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 amp Mappings for Dimension GL Source F Previous 1 Next Stage General Ledger Data v_hv_code v_ccy_code V_gaap_code v_prod_code v_org_unit_code v_branch_code v_class_code v_business_unit_code Stage
47. Run Execution parameters window List of Runs Summary Grid The following columns categorize each Run in the summary grid Oracle Financial Services Software Confidential Restricted 59 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Run Name Displays the short name of the Run Run Type Displays the type of Run Simulation or Baseline Run Created By Displays the name of the User who defined the Run Creation Date Displays the date on which the Run was created Last Modified By Displays the name of the user who has performed any modifications to the Original Run details Last Modified Date Displays the date on which the Original Run details were modified Navigation within Run Default Parameters Window Click the Run Default Parameters icon on the navigation bar of the Run Management Summary Window to input the Run level parameters The Run Parameters Window is displayed E Run Parameters Windows Internet Explorer se Run Details iiie Reconciliation Difference Calculation st Run Execution Parameters Global Threshold 20 Execution on Threshold Breach Continue Auto Approval Yes No Cave Close Oracle Financial Services Software Confidential Restricted 60 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Note To modify or view the parameters the Modify Run
48. Search amp Hierarchy Hierarchical Available Hierarchies Selected Hierarchies Product Hierarchy Product Org Unit Branch GAAP Code Customer Class Currency t Business Unit Audit Trail Map Level Reconciliation If Map Level is selected in the Settings window Settings GL Parameters Product Processor PP Parameters Dimensions Allocation amp Product Processor PP Entity B v 1 to 1 of 1 PP Entity Name GL Amount Column Select v Select v Threshold Specification Select v Threshold Amount Currency Select Positive Correction Threshold Negative Correction Threshold Adjustment Entry Floor amp Filter A amp No Element Selected siz Hierarchy Member In the window GL Reconciliation column is disabled when Map Level Reconciliation is selected click the Add icon to update the PP entity or Target entity details as follows e PP Entity Name Select the name from the drop down list GL Amount Column In this column select either Principal or Interest from the drop down list Threshold Specification Specify the Threshold from the drop down list The threshold value can be in both absolute terms and percentage terms at a PP level If the selection in all the PP s is percentage then the threshold amount currency field is disabled Threshold Amount Currency Select the Threshold Amount currency from the drop down list This field is disabled if percentage is selected in th
49. Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 GL Type m Edit Business Hierarchy amp Business Hierarchy Details Code Short Description Long Description L Type 2 Business Hierarchy Definition Hierarchy Type REGULAR Hierarchy Subtype Total Required List Entity DIM_GL_ACCOUNT General Ledger Account Dimension a Attribute V_GL_TYPE General Ledger Type amp Business Hierarchy Node Short Description Node identifier Sort Order El HGL011 EIROOT GL TYPE ELOS Loss DIM_GL_ACCOUNT V_GL_TYPE LOS 8 a Cl Gain DiM_GL_ACCOUNT V_GL_TYPE GNS SEXP Expense DiM_GL_ACCOUNT V_GL_TYPE EXP ER Revenu DiM_GL_At NT V_GL_TYPE RE I l OWNEQ Owner uit DiM_GL_ACCOUNT V_GL_TYPE OWNEQ 4 lt FLIAB Liability DiM_GL_ACCOUNT V_GL_TYPE LIAB EFA Asset DIM_GL_ACCOUNT V_GL_TYPE AST EALL ALL 1 1 1 7 Save Cancel User Info User Comments amp User Info Created By SYSADMN Creation Date Sep 11 2012 8 59 02 AM Last Modified By GLUSER Modification Date Mar 5 2013 4 26 04 PM Authorized By GLUSER Authorization Date Mar 5 2013 4 26 04 PM x Perform an excel upload for table SETUP_GLSOURCE_HIERARCHY o V_GL_HCY_CODE Hierarchy code which is created above as on GL code for new general ledger account dimension o V_GL_HCY_DIM_TABLE_NAME General ledger account dimension table name o V_GL_HCY_INTRA_GROUP_COL_NAME Intra group Column name o V_GL_HCY_GL_TYPE_COL_NAME GL Type col
50. a E ud E N E Maded cuit eanetuavade ucmcecenetas N 59 Navigation within the Summary POGEC sssccccsessccnseseccssnseccseecssausecesausessauueeessunecesaueeessausessauecssaussessausessauaseeas 59 Navigation within Run Default Parameters WiINdOW cccssssesccccssssecccsnsceccsacseecesacuseecsssaunsecessuunsecsssauneesessaans 60 Navigation within Run Execution Parameters Window ssccccssesceccanececsessecsaseccsausecssuseeesausscssausesssansessauaseses 61 Navigation within Run Execution Summary Page 1scccsseeecccsneseccascccsnsecccsueeccsaussessausecssuusessaueessauseessuasessaanseees 63 POSTINGADJUSTMENTENIRY sassissasscavassiesaccssuscessus esau ss sousaucoauanauavaacoauasaussussoaunuaonwennansuamssanaacess 65 Oracle Financial Software Services Confidential Restricted ji User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 ADUSTMENT ENTRY cunn a ences can naw saccades A on nauistacen duet neameeesbadeadeek E L a 65 Summary and Detalls PAJE irei itonti nii Te is cacieveeaduccdeail TAAA VE AATA AEA E A EE 65 ADJUSTMENT ENTRY AUTHORIZATION deaa aa E T A A EAA E TNE A E 68 S ummary and Details PAQE seese ieran aE N E OET S E EEA 68 POSTING CORRECTION ENTRY essesssessosssosssoesccssosssocssosssocsoossocesocesocssosssocesossoossosesosessossssesso 71 CORRECTIONIENTR YC VVINDOW AE EEE E EEA EEE EE ee E EE S E EAEE E E EA EE E 71 S mmay GIG DCTONS Page srra nn o RE EE E E E A
51. according to new Stage general ledger master STG_COL_NM to new General ledger account dimension COL_NM F_DIFF_AUTO_APPR F_DIFF_AUTO_APPRO 176 OVE_FLAG DA VE_FLAG 2 N VARCHAR F_LATEST_RECORD 176 _INDICATOR LRI Y N CHAR SEQ_DIM_GL_ACCOU 176 N_GL_ACCOUNT_ID_ SK NT CURRVAL N NUMBER fis fee OIE Tse Puma OY fy ume 176 EY SK NT NEXTVAL N NUMBER soe OA Lx Lv ccooe fy varia 176 DE PK V_GL_CODE N VARCHAR V_GL_ACCOUNT_N 176 AME NN V_GL_NAME 2 N VARCHAR s V_GL BOOK CODE V_GL BOOK CODE poo varcuar V_GL_PARENT_ACC OUNT_CODE V_PARENT_GL_CODE VARCHAR 11 Navigate to Operations and refer to the following steps 1 Click Batch Maintenance ll Add a new batch provide an appropriate name and description and click Save ill Add a task to the newly created batch IV Select Run Executable under Components V Select appropriate Data store type Data store Name IP Address vi Update scd lt lt MAP_REF_NUM gt gt in the executable with the unique number which is provided while inserting in SYS_TBL_MASTER and SYS_STG_JOIN_MASTER Select Wait as N and Batch Parameter as Y Click Save as shown in the following figure Oracle Financial Services Software Confidential Restricted 98 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Task Definition Batch Maintenance gt Task Definition 2 Task Definition General Ledger Dimension Data Popul
52. ach tabular report to sort the data in ascending or descending order A few reports also consist of a drill through capability wherein you can navigate to the most granular level of data Report Descriptions Dashboard Home Report Name Reconciliation Execution Summary Report Level Not Applicable Filters Report Description This tabular report displays in a nutshell the following parameters of the selected Run Execution Map Name This is the name of the reconciliation as defined in the Reconciliation Management window e Map Version Number This is the version number of the defined reconciliation Version number indicates the number of times the reconciliation was edited at the reconciliation definition stage Oracle Financial Services Software Confidential Restricted 83 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Legal Entity The Legal Entity as defined for this particular map and version number is displayed here Consolidation Type The consolidation type as Solo Consolidation or Aggregate is displayed here Reconciliation Type The reconciliation type that is a Ledger to Ledger Reconciliation General Ledger to Product Processor Manual Reconciliation or General Ledger to Product Processor Auto Reconciliation is displayed here Reconciliation Level Displays the level at which the reconciliation is performed that is GL Level or M
53. ally for income statement reporting The default value for all new dimension members is F Initial Display Level This setting controls the level at which a hierarchy is displayed when you initially enter the Hierarchies Detail screen This setting is particularly useful when you are working with a hierarchy that has many levels In a deep many leveled hierarchy only one or two high level rollup points would be displayed if the hierarchy were displayed in its entirety Hierarchy Display Grid The main body of the Hierarchies Detail screen displays a visual representation of your hierarchy When building a hierarchy within a given dimension you have access to every dimension member defined for that dimension For dimensions that support hierarchies every dimension member has the property of either being a leaf member or a rollup node member You construct your hierarchy by attaching leaf members to rollup node members and by attaching rollup node members to other rollup node members depending on how deep or multi leveled you want your hierarchy to be Hierarchies may be either balanced or unbalanced In a balanced hierarchy all leaf members reside at the same level or depth Generally there is no limit to the number of levels of depth you may build into a hierarchy for Standard Dimensions that support hierarchies For Key Processing Dimensions which always support hierarchies you may construct hierarchies with up to 14 le
54. ap Level Adjustment Allocation Adjustment Allocation is displayed here as Yes or No as defined in the Reconciliation Management windows Balance Type The Reconciliation period as defined in the Reconciliation Management window is displayed here Reconciliation Dimensions The Mandatory Dimensions and as well as Optional Reconciliation Dimensions if any are displayed here i Reconciliation Execution Summary Map Names Map Version Number Legal Entity TC25 Aggregated 1 Bank Australia Aggregate General Ledger to Product Processor Auto GL Level No End of Period Branch Consolidation Type Reconciliation Type Reconciliation Level Adjustment Allocation Balance Type Reconciliation Dimensions Business Unit Currency Customer Class GAAP Code Legal Entity Org Unit Product Report Level Filters Report Description This tabular report displays in a nutshell the identified Reconciliation Differences for a particula Map The following parameters are displayed Map Name This is the name of the reconciliation as defined in the Reconciliation Management window Map Version This is the version number of the defined reconciliation Version number indicates the number of times the reconciliation was edited at the reconciliation definition stage Reconciliation Difference Value Display If the Reconciliation Difference is to be displayed in actual format select Actual or else select Percentage GL Nam
55. are disabled conversely once you have executed a Cut operation Paste as Child Paste as Sibling and Cancel are enabled Paste as Child or Paste as Sibling After performing a Cut operation you may perform a Paste as Child or Paste as Sibling operation If you have cut a dimension member and then subsequently selected leaf member the Paste as Child option is disabled that is no dimension member may be a child of a leaf member Leaf members by definition can have no children Since OFSAA supports unbalanced hierarchies any dimension member regardless of whether it is a leaf member or a rollup member may be pasted as a sibling to any other dimension member In the following example Human Resources has been Cut from the Corporate Parent rollup node so that it may be pasted as a child into Company C Bal AE Show Hierarchy Show Results ast Gl ngs COMPANY A i LUMPANY B CUMFA Copoal Exe Fina Level Properties Hurr gt Otphan Bra Paste as child N Paste as Sibling Cancel Cancel The Cancel option is only enabled after you have executed a Cut operation Once you have Cut a dimension member you may not perform any other operation except for Paste as Child Paste as Sibling or Cancel you may however still invoke Level Properties see discussion above on Level Properties Utilizing the Cancel option allows you to select and subsequently Cut another dimension member 1 e after you have performed
56. ation Task ID Description Components RUN EXECUTABLE amp Dynamic Parameters List Property Value Datastore Type EDW Datastore Name GLINFO IP Address 10 184 135 66 Executable scd 183 Wait N Batch Parameter Save Close amp Audit Panel Created By GLUSER Creation Date 22 feb 2013 17 14 47 Last modified by GLUSER Last Modification Date 22 feb 2013 17 14 47 12 Navigate to Unified Metadata Manager and refer to the following steps to proceed further 1 Click Data Sets under Business Metadata Management ll Add a new dataset and provide code short description and long description ill Select the entities which is participating in the Dataset IV Define Ansi join Example where STG_GL_DATA is your Ledger table and DIM_GL_ACCOUNT is your General ledger account dimension STG_GL_DATA INNER JOIN DIM_CURRENCY ON DIM _ CURRENCY V_ISO_CURRENCY CD STG_GL_DATA V_CCY_CODE INNER JOIN DIM_ORG STRUCTURE ON DIM _ORG_ STRUCTURE V_ENTITY_CODE STG_GL_ DATA V_LV_CODE AND DIM ORG STRUCTURE f latest_record_indicator yY INNER JOIN DIM DATES ON DIM _DATES D_CALENDAR_DATE STG _GL_ DATA FIC_MIS_ DATE INNER JOIN DIM _ GL ACCOUNT ON DIM _ GL ACCOUNT V_GhL_ ACCOUNT_CODE STG _GL_DATA V_GL_CODE AND DIM _GL_ ACCOUNT f_latest_record_indicator Y INNER JOIN DIM GAAP ON DIM _GAAP V_GAAP CODE STG_GL_DATA V_GAAP CODE AND DIM _GAAP f latest _record_indicator Y LEFT OUTER JOIN DIM BUSINESS
57. ation Framework Release 8 0 1 0 0 Preface Intended Audience Welcome to Release 8 0 1 0 0 of the Oracle Financial Services Analytical Applications Reconciliation Framework User Guide This guide is intended for Technical Analyst This user ensures that the data is populated in the relevant tables as per the specifications This user executes schedules and monitors the execution of Runs as batches Business Analyst This user reviews the functional requirements and information sources like reports Data Analyst This user would be involved with cleaning validation and importing of data into the OFSAA Download Specification format Administrator The Administrator maintains user accounts and roles archives data loads data feeds and so on The administrator controls the access rights of users Documentation Accessibility For information about Oracle s commitment to accessibility visit the Oracle Accessibility Program website at http www oracle com pls topic lookup ctx acc amp id docacc Access to Oracle Support Oracle customers have access to electronic support through My Oracle Support For information visit http www oracle com pls topic lookup ctx acc amp id info or visit http www oracle com pls topic lookup ctx acc amp id trs if you are hearing impaired Structure 1 Introduction 2 Process Flow 3 Data Requirements 4 Setup 5 Reconciliation Management 6 Run Execution 7 Data Entry and Revi
58. bal Threshold 80 Execution on Threshold Breach Continue Auto Approval No Global threshold Breached Refresh Print Export Map Name Map Version Number Of Observations Number Of Breaches LE1_Check_1 biWiN le meee j H Refresh Print Export Threshold Breach Detailed Report Map Name LE1_Check_1 i Map Version 1 i GL Entity Cie GAAP Organization e Customer Business ane Source Target Reconciliation Threshold Threshold Threshold ee ar Name Name e Code Unit Class Unit cog y Balance Balance Difference Breach Type Value Currency By LE1 GL2PP Bank USA US Dollar United States 77 000 110 000 33 000 Negative 1 41 857 1001 of America Percentage GAAP Threshold Dohen Dafarch Drint Evnart ranta Banbmorl inl Report Name Global Threshold Breach Summary Report Level Not Applicable Filters Report Description This report displays in a nutshell the global threshold parameters of the selected Run Execution ID The following parameters are reported e Global Threshold Percentage Global Threshold displayed here indicates the point at which execution process may stop or continue at the time of execution if the reconciliation difference surpasses the defined Global Threshold level Global Threshold is compared with cumulative percentage difference across all reconciliation definitions getting executed in a Run Difference Percentage The absolute percentage differen
59. by the user in terms of either the maximum difference allowed in any single Product Processor and its corresponding GL or the maximum number of Product Processors having differences in the GL Reconciliation Primary GL Book A Legal Entity with a consolidation type can potentially maintain GL accounts in multiple source systems case of multiple GL books One of such GL Book is expected to contain absolute truth and being audited and reported Such GL book is Primary GL book for the Legal Entity and consolidation type It is used in auto reconciliation definition Positive Threshold These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Oracle Financial Services Software Confidential Restricted 108 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Audit Trail entries are posted with this information Negative Threshold These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Aud
60. cation section Select an Exposure ID in the Adjustment Entry Specification section The existing default values are displayed You can override these values by updating the relevant default values in the Default Value Override section If multiple PPs and Exposure IDs are selected then this field is disabled Oracle Financial Services Software Confidential Restricted 67 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Submission Comments You are expected to enter your comments before submission or else the default comments are applied by the GL Reconciliation application Note In this section the Submission Comments and Default Value Override fields are the only two editable fields After updating the appropriate fields you can now click the Submit button The Adjustment Entry will now be allocated to the Adjustment Entry Approval window Adjustment Entry Authorization All the adjustment entries which have been submitted through the adjustment entry window are displayed here and the concerned authorizers can either approve or reject the adjustment entry Summary and Details Page Upon initially navigating to Review gt Adjustment Entry Authorization a window is displayed showing all Adjustment entries submitted through the Adjustment Entry window By selecting a dimension and by using search criteria you can control the set of Attributes that are displayed Navigation within t
61. ce Month End Stage Cards Select Total Outstanding Balance Month End In the Allocation tab the following fields have to be selected Adjustment Allocation If GL Level Reconciliation is selected then the Adjustment Allocation is by default considered to be Automatic Adjustment Posted to Select the Target table where the adjustments are to be posted that is if the adjustment entry is to be posted to PP selected in the Product Processor Parameter window then select Product Processor or else select Others Target Entity Details As per the selections made in the preceding two fields the fields in the Target Entity section is disabled or enabled accordingly Refer to the following cases for more details Case 1 If Target table is Product Processor Default Values is the only column to be updated Default Values are the mandatory columns to be updated for populating Target Entity results Case 2 If Target table is Others Then Target Entity Default Values Allocation GL Column and Allocation Ratio are the only two columns to be updated If adjustment entry is to be passed to more than one PP entity then the ratio at which these the entry is to be passed is updated in the Allocation Ratio field Define a GL to PP Reconciliation Auto Definition For Auto Definition reconciliation select Auto in the Reconciliation Definition field To add a GL to PP reconciliation refer to the following steps Oracle Fina
62. ce is displayed here Breach Percentage The percentage by which the Global Threshold is breached based on the reconciliation difference is displayed here Drill through On Not Applicable if Global Threshold Breach Summary Global Threshold Percentage Difference Percentage Breach Percentage 10 166 667 To 156 667 o Refresh Print Export Report Name Threshold Definition Report Level e GL Map Name The name of the specific GL entity map name needs to be selected Filters Oracle Financial Services Software Confidential Restricted 89 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 here Map Version This is the version number of the selected map name Version number indicates the number of times the reconciliation was edited at the reconciliation definition stage Report Description This tabular report displays the following parameters e Target Entity The name of the Product Processor is displayed here in case of a GL to PP reconciliation or name of the Target GL entity is displayed here Target Balance Column The specific column in the Product Processor for GL PP reconciliation or target GL entity for GL GL reconciliation is displayed here Threshold in Displays the type of threshold that is absolute or percentage Threshold Currency The currency in which the threshold value is defined is displaye here Currency is not displayed when Percentage is sel
63. chy display grid Ba Eee Sz Show Hierarchy show Results Orphan Branch When you initially enter the Hierarchies Detail screen in Add mode e for a brand new hierarchy Orphan Branch is set to Yes When set to Yes unassigned leaf members and node members are displayed within a special Orphan branch This can be convenient because the user interface includes functionality that allows you to cut and paste members of the orphan branch into desired locations within your hierarchy The Orphan Branch can also be convenient when you are maintaining an existing hierarchy because when it contains members it provides a visual cue that dimension members have been defined that have yet to be assigned locations within a hierarchy You may suppress the display of the Orphan Branch by setting Orphan Branch to No Access Type You may set Access Type to Read Only or Read Write When set to Read Only only the owner the creator of a rule is its owner may modify or delete the hierarchy Display Signage Display signage is not used within any of the OFSAA engines but is used within the Oracle Financial Services Profitability Analytics OBI application Its purpose is to inform reporting applications on how to subtotal information on financial reports most Oracle Financial Services Software Confidential Restricted 31 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 typic
64. conciliation difference amount if any The requirement for Purging Archiving FACT tables needs to be analyzed developed and executed as per the implementation site requirements for better performance and space management Oracle Financial Services Software Confidential Restricted 93 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure B Adjustment Auto Approval Concept Q E Q p Q E Q Q e Q gt Q 3 p Oracle Financial Services Software Confidential Restricted N GL Code where Auto Approval flag is N will not be used for reconciliation and no adjustment entry is passed against it Allocation required and auto approval will not be considered for the GL code N The difference for the GL code is taken to the FCT_RECONCILIATION_DIFFERENCE and threshold check is performed No impact on FCT_GL_ADJUSTMENT_ENTRIES N GL Code where Auto Approval flag is N is not used for reconciliation and no adjustment entry is passed against it Allocation required and auto approval is not considered for the GL code N The difference for the GL code is taken to the FCT_RECONCILIATION_DIFFERENCE Auto Approval In Run Management Screen will not be considered N GL Code where Auto Approval flag is N is not used for reconciliation and no adjustment entry is passed against it Allocation required and auto approval is not consi
65. controlled by the Show Member Code property discussed above Adding Hierarchies When creating a new hierarchy you must initially provide a name and optionally a description You must also select the Folder in which you want the hierarchy to be stored the hierarchy s Read Only vs Read Write Access Type property and the other Hierarchy Properties described above Default values for Folder and Access Type are stored in Application Preferences ERA amp M Ca m mm Show Hierarchy Show Azuis Right click here to buld tee Add Chil Orphan Branch a K To begin the process of building a new hierarchy right click at the top of the hierarchy see example above to invoke a pop up dialog in which you may select dimension members Every hierarchy must begin with a top level rollup node Since you cannot have a leaf member as a top level rollup node your only choice at this point is Add Child Clicking Add Child invokes pop up dialog in which you may select a rollup node Oracle Financial Services Software Confidential Restricted 33 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 F Add Member Windows Internet I xp loner Members Within the Add Member pop up dialog use the shuttle box icons to select the member from the left hand side that you want to serve as the root member for your hierarchy In the example above the
66. ct the Hierarchies on which relevant filter are to be set as shown in the following figure Oracle Financial Services Software Confidential Restricted 49 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Search iM Hierarchy Hierarchical Available Hierarchies l Hierarchy Product Org Unit Branch GAAP Code Customer Class t Currency Business Unit Selected Hierarchies Product OK Close 3 Select the relevant dimensions from the Filters section 4 Click the Add icon against the selected dimension 5 Select the filter to be applied on each dimension Oracle Financial Services Software Confidential Restricted 50 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Settings GL Parameters Product Processor PP Parameters Dimensions Allocation amp Product Processor PP Entity B 1 to 1 of 1 PP Entity Name GL Reconciliation Column GL Amount Column Threshold Specification Adjustment Entry Floor Negative Correction Threshold Positive Correction Threshold V Stage Cards v Debit Interest GL Code w Total Outstanding Balance Month End v Absolute v 10 10 10 Threshold Amount Currency El Salvador Colon v amp Filter C Oto0of0 A amp No Element Selected 0to0of0 Filter Browser Webpage Dialog amp
67. cted The adjustment entry allocation depends on the reconciliation type selected In GL level reconciliation once a definition is executed the differences that emerge as a part of the reconciliation GL PP level reconciliation is reported in the adjustment entry table This table shows all the entries of an executed map which requires adjustment In GL level reconciliation the difference in amount can either be posted to Product Processors or an external table In GL level reconciliation the adjustment allocation is always automatic that is you do not have the option of editing the allocation ratio Map Level Reconciliation In map level reconciliation the difference between GL data and PP data at each reconciliation dimension node level across all PPs are identified Unlike GL level reconciliation map level reconciliation is computed at an ageregate level of the reconciliation definition by ignoring the GL code and by considering reconciliation dimensions Map level reconciliation is applied at legal entity level either solo or consolidated If it is at solo level then exposures originating in a particular legal entity are selected If it is at consolidated level then exposures originating in the selected legal entity as well as its child entities excluding intra group exposure depending on GL structure are selected Note In a map level reconciliation adequate filters for the PP data should be selected to ensure that actual data sele
68. cted on both sides are the same The adjustment entry allocation depends on the reconciliation type selected In map level reconciliation once a definition is executed the differences that emerge as a part of the reconciliation General Ledger Product Processor level reconciliation is reported in the adjustment entry table This table shows all the entries of an executed map which requires adjustment In map level reconciliation the difference in amount can either be posted to Product Processors or an external table In map level reconciliation the adjustment allocation can either be automatic or manual Common Icons Oracle Financial Services Software Confidential Restricted 8 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 The common icons which you come across in the GL reconciliation UIs are as follows Pagination Options Helps in navigating from one page to another Helps to view details of GL reconciliation parameters Allows you to update details of GL reconciliation parameters ade B Helps in defining new GL reconciliation parameters Delete Click this icon to delete the GL reconciliation parameters Search The search feature allows you to search for the entry you are looking for instead of manually searching for data Reset 5 The Reset icon refreshes the field name back to the default blank field Run Default Click this icon to define the Run level pa
69. d GL Name The name of the specific GL entity code of the selected Map Name is displayed Legal Entity The Legal Entity as defined for this particular map and version number is displayed here Currency Displays the currency in which the actual reconciliation difference is displayed GAAP Code The GAAP code defined in the reconciliation is displayed here Oracle Financial Services Software Confidential Restricted 88 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Other optional dimensions Values against respective optional dimensions if any are reported here Source Balance The account balance at the source GL entity is displayed here Target Balance The account balance at the target GL entity for Ledger to Ledger reconciliation or Product Processor is displayed here Reconciliation Difference The net reconciliation difference amount is displayed here Threshold Breach Type The threshold breach type is displayed here as negative or positive breach This is based on the positive and negative reconciliation difference Threshold Value The value as per the breach type is displayed here Threshold Currency The Threshold currency is displayed if the Threshold value is in Absolute format Threshold Breached by The value or percentage by which the threshold value is breached based on the reconciliation difference is reported here We Threshold Breach Summary Glo
70. definitions from source to target environment This section mentions the steps that need to be followed by the user for migrating reconciliation definitions Rules between different GL Recon environments Assumptions and Prerequisites The GL Reconciliation application version is the same in both source and target environments Same configuration between source and target environments Master data for the dimensions is the same in both source and target environments If the data model is customized upload the customized model in the target environment before starting the environment migration exercise The dimension data is loaded into respective dimension tables The Dimension member codes should remain the same between source and target environments Run chart is executed to load stage and dimension data before migration is done Offline Object Migration utility of OFSAAT is present in both the environments under consideration Migration of Business Metadata objects of OFSAAI Dimensions Hierarchies Datasets and so on are not considered in this section Refer to documentation associated to OFSAAI on object migration for migrating OFSAAI objects Before migrating the GL Reconciliation definitions ensure that the configuration is complete in Global Settings and Global Parameter Maintenance screens of target environment Make sure OFSAAI services like Tomcat and FIC SERVER both are running Features GL Reconciliation Object Migration
71. definitions that have successfully moved and other errors Importing objects to target environment is done successfully Note Resave the hierarchy HGLO10 Map Definition after the definitions are migrated USE CASE An example of exporting and importing Object is mentioned below Suppose you want to move 5 definitions from source environment to target environment Map Id GL Def 1 10 oroen 10 3 GLDef2 9 1t GLDe3 8 2 In this case refer the OBJECTMIGRATION xml for Export Execute ObjectMigration sh and move rules dmp file to MIGRATION_HOME metadata restore Refer the OBJECTMIGRATION xml for Import Execute ObjectMigration sh and move rules dmp file to MIGRATION_HOME metadata restore See GLReconLogger log for the operation report If no errors are shown then all definitions are moved without any error Status of Definitions in target environment Oracle Financial Services Software Confidential Restricted 78 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 To understand this we take an example of the below two cases 1 Target environment is clean and has no definitions defined in it The below five definitions is placed in this environment Map Id GLDef3 a 1 GLDef2 2 i GLDefl 3 1 GLDeft 3 2 pei 3 3 2 Target environment had 20 groups of definitions with different map name One of the de
72. dential Restricted 69 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 s Adjusted Amount Displays the amount by which the reconciliation difference need to be adjusted Status If an Adjustment entry is submitted for approval then the relevant status messages are displayed here GL Code Displays the GL code for which this reconciliation is identified This is applicable for GL Level Reconciliation only Currency Displays the currency of the adjustment entry amount Legal Entity Displays the Legal Entity in which the reconciliation difference is found and subsequent adjustment entry is to be passed e Submission Comments The comments entered while submitting the entry for approval are displayed here Approver s comments The approver comments need to be entered here Default Value Specification Section The default value of each exposure ID can be nullified in the Default Value section Select an Exposure ID in the Adjustment Entry Specification section The existing default values are displayed You can override these values by updating the relevant default values in the Default Value Override section If multiple PPs and Exposure IDs are selected then this field is disabled Note In the Edit mode the Approver comments in the Adjustment Entry Specification Section is the only editable field After verifying all the details the adjustment entry click
73. dered for the GL code N The adjustment entry for the GL code is in FCT_GL_ADJUSTMENT_ENTRIES Y The adjustment entry for the GL code is taken to the target entity PP N GL Code where Auto Approval flag is N will not be used for reconciliation and no adjustment entry is passed against it Allocation reqd and auto approval will not be considered for the GL code 94 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Map N N N GL Code where Auto Approval flag is N will not be used for reconciliation N Accounts having such GL codes will participate in map level reconciliation The difference is taken to the FCT_RECONCILIATION_DIFFERENCE and threshold check is performed No impact on FCT_GL_ADJUSTMENT_ENTRIES Map N GL Code where Auto Approval flag is N will not be used for reconciliation Auto Approval in Run Management screen will not be considered Map N Accounts having such GL codes will participate in map level reconciliation The difference for the GL code is taken to the FCT_RECONCILIATION_DIFFERENCE and threshold check is performed No impact on FCT_GL_ADJUSTMENT_ENTRIES Auto Approval in Run Management page will not be considered Map N GL Code where Auto Approval flag is N will not be used for reconciliation The adjustment entry is in FCT_GL_ADJUSTMENT_ENTRIES with status as pending for approval It ll not be taken to the targ
74. displayed here Reconciliation Difference The net reconciliation difference is displayed here Reconciliation Difference Report Map Name TC25 Aggregated Map Version 1 i Reconciliation Difference Value Display Actual GL Name Currency Source Balance Target Balance Positive Reconciliation Difference Negative Reconciliation Difference Absolute Reconciliation Difference Net Reconciliation Difference LE2 S 11001 AUD 95 000 0 95 000 0 95 000 95 000 LE3 GL S 1002 AUD 22 000 0 22 000 0 22 000 22 000 LE2 GL S 1001 AUD 75 000 0 75 000 0 75 000 75 000 LE3 GL S 1001 AUD 64 000 0 64 000 0 64 000 64 000 LE2 S 10001 AUD 95 000 45 000 50 000 0 50 000 50 000 LE2 S 11002 AUD 85 500 53 000 57 500 25 000 82 500 32 500 LE3 S 10001 INR 50 000 25 400 50 000 25 400 75 400 24 600 Refresh Print Export Amount in Absolute Reconciliation Difference Detailed Report Map Name TC25 Aggregated Map Version 1 law GL Name LE2 S 11001 GL Name Legal Entity Currency GAAP Code Organization unit Product Customer Class Business Unit Geography Source Balance Target Balance Reconciliation Difference LE2 S 11001 Bank Australia Australian Dollar Australia GAAP AU Gold Cards Corporate Medium Corporate AU10 95 000 0 95 000 Return Refresh Print Export Create Bookmark Link Report Level Map Name This is the name of the reconciliation as defined in the Reconcil
75. e Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Adjusted Amount The adjustment amount identified after executing a defined reconciliation pending to be submitted is displayed here e Status If an Adjustment Entry is approved or rejected then the relevant status message is displayed here GL Code The code based on which the reconciliation was executed is defined here e Currency The currency in which the adjustment entry is to be passed is displayed here Legal Entity The Legal Entity is displayed based on which the reconciliation was defined is displayed here Correction Entry Specification Section In this section the Edit mode you can add a correction entry to offset the reconciliation difference or the adjustment entry posted Click the Add icon to define a new correction entry In this section the following fields are the only editable fields e Attribute Value The Default values as selected in the Allocation tab in the Reconciliation Management window is displayed here You can change the Attribute value accordingly Correction Exposure ID The exposure ID to which the correction entry is to be passed for a particular PP is updated here Correction GL Code The source GL code to PP mapping is displayed here Correction Amount The correction amount is to be updated here Submission Comments If you have any specific comments for the approver of this correct
76. e The name of the specific GL entity code of the selected Map name is displayed Currency Displays the currency in which the actual reconciliation difference is displayed Source Balance The account balance at the source GL entity level is displayed here Target Balance The account balance at the target GL entity level for Ledger to Ledger reconciliation or Product Processor is displayed here Positive Reconciliation Difference Any positive reconciliation difference based on the source entity balance is displayed here Negative Reconciliation Difference Any negative reconciliation difference based on the target entity balance is displayed here Note If percentage is selected in the Reconciliation Difference Value Display field then the positive reconciliation difference and negative reconciliation difference is compared and the relevant percentage value is populated For example If Actual Positive Reconciliation Difference is 5000 and Actual Negative Reconciliation Difference is 0 then the percentage is displayed as 100 for positive reconciliation difference Absolute Reconciliation Difference This is calculated as the total difference by Oracle Financial Services Software Confidential Restricted 84 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 ignoring the signs between the negative and positive reconciliation difference For example if Positive Reconciliation Differ
77. e Adjustment Entry window is displayed here e Submitted Adjustment Amount The adjustment amount submitted from the Adjustment Entry window however waiting to be approved by authorizer is displayed here e Rejected Adjustment Amount The adjustment amount rejected by the authorizer from the Adjustment Entry Approval window is displayed here Drill through Report Name Reconciliation Adjustment Detailed Report Description Navigation Path Click GL Name in the Reconciliation Adjustment Report to view the detailed report This detailed report is displayed for the particular Map Name and Version number selected in the Report Level Filters This tabular report provides a detailed view of the adjustment entries passed and the following parameters are reported GL Name The name of the specific GL entity code of the selected Map Name is displayed Legal Entity The Legal Entity as defined for this particular map and version number is displayed here Currency Displays the currency in which the actual reconciliation difference is displayed GAAP Code The GAAP code defined in the reconciliation is displayed here Other optional dimensions Values against respective optional dimensions if any are reported here Exposure Amount The Adjustment Entry amount is displayed here Authorization Status If the Adjustment Entry is approved pending to be submitted or submitted but pending to be approved then the relevant status is displayed here Product Proce
78. e Legal Entity Currency S S ah O e United States of Americ a oe GL_425 401 234000 0 Pending for Submission LE1 GL2PP C 1001 55 Bank USA US Dollar GAAP amp Default Value Specification Attribute amp Submission Comments Default Value Existing Default Value Override Close This window consists of the six sections Oracle Financial Services Software Confidential Restricted 66 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Adjustment Entry Details Section In this section the following are displayed Run Execution ID The execution ID of the Run which has identified a reconciliation difference is displayed here e Reconciliation Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the adjustment entry is to be passed is displayed here GL Date The date of execution of the Run is displayed here Version Number The number of times the adjustment entry details are modified is displayed here Product Processor Selection Section The PPs mapped to this particular Definition or Run is displayed in this field If you want to pass an adjustment entry to a particular PP then select that PP The exposure IDs mapped to that PP is displayed in the Adjustment Entry Specification section Multiple selections of PPs are allowed Search Section To search for a particular
79. e Threshold Specification field Oracle Financial Services Software Confidential Restricted 51 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Adjustment Entry Floor Specify the value required to pass an adjustment entry If the GL PP difference is less than Adjustment entry floor specified in the definition then the calculated difference is not eligible for adjustment and an entry will not be logged in Adjustment Entry table Positive Correction Threshold Specify the Positive Correction Threshold value These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL level reconciliation values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs Negative Correction Threshold Specify the Negative Correction Threshold value These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconcil
80. e execution ID of the Run which has identified a reconciliation difference is displayed here Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the correction entry is to be passed is displayed here Oracle Financial Services Software Confidential Restricted 68 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 s GL date The date of execution of the Run is displayed here 6 Reconciliation Amount The reconciliation difference for GL PP reconciliation is displayed here e Auto Adjustment if the adjustment is done manually then Y is displayed or else N is displayed Submission pending the total adjustment amount pending for submission is displayed Approval Pending Total Adjustment amount pending for approval is displayed e Approved indicates the total amount approved for that exposure id Rejected indicates the total amount rejected 6 Version Number The number of times the adjustment entry details are modified is displayed here Navigation within Details Page When you Edit or View an Adjustment Entry the Adjustment Entry Details page is displayed This page is divided into five sections Adjustment Entry Details Section In this section the following are displayed Run Execution ID The execution ID of the Run which has identified a reconciliation difference is displayed here e R
81. e menu bar of the General Ledger to Product Processor window The following window with four tabs is displayed Settings GL Parameters Product Processor PP Parameters Dimensions Allocation 3 Enter the name and description of the reconciliation to be defined Settings In the window update the following details Reconciliation Definition Select Manual Reconciliation in this field GL Book Enter the GL Book in this field Legal Entity Click the Hierarchy icon to select the Legal Entity from drop down list Check the check box Inherit to Child Consolidation Type Select the Consolidation Type from the drop down list as Solo or Consolidated Balance Type Select the reconciliation period from the drop down list GL Type Select the GL type from the drop down list Oracle Financial Services Software Confidential Restricted 46 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Note Selection of GL type is limited to the selection of the GL hierarchy Adjustment Allocation required Select Yes in this field if you want the application is to pass an automated adjustment entry in case any reconciliation difference is found or else select No If the value is No then reconciliation differences are calculated but adjustment entry will not be passed 6 Reconciliation Definition Select the level at which the balances need to be reconciled that is
82. e the updated data click the Save button Navigation within Run Execution Parameters Window Click the Run Execution Parameters icon on the navigation bar of the Run Management Summary window The Run Execution Parameter window allows you to enter and save the Run execution parameters Oracle Financial Services Software Confidential Restricted 61 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 se Run Details Reconciliation Difference Calculation Run Name Run Execution Parameters Reconciliation Definition scenario Type Actual Global Threshold 20 Execution on Threshold Breach Continue Auto Approval Yes No FIC MIS Date Run Execution Description The Run Execution Parameters window consists of two sections Run Details and Run Execution Parameters Run Details Section This section displays the name of the Run which 1s a read only value si Run Details Reconciliation Difference Calculation Run Name Run Execution Parameters Section The following Run execution parameters can be updated Reconciliation Definition The parameters defined in the Reconciliation Management section are displayed here Scenario Type Select the scenario type wherein the differences need to be found out for the Actual data or Reported Data Reported data indicates that the GL reconciliation differences need to be found out for the foreca
83. econciliation Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the adjustment entry is to be passed is displayed here GL date The Run Execution Date is displayed here Version number The number of times the adjustment entry details are modified is displayed here Product Processor Selection Section The PPs mapped to this particular Definition or Run is displayed in this field If you want to pass an adjustment entry to a particular PP then select that PP The exposure IDs mapped to that PP is displayed in the Adjustment Entry Specification window Multiple selections of PPs are allowed Search Section To search for a particular exposure ID there are two options provided o A Simple Search wherein you have the option to input the minimum and maximum adjusted amount All the Exposure IDs which falls in that range are displayed Advanced Search wherein you can search for Exposure IDs based on the dimensions mapped to the Exposure Select the Reconciliation Dimension Add icon to add more reconciliation dimensions in the Search section Adjustment Entry Specification Section The Adjustment Exposure IDs mapped to the selected PPs are displayed in this section The following fields are displayed in this section Adjustment Exposure ID The column mapped to a PP to which adjustment entry is passed is displayed here Oracle Financial Services Software Confi
84. ected Positive Correction Threshold The positive correction threshold value as defined in the Reconciliation Management window is displayed here Negative Correction Threshold The negative correction threshold value as defined in the Reconciliation Management window is displayed here A hh Threshold Definition GL Map Name LE1 Check_1 lial Map Version 1 ial Target Entity Target Balance Column Thresholdin Threshold Currency Positive Correction Threshold Negative Correction Threshold STG_CARDS_ _ n_eop_prin_bal Percentage _ NA 1 1 Refresh Print Export Dashboard Reconciliation Execution Audit Trail This dashboard provides evidence on the sequence of activities performed by a User ID on a particular execution date This audit trail is useful for the following reasons It provides a record on the history of a defined Reconciliation for the benefit of senior management It is useful for maintaining security of the system Errors can be easily detected After selecting the value from the page level prompts the following report is populated in a tabular format Recon Framework Analytics Home Catalog Favorites Dashboards v E New v Be Open v Signed In As weblogic N Home gt Threshold Breach Reconciliation Execution Audit Trial RG User ID GLUSER lx Information Type INFO lel Execution Date 02 11 2013 Apply Reset v s3 y Reconciliation Exec
85. ed The batch created can be executed by clicking the Execute button Note To execute a Run the execute run role should be mapped to your user profile Navigation within Run Execution Summary Page Select a Run from the Run Management Summary page and click the Run Execution Summary icon to display the Run Execution Summary page where the following sections are displayed Run Name Reconciliation Difference Calculation Run ID 1347852095160 Run Type BASELINE RUN amp Run Execution Details 1 to 10 of 503 Run Skey Y Run Execution Id FIC MIS DATE Execution Status Execution Date Time of Execution Reporting flag 43 1359146620431 12 31 2010 COMPLETE 01 25 2013 15 18 05 44 1359146673778 12 31 2010 FAILED 02 18 2013 16 49 38 45 1359147030593 12 31 2010 COMPLETE 01 25 2013 15 24 54 46 1359147162193 12 31 2010 COMPLETE 01 25 2013 15 27 05 47 1359147247582 2 31 2010 COMPLETE 01 25 2013 5 28 31 48 1359147472760 12 31 2010 COMPLETE 01 25 2013 5 32 16 49 1359150304622 12 31 2010 FAILED 01 25 2013 16 19 28 50 1359150385998 12 31 2010 FAILED 01 25 2013 6 20 49 51 1359150575911 12 31 2010 FAILED 01 25 2013 6 23 59 2 359151231296 2 31 2010 COMPLETE 01 25 2013 6 34 57 Approved This section consists of the two sections Run Execution Summary and Run Execution Details Run Execution Summary Section The Run Execution Summary displays the following details Run Name Displays the name of the Run Run Type Di
86. ed Metadata Manager To process further refer to the following steps Click Import Model Select Incremental Changes Sliced Model in Choose Type to Upload Select the file from the server It will list out the files present in the path Select your xml file and click upload to begin the process to upload the data model On successful upload a dialog box pops up Similarly follow the steps mentioned above to add a Stage General Ledger Master STG_GL_MASTER General ledger account dimension Example DIM_GL_ACCOUNT or Product processor Example STG_CARDS Oracle Financial Services Software Confidential Restricted 97 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Follow the steps given below to continue further these steps are not applicable for a Product Processor entity 10 Insert a new unique map_ref_num in two tables SYS_TBL_MASTER and SYS_STG_JOIN_MASTER for creating SCD for data movement from new Stage general ledger master to new General ledger account dimension Example SYS_TBL_MASTER Table contains table level information Stage to Dimension Table names should be changed according to new stage general ledger master STG_TBL_NM to new General ledger account dimension TBL_NM DIM_GL_ACCOUN STG_GL_MASTE 176 T R MASTER Example SYS_STG_JOIN_MASTER Column level mapping information from Stage to Dimension Column names and data types should be modified
87. ed in a summary grid The Adjustment Entry Page has two sections e Search Adjustment Entry Status Search Section Among other properties each Adjustment Entry possesses a Run Execution ID a GL Date and a Definition You may search on any of these properties in the Search section Search E Run Execution ID GL Date T Definition Name aiil Adjustment Entry Status Section The Adjustment Entry Status_section presents a grid containing all of the Adjustment Entries that meet your search criteria This grid also offers several icons that allow you to perform different functions when an Adjustment Entry is selected To select an Adjustment Entry click a check box in the first column of the grid e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed parameters of an Adjustment Entry on a read only basis Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify a few parameters of an existing adjustment entry The Edit icon is only enabled when a single Adjustment Entry has been selected Adjustment Entry Summary Grid The following columns categorize each Adjustment entry in the grid Oracle Financial Services Software Confidential Restricted 65 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Execution ID The execution ID of the Run
88. efinition of an attribute on a read only basis The View icon is only enabled when a single attribute has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify an existing attribute The Edit icon is only enabled when a single attribute has been selected Copy Selecting a single row out of the grid enables the Copy icon Clicking the Copy icon allows you to create a copy of an existing attribute The Copy icon is only enabled when a single attribute has been selected Check Dependencies Select an attribute and then click the Check Dependencies icon to generate a report on all dimension members that utilize your selected attribute For example if you have created an attribute named Color and have assigned values of Red White and Blue to dimension members 1 2 and 3 checking dependencies for the Color attribute will result in a report indicating that dimension members 1 2 and 3 utilize the Color attribute The Check Dependencies icon is only enabled when a single attribute has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the Attribute s you have selected OFSAAT will not allow you to delete Attributes which have any dependencies see Check Dependencies above Dimension Attributes Summary Grid The following columns categorize each attribute in the summary grid Code Dis
89. eirena e E E S 8 DATA REO CURR EIGEN T Sonano E 10 PRODUC IP ROCESSORS fe cteee nc cats SE ceca E E se taeeede meccees acuimepenaae ss svavaces onsen esdmaeete ee aaeee sae 13 SE TILING CP DATA aeii 15 GLOBAL SETTING 2 2 c0stes cary canaswaneaaenies daeaswcn Cec euiea ndaedawiancanen cundee nies eepotican da leanne deen gees Cations TO E T eee dentauee 15 Navigation within Global Settings WINGOW ccccssescccssseseccsesccnsssccsausecssueeeesausecesauseessaseesaunscssauseessasessaenseses 15 GE PARAMETER MAINTENANCE ourensana aeaa N EE E A A 20 Navigation within the Summary and Details PAGE scccccsseesecccenssccccsnnssecescauseecsssaunsecsssausecsssausecsssauseeessaees 21 PIVIRIIVGINVAINTE NANCE crror no EATE AE TE EA NOOT EE 22 AIDU E S anean a TE N 23 Membe ooren E eaeaeaaaeb ac ee aaa mebaneaatoe Lea eta 26 PHOTO CICS a att eoaesmaus nese ce teoasawadncd ico senaacaaunecaeh E undresses 29 DEFINING RECONCILIATION wscvciecevececec cccciec eascseuawdacceuscdwdacaccdwaccessiwecianccwieieucewawdedsasuddwisdstiteisistne 41 REDGER WO EDGER siya ca wideaa tose cnn ateunnnscearmamudorac N cus tamamcaebamedesaameanees 41 NAVIGATION WITHIN summary PAGO socio EE TTO en eg N O OEO 41 GENERAL LEDGER TO PRODUCT PROCESSOR Caia anina exit sane EE tats vi suite wei waa oa oan em tes aac EE E E ERE I 45 Navigation WITHIN Summary Page sikerse a LA Guande aT AS OR A 45 EXECUTING RECONCILIATION cite ik ha di a OA 59 SUMMARY AND DETAILS PAGES reiras tirer
90. ence is 19 500 and Negative Reconciliation Difference is 23 000 then the absolute difference is 42 500 Net Reconciliation Difference This is the net difference between the negative and positive reconciliation difference For example if Positive Reconciliation Difference is 19 500 and Negative Reconciliation Difference is 23 000 then the net difference is 3 500 Drill through Report Name Reconciliation Difference Detailed Report Description Navigation Path Click GL Name in the Reconciliation Difference Report to view the detailed report This detailed report is displayed for the particular Map Name and Version number selected in the Report Level Filters This tabular report provides a detailed view of the indentified reconciliation differences and the following parameters are reported GL Name The name of the specific GL entity code of the selected Map Name is displayed Legal Entity The Legal Entity as defined for the particular map and version number is displayed here GAAP Code The GAAP code defined in the reconciliation is displayed here Currency Displays the currency in which the actual reconciliation difference is displayed Other optional dimensions Values against respective optional dimensions if any are reported here Source Balance The account balance at the source GL entity level is displayed here Target Balance The account balance at the target GL entity level for Ledger to Ledger reconciliation or Product Processor is
91. eport to view the detailed report This detailed report is displayed for the particular Map Name and Version number selected in the Report Level filters This tabular report provides a detailed view of the correction entries passed and the following parameters are reported GL Name The name of the specific GL entity code of the selected Map Name is displayed here Legal Entity The Legal Entity as defined for this particular map and version number is displayed here Currency Displays the currency in which the actual reconciliation difference is displayed GAAP Code The GAAP code defined in the reconciliation is displayed here Other optional dimensions Values against respective optional dimensions if any are reported here Adjustment Amount The Adjustment Entry amount is displayed here Approved Correction Amount The correction amount authorized by the approver is displayed here Submitted Correction Amount The correction amount submitted from the Correction Entry window however waiting to be approved by the Authorizer is displayed here Rejected Correction Amount The correction amount rejected by the authorizer from the Correction Entry Approval window is displayed here Product Processor The PP to which the Correction Entry is passed is displayed here Product Processor Balance Column The specific column in the PP to which to Correction Entry is passed is displayed here Oracle Financial Services Software Confidential Restricted 8
92. eshold Positive Correction Threshold Stage Cards X Select v Total Outstanding Balance Month End v Select v Threshold Amount Currency amp Filter amp No Element Selected Hierarchy Member In the window click the Add icon to update the PP entity details as follows PP Entity Name Select the name from the drop down list GL Reconciliation Column Select the reconciliation column from the drop down list e GL Amount Column n this column select the Reconciliation period Threshold Specification Specify the Threshold from the drop down list The threshold value can be in both absolute terms and percentage terms at a PP level If the selection in all the PP s is percentage then the threshold amount currency field is disabled Oracle Financial Services Software Confidential Restricted 55 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Threshold Amount Currency Select the Threshold Amount currency from the drop down list Adjustment Entry Floor Specify the value required to pass an adjustment entry If the GL PP difference is less than Adjustment entry floor specified in the definition then the calculated difference is not eligible for adjustment and an entry will not be logged in Adjustment Entry table Positive Correction Threshold Specify the Positive Correction Threshold value These values are used to identify the breach types
93. et entity PP Map N Accounts having such GL codes will participate in map level reconciliation The adjustment entry for the GL code is in FCT_GL_ADJUSTMENT_ENTRIES with status as pending for approval It ll not be taken to the target entity PP Y Accounts having such GL codes will not participate in map level reconciliation The adjustment entry for rest of the reconciliation is taken to the target entity PP Oracle Financial Services Software Confidential Restricted 95 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Y Accounts having such GL codes will participate in map level reconciliation The adjustment entry for rest of the reconciliation is taken to the target entity PP Oracle Financial Services Software Confidential Restricted 96 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure C Data Model and Metadata Extensions Steps to Configure an Additional Table in the Application Refer to the following steps if you wish to add a Ledger entity Product Processor entity or Dimension table in OFS Analytical Application Reconciliation Framework For example Follow the steps given below to add a GL Entity for General Ledger to General Ledger reconciliation L 2 ee tlic i Open the OFSRecon_Datamodel erwin file in Erwin Data Modeler Change the view mode to Physical
94. etails on the additional dimensions selected Dimensions Settings Source Ledger Parameters Target Ledger Parameters Dimensions amp Mandatory Dimensions Reconciliation Dimension g9 In this window the Mandatory Dimensions are displayed Click the Dimensions icon to add the dimension to the map definition from the Reconciliation Dimension tab Click Save to save the changes made else click Cancel Note STG_MANAGEMENT_LEDGER table is included in the datamodel of OFSAA Reconciliation Framework This table can be used as a target ledger table STG_MANAGEMENT_LEDGER is a single table to store thick ledger of bank and it is configurable Oracle Financial Services Software Confidential Restricted 44 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 General Ledger to Product Processor GL to PP Reconciliation is to identify the difference between GL system and Transaction Processing system PP data It is also used to nullify the difference by posting adjustment entry up to the amount of difference and subsequently correcting the cause of difference by posting correction entry against approved adjustment entry GL to PP reconciliation is performed at the following levels GL Level Reconciliation Map Level Reconciliation GL to PP reconciliation can be defined in following way e Manual Reconciliation Definition Auto Definition Navigation within Summar
95. ew 8 Dashboards and Reports Annexure A Entity Details Annexure B Adjustment Auto Approval Concept Annexure C Data Model Extension Glossary Oracle Financial Services Software Confidential Restricted 1 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Related Information Sources Refer to the below documents in OTN Documentation Library Oracle Financial Services Data Management Pack Installation Manual Release 8 0 1 0 0 Oracle Financial Services Software Confidential Restricted 2 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Introduction Oracle Financial Services Analytical Applications OFSAA Reconciliation Framework Release 8 0 1 0 0 GL Reconciliation reconciles the balances from the operational systems of a bank with the balances as maintained in the General Ledger hereinafter referred to as GL of the bank With this application banks can also reconcile between General Ledgers maintained in the bank The balances in the GL of a bank are the ones which are audited and duly certified by the internal and external auditors The GL balances are considered to be the final version of truth in a bank Therefore all data extracted from any other operational systems of a bank need to be reconciled with the balances maintained in the GL to ensure that they are complete accurate and comprehensive It then acts as an aut
96. ework Release 8 0 1 0 0 Version Number The number of times the adjustment entry details are modified is displayed here Product Processor Selection Section The PPs mapped to this particular Definition or Run is displayed in this field If you want to pass an adjustment entry to a particular PP then select that PP The exposure IDs mapped to that PP is displayed in the Adjustment Entry Specification window Multiple selections of PPs are allowed Search Section To search for a particular exposure ID there are two options provided A simple search wherein you have the option to input the minimum and maximum adjusted amount All the Exposure IDs which falls in that range are displayed Advanced Search wherein you can search for Exposure IDs based on the dimensions mapped to the Exposure Select the Reconciliation Dimension Add icon to add more reconciliation dimensions in the Search section Adjustment Entry Specification Section The Adjustment Exposure IDs mapped to the selected Product Processors are displayed in this section The following fields are displayed in this section Adjustment Exposure ID The column mapped to a PP to which adjustment entry is passed is displayed here Adjusted Amount Displays the amount by which the reconciliation difference needs to be adjusted e Status If correction entry is submitted for approval or is already approved then the relevant status message is displayed here e
97. figures Execution ID All successful Run executions with the status as complete in the Run Execution Summary window is populated here Select the appropriate Run Execution ID from the drop down After updating the prompts click the Apply button To refresh the data in the fields click Reset The Reconciliation Execution Audit Trail Dashboard consists of the following page level prompts User ID GLADMIN Information Type tha O Execution Date 03 05 2013 li Apply Reset User ID Data is displayed on the basis of the User ID selected from drop down list Information Type Select the information type from the drop down list as Null Error or Info o Execution Date Select the date on which the Run was executed A few reports also have filters at each individual report level which are detailed in the section Report Descriptions Select the appropriate report filters so that data is displayed accordingly Each report within a dashboard contains the following features Refresh By clicking this button you can update the values displayed in the report Print By clicking this button you can print a particular report Export By clicking this button you can export data into multiple formats such as PDF Excel PowerPoint and so on Return To navigate back to the previous window click Return Create Bookmark Link To share or save a browsed page click Create Bookmark Link Sort icons also appear on e
98. finitions group in target environment has map Name GL Def 1 and Map Id 13 and has three definitions with 1 2 amp 3 version number and none of the definitions group has map Name GL Def 2 or GL Def 3 Then the below five definitions is placed in this environment Map Id GLDef 13 4 GL Def 1 GLDefl 3 6 GLDef2 2 1 GLD a a Oracle Financial Services Software Confidential Restricted 79 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Metadata Browser MDB All definitions that is GL GL Reconciliation as well as GL PP Reconciliation definitions is seen in Metadata in order to view the summary of all the definitions in Metadata Browser As a summary the definitions are listed in LHS hierarchy of Metadata Browser MDB under Metadata Browser gt Metadata Browser Object and Application gt Object Tab Process Metadata gt Rules gt Reconciliation Rules gt Ledger to Ledger General Ledger to Product Processor Click Object View OFSAA Infrastructure Windows Internet Explorer Financial Services Analytical Applications Infrastructure ORACLE EET L t l enn bed i N Et I ee Connected to GL1 da Home BET Unified Metadata Manager HEF Rules Framework af Metadata Browser Metadata Browser Object View Utilities Hf Forms Framework EHS Operations cimi System Configuration H Administration ll
99. for populating Target Entity results Oracle Financial Services Software Confidential Restricted 53 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Case 2 If Adjustment Allocation is Manual and Target table is Product Processor Then Default Values and Allocation Ratio are the only two columns to be updated If adjustment entry is to be passed to more than one PP entity then the ratio at which these the entry is to be passed is updated in the Allocation Ratio field Case 3 If Adjustment Allocation is Automatic and Target Table is Others If Other is selected as the Target table then the corresponding Target Entity Default Values have to be updated Case 4 If Adjustment Allocation is Manual and Target table is Others In this case the Target Entity Default Values and Allocation Ratio are to be updated NOTE In the Default values field a date value should be in mmddyyyy or mm dd yyyy format Allocation GL Level Reconciliation if GL Level Reconciliation is selected in the Settings window Settings GL Parameters Product Processor PP Parameters Dimensions Allocation Adjustment Allocation Automatic Manual Adjustment Posted to Product Processor Other 2 Target Entity Details Product Processors Reconciliation Amount Column Target Entity Default Values Allocation GL Column Allocation Amount Column Allocation Ratio age Cards Total Outstanding Balan
100. g Target Entity results Case 2 If Target table is Others Then Target Entity Default Values Allocation GL Column and Allocation Ratio are the only two columns to be updated If adjustment entry is to be passed to more than one PP entity then the ratio at which these the entry is to be passed is updated in the Allocation Ratio field Oracle Financial Services Software Confidential Restricted 58 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Executing Reconciliation After defining the parameters on both the GL side and Product Processor side defined reconciliation parameters need to be executed and thereby the differences between the GL data and PP data need to be computed The Run Management framework is used for this purpose The Run Management framework is a unique feature of the OFS Analytical Applications Reconciliation Framework which enables a business user without assistance from a technical analyst to easily define and execute a Run This framework allows you to define a Run by selecting a combination of different GL reconciliation parameters Summary and Details Pages Upon initially navigating to Run Management gt Run Management a summary page is displayed showing all the defined Runs By selecting a Run or by using search criteria you can control the set of Runs that are displayed This page displays the list of runs defined in the Run Rule RRF Framework excep
101. ght arrow keys to move from dimension member to dimension member Oracle Financial Services Software Confidential Restricted 40 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Defining Reconciliation Reconciliation management is the designated level at which account balances are reconciled It stores information that specifies the granular level at which account balances are reconciled across one or many Reconciliation can be defined in two ways GL to GL reconciliation In Ledger to Ledger GL to GL reconciliation the difference between two sources of GL for the same legal entity and consolidation type is identified Adjustment entry and correction entry is not passed in GL to GL reconciliation GL to Product Processor PP reconciliation In GL to PP Reconciliation the difference between GL system and Transaction Processing system PP data is identified GL to PP reconciliation definition can be Manual or Auto Ledger to Ledger In Ledger to Ledger GL to GL reconciliation the difference between two sources of GL for same legal entity and consolidation type is identified This difference is identified at the granularity of the GL code for the selected hierarchy mandatory dimensions and selected optional dimensions Adjustment entry and correction entry is not passed in Ledger to Ledger reconciliation Also the difference is identified by comparing the source ledger wit
102. h target ledger so as to ensure that all GL codes amount is covered to calculate the difference A legal entity in the bank can maintain the same GL data either solo or consolidated in one or more source systems If GL data is maintained in multiple source systems then it is essential to compare the GL balances among such GL sources to ensure that all GL sources reflect accurate and uniform balance Any difference between two GL source systems is expected to be rectified outside the framework Reconciliation definition is applied at Legal Entity Level either Solo or Consolidated Based on consolidation type selected GL source would be made available through GL Book for reconciliation Adjustment entry and correction entry is not passed in GL to GL reconciliation If reconciliation difference is greater than the threshold value then the difference is reported Threshold is specified at a target ledger level Threshold values can be specified in percentage or in absolute amount Percentage value represents the difference in percent to source ledger side amount If threshold is specified in amount then it should be read in connection with a currency of the threshold amount The reconciliation difference is reported in the base currency If currency specified here is different than that of reconciliation dimension then the difference amount should be converted in threshold currency using exchange rate of execution date or latest available rate of
103. hanical for any purpose without our prior written permission Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners Intel and Intel Xeon are trademarks or registered trademarks of Intel Corporation All SPARC trademarks are used under license and are trademarks or registered trademarks of SPARC International Inc AMD Opteron the AMD logo and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices UNIX is a registered trademark licensed through X Open Company Ltd 0611 Oracle Financial Services Software Confidential Restricted 110
104. he Summary Page When you first navigate to the Attributes summary page the Attributes associated with your first dimension are presented in a summary grid The Attributes summary page has two sections Search Adjustment Entry Status Search Section Among other properties each attribute possesses a Run Execution ID GL Date and a Definition Name You may search on any of these properties in the Search section amp Search E Run Execution ID GL Date Definition Mame le Adjustment Entry Status Section The Adjustment Entry Status section presents a grid containing all of the Adjustment Entries that meet your search criteria This grid offers several icons that allow you to perform different functions when an Adjustment Entry is selected To select an Adjustment Entry click a check box in the first column of the grid e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed parameters of an Adjustment Entry on a read only basis The View icon is only enabled when a single Adjustment Entry has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify a few parameters of an existing Adjustment Entry The Edit icon is only enabled when a single Adjustment Entry has been selected Adjustment Entry Status Grid The following columns are displayed in this grid Execution ID Th
105. he following features Computes the GL Reconciliation differences Posts adjustment entries when differences are encountered within the specified threshold and reports these adjustment entry details For more information about threshold refer to the Glossary Posts correction entries to reverse the adjustments wherever applicable Ability to select the GL reconciliation parameters such as The GL to be considered for the process The operational system data to be reconciled The threshold and adjustment Entry floor to be considered before passing adjustments For more information on threshold and adjustment entry floor refer to the Glossary e Ability to monitor and track the status of the GL reconciliation process through a series of reports Ability to track actions of all users through an audit trail feature A different allocation ratio can be fixed for passing the adjustment entry into the different Product Processors PP that participates in the mapping Product Processor is an entity in the OFSAAI System used to store data which is received from the operational system of the bank The GL Reconciliation application handles the consolidation concept as prescribed by Basel H guidelines It handles intercompany adjustments by ignoring the intra group transactions while summing up balances from the operational system Oracle Financial Services Software Confidential Restricted 3 User Guide Oracle Financial Se
106. hentic and reliable base for any further decision making Features of OFSAA Reconciliation Framework The Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 primarily compares the balances received from the operational systems with the balances as received from the bank s financial systems which are reflected in the GL and thus finds out differences between the two if any On the basis of such reconciliations adjustment entries are passed where it is needed to ensure that the data from the operational systems tally with the balances in the GL If there is scope for any corrections then these are allowed on the data received from operational systems The balances received from the bank s financial systems are deemed to be true and correction of these balances is strictly not permitted The Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 also has the capability to compare the balances between the General Ledgers maintained by the bank and computes differences if any Thus GL Reconciliation on one hand computes the difference if any between the operational system and the financial system of the bank while on the other hand brings the operational system at par with the financial system by passing adjustment entries or correction entries or both Broadly Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 has t
107. herefore the Download Specification of OFSDF can be generated and the User Defined Property UDP value of GL ReconR can be viewed to identify the fields relevant to the Reconciliation Framework Oracle Financial Services Software Confidential Restricted 104 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure G Map Level Recon Parent Node Selection To select Map Level Recon parent node follow the below steps 1 Ensure that the General Ledger Product Processor GL PP Definition has the following settings a Reconciliation Definition Type as Manual b Consolidation Type as Solo c Reconciliation Definition as Map Level Recon 2 Create an entry in the SetUpMaster as LAM for the corresponding MapId and VersionNumber 1 SELECT FROM setup master Hy 8 A g 4 a Sua V_COMPONENT_CODE V_COMPONENT_DESC V_COMPONENT_VALUE 3 The parent child hierarchy for the legal entity selected in the definition is considered for filtration Oracle Financial Services Software Confidential Restricted 105 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure H Adjustment Entry Template If a custom Adjustment Entry table is required then refer the Adjustment Entry Template structure as guidance before creating the table in the data model of OFS Reconciliation Framework Oracle Financial Services S
108. iation Filters Management window Map Version This is the version number of the defined reconciliation Version number indicates the number of times the reconciliation was edited at the reconciliation definition stage Reconciliation Difference Value Display If the Reconciliation Difference is to be displayed in Actual format select Actual or else select Percentage Report Description This tabular report is displayed if Adjustment Allocation is selected as Yes while defining reconciliation This report displays in a nutshell the adjustment amount passed The following parameters are displayed e GL Name The name of the specific GL entity code of the selected Map Name is displayed e Currency Displays the currency in which the Adjustment Entry is processed Oracle Financial Services Software Confidential Restricted 85 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Reconciliation Difference The net reconciliation difference is displayed here Significant Reconciliation Difference If a correction entry has been passed for a partial amount then the remaining difference is displayed here e Legal Entity The Legal Entity as defined for this particular map and version number is displayed here e Approved Adjustment Amount The adjustment amount authorized by the approver is displayed here e Pending Adjustment Amount The adjustment amount pending to be submitted from th
109. iation has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify an existing reconciliation The Edit icon is only enabled when a single reconciliation has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the reconciliations you have selected Definition List Grid The following columns are displayed in this grid Oracle Financial Services Software Confidential Restricted 45 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Name The name of the reconciliation is displayed here Version Number The number of times the reconciliation details are modified is displayed here Definition Type The definition type is displayed here GL Book The name of the GL Book is displayed here Legal Entity The legal entity of the defined reconciliation is displayed here Inheritance Inherit to child flag Created By The name of the user who created this reconciliation is displayed here Creation Date The date on which the reconciliation was created is displayed here Define a GL to PP Reconciliation Manual Definition To add a GL to PP reconciliation refer to the following steps 1 Select General Ledger to Product Processor under Reconciliation Management in the LHS of the page 2 Click Add icon in th
110. iation process and Audit Trail entries are posted with this information For GL Level Recon values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs Dimensions Name Description Settings amp Reconciliation Definition GL Parameters Product Processor PP Parameters Dimensions Allocation amp Mandatory Dimensions Legal Entity Currenc GAAP C ode amp Reconciliation Dimension r3 Legal Entity Currency and GAAP code are the mandatory dimensions These dimensions which are defined in the Global Settings window appear in the Dimensions window as well which indicate that comparison between GL system and PP system and any reconciliation difference is populated based on these Dimensions The Reconciliation Dimensions are optional dimensions which are also populated in this window as defined in the Global Settings window You can exclude these one or many reconciliation dimensions from participating in the reconciliation process by clicking W icon Click the Deselect or Select buttons to exclude or include optional reconciliation dimensions in the reconciliation process Oracle Financial Services Software Confidential Restricted 52 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 amp Search fal Hierarchy Hierarchical Available Dimensions Selected Dimensions hy
111. ices Analytical Applications Reconciliation Framework Release 8 0 1 0 0 s GL Table Name This field is auto populated when the GL source system table name is selected e GL Data Set This drop down list displays all the available datasets mapped to the selected GL table Select any one of the data sets from the drop down list e GL Code Column Select the GL code from the drop down list GL Book Name Select the GL book from this drop down list You can select multiple GL books GL Consolidation Type Select the consolidation type column from this drop down list Extraction Date Column Select the column name of the extraction date or FIC MIS date In the Recon Balance Type Mapping section select the corresponding column name against the reconciliation period Recon Balance Type Mapping enables you to map which column of the GL table will store the specified balances such as end of period balance year to date balance and so on The balance type is then selected in reconciliation definition and the data in the associated column is picked up for reconciliation purpose These fields are not computation fields in the global settings It is a setting related to GL tables It is used for the purpose of mapping and referred to in reconciliation definition for data reconciliation from General Ledger to Product Processor Additionally it is also used to read GL data Hence these available column settings are applicable to General Ledger
112. ined is displayed here Financial Year Setup This parameter value indicates the date that is to be considered while reconciliation closures are performed A reconciliation closure is performed for a specific period If the period is the same as mentioned in this parameter then differences reported in the Contra GL Accounts for all mappings available for the year end date should be zeroed down through corrections to allow for closure of accounts This parameter need not be specified year on year but just for date and month Created By This section displays the name of the user who created the Legal Entity definition Created Date This section displays the date the Legal Entity definition was created Modified By This section displays the name of the user who modified the original Legal Entity definition in the Edit mode Modified Date This section displays the date on which the Legal Entity details were modified Navigation within the Details Page When you click the Add View or Edit icon the following window is displayed wherein the Legal Entity and Financial Year Closure need to be updated Global Parameters amp Definition Leve Legal Entity Name amp Financial Year Setup Financial Year Closure MM DD v AMHM Maintenance The Analytical Application framework includes the functionality for adding viewing editing or deleting dimension attributes and members Hierarchies are currently
113. ing refer to Reveleus Parameter Master STG _GL_ MASTER The master list of all GL codes available in the bank needs to be uploaded in the entity STG_GL_MASTER Data from STG_GL MASTER is populated to DIM_GL_ACCOUNT Note The data loaded into STG tables for populating hierarchy data into DIM_GL_ACCOUNT mandates parent child relationship For a parent node its parent code value should be null Parent and child nodes in a hierarchy have to be mapped to single book code Note V_GL_TYPE a column in STG_GL_MASTER stores seeded data for GL Type such as Asset Revenue and so on The GL type provided by the bank may differ from the one provided in the standard application In this case modify the nodes under GL Type Hierarchy shown in the following figure to the values provided by the bank There are three ways in which you can receive and store this information in the entity STG_GL MASTER ASCII File The format and granularity in which this information is required to be available in the ASCII file is published in the Download Specification document Choose this option when you have large quantities of data If you choose to receive data by this option then you need to define the structure of the incoming file in OFSAAI through the following menu option Click Unified Metadata Manager then click Data Integrator Framework then click Warehouse Designer and then click Data Sources Upon completion of the flat file definition you
114. ion entry then update this field Note Correction GL code is enabled when GL Level Reconciliation is selected for a Consolidated Entity in the Reconciliation Management window Also a correction entry should always be passed in Product Processor irrespective of the target table for adjustment entry Correction entry alters the balance of the identified account within the Product Processor s or creates new account After verifying and updating the appropriate fields you can now click the Submit button The Correction Entry will now be allocated to the Correction Entry Authorization window Note The correction entry amount should not exceed the adjustment entry amount Also if any correction entry is pending to submitted or approved for a particular amount in the current financial year then correction entries cannot be passed for the next financial year Correction Entry Authorization All the correction entries which have been submitted through the Correction Entry window are displayed and the concerned authorizers can either approve or reject the correction entry Summary and Details Page Upon initially navigating to Review gt Correction Entry Authorization a window is displayed showing all of the Correction entries submitted through the Correction Entry window By selecting a dimension and by using search criteria you can icon the set of Correction Entries that are displayed When you Edit or View a details page is displayed Na
115. ion drop down list box is enabled You may select any dimension to serve as a Dimension Attribute Required Attribute Various OFSAA engines utilize attributes within their processing For example both OFS Funds Transfer Pricing and OFS Profitability Management utilize the Oracle Financial Services Software Confidential Restricted 25 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 account type attribute in order to understand whether a balance is a debit balance or a credit balance on balance sheet or off balance sheet You may not create user defined required attributes Default Value Use to set a default value for your attribute When you create a new dimension member each attribute that has a default value is set to its default value for your convenience Members Summary and Detail Pages Upon initially navigating to Setup gt AMHM Maintenance gt Members a summary screen is displayed showing all of the defined Dimension Members for one dimension your first dimension alphabetically By selecting a dimension and by using search criteria you can control the set of Dimension Members that are displayed When you Add Edit Copy or View a Dimension Member a detail screen is displayed Navigation within the Summary Page When you first navigate to the Dimension Members summary page the Dimension Members associated with your first dimension are presented in a summa
116. ion wherein reconciliation differences were identified based on which the correction entry is to be passed is displayed here GL date The Run Execution Date is displayed here Version Number The number of times the adjustment entry details are modified is displayed here Product Processor Selection Section The PPs mapped to this particular Definition is displayed in this field If multiple PPs are displayed and you want to pass an adjustment entry to a particular PP then select that PP The exposure IDs mapped to that PP is displayed in the Adjustment Entry Specification window Multiple selections of PPs are allowed Search Section To search for a particular exposure ID there are two options provided A Simple Search wherein you have the option to input the minimum and maximum adjusted amount All the Exposure IDs which falls in that range are displayed o Advanced Search wherein you can search for Exposure IDs based on the dimensions mapped to the Exposure Select the Reconciliation Dimension Add icon to add more reconciliation dimensions in the Search section Adjustment Entry Specification Section The Adjustment Exposure IDs mapped to the selected PPs are displayed in this section The following fields are displayed in this section Adjustment Exposure ID The column mapped to a PP to which Adjustment Entry is passed is displayed here Oracle Financial Services Software Confidential Restricted 72 User Guid
117. it Trail entries are posted with this information Threshold Breached Type The different types of threshold breaches are listed below e PAT Positive Absolute Threshold e NAT Negative Absolute Threshold e PPT Positive Percentage Threshold e NPT Negative Percentage Threshold e G Global e NB Not breached Oracle Financial Services Software Confidential Restricted 109 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 ORACLE Oracle Financial Services Analytical Applications Reconciliation Framework User Guide August 2015 Oracle Corporation World Headquarters 500 Oracle Parkway Redwood Shores CA 94065 U S A Worldwide Inquiries Phone 1 650 506 7000 Fax 1 650 506 7200 oracle com Copyright 2015 Oracle and or its affiliates All rights reserved This document is provided for information purposes only and the contents hereof are subject to change without notice This document is not warranted to be error free nor subject to any other warranties or conditions whether expressed orally or implied in law including implied warranties and conditions of merchantability or fitness for a particular purpose We specifically disclaim any liability with respect to this document and no contractual obligations are formed either directly or indirectly by this document This document may not be reproduced or transmitted in any form or by any means electronic or mec
118. licking the Edit icon allows you to modify details of an existing correction entry Oracle Financial Services Software Confidential Restricted 71 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Correction Entry Status Grid The following columns categorize each Attribute in the summary grid Execution ID The execution ID of the Run which has identified a reconciliation difference is displayed here Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the correction entry is to be passed is displayed here e GL date The date of execution of the Run is displayed here Adjustment Amount The adjustment amount passed initially when the reconciliation difference was found for GL to PP reconciliation is displayed here Correction Amount The correction amount to be passed is displayed here Version Number The number of times the correction entry details are modified is displayed here Navigation within Details Page When you Edit or View a Correction Entry the Correction Entry details page is displayed This window consists of the six sections Adjustment Entry Details Section In this window the following are displayed Run Execution ID The execution ID of the Run which has identified a reconciliation difference is displayed here e Reconciliation Definition Name The name of the reconciliat
119. me Hierarchy Member GL Parameters Product Processor PP Parameters Dimensions Allocation amp Product Processor PP Entity BS X ttotof1 GL Reconciliation Column GL Amount Column Threshold Specification Adjustment Entry Floor Negative Correction Threshold Positive Correction Threshold v Select v Select v Select v Threshold Amount Currency Select v amp No Element Selected In the window click the Add icon to update the PP entity details as follows PP Entity Name Select the name from the drop down list GL Reconciliation Column Select the reconciliation column from the drop down list GL Amount Column In this column select either Principal or Interest from the drop down list Threshold Specification Specify the Threshold from the drop down list The threshold value can be in both absolute terms and percentage terms at a PP level If the selection in all the PP s is percentage then the threshold amount currency field is disabled Threshold Amount Currency Select the Threshold Amount currency from the drop down list Adjustment Entry Floor Specify the value required to pass an adjustment entry If the GL PP difference is less than Adjustment entry floor specified in the definition then the calculated difference is not eligible for adjustment and an entry will not be logged in Adjustment Entry table Positive Correction Threshold Specify the Positive Correction Threshold value These values are
120. member to be stored at the root level of the hierarchy so the Add Sibling option is disabled Whenever you select the Add Child or Add Sibling or Add Leaf option the Add Member dialog is displayed Add Child For the Add Child option the Add Member dialog presents all dimension members that have not already been assigned elsewhere 1 e all members that are not found in the orphan branch The value or values you select is placed in the hierarchy one level beneath the node you originally selected In the following example Company A Company B and Company C have been selected to act as the children of the All Orgs root node Oracle Financial Services Software Confidential Restricted 35 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 1 hars C Add Member Windows Intennet pores o Hcmbes E Er TA a Bi TWE S When you click OK on the Add Member dialog the dialog box closes and the underlying the Hierarchy Display is updated to reflect your choices Show Hierarchy Show Results All Oras i COMPANY A COMPANY B i COMPANY C i rphan Branch Add Sibling For the Add Sibling option the Add Member dialog presents all dimension members that have not already been assigned elsewhere 1 e all members that are not found in the orphan branch The value or values you select is placed in the hierarchy at the same level as the node you originally selected
121. n menu containing the listing of all of the seeded dashboards that you can select for navigating to the desired location as shown in the following figure ORACLE Business Intelligence My Dashboard GL Recon Framework Recon Fromewy hy Analitics Sample Lite QuickStart OFS Analytical Applications Reconciliation Framework Analytics consists of the three dashboards Home Threshold Breach e Reconciliation Execution Audit Trail ORACLE Business Intelligence Home Threshold Breach Reconciliation Execution Audit Trial Each seeded dashboard contains a set of prompts at the top of the page which require selections in order for the reports to produce results Make the appropriate selections for each prompt to correctly filter the query for your results The Home and Threshold Breach dashboard consists of the following page level prompts Oracle Financial Services Software Confidential Restricted 82 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Extraction Date 12 31 2010 B Scenario Type Actual x Execution ID GLINFO_1359147472 Apply Reset Extraction Date Select the FIC MIS Date by clicking the Calendar icon Scenario Type Select the Scenario Type from the drop down as Reported or Actual Reported data indicates that the GL reconciliation differences are identified based on forecasted
122. n save a new Dimension Member definition and you may not change a code value once a Dimension Member definition has been saved When editing an existing Dimension Member code is a read only value When copying an existing Dimension Member you must supply a new code value Name Used to name or re name your Dimension Member You must supply a name or a new name if you wish to re name your Dimension Member before you can save a Dimension Member definition Description Used to store a description of your Dimension Member Enabled Not used in the current release Is Leaf Member may be declared to be either leaf members or rollup members When building a hierarchy in OFSAAI leaf members are those dimension members that have no descendent dimension members In building a dimension member set you must have at least some rollup members Is Leaf No before you can construct a multilevel hierarchy Copy Attribute Assignment From Instead of manually completing all the attribute value assignments for a new Dimension Member you may copy attribute assignments from a pre existing Dimension Member To do so click the ellipses adjacent to Copy Attribute Assignment From field to open the Member Browser window You may select a member directly or you may search for the member whose attributes you wish to copy Once you have selected a member and clicked OK the attribute values of the member you selected are copied into the defini
123. nancial Services Software Confidential Restricted 92 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure A Entity Details The following provides a brief description of the various tables GL Master This table stores a list of all available GL codes Select a subset of GL codes that Partly DL amp is to be considered for the GL Reconciliation Partly Setup subset of Product Processors for which GL Recon is required This table stores the table name of the table which stores the GL data along with the mapping of various columns within that table Stage GL Data This table stores the values pertaining to each of the GL code which is presentin DL Rees net Mager sR RST Consent PE GL Global Parameters This table stores the threshold specified for the differences at an Entity Consolidation and Financial Year End level GL Mapping Master Setup the GL Reconciliation GL PP Map This table stores the mapping between a GL and a PP and the associated Setup granularity of the GL that must be reconciled with a certain granularity in the PP The same GL can be mapped to multiple PPs and conversely a PP can be This table stores the information about mapping with respect to its reconciliation Setup treatment and any thresholds that need to be applied at a mapping level during mapped to multiple GLs The mapping stored in this entity drives all other processes for G
124. ncial Services Software Confidential Restricted 54 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 1 Select General Ledger to Product Processor under Reconciliation Management in the LHS of the window 2 Click Add icon in the menu bar of the General Ledger to Product Processor window The following window with three tabs is displayed Settings Product Processor PP Parameters Allocation 3 Enter the Name and Description of the reconciliation to be defined Settings Setiings Product Processor PP Parameters Afocatan In the window update the following details Legal Entity Click the Hierarchy icon to select the Legal Entity from drop down list Check the check box Inherit to Child Consolidation Type Select the Consolidation Type from the drop down list as Solo or Aggregate Balance Type Select the reconciliation period from the drop down list GL Type Select the GL type from the drop down list Adjustment Allocation required Select Yes in this field if the application is to pass an automated adjustment entry in case any reconciliation difference is found or else select No Product Parameters Settings Product Processor PP Parameters Allocation amp Product Processor PP Entity A 1 to 1 of 1 PP Entity Name GL Reconciliation Column GL Amount Column Threshold Specification Adjustment Entry Floor Negative Correction Thr
125. ness AU19 5 00 3 00 3 00 Bank UK Australia GAAP Australian Dollar gt LEBAM A 1000 C 1111 gt Product Hierarchy Total EU Retail Loans Group Risk EU11 1 00 17 00 18 00 US Household Commercial AU19 4 00 7 00 3 00 Refresh Print Export Oracle Financial Services Software Confidential Restricted 91 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Adding custom reconciliation dimensions in detailed reconciliation reports To add custom dimensions in reports follow the below steps 1 Open the RPD 2 Provide the Database connection details in Physical Layer 3 Keep the Physical Schema name similar to that of the Database Schema Username 4 Add the Dimension Table to the Physical Layer 5 Create required join s between the Dimension and Fact Table s 6 Drag the Physical Dimension Table into the Business Model and Mapping Layer 7 Create required join s between the Dimension and Fact Table s in Business Model and Mapping Layer 8 Ifrequired create hierarchies in Business Model and Mapping Layer 9 Drag the Logical Dimension table from Business Model and Mapping Layer into Presentation Layer 10 Deploy the RPD and restart services The newly added dimension is now ready to be used in the reports Finally the Physical Schema name in Physical Layer can be changed to any other required name Oracle Fi
126. nges reflected in database Oracle Financial Services Software Confidential Restricted 102 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure E Optimization of GL Reconciliation Processing Package Use of parallel hint is optional in the queries Follow the below mentioned steps to use the parallel hint in SELECT clause of the queries generated during execution Insert a record into SETUP_MASTER table and provide a parallel hint in V_COMPONENT_VALUE column Example Insert into setup_master V_COMPONENT_CODE V_COMPONENT_DESC V_COMPONENT_VALUE values GLRECON_SEL_ PARALLEL HINT To use Parallel hint in GL Recon Application parallel In case parallel hint is not required then the above step is not required The usage of parallel hint is optional for the GL Processing package Oracle Financial Services Software Confidential Restricted 103 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure F Generating Download Specifications Data Model for OFSAA Reconciliation Framework is available on customer request as an ERwin file Download Specifications can be extracted from this model Refer the whitepaper present in OTN for more details Oracle Financial Services Data Management Pack is supposed to be used along with other packs such as Oracle Financial Services Data Foundation OFSDF and so on T
127. not used in the OFS Analytical Applications Reconciliation Framework The type of functions you can access depends on your logon privileges and on the dimension with which you wish to work Dimensions are used to stratify your business data for processing or reporting purposes For example at a minimum general ledger systems are typically stratified as a general ledger dimension an organization or cost center dimension and a time dimension Dimensions are comprised of lists of members Some OFSAA dimensions support attributes Dimension attribute values are used to qualify dimension members For example a general ledger account say benefit expense might have an account type attribute with a value of non interest expense Like dimensions attributes are used to stratify your business data for processing or reporting purposes Some dimension attributes are seeded within the OFSAA data model and are used extensively in processing You may define as many user defined attributes as you need Dimension attribute data types may be either bounded or unbounded The date string and number type are unbounded that is there is no predetermined set of attribute values A date attribute value may be any valid date a string attribute value may be any string up to 30 characters in length and a number attribute value may be any number Oracle Financial Services Software Confidential Restricted 22 User Guide Oracle Financial Services Analytical Applicatio
128. ns Reconciliation Framework Release 8 0 1 0 0 Attributes Summary and Details Page Upon initially navigating to Setup gt AMHM Maintenance gt Attributes a summary page is displayed showing all of the defined attributes for one dimension your first dimension alphabetically that supports attributes By selecting a dimension and by using search criteria you can control the set of attributes that are displayed When you add edit copy or view an attribute a detail page is displayed Navigation within the Summary Page When you first navigate to the attributes summary Page the attributes associated with your first dimension are presented in a summary grid The attributes summary window has three sections Dimension e Search Dimension Attributes Dimension Section Attributes are properties of dimensions To add or maintain an attribute you must first select the dimension to which an attribute belongs In the case of Analytical Applications framework the dimension set is by default the General Ledger dimension Note As the only dimension available in this screen is General ledger no hierarchy is available for selection Search Section Among other properties each attribute possesses a code value a name and a data type You may search on any of these properties in the Search section Search Te Numeric Code Name Data Type Dimension Attributes Section The Dimension Attributes section presents
129. nsolidated treatment then an exposure of any legal entity participating in the above structure to any other legal entity participating in the same above structure is considered as intra group exposure If you select LE2 for consolidated treatment then exposure to LE 4 LE 5 and LE7 are considered as intra group exposures Note The application only aggregates data on the PP side for a consolidation reconciliation type such aggregation is only for the purpose of reconciling data and does not consider minority or majority holdings Intra group exposures are identified by the customer reference ID in the Product Processor For LE2 if the customer reference ID is LE4 LES and LE7 then these are considered as intra group exposures Exposures to LE3 or LE6 will not be considered as intra group exposures as they are not the child descendant of LE 2 If you select LE7 for consolidated treatment then no exposures are considered as intra group exposure since LE7 has no child legal entity Note Intra group exposures are identified by the customer reference ID While passing the correction entry if you want to pass the entry as intra group scenario then provide a value in the customer reference column under Default Values in the Correction Entry screen A null value in this column is considered as non intra scenario Aggregated When a parent legal entity is selected as Aggregated then all the exposures of that legal entity as well as exp
130. nt and would carry a leaf level designation of the product Navigation within the Detail Page When you Add Edit Copy or View a Dimension Member the Dimension Members Detail page is displayed Oracle Financial Services Software Confidential Restricted 27 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Members amp Dimension Dimension General Ledger Account v amp Member Details amp Member Attributes Alphanumeric Code a Attribute Value ECAA B Difference Auto Approve Flag General Ledger Account Name General Ledger Book Code General Ledger Name Description General Ledger Type Intra Group Enabled Yes _ No Parent General Ledger Account ls Leaf Yes No Copy Attribute Assignment From s Dimension Section Displays the name of the dimension to which a Dimension Member belongs which in this case is the general ledger account This is a read only value Dimension Dimension General Ledger Account Dimension Member Details Section Code When adding a new Dimension Member you must select a Code value to which you want your new Dimension Member to be assigned Code values for each Dimension Member belonging to a dimension must be unique but you are otherwise free to pick any numeric value You may also click the Generate Code shortcut key to automatically generate a new code value You must supply a code value before you ca
131. nter relationship is defined by specifying a join condition between the various tables is displayed here GL Code column The GL code column based on which GL level reconciliation happens is displayed here Navigation within General Ledger GL Source Settings When you click the Add Edit or View icon the following window is displayed amp General Ledger GL Source Settings GL Hierarchy GL Code Flex v GL Source System Name Business Unit Dimension ome GL Table GL Book Name MSG wm GL Data Set GL Flex Dataset Lass Consolidation Type Column d_record_end_date Record End Date mn GL Code Column d_record_end_date Record End Date se Extraction Date Column d_record_end_date Record End Date ma amp Recon Balance Type Mapping Balance Type Column Name End of Period d_record_start_date Record Start Date v Monthly Average f_latest_record_indicator Latest Record Indi v Yearly Average Select y Month to date Select v Quarter to date Select v Year to date Select v The following columns needs to be updated in this section GL Hierarchy Select the GL Hierarchy name from the drop down list The values of the hierarchy are selected from the REVELEUS_PARAMETER_MASTER table Presently it refers to DIM_GL_ACCOUNT GL Source Name Select the source system table name from this drop down list For example Stage GL Data Oracle Financial Services Software Confidential Restricted 17 User Guide Oracle Financial Serv
132. o PP solo reconciliation is not the same Delete the row with V PARAM CODE AUTO MAP GENERATOR from the REVELEUS_PARAMETER_ MASTER table Then manually create a mapping between the consolidation and solo codes of the GL entity and PP entity in STG_GLCODE_MAP Case 2 If GL codes for GL to PP solo reconciliation are the same and the same hierarchy HGLOO9 shipped with application is being used Create a mapping between the GL entity consolidation codes and PP entity solo codes in STG_GLCODE_MAP Since the application automatically generates a mapping for solo codes you are not required to manually create a mapping between the GL entity and PP entity solo codes Case 3 If GL codes for GL to PP Solo reconciliation are the same however the same hierarchy HGLOO9 that is shipped with application is not being used Create a mapping between GL entity consolidation codes and PP entity solo codes in STG_GLCODE_MAP In the table REVELEUS_PARAMETER MASTER _ against V_PARAM_CODE AUTO_MAP_GENERATOR 1 update the appropriate hierarchy code in V_PARAM_VALUE Since the application automatically generates a mapping for solo codes you are not required to manually create a mapping between the GL entity and PP entity solo codes Case 4 If more than one source system is available and GL Codes for GL to PP solo reconciliation are the same Create a mapping between the GL entity consolidation codes and PP entity solo codes in STG_GLCODE_MAP Add
133. obal Global Parameters Section The Global Parameters section presents a grid containing all of the legal entities that meet your search criteria It also offers several icons that allow you to perform different functions when a legal entity is selected To select a legal entity click a check box in the first column of the grid Add By clicking the Add icon a legal entity to be defined against a specific financial year can be selected The Add icon is disabled if any rows in the grid have been selected e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the definition of a legal entity on a read only basis The View icon is only enabled when a single attribute has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify an existing Legal Entity The Edit icon is only enabled when a single Legal Entity has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the legal entities you have selected Oracle Financial Services Software Confidential Restricted 21 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Global Parameters Grid The following columns are displayed in this section Legal entity name The legal entity name for which the Financial Year Setup is def
134. oftware Confidential Restricted 106 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure I GL Nodes Configuration In case the GL nodes exceed 2024 then use the below configuration to support the hierarchy browser of GL L Change lt PARAMETER NAME PC_NONBI_BI_SWITCH VALUE lt PARAM gt gt in SFIC_HOME conf DynamicServices xm1 and in deployed location lt CONTEXT_PATH gt CONTEXT_NAME conf DynamicServices xml lt PARAM gt Parameter value to be chosen based on no total number of nodes in a hierarchy OOB 2048 For example if hierarchy nodes is 9000 then VALUE should be 9500 After taking backup of these tables delete the data from rev_bihier rev_locale_hier for the respective hierarchy code Restart the web and app servers by clearing work cache tmp folder Resave the respective hierarchy and verify whether the data is populated into rev_bihier table with version 0 Clear browser cache and create the definition from the start Oracle Financial Services Software Confidential Restricted 107 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Glossary Adjustment Entry An entry passed in the Product Processor PP to reconcile it with the associated GL for the amount equivalent to the difference and an entry in the Contra GL Account with the opposite sign for the same amount is an adjustment entry
135. on For more information on adding operational data tables to the data model refer Annexure C Data Model and Metadata Extensions on page 97 The list of Product Processor supported by this application is as follows Oracle Financial Services Software Confidential Restricted 13 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 es Oracle Financial Services Software Confidential Restricted 14 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Setting up Data The Setup page pertains to setting and maintenance of data This is a onetime activity and defines the boundaries of GL reconciliation The Setup page consists of the following Global Setting Global Parameter Maintenance AMHM Maintenance Global Setting In the Global Setting window you can select the following Tables among PP entities which should be included in the GL Reconciliation process Tables among the GL data to be included in the GL Reconciliation process As part of a standard release STG_GL_Data is used to hold GL data Other tables having dataset with GL dimension can participate as GL The mandatory dimensions optional dimensions and nodes participating in the GL Reconciliation process Navigation within Global Settings Window Upon initially navigating to Setup gt Global Settings a summary page is displayed showing all of
136. on Offline Object Migration is a two step process 1 Export of Objects from source environment and 2 Import of Objects in target environment For both of these steps refer sample file OBJECTMIGRATION xml which is also present at MIGRATION_HOME conf in the OFSAAI setup Exporting Objects from source environment Follow the below procedure to export object from source environment 1 Replace placeholders of UserId Infodom with source Userld amp Infodom 2 For Folder put segment name for the infodom provided above Mention locale as en_US 3 FILE_NAME Specify the file name which is created under metadata archive folder For example mention rules in place of FILE_NAME and you get rules dmp in archive folder Fail On error Fail on any error occurred while restoring metadata Mention Y for Yes and N for No OVERWRITE If Metadata exist in the system then Overwrite while restoring metadata Mention Y for Yes and N for No In Mode tag mention EXPORT For FAILONERROR and OVERWRITE it s recommended to mention Y 4 In OBJECT tag mention ALL for Code property to export all definitions Else for each definitions put equal number of OBJECT tag with map ID and version number in comma separated format Type Use 3100 for GL Reconciliation definitions 5 The format for All OBJECTS tag is lt OBJECTS TargetFolder GLRECONSEG gt lt OBJECT Code ALL Type 3100 gt lt OBJECTS
137. on a second time to shrink the hierarchy display down to 1 the root node of the hierarchy plus 2 the Orphans branch The Orphan branch is only displayed when a hierarchy s Orphan Branch property is set to Yes Oracle Financial Services Software Confidential Restricted 32 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 For very large hierarchies the Expand All Collapse All icon is disabled You may define what constitutes a very large hierarchy For more information see Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Expand Branch When you click a node member and then click Expand Branch your selected rollup node is expanded to its maximum depth Collapse Branch Select a dimension member and then click the Collapse Branch icon to shrink the display of any members beneath the dimension member you have chosen Focus and Unfocus When you click a node member and then click the Focus icon only your selected node and its descendents are displayed Clicking Unfocus removes the focus that you established using the Focus icon described earlier Show Code Values Left and Right Click Show Code Values Left to show code values to the left of each dimension member name Click Show Code Values Right to show code values to the right of each dimension member name The default behavior for your hierarchy is
138. on is only enabled when a single Correction Entry has been selected Correction Entry Status Grid The following columns are displayed in this grid Execution ID The execution ID of the Run which has identified a reconciliation difference is displayed here The Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the adjustment entry is to be passed is displayed here Version Number The number of times the adjustment entry details are modified is displayed here The GL Date The date of execution of the Run is displayed here The Adjustment Amount The adjustment amount passed to rectify the reconciliation difference for an execution ID is displayed here Navigation within Details Page When you Edit or View the details page is displayed This page consists of five sections Adjustment Entry Details Section In this section the following are displayed Run Execution ID The execution ID of the Run which has identified a reconciliation difference is displayed here e Reconciliation Definition Name The name of the reconciliation wherein reconciliation differences were identified based on which the correction entry is to be passed is displayed here o GL date The date of execution of the Run is displayed here Oracle Financial Services Software Confidential Restricted 74 User Guide Oracle Financial Services Analytical Applications Reconciliation Fram
139. one more row in the table REVELEUS_PARAMETER_ MASTER For example refer to the following table V_PARAM_DESC Auto Generation of Mapping Codes Where Solo GL Codes are Same in Ledger to Product Processor Auto Generation of Mapping Codes Where Solo GL Codes are Same in Ledger to Product Processor Update V_PARAM_ CODE value as AUTO_MAP_ GENERATOR lt lt number gt gt In V_PARAM_VALUE provide the new hierarchy code which is created on the GL code of the new source system STG FORWARD _EXCHG RATES Oracle Financial Services Software Confidential Restricted 12 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Cross currency exchange rates are not supported by the application therefore direct quotes need to be uploaded in STG_FORWARD_EXCHG_RATES table The sources of such exchange rates are also recorded in this table which is directly linked to a legal entity in the table DIM_ORG_ STRUCTURE Product Processors GL Reconciliation application also requires you to specify the physical column names of certain columns in the various Product Processor PP entities for which the reconciliation process needs to be executed These column names can be specified in the Global Settings screen Note You also have the option to reconcile GL codes with other operational data being used by the bank which does not flow into the standard Product Processors configured in the applicati
140. ons that allow you to perform different functions when a defined reconciliation is selected To select a defined reconciliation click a check box in the first column of the grid Add Clicking the Add icon begins the process of building a new Ledger to Ledger reconciliation The Add icon is disabled if any row in the grid has been selected View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed definition of reconciliation on a read only basis The View icon is only enabled when a single reconciliation has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify an existing reconciliation The Edit icon is only enabled when a single reconciliation has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the reconciliations you have selected Definition List Grid The following columns are displayed in this grid Name The name of the reconciliation is displayed here Version Number The number of times the reconciliation details are modified is displayed here GL Book The name of the GL Book is displayed here Legal Entity The legal entity of the defined reconciliation is displayed here Inheritance Inherit to child flag Created By The name of the user who created this reconciliation is displayed here
141. ontinue at the time of execution Global Threshold is compared with cumulative percentage difference across all reconciliation definition getting executed in a Run Execution on Threshold Breach Depending upon your selection in the Run Execution Parameters window Continue or Stop is displayed here Auto Approval The value as selected in the Run Execution Parameter window that is Yes or No is displayed here Global Threshold If the Global Threshold Level is breached or not breached then the relevant information is displayed here In a tabular form the following parameters are reported e Map Name This is the name of the reconciliation as defined in the Reconciliation Management window Map Version Number This is the version number of the defined reconciliation Version number indicates the number of times the reconciliation was edited at the reconciliation definition stage Number of Observations The number of times the same map and version is executed is displayed here Number of Breaches The number of breaches reported based on the threshold value specified in the Reconciliation Management window is displayed here Drill through Report Name Threshold Breach Detailed Report Description Navigation Path Click Map Name in the Threshold Breach Summary to view the detailed report Map Level Filters Map Name Map Version This tabular report provides a detailed view of the threshold value breaches and the following parameters are reporte
142. osure of each level s of descendant child legal entities are selected In this case intra group accounts are also selected for processing from both GL and PP side Note The data loaded into STG tables for populating hierarchy data into DIM_ORG_STRUCTURE mandates parent child relationship For a parent node its parent code value should be null Inherit to Child This feature is used to find child legal entities under the hierarchy node of Legal Entity that is selected at the definition level If this feature is used while defining the GL Reconciliation rule then all child nodes will participate in the reconciliation process Manual Reconciliation Definition In manual reconciliation definition user input is sought on the GL side and PP side to determine the course of Oracle Financial Services Software Confidential Restricted 7 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 reconciliation This is applicable for both GL level and map level reconciliation In GL level reconciliation unique GL codes are identified from the selected GL book and GL code mapping In map level GL codes do not form a part of the reconciliation Manual reconciliation definition can be used for a solo or consolidated legal entity Reconciliation for a consolidated GL having an intra group GL structure is computed from GL data and not from PP data Therefore any account present in the PP but unavailable in G
143. ou to input your comments Click Submit and the status of this Run is displayed in the Reporting Flag section Only a successful execution can be requested for reporting For the selected Run and Execution date there can be only one reporting flag Override the Reporting Run Any reporting execution can be overwritten with another execution Select a successfully triggered batch in the Run Execution Summary page The Override the Reporting Run icon is enabled if an execution is already marked as a Reporting Run You can override the execution by updating your comments This should be approved by the approver and the procedure is similar to the procedure detailed in the section for Approval of Reporting Run Approval for Reporting Run After submitting the Reporting Run in the earlier section the Approval for Reporting Run icon is enabled On clicking the icon a dialog box with the User Comments and Approver Comments is displayed The Approver can update the comments in the Approver Comments field and then click the Approve or Reject buttons accordingly Run Execution Grid The Run Execution Details displays the following details Run Skey Displays the Run skey of an individual execution Run Execution Id Displays the execution ID of the Run e FIC MIS DATE Enter the extraction date in this field Execution Status Displays the status of the execution which is failed or complete Execution Date Displays the date when the Run was
144. plays the attribute s code value Name Displays the attribute s short name Performing a mouse over on an attribute Name displays the attribute s description Data Type Displays the attribute s data type string number date or dimension Required Attributes are either Required Yes or Optional No When creating a new dimension member you must provide an attribute value for any attribute that is Required Only certain seeded attributes are Required You may not create Required user defined attributes Seeded Displays whether or not an attribute 1s seeded You may not edit or delete seeded attributes Navigation within the Detail Page When you Add Edit Copy or View an attribute the Attributes Detail Page is displayed amp Dimens Dimension R Attribut Name Description Attributes 10n General Ledger Account v e Details amp Attribute Properties Numeric Code a Data Type Date v Dimension Required Attribute Yes No Default value m Oracle Financial Services Software Confidential Restricted 24 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Dimension Section Displays the name of the dimension to which an attribute belongs to which in this case is the general ledger account This is a read only value When adding a new attribute you must select the dimension to which you want your new attribute
145. pteron the AMD logo and the AMD Opteron logo are trademarks or registered trademarks of Advanced Micro Devices UNIX is a registered trademark of The Open Group This software and related documentation are provided under a license agreement containing restrictions on use and disclosure and are protected by intellectual property laws Except as expressly permitted in your license agreement or allowed by law you may not use copy reproduce translate broadcast modify license transmit distribute exhibit perform publish or display any part in any form or by any means Reverse engineering disassembly or decompilation of this software unless required by law for interoperability is prohibited The information contained herein is subject to change without notice and is not warranted to be error free If you find any errors please report them to us in writing If this is software or related documentation that is delivered to the U S Government or anyone licensing it on behalf of the U S Government the following notice is applicable U S GOVERNMENT END USERS Oracle programs including any operating system integrated software any programs installed on the hardware and or documentation delivered to U S Government end users are commercial computer software pursuant to the applicable Federal Acquisition Regulation and agency specific supplemental regulations As such use duplication disclosure modification and adaptation of the program
146. r user role lies with the System Administrator Key Terms and Concepts Consolidation Type There are three consolidation types supported by the application Solo Consolidated Aggregated Solo When legal entity is selected with consolidation type as Solo then all the exposures of that particular legal entity is selected for processing Both Manual and Auto reconciliation definition can process solo legal entity data Consolidated When a parent legal entity is selected as Consolidated then all the exposures of that legal entity as well as exposure of each level s of descendant child legal entities without intra group exposures are selected for processing In intra group exposures the counterparty is a child descendant of any level For an intra group scenario where GL structure has specific intra group GL code in addition to regular GL codes intra GL codes are considered only from the GL side for processing Non Intra is a scenario where no GL codes are present for reconciliation Oracle Financial Services Software Confidential Restricted 6 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 In this case LE 1 is the parent legal entity and LE2 and LE3 are the immediate child legal entities of LE1 Similarly LE4 and LES are immediate child legal entities of LE2 but second level descendant legal entities of LEI If you select LE1 parent for co
147. r to Product Processor Reconciliation Manual Reconciliation Definition Auto Definition Ledger to Ledger Reconciliation GL Level Reconciliation GL Level Reconciliation Once reconciliations are defined executions are performed from the Run Management screen When reconciliation differences arise then adjustment entries are passed either manually or by the application Correction entries are also passed once these reconciliation differences are investigated upon Oracle Financial Services Software Confidential Restricted 5 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Run Management Executions GL PP Difference reported GL PP No differences reported GL GL Difference reported GL GL No differences reported Difference postedto Difference postedto i FCT_RECON DIFFERENCE table Soe FCT_RECON DIFFERENCE table PE Differences pre to Adjustment Post toGL Audit Trail Adjustment Entry Approved Posted to Product Processor simultaneously update contra column Correction Entry Correction Entry Approved Posted to Product Processor simultaneously update contra column Note It is imperative to map each function to a specific user role to be able to work with the OFSAA Reconciliation Framework application The responsibility to map the various function codes of the OFSAA Reconciliation Framework application such as Add View and Delete access to a particula
148. rameters Parameters Run Execution Click this icon to define the Run execution parameters Parameters Run Execution Click this icon for the Run Execution Summary screen Summary to be displayed Click this icon to copy the parameters defined at Run Reconciliation Click this icon to add a reconciliation dimension in the Dimension Add Data Entry or Review screens Check Dependency Generates reports which lists dependencies of hierarchies and attributes to other dimension members Select Dimension Click this icon to add Optional Dimensions to your Reconciliation reconciliation Management Screen Select Dimensions Click this icon to map the GL Source Entity to the Setup Screen Dimensions Oracle Financial Services Software Confidential Restricted 9 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Data Requirements After the OFSAAIT platform has been deployed the OFSAA Reconciliation Framework has to be deployed For more information on installing the OFSAA Reconciliation Framework refer to the OF SAA Reconciliation Framework Release 8 0 1 0 0 Installation Manual You now have the choice to perform model upload through the installer or manually Refer to the following steps to perform model upload manually 1 Click Unified Metadata Manager on the left pane of the OFSAAIT platform 2 Click Import Model to open up the Business Model Upload window 3
149. reach type NPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code USGAAP GLINFO_ 1360611628094 _20101231_1 265 1 INFO Map Level Threshold has been breached for Execution ID GLINFO_1360611628094_20101231_1 Map ID 265 Version No 1 GL CODE LE1 MAP S 1001 Threshold Breached By 98 Breach type NPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code AUGAAP 1 Map Level Threshold has been breached for Execution ID GLINFO_1360611628094_20101231_1 Map ID 265 Version No 1 GL CODE LE1 MAP S 1002 Threshold Breached By 7 714 Breach type PPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code USGAAP GLINFO_1360611722783_20101231_1 265 1 INFO Map Level Threshold has been breached for Execution ID GLINFO_1360611722783_20101231_1 Map ID 265 Version No 1 GL CODE LE1 MAP 5 1001 Threshold Breached By 98 Breach type NPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code USGAAP 1 Map Level Threshold has been breached for Execution ID GLINFO_1360611722783_20101231_1 Map ID 265 Version No 1 GL CODE LE1 MAP S 1002 7 _ Threshold Breached By 7 714 Breach type PPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code USGAAP Oracle Financial Services Software Confidential Restricted 90 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Dashboard Drill Down Extraction Date Select the FIC MIS Date by clicking the Calendar
150. rvices Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Note The Oracle Financial Services Analytical Application Reconciliation Framework Release 8 0 1 0 0 is designed only to compare the balances in the operational system with the balances in the financial system of the bank It does not aim at finding out the cause and source of the difference Oracle Financial Services Software Confidential Restricted 4 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Process Flow Overview The GL structure is designed in such a way that it facilitates verification of the differences which arise by comparing the GL source systems with the bank s operational systems Product Processor At a global level you need to input GL and Product Processor setting details which form a base at a reconciliation level The input provided in the Global Settings window is reflected at a global level Global Settings GL Source Settings Product Processor Settings Then reconciliations are defined which forms a part of execution and data verification These can be broadly defined as two types of reconciliations Manual Reconciliation Definition and Auto Definition These reconciliations are defined in the Reconciliation Management screen For more information on Manual Reconciliation Definition and Auto Definition refer Key Terms and Concepts Reconciliation Definition General Ledge
151. ry grid The Dimension Members summary page has three sections Dimension e Search Dimension Members Dimension Section To add or maintain a member you must first select the dimension to which an attribute belongs In the case of Analytical Applications framework the dimension set is by default the General Ledger dimension Dimension Dimension General Ledger Account Note As the only dimension available in this screen is General ledger no hierarchy is available for selection Search Section Each Dimension Member possesses a code value a name and a description Dimension Members also have the properties of being enabled or disabled and of being a leaf member last descendent child value or a rollup member representing a rollup point in a hierarchy Finally each Dimension Member value is assigned an attribute value for each its attributes You may search on any of these properties in the Search section Search fe Alphanumeric Code Numeric Code Name Description Enabled T Yes E No Is Leaf 3 Yes E No Attribute Name Attribute Walue Oracle Financial Services Software Confidential Restricted 26 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Dimension Members Section Dimensions are comprised of finite lists of Dimension Members The Dimension Members section presents a grid containing all of the Dimension Members that meet
152. s including any operating system integrated software any programs installed on the hardware and or documentation shall be subject to license terms and license restrictions applicable to the programs No other rights are granted to the U S Government This software or hardware is developed for general use in a variety of information management applications It is not developed or intended for use in any inherently dangerous applications including applications that may create a risk of personal injury If you use this software or hardware in dangerous applications then you shall be responsible to take all appropriate fail safe backup redundancy and other measures to ensure its safe use Oracle Corporation and its affiliates disclaim any liability for any damages caused by use of this software or hardware in dangerous applications This software or hardware and documentation may provide access to or information on content products and services from third parties Oracle Corporation and its affiliates are not responsible for and expressly disclaim all warranties of any kind with respect to third party content products and services Oracle Corporation and its affiliates will not be responsible for any loss costs or damages incurred due to your access to or use of third party content products or services Oracle Financial Software Services Confidential Restricted V User Guide Oracle Financial Services Analytical Applications Reconcili
153. sents a grid containing all of the Hierarchies that meet your search criteria The Hierarchies summary grid offers several icons that allow you to perform different functions when a Hierarchy is selected To select a Hierarchy click a check box in the first column of the grid More than one Hierarchy can be selected at a time but this will cause some of the icons to become disabled Clicking a check box a second time deselects a Hierarchy You may select or deselect all of the Hierarchies in the summary grid by clicking the check box in the upper left hand corner of the summary grid directly to the left of the Name column header Add Clicking the Add icon begins the process of building a new Hierarchy The Add icon is disabled if any row in the grid has been selected View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed definition of a Hierarchy on a read only basis The View icon is only enabled when a single Hierarchy has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify an existing Hierarchy The Edit icon is only enabled when a single Hierarchy has been selected e Copy Selecting a single row out of the grid enables the Copy icon Clicking the Copy icon allows you to create a copy of an existing Hierarchy The Copy icon is only enabled when a single Hierarchy has been selected Check
154. splays the type of Run baseline or Simulation Run ID Displays the Run Execution ID Run Execution Details Section The Run Execution Details section presents a grid containing all of the executions of Run and status of a Oracle Financial Services Software Confidential Restricted 63 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 particular execution of the Run The menu bar in this grid offers several icons that allow you to perform different functions when a Run Execution is selected To select a Run Execution click the check box in the first column of the grid More than one Run Execution can be selected at a time but this will cause some of the icons to become disabled Param details Click this icon to view the Run execution and Run default parameter details on a read only basis Copy Click the Copy icon to copy the parameters as defined in the Run Execution Parameter window to create a new batch Execute Click the Execute icon to trigger the batch which has been created from the Run Execution Parameter window The status of the triggered batch is displayed In the Execution Summary page multiple selections of the execution ids are available to trigger a batch e Request for Reporting Run To request for a Reporting Run select a Run Execution ID in the Run Execution Summary page and click the Request for Reporting Execution icon A dialog box will appear for y
155. ssor The PP to which the Adjustment Entry is passed is displayed here Product Processor Balance Column The specific column in the PP to which the Adjustment Entry is passed is displayed here Wh Reconciliation Adjustment Report Map Name LE1_Check_1 Map Version 2 iw Reconciliation Adjustment Value Display Actual A GL Name Currency Reconciliation Difference Significant Reconciliation Difference Approved Adjustment Amount Pending Adjustment Amount Submitted Adjustment Amount Rejected Adjustment Amount LE1 GL2PP S 1001 USD 33 000 33 000 33 000 0 0 0 Refresh Print Export Amount in Absolute Reconciliation Adjustment Detailed Report Map Name LE1_Check_1 Map Version 2 iw GL Name LE1 GL2PP S 1001 iw i Entity Organization Customer Business Exposure Authorization Product Product Processor Gis name Ea GAAP Code Unit Product Class Unit graphy Amount Status Processor Balance Column LE1 GL2PP S Bank USA US Dollar United States of 33 000 Approved STG_CARDS n_eop_prin_bal 1001 America GAAP Report Name Reconciliation Correction Report Report Level Map Name This is the name of the reconciliation as defined in the Reconciliation Filters Management window Map Version This is the version number of the defined reconciliation Version Oracle Financial Services Software Confidential Restricted 86 User Guide Oracle Financial Services Analytical
156. sted figures Global Threshold Global Threshold is applied over and above the mapping level threshold If this threshold is breached during execution then you have the choice to select continue or you may stop the execution process Global Threshold is compared with the cumulative percentage difference across all reconciliation definitions being executed in a Run Execution on Threshold breach In this field you have the choice of selecting Continue or No If Continue is selected and if the GL reconciliation breaches the global threshold level then the execution will continue or else if No is selected the Execution is discontinued Oracle Financial Services Software Confidential Restricted 62 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Auto Approval If Auto Approval is selected as Yes then it is directly be updated in the Adjustment Entry Authorization window This field can be edited only by the authorizer The default selection is No FIC MIS Date Enter the extraction date in this field Run Execution Description Enter a longer description of the Run The below functions are required to get RUN MANAGEMENT link in GL RECONCILAIATION screen VIEWRUNDET You can view the Run Detail MODRUNPRM You can modify the Run Parameters EXEREQRUN You can execute the Requested Run By clicking the Save button a batch with the defined Run execution parameters is creat
157. t contain a book code mapped to the target GL code The application automatically matches similar GL codes from the Product Processor entity and general ledger entity and the reconciliation difference is computed However you need to create mappings when GL codes differ across the Product Processor entity and general ledger entity For more information on procedure to manually map the GL codes refer to Reveleus_Parameter_Master STG LE GL BOOK MAPPING The expected values for STG_LE_GL_BOOK_MAPPING are S Solo and C Consolidate While uploading data into STG_LE_GL_BOOK_MAPPING ensure the following If you are executing for the first time then in the table STG_LE_GL_BOOK_MAPPING complete set of data has to be uploaded Thereafter if there is any change in GL Book Mapping data then only the new book mapping should be available in STG_LE_GL_BOOK_MAPPING table to be uploaded in the processing table If old set of data is also present in STG_LE_GL_BOOK_MAPPING with new incremental upload Oracle Financial Services Software Confidential Restricted 10 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 then the application will merge the new and old data for the date batch executed This need not be uploaded for each FIC MIS Date Note Mappings have to be created only when the GL codes differ across general ledger entity and Product Processor entity For more information on creating a mapp
158. t filter are to be set as shown in the following figure Oracle Financial Services Software Confidential Restricted 56 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 amp Reconciliation Definition Name Description Settings Product Processor PP Parameters Allocation amp Product Processor PP Entity PP Entity Name GL Reconciliation Column GL Amount Column Threshold Specification WV Stage Cards v Debit Interest GL Code v Total Outstanding Balance Month End v Percentage v 10 Threshold Amount Currency Select amp Filter amp No Element Selected Filter Browser Webpage Dialog Adjustment Entry Floor jill 1totof1 Negative Correction Threshold Positive Correction Threshold 10 10 Otodofd 0 to 0 of O amp Search amp Hierarchy Hierarchical Available Hierarchies Selected Hierarchies Product Hierarchy Product Org Unit Branch GAAP Code Customer Class Currency t Business Unit Audit Trail amp Audit Trail Created By 3 Select the relevant dimensions from the Filters section 4 Click the Add icon against the selected dimension 5 Select the filter to be applied on each dimension 03 05 13 e Allocation Settings GL Parameters Product Processor PP Parameters Dimensions Allocation Adjustment Allocation Automatic Manual
159. t those with Immediate Execution Option Yes in the grid Navigation within the Summary Page When you first navigate to the Run Management summary page the Runs defined in the RRF are presented in a summary grid The Run Management summary page has two sections Search List of Runs Search Section Among other properties each Run possesses a segment a Run Name and a Run Type You may search on any of these properties in the Search section Run Management Summary amp Search EQ Segment GLSEG v Run Name Run Type lt List of Runs Section The List of Runs section presents a grid containing all of the Runs that meet your search criteria This summary grid offers several icons that allow you to perform different functions when a Run is selected To select a Run click the check box in the first column of the grid e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed definition of a Run on a read only basis The View icon is only enabled when a single Run has been selected Run Default Parameters Selecting a single row out of the grid enables you to define the default parameters of a Run Run Execution Parameters Selecting a single row out of the grid enables you to define the execution parameters of a Run Run Execution Summary Selecting a single row out of the grid enables you to view the status of the Run executed in the
160. the defined settings When you Add View Edit or Delete a detail page is displayed Navigation within Summary Page When you first navigate to the Global Settings screen the settings are presented in a summary grid This has three sections 6 Product Processor PP Source Settings General Ledger GL Source Settings Dimensions The Product Processor PP Source Settings and General Ledger GL Source Settings in the summary grid offers several icons that allow you to perform different functions when a setting is selected Add Clicking the Add icon begins the process of building new settings The Add icon is disabled if any row in the grid has been selected e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed definition of a setting on a read only basis The View icon is only enabled when a single setting has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify settings The Edit icon is only enabled when a single setting has been selected Delete Selecting one or more rows out of the grid enables the Delete icon Clicking the Delete icon deletes the settings you have selected The dimensions section in the summary grid offers the following icons Add Clicking the Add icon begins the process adding a new dimension as an optional dimension The Add icon is disabled if any
161. the five preceding days While reconciling source ledger and target amounts differences can arise in two ways either when source ledger amount is greater than target ledger amount or when source ledger amount is less than target ledger amount Hence there are two threshold values to address difference arising out of this condition For more information refer to Target Ledger Parameters Navigation within Summary Page Upon initially navigating to Reconciliation Management gt Ledger to Ledger a summary page is displayed showing all of the defined Ledger to Ledger reconciliations By selecting a dimension and by using search criteria you can control the set of reconciliations that are displayed When you Add Edit or View the details page is displayed This summary page consists of the two sections Search Definition List Oracle Financial Services Software Confidential Restricted 41 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Search Section Among other properties each attribute possesses a Name definition name GL Book Consolidation Type and a Legal Entity You may search on any of these properties in the Search section amp Search KR Name GL Book Legal Entity Consolidation Type v Definition List Section The Definition List section presents a grid containing all of the definitions that meet your search criteria This grid offers several ic
162. tion Specify the threshold from this drop down list If the value is specified in percentage terms then the Threshold Amount Currency field is disabled Positive Correction Threshold Specify the Positive Correction Threshold value These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL level reconciliation values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs e Negative Correction Threshold Specify the Negative Correction Threshold value These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL Level Recon values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs Select the currency in which the Threshold Amount is to be specified in Additionally click the Filters section to add more d
163. tion of your new Dimension Member Oracle Financial Services Software Confidential Restricted 28 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Member Attributes Section If you have not copied attribute values from a pre existing dimension member using the Copy Attribute Assignment From feature described above then assign them in the Member Attributes section Dimension Member attributes have defined data types including string number date and dimension If an attribute is a date data type then use the calendar icon to select a date If an attribute is a number or string data type then enter a free form value directly If an attribute is a dimension data type then select your value from the drop down list A Member Attributes is Attribute Value Difference Auto Approve Flag General Ledger Account General Ledger Book Code General Ledger Name General Ledger Type Intra Group Parent General Ledger Account Hierarchies Summary amp Detail Screens Upon initially navigating to Setup gt AMHM Maintenance gt Hierarchies a summary screen is displayed showing all of the defined Hierarchies for one dimension your first dimension alphabetically that supports hierarchies By selecting a dimension and by using search criteria you can control the set of Hierarchies that are displayed When you Add Edit Copy or View a Hierarchy a detail screen is displayed Na
164. umn name o V_GL_HCY_GL_BOOK_COL_NAME GL Book code column name Example V_GL_HCY_ V_GL_HCY_DIM_TAB V_GL_HCY_INTRA_ GROUP V_GL_HCY_GL_TYPE_ V_GL_HCY_GL_BOOK_ CODE LE_NAME _COL_NAME COL_NAME COL_NAME HGLO09 DIM_GL_ACCOUNT F_INTRA_GROUP V_GL_TYPE V_GL_BOOK_CODE Now you can define new GL Source Name in the Global Settings window Oracle Financial Services Software Confidential Restricted 101 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Annexure D Procedure to add Optional Dimensions 1 Create a dimension table in the model if required 2 Add the table where the dimension is defined in the join condition of GL dataset amp Product Processor dataset 3 Create a Hierarchy with metadata authorization 4 Add additional field from respective dimension table which is used to join with stage product processor tables in below tables a FCT_RECONCILIATION_DIFFERENCE b FCT_GL_ADJUSTMENT_ENTRIES c FCT_GL_CORRECTION_ENTRIES d FSI_TMP_TARGET_BALANCE e FST TMP_SOURCE_ BALANCE f FSI_GL_THRESHOLD_BREACHES 5 Add additional field from respective dimension table which is used to join with stage product processor tables in unique index of below mentioned tables a FCT_RECONCILIATION_DIFFERENCE b FCT_GL_ADJUSTMENT_ENTRIES c FCT_GL_CORRECTION_ENTRIES d FSI_TMP_TARGET_BALANCE e FST TMP_SOURCE_ BALANCE 6 Upload the customized datamodel to see the cha
165. used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL level reconciliation values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs Negative Correction Threshold Specify the Negative Correction Threshold value These values are used to identify the breach types categorized as Negative Percentage Threshold NPT Positive Percentage Threshold PPT Negative Absolute Threshold NAT Positive Absolute Threshold PAT and Not Breached NB The Breach Type is identified at run time during the reconciliation process and Audit Trail entries are posted with this information For GL Level Recon values can be updated at different PP levels For Map Level Recon you have to manually enter only one value for all the PPs You also have the option of adding filters to the optional dimensions product business unit and so on defined in the Global Setting window Comparison between the GL source system and PPs is based on the filters set on these dimensions Refer to the following steps to add filters 1 Click the Add icon in the Filters section as highlighted in the previous figure 2 Sele
166. ution Audit Trail Map Map Version Information iEseauion Identifier id Num Type pout GLINFO_1360603104000_20101231_1 257 4 INFO Map Level Threshold has been breached for Execution ID GLINFO_1360603104000_20101231_1 Map ID 257 Version No 4 GL CODE LE1 MAP S 1001 Threshold Breached By 99 Breach type NPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code AUGAAP _ i i 4 Map Level Threshold has been breached for Execution ID GLINFO_1360603104000_20101231_1 Map ID 257 Version No 4 GL CODE LE1 MAP S 1002 Threshold Breached By 9 714 Breach type PPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code USGAAP GLINFO_1360605182817_20101231_1 263 1 INFO Map Level Threshold has been breached for Execution ID GLINFO_1360605182817_20101231_1 Map ID 263 Version No 1 GL CODE LEBAP A 6000 S 4444 Threshold Breached By 58 079 Breach type PPT v_iso_currency_cd AUD v_entity_code BAP v_gaap_code AUGAAP GLINFO_1360608370923_20101231_1 264 1 INFO Map Level Threshold has been breached for Execution ID GLINFO_1360608370923_20101231_1 Map ID 264 Version No 1 GL CODE LE1 GL S 1001 Threshold Breached By 99 Breach type NPT v_iso_currency_cd USD v_entity_code LE1 v_gaap_code USGAAP _ 1 Map Level Threshold has been breached for Execution ID GLINFO_1360608370923_20101231_1 Map ID 264 Version No 1 GL CODE LE1 GL S 1002 ee Threshold Breached By 93 286 B
167. vels of depth For details on depth limitations and configuring maximum depth levels for hierarchies see Oracle Financial Services Analytical Applications Infrastructure OFSAAI Installation and Configuration Guide Controlling the Hierarchy Display There are a number of icons on the title bar of the hierarchy that allow you to modify how the hierarchy is displayed Search Clicking the Search icon invokes a pop up dialog in which you can perform wildcard searches for dimension members by Member Code or by Member Name When you click the Search button within the pop up dialog box the dialog boxes closes your search is executed and results are returned within the Hierarchy Display Grid under the heading of Show Results gt Search Windows Internet Explorer When viewing search results under the Show Results heading you may locate a dimension member within the hierarchy by selecting it and clicking the Focus icon After selecting a dimension member and clicking Focus the application responds by focusing on your selected member under the Show Hierarchy heading that is under the normal hierarchy display This method of searching for dimension members will only find assigned members that is members that are not found in the Orphans Branch Expand All Collapse All When you initially enter the Hierarchies Detail screen clicking this icon expands every branch of your hierarchy to display its entire depth Click this ic
168. vels within your hierarchy Level Properties Properties LIF LOSE The Level Properties dialog will display as many levels as you have currently built out In the above example names and descriptions are being added at a time when only 3 levels have been built within the underlying hierarchy If a fourth level is built into the hierarchy then you could return to Level Properties to add a name and description to level 4 Assigning names or descriptions to levels is completely optional Within the Hierarchy Properties Section the drop down list for Initial Display Level will reflect your level name choices Your choices may also be utilized within downstream reporting applications but level names and descriptions are otherwise not utilized within OFSAA Cut If you wish to move a dimension member then click a leaf member or a rollup member and select Cut You may wish to move a dimension member because it is in the wrong location within the hierarchy You may also wish to Cut a dimension member from the Orphan Branch in order to subsequently paste it within the body of Oracle Financial Services Software Confidential Restricted 38 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 your hierarchy Any Cut operation must be followed by a Paste as Child Paste as Sibling or Cancel operation Until you have executed a Cut operation Paste as Child Paste as Sibling and Cancel
169. vigation within Summary Page When you first navigate to the Correction Authorization window the correction entries are presented in Correction Entry Status grid This window has two sections Oracle Financial Services Software Confidential Restricted 73 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Search Correction Entry Status Search Section Among other properties each correction entry possesses a Run Execution ID a Definition Name and a GL Date You may search on any of these properties in the Search section amp Search B Run Execution ID GL Date Definition Name wwe Correction Entry Status Section The Correction Entry Status section presents a grid containing all of the Correction Entries that meet your search criteria This grid offers several icons that allow you to perform different functions when a Correction Entry is selected To select a Correction Entry click a check box in the first column of the grid a View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed parameters of a Correction Entry on a read only basis The View icon is only enabled when a single Correction Entry has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify a few parameters of an existing Correction Entry The Edit ic
170. vigation within the Summary Screen When you first navigate to the Hierarchies summary screen the Hierarchies that are stored within your current default folder and that are associated with your first dimension are presented in a summary grid The Hierarchies Summary screen has three sections Dimension e Search Hierarchies Dimension Section Select the Dimension of the hierarchies you wish to View When you change your dimension selection in the summary screen the screen refreshes and displays the Hierarchies that are stored within your current default folder For Analytical Applications Framework the dimension is by default the General Ledger Account Dimension Dimension General Ledger Account Search Section Oracle Financial Services Software Confidential Restricted 29 User Guide Oracle Financial Services Analytical Applications Reconciliation Framework Release 8 0 1 0 0 Your default Folder functions as a search constraint The value of your default Folder is set in Application Preferences You may select a different Folder or you may remove the Folder constraint entirely by selecting the blank Folder that is no Folder You may also search by Hierarchy Name Dimension Member Code and or Dimension Member Name amp Search fe Folder Hierarchy Name Dimension Member Dimension hember Alphanumeric Code Numeric Code Dimension Member Mame Hierarchies Section The Hierarchies section pre
171. y or View a Hierarchy the Hierarchies Detail screen is displayed Dimension Section For a new Hierarchy select the dimension upon which you want to build a hierarchy For an existing Hierarchy you may not change the dimension Hierarchy Properties Section Specify a Hierarchy Name and Description select a Folder in which the Hierarchy is to be stored and specify whether you want the Hierarchy to be Read Write or Read Only Access Type Naming your Hierarchy is required before it can be saved Default values for Folder and Access Type are stored in Application Preferences The Hierarchy Properties section also stores values for Automatic Inheritance Display Signage Show Member Code Initial Display Level and Orphan Branch Name and Description Displays the hierarchy s name and description Name is a required property you cannot save a hierarchy until you supply a name Folder Select the folder in which you want the hierarchy to be stored Automatic Inheritance Not used in the current release Show Member Code Show Member Code governs the default display behavior of a hierarchy This code maybe set to one of three different values Code to Left of Name Code to Right of Name Only Name No Code While viewing or editing a hierarchy you may override whatever default behavior has been set by clicking the Show Code Values Right or on the Show Code Values Left icons that are located on the title bar of the Hierar
172. y Page Upon initially navigating to Reconciliation Management gt General Ledger to Product Processor a summary page is displayed showing all of the defined Ledger to Ledger reconciliations By selecting a dimension and by using search criteria you can control the set of reconciliations that are displayed When you Add Edit or Edit the details page is displayed This summary page consists of the two sections Search Definition List Search Section Among other properties each attribute possesses a Name definition name GL Book Consolidation Type and a Legal Entity You may search on any of these properties the Search section amp Search EX Name GL Book Legal Entity Consolidation Type Definition List Section The Definition List section presents a grid containing all of the definitions that meet your search criteria This grid offers several icons that allow you to perform different functions when a defined reconciliation is selected To select a defined reconciliation click a check box in the first column of the grid Add Clicking the Add icon begins the process of building a new Ledger to Ledger reconciliation The Add icon is disabled if any row in the grid has been selected e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed definition of reconciliation on a read only basis The View icon is only enabled when a single reconcil
173. your search criteria The Dimension Members summary grid offers several icons that allow you to perform different functions when a Dimension Member is selected To select a Dimension Member click a check box in the first column of the grid More than one Dimension Member can be selected at a time but this may disable some of the icons Clicking a check box a second time clears a Dimension Member You may select or deselect all of the Dimension Members in the summary grid by clicking the check box in the upper left hand corner of the summary grid directly to the left of the Code column header Add Clicking the Add icon begins the process of building a new Dimension Member The Add icon is disabled if any row in the grid has been selected e View Selecting a single row out of the grid enables the View icon Clicking the View icon allows you to view the detailed definition of a Dimension Member on a read only basis The View icon is only enabled when a single Dimension Member has been selected Edit Selecting a single row out of the grid enables the Edit icon Clicking the Edit icon allows you to modify an existing Dimension Member The Edit icon is only enabled when a single Dimension Member has been selected e Copy Selecting a single row out of the grid enables the Copy icon Clicking the Copy icon allows you to create a copy of an existing Dimension Member The Copy icon is only enabled when a single Dimension Member has been selected

User Manual: Product Name

Contents

Download Pdf Manuals

Related Search

Related Contents