Posting Job Failing With ORA-00979 Error
(Doc ID 3002774.1)
Last updated on FEBRUARY 07, 2024
Applies to:
Oracle Retail Invoice Matching Cloud Service - Version 19.3 and laterInformation in this document applies to any platform.
Symptoms
Posting batch is failing with an error after applying IMCS 19.3.012.25 hotfix patch.
ERROR
-----------------------
"An error occurred while posting -@0PACKAGE_ERROR@1ORA-00979: not a GROUP BY expression DOC ID - > @2REIM_POSTING_SQL.CHK_DB_CR_BALANCE_AP_STAGE"
Steps to Recreate:
- Apply IMCS 19.3.012.25 hotfix patch.
- Ensure that there are few invoices eligible for posting.
- Run posting batch and notice the error:
"An error occurred while posting -@0PACKAGE_ERROR@1ORA-00979: not a GROUP BY expression DOC ID - > @2REIM_POSTING_SQL.CHK_DB_CR_BALANCE_AP_STAGE"
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |