Oracle Insurance Policy Administration Configuration II v8

Total time
Logo Oracle University

Need more information? Get more details on the site of the provider.

Starting dates and places

There are no known starting dates for this product.

Description

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 da…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

Didn't find what you were looking for? See also: Insurance, Policy Studies, Oracle, Personal Financial Planning, and International Politics.

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

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.