Transactions With Activity Sequence Failing

(Doc ID 2388822.1)

Last updated on APRIL 19, 2018

Applies to:

Oracle Insurance Policy Administration J2EE - Version 10.2.0.29 and later
Information in this document applies to any platform.

Symptoms

On : 10.2.0.29 version, General

ACTUAL BEHAVIOR
---------------
Transactions with Activity Sequence failing with below error

com.adminserver.utl.exception.AsExceptionUtl: Error.InvalidActivityTargetLevel

The error seems to be associated with any transaction which uses Activity Sequences, and cites a syntax problem in the code, on a line which we know is certainly correct.


 

EXPECTED BEHAVIOR
-----------------------
Transaction should get processed succesfully

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
At the Customer level, have at least one policy that has billed for a different client that is not associated with the policy being added via the invoice change activity in this scenario

-Have one policy associated with another customer and is paid one month behind the billed period of the customer the policy is being transferred TO
Step 1:
Enter the following information:
-change code X
-client ID
-effective date
-premium received is for the amount past due plus the -current month due

Step 2:
Generate the next bill for Bill A to verify the policy has moved to the new bill class

Generate the next bill for Bill B to verify the policy is no longer associated with the bill class

Step 1: Then verify the following:
-transfer the policy to the new bill class
-apply the funds for each period
-update the paid to date
-update the appropriate GL sub-account
-premium posted CR to 32000100 (apply premium activity / accounting tab
-offsetting DR entry to 23400100 ASA suspense (manual reconciliation activity / accounting tab)
- the used portion of the funds are cleared from suspense

Step 2:
Verify the policy appears on the bill for Bill Class A

Verify the policy does not appear on the bill for Bill Class B

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, The business is not able to test billing due to the failure.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms