EAR9.1: Payment Worksheet Truncating Decimals per USD Currency but Capturing Three Decimals on PAYMENT_ITEM Table. (Doc ID 1962106.1)

Last updated on SEPTEMBER 30, 2024

Applies to:

Symptoms

On : 9.1 version.

ACTUAL BEHAVIOR
---------------
Payment worksheet truncating decimals per USD currency but capturing three decimals on PAYMENT_ITEM table.

EXPECTED BEHAVIOR
---------------
Validate that the amount on the ITEM_ACTIVITY row reads -201.502. The worksheet shows -201.50 after save, but the table shows -201.502

ENVIRONMENT
---------------
Application & Version: 9.1
Bundle/Patch: 19
Environment: Production

STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Create a payment for $201.50
2. Build a payment worksheet for any customer.
3. Put the payment on account but instead of keying -201.50, key the value -201.502.
4. Save the payment worksheet. You will probably see the keyed value truncate to two decimal places. This is okay.
5. Payment Worksheet Action. Save the payment worksheet.
6. Run AR Update Process.
7. Process ran into success.
8. Run SQL to perform a select on the on-account item that was created. SELECT * FROM PS_ITEM_ACTIVITY WHERE ITEM = 'OA-18'
9. Validate that the amount on the ITEM_ACTIVITY row reads -201.502. The worksheet shows -201.50 after save, but the table shows -201.502

Cause

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