Using the #USER_ID# event substitution variable inside a custom Event's PL/SQL condition (for example, checking that the current user isn't in a specific list) fails with 'PLS-00201: identifier IFSAPP must be declared.'

All FAQ questions / Developer Studio, deployment, and upgrades

Answer

Replace #USER_ID# with a direct call to Fnd_Session_API.Get_Fnd_User() instead — event substitution variables like #USER_ID# work in simpler condition contexts, but once the logic gets more complex (for example, wrapped inside additional PL/SQL structure), the substitution can fail to resolve correctly and instead leaves behind a broken reference that the compiler can't resolve. Calling Fnd_Session_API.Get_Fnd_User() directly returns the current session's user ID reliably in PL/SQL, avoiding the substitution-related compilation error entirely.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Developer Studio, deployment, and upgrades questions