My Oracle Support Banner

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 DECEMBER 10, 2020

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

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:

     PA_Client_Extn_Inv_Actions.Approve_Invoice( l_project_id,

For the second occurrence, if the following call to the client extension is not successful, the error is thrown:

     PA_Client_Extn_Inv_Actions.Release_Invoice( l_project_id,

For the third occurrence, the following  code throws the error of the return code is greater than 0:

PA_Client_Extn_Inv_Transfer.Get_AR_Trx_Type( P_Project_ID,

 

Output of the following shows the AR Transaction Type extension had been modified:

select text
from all_source
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

Changes

 Upgraded the database from 11.1.0.7 to 12.1.0.2

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.