My Oracle Support Banner

Siebel Clinical: In Site Management > Payment Exception View "Payment Split Status" Shown Incorrectly As Red Due To Rounding (Doc ID 2988709.1)

Last updated on NOVEMBER 27, 2023

Applies to:

Siebel Contracts for Clinical Trial Management System - Version 21.1 and later
Information in this document applies to any platform.


When entering split details records under Site Management > Payment Exception screen, Payment Split Status is not showing the correct value even if the split percentage is equal to 100%.

In some cases , the split status indicator will appear as 'Red':

  1. When user enters split percentages, application calculates split amounts, but due to rounding the split amounts total is not matching exactly the payment exception amount
  2. When user enters the split amounts so the total will match the payment exception amount, the split percentages will be automatically calculated, but due to rounding the total percent will not be 100%.


Issue was reproduced in standard application 23.8 version using steps: 

  1. Navigate to the Site Management screen, then the Protocol Site List view
  2. In the Protocol Site list, drill down on the site number field of the site for which you want to set up split payment
  3. Navigate to the Payment Exceptions view
  4. In the Payment Exceptions list, create a payment exception record with amount set to 300
  5. Navigate to the Split Details list
  6. Create a new record for each payment split and enter split percentages as below. Note the split amounts calculated by application:


Split percentage                       Split amounts
33.33%                                    100

16.67%                                     50

16.67%                                     50

16.67%                                     50

10%                                        30

3.33%                                      10

1.67%                                      5

1.66%                                      4.98


 Note that total percent is 100% but due to rounding the sum of split amounts is not equal with 300 and payment split status remains red.

If instead of entering 1.66% percent for the last payment, user enters 5 in split amount of the last record ( in order to match the 300 payment value), then the percent will be automatically set to 1.67 and the total percent will be 100.01%, so the status remains red.




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.