If More Than 1k Audit Events Are In Process, The C1-DISTA Batch Failed.
(Doc ID 3071016.1)
Last updated on FEBRUARY 10, 2025
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 6.0.0.0.0 to 6.0.0.0.0 [Release 6]Information in this document applies to any platform.
Goal
On : 6.0.0.0.0 version.
The C1-DISTA batch fails, if more than 1k Audit Events are in Pending Status.
Error message: causing java.sql.SQLSyntaxErrorException: ORA-01795: maximum number of expressions in a list is 1000
Steps to reproduce
Test Case 1
1. Create more than 1000 audits events of Maintenance objects 'C1_PRICEASGN', 'C1_PRICELIST', 'C1_PLASSGN', 'C1_PRCRULE', 'PERSON', 'ACCOUNT'). BO_STATUS_CD of these audit entries are ‘PENDING’.
2. Run C1-DISTA batch
3. After completion of C1-DISTA batch, Batch post proc algo C1-DISAUP will get triggered and must update all audit entries with “COMPLETE” BO_STATUS_CD.
Test Case 2
1. Create less than 1000 audits events of Maintenance objects 'C1_PRICEASGN', 'C1_PRICELIST', 'C1_PLASSGN', 'C1_PRCRULE', 'PERSON', 'ACCOUNT'). BO_STATUS_CD of these audit entries are ‘PENDING’.
2. Run C1-DISTA batch
3. After completion of C1-DISTA batch, Batch post proc algo C1-DISAUP will get triggered and must update all audit entries with “COMPLETE” BO_STATUS_CD.
Solution
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
| Goal |
| Solution |
| References |