Last updated on JANUARY 31, 2017
Applies to:Business Intelligence Applications Consumer - Version 184.108.40.206.1 and later
Information in this document applies to any platform.
- PeopleSoft 9.1.
- BI Apps 220.127.116.11.1
During our load plan execution, the session "SDE_PSFT_91_ADAPTOR_SDE_PSFT_GLACCOUNTDIMENSION" is running very slow.
Within the session there are 24 lookups to the same source table (SET_CNTRL_REC) resulting in the same dataset each time.
Each lookup takes about 5 minutes in our DEV environment (representing just a small subset of the PROD data), so just the lookups take over 2 hours to complete
Is there a way to improve this interface, so we can use the lookup just once and reuse it from the cache?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms