Get FND Profile Values in Oracle EBS 12.2
SELECT FND_PROFILE.VALUE (‘MFG_ORGANIZATION_ID’), FND_PROFILE.VALUE (‘ORG_ID’), FND_PROFILE.VALUE (‘LOGIN_ID’), FND_PROFILE.VALUE (‘USER_ID’), FND_PROFILE.VALUE (‘USERNAME’), FND_PROFILE.VALUE (‘CONCURRENT_REQUEST_ID’), FND_PROFILE.VALUE (‘GL_SET_OF_BKS_ID’), FND_PROFILE.VALUE (‘SO_ORGANIZATION_ID’), FND_PROFILE.VALUE (‘APPL_SHRT_NAME’), FND_PROFILE.VALUE (‘RESP_NAME’), FND_PROFILE.VALUE (‘RESP_ID’) FROM DUAL; FND_PROFILE.PUT Summary procedure FND_PROFILE.PUT (name IN varchar2, valueIN varchar2); Location FNDSQF library and database (stored procedure) Description Puts a value to the specified user profile option. If the option does not exist, you can also create it with PUT. All PUT operations are local -- in other words, a PUT on the server affects only the server-side profile cache, and a PUT on the client affects only the client-side cache. By using PUT, you destroy the synchrony between server-side and client-side profile caches. As a result, we do not recommen