Why Does Dynamic SQL "select FND_PROFILE.VALUE('RESP_ID') from dual;" Used in AME Change its Value?

(Doc ID 1642516.1)

Last updated on DECEMBER 21, 2016

Applies to:

Oracle Approvals Management - Version 12.1 and later
Information in this document applies to any platform.

Goal

Why does below dynamic SQL used in AME change its value?

 

Solution

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