R12:JL: Ora-01422 WHEN-NEW-FORM-INSTANCE trigger raised in JLBRPCCD

(Doc ID 790136.1)

Last updated on APRIL 10, 2018

Applies to:

Oracle Financials for the Americas - Version 12.0.6 and later
Information in this document applies to any platform.
This problem can occur on any platform.
Oracle Applications for Brazil


On 12.0.6 in Production:
Find When trying to select the option from Menu --> Maintain Interface, following:
Brazilian Localizations > Collections Documents > Maintain Interface

Occurs the error:
ORA-01422: exact fetch returns more than requested number of rows
FRM-40735: WHEN-NEW-FORM-INSTANCE trigger raised unhandled exception ORA-01422.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
AP > Brazilian Localizations > Collections Documents > Maintain Interface


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms