PRC: Interface Invoices to Receivables Errors with PA_CLIENT_EXTN_APP_ERROR when Using the AR Transaction Type Extension. Query in Extension Gives 'ORA-00979: not a GROUP BY expression'.
(Doc ID 2603261.1)
Last updated on MARCH 29, 2022
Applies to:Oracle Project Billing - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
PRC: Interface Invoices to Receivables errors with PA_CLIENT_EXTN_APP_ERROR in the log file. The error, PA_CLIENT_EXTN_APP_ERROR, occurs in the following packages:
NAME LINE TEXT
PA_INVOICE_ACTIONS 1146 'PA_CLIENT_EXTN_APP_ERROR');
PA_INVOICE_ACTIONS 1289 'PA_CLIENT_EXTN_APP_ERROR');
PA_INVOICE_TRANSFER 133 X_Reject_Code := 'PA_CLIENT_EXTN_APP_ERROR';
For the first occurrence if the following call to the client extension fails, the error is thrown:
For the second occurrence, if the following call to the client extension is not successful, the error is thrown:
For the third occurrence, the following code throws the error of the return code is greater than 0:
Output of the following shows the AR Transaction Type extension had been modified:
where name = 'PA_CLIENT_EXTN_INV_TRANSFER'
and type = 'PACKAGE BODY';
When one of the queries from the extension was run, it returned:
ERROR at line 4:
ORA-00979: not a GROUP BY expression
fnd_log_messages also showed:
Started to process Draft Invoice Number "1" for project XXXXX
Failed to get INVOICE CLASS for project invoice "1". Cause: ORA-00979: not a GROUP BY expression
Upgraded the database from 188.8.131.52 to 184.108.40.206
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