My Oracle Support Banner

RPBATCH In EOD Failed With The Error RPBATCH01 (Doc ID 2926065.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Oracle FLEXCUBE Universal Banking - Version 14.7.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 14.6.2.0.0 version, Implementation Support

RPBATCH in EOD failed with the error RPBATCH01

ERROR
-----------------------
RPBATCH01

ANALYSIS
-----------------------
We've identified that system is trying to truncate view STTB_CUST_PART_INFO in copks_rpbatch package which is not allowed in Oracle DB.
And got failed with error 'ORA-01702: a view is not appropriate here'

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, RPBATCH in EOD failed

Changes

 Fix provided to refer proper table name instead of view name so that
processing happens successfully.

 
Components Affected
-------------------
copks_rpbatch.sql;
 
Search String
-------------

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.