My Oracle Support Banner

US Form 4626 Is Completing With Error (Doc ID 2745843.1)

Last updated on MARCH 14, 2021

Applies to:

Oracle Fusion Assets Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

When running the Summary or Detail report for US Form 4626 in Scheduled
Processed, the report runs to 'Error'.

When running the same reports in xmlpServer, the reports produced the
following errors:

oracle.xdo.servlet.data.DataException: oracle.xdo.servlet.data.DataException:
oracle.xdo.servlet.data.DataException: oracle.xdo.XDOException:
java.sql.SQLSyntaxErrorException:
ORA-00979: not a GROUP BY expression


The issue can be reproduced at will with the following steps:
    1. Navigate to Scheduled Processes.
    2. Run the US Form 4626 - AMT Summary Report

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.