Oracle Insurance Policy Administration Configuration II v8

In this course, participants will spend the first day reviewing the database model, locating required GUIDs and writing SQL statements to retrieve data saved in the database. The entire second day is focused on writing intermediate Math configuration to perform calculations and processes. Additional topics and hands on configuration practice will include Spawning transactions, configuring OnLoad/OnChange functionality for fields and using reusable CopyBook configuration.

Focus on debugging and locating Math configuration issues are covered, as well as reading and correcting Sad Servers due to configuration issues. Finally, explore the valuation engine, what business rules it invokes, the database tables it uses, how the system performs calculations and how to retrieve its results. All participants will participate in hands on configuration exercises, as well as an individual configuration project at the end of the class.

Learn to:

• Retrieve data using SQL statements
• Configure fields that use OnLoad/Change configuration
• Write intermediate Math configuration
• Configure transactions that use reusable CopyBooks
• Configure transactions that Spawn
• Learn to debug and interpret Sad Severs to rectify configuration errors

Audience

• Application Developers
• Business Analysts
• Developer
• Functional Implementer
• Project Manager
• Support Engineer
• System Analysts
• Technical Consultant

Course Topics Retrieving data using SQL statements

• Using a SQL editor
• Identifying the correct tables to retrieve data from
• Locating GUIDs
• Constructing SQL statements using SELECT and FROM
• Constructing SQL statements using WHERE and LIKE
• Constructing SQL statements using JOIN and ON
• Constructing SQL statements using multiple JOINs
• Populating combo boxes with SQL statements

Intermediate Math Configuration

• Configuring Field type MathVariables including PolicyField, PlanField and SegmentField types
• Configuring Segment loops
• Configuring MATHIF and IIF MathVariables types
• Configuring EXPRESSION and VALUE MathVariable types
• Configuring Valuation and XML MathVariable types
• Configuring SQL MathVariable types

Spawns

• Identifying situations that Spawning is appropriate
• Configuring Spawns to occur at different times
• Configuring Spawns to occur based on the value of a MathVariable
• Configuring Spawns that occur if a condition is true
• Passing values from transaction configuration to a Spawned transaction

OnLoad/OnChange

• Configuring OnLoad elements
• Prefixing fields with data types to use in OnLoad/OnChange expression writing
• Loading fields that perform OnLoad/OnChange
• Writing JavaScript expressions for OnLoad/OnChange statements
• Writing expressions that hide and display fields
• Configuring OnChange that is type RELOAD

Valuation

• Explain the main components of the valuation engine
• Calling the valuation engine
• Accessing values from the valuation structure
• Identifying activities that store valuation results
• Differentiate the data stored in AsValuation and AsValuationXML
• Configuring transactions according to their use of Net Unit Values
• Writing to AsValuation using the Assignment element

CopyBooks

• Creating reusable global CopyBooks
• Overriding global CopyBooks
• Calling CopyBooks in configuration
• Resolving transactions that use CopyBooks

Course Objectives

• Construct SQL statements using appropriate GUIDs that retrieve desired results from the database
• Construct SQL statements using SELECT, FROM, WHERE, LIKE, JOIN, ON and IN
• Populate fields using SQL statements by configuring MathVariables
• Configure transactions that use PlanField, PolicyField,SegmentField, Expression, MathIF, IIF, Value, XML and Valuation Math Variables to perform
• Configure a transaction that loops thru Segment records on a policy and retrieves required values
• Troubleshoot Sad Servers and identify whether the problem is in the code or the configuration
• Demonstrate the ability to Spawn one or more transactions according to various timeframes and conditions
• Write OnLoad/OnChange JavaScript expressions that update data in loaded in fields
• Describe how the valuation engine processes data
• Integrate CopyBook Rules in transaction configuration
• Use configuration best practices when performing configuration