RA OEBS jobs fail with ORA-01422: exact fetch returns more than requested number of rows

book

Article ID: 193767

calendar_today

Updated On:

Products

CA Automic One Automation CA Automic Operations Manager

Issue/Introduction

All RA OEBS jobs start failing with error:
RA OEBS jobs fail with 'ORA-01422: exact fetch returns more than requested number of rows'

 

 

Cause

FND_CONCURRENT_REQUESTS table is replicated in a temporary table space

Resolution

Drop FND_CONCURRENT_REQUESTS table which has been temporarily created