Metalink Note 456507.1 describes an issue with Noetix after application of ATG RUP5/6. The same applies to Sabrix too:
After applying patchset ATG RUP 5, the Noetix Views in the General Ledger business area, e.g GLIBS_JOURNAL_ENTRY_LINES, no longer return any data, even after the views were
re-generated successfully and all business areas were refreshed.
Note 452713.1 recommends applying Patch 6265836 after ATG RUP 5. The Noetix issue remains after doing so.
In Discoverer Administrator Edition, the folders in the GL business area return the error:
Table or view does not exist
ATG RUP 5
This is a known Noetix issue:
Incorrect database permissions on FND_CACHE_VERSIONS_PKG and FND_CACHE_VERSIONS granted to the Noetix/Sabrix end user layer owner.
-- To implement the solution, please execute the following steps::
To implement the fix, follow these steps:
1. Log into sqlplus as APPS or a DBA account.
2. SQL> Grant execute on APPS.FND_CACHE_VERSIONS_PKG to NOETIX_SYS;
SQL> Grant select on APPS.FND_CACHE_VERSIONS to NOETIX_SYS;
3. Log into sqlplus as NOETIX_SYS
4. SQL> Create synonym FND_CACHE_VERSIONS for APPS.FND_CACHE_VERSIONS
5. Test that the fix has worked as follows:
SQL> select je_batch_name, Acct$IBS_SERVICE
where acct$ibs_service = 'KF'
and period_name = 'JUN-07' -- this line optional if env is old
6. Migrate the solution as appropriate to other environments.
Do the steps 1 to 5 for SABRIX user too. This holds true for any bolt on which is using APPS.FND_CACHE_VERSIONS_PKG package and APPS.FND_CACHE_VERSIONS table
Blog dedicated to Oracle Applications (E-Business Suite) Technology; covers Apps Architecture, Administration and third party bolt-ons to Apps