EAP APX1011 -Control Group Register Dist Line# Sort Order Issues (Doc ID 2228910.1)

Last updated on JANUARY 31, 2017

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

APX1011 -Control Group Register Dist Line# is sorted based on Alphanumeric instead of Numeric eg 1,10,11,12,2,20,21, etc..instead of 1,2,3,4,5....
This makes the report very unreadable for verification purposes for the users.


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


1. Created Control Group 0000000001.

2. Create Voucher with 13 Distribution lines.

3. Select Accounts Payable, then select Reports, then select Vouchers, then select Control Group Register, then select Control Group Register.

4. Run APX1011 - 0000000001.

APX1011 Report is generated. Notice the Line # under Distribution Line Information. The Line Numbers are displayed in the series 1, 10, 11, 12, 13,2, .....9 which indicates that the lines numbers are   treated as alphanumeric
instead of numeric.

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