Fusion Absence management - R13: Open Entitlement Agreements Page Results In ORA-00904 Error "ENT." "INTEND_TO_WORK" Invalid Id

(Doc ID 2372440.1)

Last updated on MARCH 12, 2018

Applies to:

Oracle Fusion Absence Management Cloud Service - Version 11.13.17.11.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.17.11.0 version, Absence Transactions

R13: Open Entitlement Agreements page results in ORA-00904 Error "ENT." "INTEND_TO_WORK" invalid id

When you open the Entitlements Agreements page it instantly throws ORA-00904 Error" "ENT." "INTEND_TO_WORK" invalid identifier "

Attached screenshots - confirmed that I have security access to all the tables where there is a column called "INTEND_TO_WORK"
Navigation > Person Management > Manage Absence Records > Entitlement Agreements > Add > Error.
Same config in R12 and there is no problem there.

ERROR
-----------------------
ORA-00904 Error" "ENT." "INTEND_TO_WORK" invalid identifier "


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Navigation > Person Management > Manage Absence Records > Entitlement Agreements > Add > Error.

BUSINESS IMPACT
-----------------------
The issue has the following business impact: Test environment

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