R12: Apache Is Required To Be Bounced To See Item Update [ID 740222.1]

Cause

This issue is related to the cache component, so when someone update an item's information it will not be reflected in the customer UI because iStore will search the description in the cache and not in the database.

Solution

I. Set the Item Cache's Time-To-Live as short as possible
1. Use Functional Administrator responsibility
2. Go to Core Services > Caching Framework > Tuning
3. Search for Cache Component Name "Item Cache", click on Go
4. Click on Update
5. Configure the Cache Component as follow
Time Out Type: Time to Live
Time Out After: 5 Minutes

OR

II. Clear the cache relevant for the flow that you're using, in this case IBE_ITEM_CACHE.
1. Use Functional Administrator responsibility
2. Go to Core Services > Caching Framework > Name = Item Cache > Go
3. Check Select and press 'Clear Cache'

OR

III. Clear all the caches across all the mid-tier
1. Use Functional Administrator responsibility
2. Go to Core Services > Caching Framework > Global Configuration
3. Click on button Clear All Cache, then on Yes


For more details refer to NOTE 395439.1

GRANTING THE SELECT TO A PARTICULAR VIEW: 

How to grant SELECT access to v$session to other users?

December 18th, 2008 | Tags: Grant, V$session, v_$session

One can’t grant direct access V$session as v$session is a synonym.

SQL> GRANT SELECT ON v$session TO scott;

grant select on v$session to test

*

ERROR at line 1:

ORA-02030: can only select from fixed tables/views

– shows the V$SESSION is a public synonym

SQL> SELECT owner, object_type FROM dba_objects WHERE object_name = ‘V$SESSION’;

OWNER OBJECT_TYPE

———————— ——————-

PUBLIC SYNONYM

– shows the object (table/view) the synonym points to

SQL> select table_owner, table_name FROM dba_synonyms where synonym_name = ‘V$SESSION’;

TABLE_OWNER TABLE_NAME

————– ——————————

SYS V_$SESSION

But one can grant access the underlying table/view.