My Oracle Support Banner

Transactions With Activity Sequence Failing (Doc ID 2388822.1)

Last updated on MARCH 20, 2019

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.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.