My Oracle Support Banner

ABEND At CA_BI_INTFC.RB-20001.RdyPPD: Column 'PS_CA_PREPAID_TBL.ACTIVITY_ID' Is Not In Group By (Doc ID 2375677.1)

Last updated on MARCH 19, 2018

Applies to:

PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

On : 9.2 version, Interface

CA_BI_INTFC failed in multiple steps with:Column 'PS_CA_PREPAID_TBL.ACTIVITY_ID' is not in group by

In CA_BI_INTFC the following sql steps fail with the same error as described in Error Codes
RB-20001.RdyPGP2
RB-20001.RdyPPD
RB-20001.RdyPPD2
RB-20100.RclPPD
RB-20100.RclPPDIm
I received the same message on the BUSINESS_UNIT_PC field in all of the same steps. The alias between the select list and the group by was different.
 

ERROR
-----------------------
-- 12:46:06.753 Process 888492 ABENDED at Step CA_BI_INTFC.RB-20001.RdyPPD (Action SQL) -- RC = 8601
ROLLBACK
/
-- 12:46:06.763 SQL Error: [Microsoft][SQL Server Native Client 11.0][SQL Server]Column 'PS_CA_PREPAID_TBL.ACTIVITY_ID' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.
[Microsoft][SQL Server Native Client 11.0][SQL


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add a prepaid
2. Add an immediate billing plan associated with the prepaid
3. Ready the prepaid and billing plan
4. Ensure the contract is ACTIVE
5. Run Process Other Billing Methods
Step 5 generates the error.


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!


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