My Oracle Support Banner

When Performing A RUA Action It Throws Error "Cannot Perform Insert" (Doc ID 2373179.1)

Last updated on MARCH 20, 2018

Applies to:

Oracle Retail Invoice Matching - Version 14.0.3 and later
Information in this document applies to any platform.

Symptoms

When performing a RUA action it throws error "Cannot perform insert"

After resolving an issue with RUA Action, and click OK button it shows the Error "Cannot perform insert".

Error:

In the ReIM online log it capture the error "PL/SQL: numeric or value error devuelto por la unidad de programa RMSSUB_OTBMOD.CONSUME" on the trigger that performs the adjustment (REIM_TABLE_IRUA_AIR).


### Steps to Reproduce ###

1) Create a order, ship and receive ex: 100 qty

2) Create a invoice with qty 80

3) Run automatch

4) In a process with quantity discrepancy, go throw the resolution process by select that the invoice is correct and then select a reason that will adjust the receipt.

5) One all information is provided, click ok button.

Observe:

it shows the Error "Cannot perform insert". In the ReIM online log it capture the error "PL/SQL: numeric or value error devuelto por la unidad de programa RMSSUB_OTBMOD.CONSUME" on the trigger that performs the adjustment (REIM_TABLE_IRUA_AIR).

Changes

 

Cause

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.