After 12.2.4 Upgrade Package Body 'FND_JAF_LOG_EVENT_PKG' Is Invalid with Error 'ORA-00932: inconsistent datatypes: expected TIMESTAMP WITH TIME ZONE got NUMBER'

(Doc ID 2190825.1)

Last updated on OCTOBER 12, 2016

Applies to:

Oracle Applications Manager - Version 12.2.4 to 12.2.6 [Release 12.2Cloud to 12.2]
Information in this document applies to any platform.

Symptoms

After an upgrade EBS from R12.1.3 to R12.2.4, the status of package body 'FND_JAF_LOG_EVENT_PKG' is invalid and if you try to compile by

 

Changes

 Upgrade from 12.1.3 to 12.2.4.

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