Intended Use update in Fiscal Invoice Lines Open Interface is failing with ORA-01422 error (Doc ID 2646496.1)

Last updated on APRIL 14, 2020

Applies to:

LAD Add-on Localizations - Version 12.1 and later
Information in this document applies to any platform.

Version 12.1: Brazil Consulting Localizations

Actual Behavior

Intended Use update in Fiscal Invoice Lines Open Interface is failing with ORA-01422 error.

Expected Behavior

Intended Use update in Fiscal Invoice Lines Open Interface should complete without any error.

Steps

The issue can be reproduced at will with the following steps:

Responsibility: Integrated Receiving
Navigation: Receipts > Open Interface
Find any Fiscal Invoice
Click Lines
On Invoice Lines tab, enter a new value for Intended Use Id or Intended Use Code

The following error message is exhibited:

Error Message: FRM-40735: WHEN-VALIDATE-ITEM trigger raised unhandled exception ORA-01422

Business Impact

Due to this issue, incorrect Intended Uses cannot be fixed in Fiscal Invoice Lines of Open Interface.

N/A

	To view full details, sign in with your My Oracle Support account.
	Don't have a My Oracle Support account? Click to get started!

In this Document

Symptoms

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.