Administration User Manual
Contents
1. Name CI Dynamic Procedure Name A Additional Information Archive Required No installation Criteria Commit Counter User Criteria Table Information 101 E Purge Order Table Name Archive Table Name Primary Key Column Name Parent Primary Key Column Name input by DateTime Authorized by DateTime Mod No Open Authorized e ORACLE 2 2 1 2 2 1 1 Fields in Purge Frequency Screen Basic Information Section Purge Key Purge key is the purge name that you need to maintain Table Name Display Only The name of the table for which a purge frequency must be set up is displayed here Purge Frequency Alphanumeric Mandatory Specify the frequency at which the selected table must be purged as part of the End of Day processes You can use the drop down list to make your choice Following are the options available in the drop down list e Daily e Weekly e Bi Weekly e Monthly e Quarterly e Half Yearly e Yearly e Not Scheduled If purge frequency is maintained as not scheduled the system will ignore this purge activity from execution during EOD Last Purge Date Display Only The most recent date on which the purge was performed is displayed in this field Retention Period Display Only The system will compute retention period in days based on retention period and frequency maintained Retention Frequency Select the retention frequency from the drop down Following are the options ava2. Admin User Guide Oracle FLEXCUBE Investor Servicing Release 12 0 4 0 0 Part Number E57474 01 September 2014 ORACLE Table of Contents About This Manual ae aaa iocis ecc ec es aaa aaa ea dai amd adapa essa cai aa 1 1 11 gt INTOGUCUON accord ela da EE 1 1 1 2 Related Documents eee eee ana aaa na a ta aa ti a 1 1 1 3 Audience ni atta tes eem iae a iate 1 1 1 4 Organization hee ROG de Me 1 1 1 5 Conventions Used in this Manual nenea enne 1 1 1 5 1 General Conventions eei eise aate dena ttn dana area aaa 1 2 1 5 2 Keyboard Conventions sse 1 2 16 Glossary of ICONS oerte rede lua 3 a a ee a e ai e dn ed 1 2 1 7 X Abbreviations and Acronyms sssssssssseeeeeeenn mener nennen nenne 1 2 1 9 Getting Help i need an een cent ed qe te tinm inition a 1 3 AdministratiQIi ci aeu eani di aa eee aaa Qu RN UU S a au MM M INR aa E LEE 2 1 2 1 Introduction cae eee cae ear aa e n e ta a ceret idee d i i end de a a ia uu 2 1 2 2 Purge Frequency Maintenance mme nenea emana en 2 1 2 2 1 Fields in Purge Frequency Screen mmm nenea nenea nana anna 2 2 2 2 2 Purge Frequency Summary screen nana nana anna ea 2 4 Function ID Glossary socata oii ia ata eee 3 1 1 1 1 2 1 3 1 4 1 5 1 About This Manual Introduction Welcome to Oracle FLEXCUBE Investor Servicing a comprehensive mutual funds automation software from Oracle Finan
3. Frequency Maintenance Detail screen is displayed Select Delete Operation from the Action list The system prompts you to confirm the deletion and the record is physically deleted from the system database 2 2 2 5 Authorizing Purge Frequency Maintenance An unauthorized Purge Frequency must be authorized in the system for it to be processed To authorize a record Invoke the Purge Frequency Summary screen from the Browser Select the status of the record that you want to retrieve for authorization Typically choose the unauthorized option Specify any or all of the details and click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen 25 ORACLE 2 2 2 6 2 2 2 7 2 2 2 8 e Double click the record that you wish to authorize The Purge Frequency Maintenance Detail screen is displayed Select Authorize operation from the Action List When a checker authorizes a record details of validation if any that were overridden by the maker of the record during the Save operation are displayed If any of these overrides results in an error the checker must reject the record Amending Purge Frequency Maintenance After a Purge Frequency Maintenance is authorized it can be modified using the Unlock operation from the Action List To make changes to a record after authorization e Invoke the Purge Frequency Summary screen from th
4. cial Servicing Software Ltd This Oracle FLEXCUBE Investor Servicing User Manual helps you use the system to achieve optimum automation of all your mutual fund investor servicing processes It contains guidelines for specific tasks descriptions of various features and processes in the system and general information Related Documents The User Manual is organized in to various parts each discussing a component of the Oracle FLEXCUBE Investor Servicing system Audience This Fund Manager User Manual is intended for the Fund Administrator users and system operators in the AMC Organization This volume of the Fund Manager User manual is organized under the following chapter sequence About This Manual explains the structure audience organization and Chapter 1 l related documents of this manual Chapter 2 iiim explains Purge frequency maintenance Purge processing query Conventions Used in this Manual Before you begin using this User Manual it is important to understand the typographical conventions used in it t1 ORACLE 1 5 1 General Conventions Convention Type of Information Italics type For emphasis Functional foreign terms Validations for fields on a screen References to related Headings Users Manuals Numbered Bullet Step by step procedures 1 5 2 Keyboard Conventions Convention Type of Information Keys All keys of th
5. e Browser e Select the status of the record that you want to retrieve for authorization You can only amend authorized records e Specify any or all of the details and click Search button All records with the specified details that are pending authorization are retrieved and displayed in the lower portion of the screen e Double click the record that you wish to authorize The Purge Frequency Maintenance Detail screen is displayed in amendment mode Select Unlock operation from the Action List to amend the record e Amend the necessary information and click on Save to save the changes Authorizing Amended Purge Frequency Maintenance An amended Purge Frequency Maintenance must be authorized for the amendment to be made effective in the system The authorization of amended records can be done only from Fund Manager Module and Agency Branch module The process of subsequent authorization is the same as that for normal transactions Copying Attributes If you want to create a new Purge Frequency Maintenance with the same attributes of an existing maintenance you can copy the attributes of an existing Purge Frequency Maintenance to a new one To copy the attributes e Retrieve the record whose attributes the new Purge Frequency should inherit You can retrieve the record through the Summary screen or through the F7 F8 operation explained in the previous sections of this chapter e Click on Copy e Indicate the ID for t
6. e keyboard are represented in capital letters For example lt CTRL gt Shortcut All short cut keys are contained in brackets For example keys lt ALT SHIFT gt 1 6 Glossary of Icons This User Manual may refer to all or some of the following icons Icons Function am Exit Add Row zs Delete Row Option List 1 7 Abbreviations and Acronyms The following acronyms and abbreviations are adhered to in this User Manual Abbreviation Meaning Acronym ADMIN User Administrator AGY The Agency Branch component of the system AMC Asset Management Company BOD Beginning of Day CDSC Contingent Deferred Sales Charge CGT Capital Gains Tax Tg ORACLE 1 8 Abbreviation Acronym Meaning CIF Customer Information File EOD End of Day EPU Earnings per unit FC IS Oracle FLEXCUBE Investor Servicing FMG The Fund Manager component of the system FPADMIN Oracle FLEXCUBE Administrator ID Identification IHPP Inflation Hedged Pension Plan IPO Initial Public Offering LEP Life and Endowment Products LOI Letter of Intent NAV Net Asset Value REG The Registrar component of the system ROA Rights of Accumulation ROI Return on Investment SI Standing Instructions SMS Security Management System URL Uniform Resource Locator VAT Value Added Tax WAUC Weighted Average Unit C
7. hanges made are reflected in the Purge Frequency Summary screen 2 2 2 3 Viewing Purge Frequency Maintenance record To view a record that you have previously input you must retrieve the same in the Purge Frequency Summary screen as follows Invoke the Purge Frequency Summary screen from the Browser Select the status of the record that you want to retrieve for viewing in the Authorized field You can also view all records that are either unauthorized or authorized only by choosing the Unauthorized Authorized option Specify any or all of the details of the record in the corresponding fields on the screen and click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen Double click the record that you want to view in the list of displayed records The Purge Frequency Maintenance Detail screen is displayed in View mode 2 2 2 4 Deleting Purge Frequency Maintenance record You can delete only unauthorized records in the system To delete a record that you have previously entered Invoke the Purge Frequency Summary screen from the Browser Select the status of the record that you want to retrieve for deletion Specify any or all of the details and click Search button All records with the specified fields are retrieved and displayed in the lower portion of the screen Double click the record that you want to delete in the list of displayed records The Purge
8. he new Purge Frequency Maintenance You can however change the details of the new maintenance 27 ORACLE 3 Function ID Glossary U UTSPURGS 2 4 UTDPURGS 2 1 91 ORACLE Admin User Guide September 2014 Oracle Financial Services Software Limited Oracle Park Off Western Express Highway Goregaon East Mumbai Maharashtra 400 063 India Worldwide Inquiries Phone 91 22 6718 3000 Fax 91 22 6718 3001 www oracle com financialservices Copyright 2007 2014 Oracle and or its affiliates All rights reserved Oracle and Java are registered trademarks of Oracle and or its affiliates Other names may be trademarks of their respective owners 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 programs 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 informat
9. ilable in the drop down list e Daily e Weekly e Bi Weekly e Monthly e Quarterly e Half Yearly e Yearly e ORACLE 2 2 1 2 Retention Period in Days Display The system will calculate the days based on the Retention Period Value and Frequency system will calculate the days and is displayed here For instance If Retention Period is 1 and Retention Frequency is selected as weekly then 7 will be displayed in this field 1 7days in a week 7 Additional Information Section Archive Required Select Yes if you want backup to be taken before purge Else select No If you select Yes the system will copy the existing data into corresponding purge tables specified in the grid Note Actual Table and corresponding purge table should be in same number of columns and order of columns If there is mismatch dynamic procedure creation will fail and mainte nance cannot be authorized If you select No the system will delete the data from the table Column referred for Retention Displays the Column in the table which will be referred before processing purge If purge is already processed then process will start from the last purge date Installation Criteria Enter the installation criteria based on which the purge will be maintained If any new purge activity is maintained the same can be provided during first time maintenance only Subsequent amendment of this value is restricted Use
10. ils in the corresponding fields e The status of the record in the Authorized field If you choose the Blank Space option then all the records are retrieved e The status of the record in the Open field If you choose the Blank Space option then all records are retrieved e The Purge Key e The Purge Frequency e The Last Purge Date e Archive Required es ORACLE e Dynamic Procedure Name Click Search button to view the records All the records with the specified details are retrieved and displayed in the lower portion of the screen Note You can also retrieve the individual record detail from the detail screen by querying in the following manner Press F7 Input the Purge Key Press F8 You can perform Edit Delete Amend Authorize Reverse Confirm operations by selecting the operation from the Action list You can also search a record by using a combination of and alphanumeric value Example You can search the record for Purge Key by using the combination of value as follows A For example AGC17 AGVO6 AGC74 etc value 7 For example AGC17 GSD267 AGC77 etc numeric value 17 For example GSD217 GSD172 AGC17 etc Search is Case Serstve Authorized Open Purge Key 2i Purge Frequency Select Last Purge Date 5 Dynamic Procedure Name Archive Required Records per page 15v 1 of 1 E Authorized Open Purge Key Purge Frequency LastPurge Date Table Name Re
11. ion 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 failsafe 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 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 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 w
12. ith 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
13. ost Getting Help Online help is available for all tasks You can get help for any function by clicking the help icon provided or by pressing F1 ORACLE 2 1 2 2 2 Administration Introduction The Fund Manager component is equipped to manage administrative activities which include the purging of data maintenance of extraction information for extraction of data from the FIC application This chapter explains these functions This chapter also explains the Query Builder which can be used to construct user defined query statements to obtain information from the database Purge Frequency Maintenance You can use this screen to maintain the frequency of purging for the tables in the system According to the frequency specified here the tables are purged during the End of Day processes Invoke the Purge Frequency Maintenance Detail screen by typing UTDPURGS in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button The Purge Frequency Maintenance Detail screen is displayed Select New from the Actions menu in the Application tool bar or click new icon to enter the details Purge Frequency Maintenance Detail Save Basic information Purge Frequency Retenton Period Last Purge Date GA Retention Frequency Retention Period in Days Pre Purge Procedure Yes v Column Referred For C TF Required Retention Pre Purge Procedure
14. r defined Criteria You can amend the purge details before process and enter the user defined criteria User defined Criteria is an additional criteria which will be appended to installation criteria to filter parent table data to be archived Dynamic Procedure Creation Related Dynamic Procedure Name Specify the name of the dynamic procedure to be created The system will create dynamic procedure during authorization The system will validate the parameters provided for purging If the specified procedure name already exists then the system displays an override message Authorization will fail if dynamic procedure cannot be created without errors Pre Purge Procedure Related You can execute a pre defined procedure before the purging activity Following are the options available e Yes e No xs ORACLE 2 2 1 3 2 2 2 2 2 2 1 If you select Yes then the system will capture Pre Purge Procedure Name If you select No then Pre Purge Procedure Name is not required Commit Counter Specify commit frequency for archival purging activity If maintained it should be greater than zero If you do not provide commit frequency then the system will consider static maintenance available In the absence of static data system will default 10000 as commit counter Archived Table Information Table Name Specify the archived table name Archived Table Name The archived table name will be displayed The sys
15. tem performs the following validations for Purge Order e Purge Order defines the order in which the tables needs to be purged e Purge order for Master table should be 0 e f master table is not provided in the grid the system will use master table only for identifying the data for purge during purge process the system will purge only the tables provided in the grid e If no table information are provided in the grid the system will delete the parent table data based on the criteria provided If no criteria is provided then the system will truncate the table e Purge order of child tables should be greater than 0 e Purging of master table will be done after purging of all the child tables if master table is provided in the grid e Primary Key Column Name and Parent Primary Key Column Name Column names of master and child tables to be provided here e Details of child table to be provided in Primary Key Column Name and details of master table to be provided in Parent Primary Key Column Name e Data is mandatory for all child tables Purge Frequency Summary screen Retrieving Record in Purge Frequency Summary Screen You can retrieve a previously entered record in the Summary Screen as follows Invoke the Purge Frequency Maintenance Summary screen by typing UTSPURGS in the field at the top right corner of the Application tool bar and clicking on the adjoining arrow button Specify any or all of the following deta
16. tention Period r r r r r r r r r r r r r 2 2 2 2 Editing Purge Frequency Maintenance You can modify the details of Purge Frequency Maintenance that you into the system provided it has not subsequently authorized You can as follows 2 5 and alphanumeric Search by A System will fetch all the records whose Purge Key starts from Alphabet Search by 7 System will fetch all the records whose Purge Key ends by numeric Search by 17 System will fetch all the records whose Purge Key contains the a Dynamic Proc have already entered perform this operation ORACLE Invoke the Purge Frequency Summary screen from the Browser Select the status of the record that you want to retrieve for modification in the Authorized field You can only modify records that are unauthorized Accordingly choose the unauthorized option Specify any or all of the details in the corresponding fields to retrieve the record that is to be modified Click Search button All unauthorized records with the specified details are retrieved and displayed in the lower portion of the screen Double click the record that you want to modify in the list of displayed records The Purge Frequency Maintenance Detail screen is displayed Select Unlock Operation from the Action list to modify the record Modify the necessary information Click Save to save your changes The Purge Frequency Maintenance Detail screen is closed and the c
Download Pdf Manuals
Related Search