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 and later
Information in this document applies to any platform.


On : version, General

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.


Transaction should get processed succesfully

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

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


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

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