Statement Generation Program (ARXSGP): Known Issues, Patches and Enhancement Requests (Doc ID 1352529.1)

ARXSGP

ORA-1422 exact fetch returns more than requested number of rows

Please follow the doc. 

OPTIMIZER_SECURE_VIEW_MERGING. If this is set to TRUE and you are encountering this error, try setting it to FALSE and re-test.


After Make it FALSE. ORA-1422 went away.