Program RGRSTXML Publish FSG Report Set, Numbers Are Stored As Text and Column Set Factor Not Used
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
When running the program "RGRSTXML module: Program - Publish FSG Report Set," the Excel output has all numbers formatted as text output rather than numbers.
The expected output should be as follows:
- Numbers rather than Text
- Factor of Thousands
Both a custom template and seeded template were used, but none give the needed results (amounts as numbers, with factor of thousands).
* In the custom template: The amounts in the template are formatted as numbers, but the output for the amounts is still in text format.
* In the seeded template "FSG Report Set: Basic Excel Template (Raw Amounts)": Numbers in the output are stored as numbers. This template does not keep the Factor from the column set (i.e., displaying numbers in thousands).
* In the seeded template "FSG Report Set: Basic Excel Template": All numbers in the output are stored as text.
The issue can be reproduced at will with the following steps:
1. Submit a New Request/single request
Name: Program - Publish FSG Report Set
2. Click options button
Upon completion screen
Template Name: select the template
3. Submit the request
4. Open the Excel output
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