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 Workload Automation - Automation Engine
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
Feedback
thumb_up
Yes
thumb_down
No