My Oracle Support Banner

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


To view full details, 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 a vibrant support community of peers and Oracle experts.