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.
On : 10.2.0.29 version, General
Transactions with Activity Sequence failing with below error
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
Enter the following information:
-change code X
-premium received is for the amount past due plus the -current month due
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
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