E-PIA: Incorrect Display Format of Amount Fields in Search Results Grid of Components
Last updated on NOVEMBER 15, 2017
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
Amount fields are not getting properly formatted in Search Results Grid of Components.
The Digit Group Separator, as specified in My Preferences, and the Decimal Positions, specified for the Currency Code, are not taken into account when displaying amount fields in the Search Results grid of the components.
Digit Group Separator can be defined in My Preferences or at PeopleTools > Personalization > Personalization Options, Option Category Level: 'PPTL' (PeopleTools), Definition 'TSEP' (Digit Group Separator).
Decimal Positions can be defined for the Currency at Set Up Financials/Supply Chain > Common Definitions > Currency > Currency Code.
Navigate to Accounts Payable > Vouchers > Add/Update > Regular Entry
Click on Find an Existing Value tab
Enter US001 for Business Unit
Enter Regular Voucher for Voucher Style
Hit Search Button
Gross Invoice Amount and Payment Amount do not always display the Decimal Positions.
Component VCHR_EXPRESS uses Record View VOUCHER_SRCH_VW as Search Record.
Fields GROSS_AMT (Gross Invoice Amount) and PAY_AMT (Payment Amount) have TXN_CURRENCY_CD (Transaction Currency) as Currency Control Field.
Even if the field TXN_CURRENCY_CD is made List Box Item, to show up in the search results grid, the amount fields are not formatted according to the currency setup.
The Search Results Grid also does not display the Digit Group Separator, as defined in My Preferences.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms