Technology Stack - EBS (MOSC)

MOSC Banner

Profile caching in EBS

edited Feb 13, 2014 5:53AM in Technology Stack - EBS (MOSC) 6 commentsAnswered
Hi All,

I have some questions regarding profile caching in Oracle EBS.
We have exposed some pl/sql APIs through Web Services hosted on Oracle iAS servers.
In those APIs we are fetching value of a profile using fnd_profile.value API which uses a cached value.

The issue is when we are changing profile value from EBS, and when we execute web services, it still fetches the old cached value of profile .

We are updating profile value through fnd_profile.save API on EBS which updates the cache also. Is it happening due to client profile cache on iAS servers connection pool. Please advise.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center