6.2.1 Invalid Trigger BIU_RUPD$_D_INVOICE TRIGGER During Installation (Doc ID 1321982.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Fusion Transportation Intelligence - Version: 6.2.1 to 6.2.2 - Release: 6.2 to 6.2
Information in this document applies to any platform.

Symptoms


On OTM Version 6.2.1
When attempting to migrate to 6.2.1, the following error occurs during installation.

-- Error
BIU_RUPD$_D_INVOICE TRIGGER

Errors for TRIGGER BIU_RUPD$_D_INVOICE:
3/10 PLS-00049: bad bind variable 'NEW.AA_INSERT_DATE'

4/10 PLS-00049: bad bind variable 'NEW.AA_INSERT_DATE'

7/30 PLS-00049: bad bind variable 'OLD.AA_INSERT_DATE'

7/7 PLS-00049: bad bind variable 'NEW.AA_INSERT_DATE'

8/7 PLS-00049: bad bind variable 'NEW.AA_UPDATE_DATE'

-- Expected Behavior
That OTM would install successfully without errors.


-- Steps
The issue can be reproduced at will with the following steps.
1. Install OTM 6.2.1

Cause

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