My Oracle Support Banner

E1: ORCH: Data Service Request with Table Join Business View Doesn't Return the correct Data When Using Aggregation::Include Count with Group By. (Doc ID 2650723.1)

Last updated on MARCH 20, 2020

Applies to:

JD Edwards EnterpriseOne Orchestrator - Version 9.2 and later
Information in this document applies to any platform.

Symptoms

Data Service Request with Table Join View (e.g. V0101JE) with "Aggregate::Include count" with "Group by" doesn't work.

 

Testing this in the Orchestrator Run option will give the result of 0 record.
Testing the Direct API call from postman throws the following error.

 

Other aggregations (e.g. Sum) work fine with Group by, but when turning on the "include count" check mark, then it doesn't work as expected.

Table and single table View work with the count option.

STEPS TO REPRODUCE
==================
1. Create Data Service Request with V0101JE
2. Select "Search Type" in the Filter Criteria
3. Turn on Aggregations and select "Include Count" and Address Number SUM
4. Select "Business Unit" in the Group By
5. Run it and you should get 0 result back.
6. Turn OFF the "Include Count"
7. Run. It should work and get the following result. . .

{
"V0101JeAgg": {
"tableId": "V0101JE",
"rowset": [
{
"Address Number [F0101]-Sum": "47286394",
"Business Unit [F0101]": " 1"
},
{
"Address Number [F0101]-Sum": "43454",
"Business Unit [F0101]": " 28"
},
{
"Address Number [F0101]-Sum": "20092",
"Business Unit [F0101]": " 209"
},
{
"Address Number [F0101]-Sum": "75020",
"Business Unit [F0101]": " 75001"
},

 

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
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.