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 21, 2016

Applies to:

PeopleSoft Enterprise FIN Receivables - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

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


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users find worksheet shows -201.50 after save, but the table shows -201.502

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms