Unable to save WIP Completion Return transaction in an OSP batch

Applies to R12.

Whenever you try to do “WIP Completion Return” transaction in an OSP batch the system will throw this error message, because as of now India Localization does not support return transactions.

Unexpected ORA-20001: APP-20110: You can not reduce the Actual Quantity

ORA-06512: at “APPS.APP_EXCEPTION”, line xx

ORA-06512: at “APPS.JAI_OPM_GMD_A

Even in 11i the same bug was there, but the error message will clearly provide us the information regarding the trigger obstructing the transaction.

 

Solution:

Oracle suggests to disable the trigger “JAI_OPM_GMD_ARIUD_T1” and complete the transaction.

Disabling the trigger:

ALTER TRIGGER JAI_OPM_GMD_ARIUD_T1 DISABLE

Complete the transaction.

Enabling the trigger:

ALTER TRIGGER JAI_OPM_GMD_ARIUD_T1 ENABLE

---X---