My Oracle Support Banner

E1: ORCH: Data Request Aggregation Ignores Decimal for Aggregated Columns - Specific to SQL Server Instances (Doc ID 2980646.1)

Last updated on NOVEMBER 13, 2023

Applies to:

JD Edwards EnterpriseOne Tools - Version 9.2 to 9.2 [Release 9.2]
Information in this document applies to any platform.
Specific to SQL Server

Symptoms

Data request aggregation ignores decimal for aggregated columns. Issue is observed with multiple tables like F4211, F03B11 etc. This issue seems to be specific to the instances involving SQL server as it is working as expected in instances with Oracle database. Sample result given below demonstrates the issue:

Result from Oracle database:
"Gross Amount-Sum": 1564.22  (Correct result with decimal)

Result from SQL server database:
"Gross Amount-Sum": 156422   (Incorrect result, without decimal)

Steps to replicate:

  1. Login to the orchestrator studio
  2. Design a Data Request with Aggregation output for a column - Eg: Sum for Gross Amount from the table F03B11
  3. Create an Orchestration to call the data request
  4. Run the Orchestration and review the aggregate output

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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

In this Document
Symptoms
Changes
Cause
Solution
References


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