Querying Account Records

Oracle Insurance Logo

Oracle® Rules Palette Release 9.0 E14640_01

In the database you can use the ActivityGUID to locate the record written to AsAccountingDetail. You can locate the ActivityGUID by right clicking in the ActivityDetail screen and selecting View Source. In the source text file, do a search for activityguid. Use the Find Next button until you find a reference for ActivityGUID that has a value associated with it that is a GUID.

CoA database file

You can see all of the accounting details for all transactions and suspense on a policy by using the following SQL statement.

CoA SQL statement for transaction and suspense account details

The following SQL statement will allow you to view all CoA information.

SQL statement to view all CoA information