Understanding Real Time Indexing in HCM
Real Time Indexing (RTI) uses DirectTransfer methods to transmit search indexing data directly from PeopleSoft batch servers to the search engine. It is performed in near real-time by indexing the data as soon as it is saved.
For additional information about DirectTransfer, see PeopleSoft PeopleTools, Search Technology, "Administering PeopleSoft Search Framework," Using Direct Transfer.
High volume batch updates (for Search definitions enabled for RTI) can cause a sudden spike in the number of entries to process in the RTI staging table added by the database trigger. This can cause the database table fragmentation to go high and potentially slow down overall system performance.
If you have large volumes of batch updates, the RTI process should be temporarily turned off and when the batch is complete, perform catch-up updates to indexed data using incremental indexing before resuming RTI.
RTI switch enables the application to turn OFF RTI before initializing high volume batch programs. It turns ON RTI during the incremental indexing time for a specific search definition.
Note: If your updates are not available in the search results or analytics after the batch is complete, you have to manually run the incremental index to enable RTI.
Batch Process |
Minimum PeopleTools Release |
HCM Update Image |
---|---|---|
HRS_BTCH_LET |
8.59.09 |
Image 45 |
HRS_CRJOB |
8.59.09 |
Image 45 |
HRS_DUPE_MERGE |
8.59.09 |
Image 45 |
HRS_RESLOAD |
8.59.09 |
Image 45 |
HRS_JO_SCR |
8.59.09 |
Image 45 |
HRS_PRI_PLCM |
8.59.09 |
Image 45 |
HR_MASS_UPD |
8.59.10 |
Image 46 |
TRW_EXT_STMT |
8.59.09 |
Image 47 |
WCS_CYCLOAD |
8.59.09 |
Image 47 |
BAS_BARUN_RT |
8.59.09 |
Image 48 |
BAS_BAS04_RT |
8.59.09 |
Image 48 |
BAS_BAS05_RT |
8.59.09 |
Image 48 |
BAS_CONFSTMT |
8.59.09 |
Image 48 |
Note: Oracle's PeopleSoft recommend that you do not change the Configure Batch switch without a complete understanding of how it works, because batch processes must be specifically coded to reference the RTI Switch.
For additional information about RTI Switch, see PeopleTools: Search Technology, "Administering Real-Time Indexing" documentation.
PeopleSoft delivers search definitions that you can implement for RTI. PeopleSoft Applications Development plans to deliver more search definitions for RTI in future images.
RTI can be used on these Search Definitions as long as the minimum tools release is in effect.
Warning! Oracle recommends that you do not implement RTI for any other search definition in the PeopleSoft application at this time. The PeopleSoft system does not support RTI for any other search definition other than those listed in this table.
Search Definition |
Minimum PeopleTools Release |
HCM Update Image |
---|---|---|
HC_HR_JOB_DATA |
8.59.07 |
Image 42 |
HC_HR_PERSON |
8.59.07 |
Image 42 |
HC_TL_GBL_PAYABLETIME |
8.59.07 |
Image 42 |
HC_TL_GBL_PAYABLETIME_EXCPTN |
8.59.07 |
Image 42 |
HC_HRS_APP_INDEX |
8.59.11 |
Image 43 |
HC_HRS_APPLICANT |
8.59.11 |
Image 43 |
HC_HRS_JOB_OPENING |
8.59.10 |
Image 43 |
HC_HRS_JOB_POSTING |
8.59.10 |
Image 43 |
HC_HRS_RCMNT_ALL |
8.59.10 |
Image 43 |
HC_JPM_NONPERSON_PROFILE |
8.59.05 |
Image 43 |
HC_HRS_RECRUITER_RCMNT_ALL |
8.59.10 |
Image 43 |
HC_TL_GBL_TIMESHEET |
8.59.06 |
Image 43 |
HC_TL_GBL_TIMESHEET_SCHEDULE |
8.59.09 |
Image 43 |
HC_BEN_ADMINERR_DATA |
8.59.09 |
Image 44 |
HC_BEN_APPR_DATA |
8.59.09 |
Image 44 |
HC_BEN_ATTACH_DATA |
8.59.09 |
Image 44 |
HC_BEN_EOI_DATA |
8.59.09 |
Image 44 |
HC_BEN_LE_DATA |
8.59.09 |
Image 44 |
HC_GP_ABS_RQST |
8.59.11 |
Image 44 |
HC_HR_RWHIS_MGR_IDX |
8.59.10 |
Image 44 |
HC_HR_RWORK_INDEX |
8.59.10 |
Image 44 |
HC_HR_RWORK_MGR_IDX |
8.59.10 |
Image 44 |
HC_HR_RWORKHIS_ADM_IDX |
8.59.10 |
Image 44 |
HC_JPM_PERSON_PROFILE |
8.59.10 |
Image 44 |
HC_HS_EMPL_TEST_DATA |
8.59.13 |
Image 45 |
HC_HS_EMPL_VACC_DATA |
8.59.13 |
Image 45 |
HC_HS_INCIDENT_DATA |
8.59.10 |
Image 45 |
HC_HR_RW_EMP_VACC_INDEX |
8.59.10 |
Image 45 |
HC_HR_WF_DIVERSITY |
8.59.10 |
Image 45 |
HC_BEN_OE_APPR |
8.59.09 |
Image 46 |
HC_BEN_OE_ATTACH |
8.59.09 |
Image 46 |
HC_BEN_OE_CURR |
8.59.09 |
Image 46 |
HC_BEN_OE_ENROLL |
8.59.09 |
Image 46 |
HC_BEN_OE_EOI |
8.59.09 |
Image 46 |
HC_EP_PERFORMANCE_ADM |
8.59.10 |
Image 48 |
HC_EP_PERFORMANCE_MGR |
8.59.10 |
Image 48 |
HC_POSITION_DATA_INDEX |
8.59.22 or 8.61.01 or 8.60.11 or higher |
Image 48 |
HC_EP_PERFORM_ITEM_MGR |
8.60.11 |
Image 49 |
HC_HR_ONBOARDING_ADM |
8.61.03A |
Image 49 |
HC_HR_ONBOARDING_MGR |
8.61.03A |
Image 49 |
HC_EP_PERF_RATINGS_MGR |
8.60.11 |
Image 50 |
Note: Search definitions that are enabled for RTI prior to PeopleTools 8.59.10 are not certified for multiple languages. RTI only indexes changes made in the base language. When your system upgrades to PeopleTools 8.59.10, any index that is certified for use in the table above is certified for multiple language situations.
To build Real Time Indexes:
Perform a full index build of the indexes that you will use.
This allows a baseline index for RTI to add records.
Enable RTI on the search definition using the Configure Real Time Indexing page (
).Enter the search definition (from the list above) in the filter box.
Select the Enable Real Time Indexing check box and save.
Download the trigger sql for your database environment using the Trigger SQL link.
MSS, DB2 z/OS, and Oracle are supported.
Note: When you click the link, trigger SQL is generated for each supported database platform. Based on the browser you use, you may receive a prompt to Save the file or Cancel. Click Cancel if the prompt is for a Database platform that is different from what you use, and the next database platform’s SQL is generated.
Provide the trigger to your database administrator to apply to the database.
For additional information about configuring Real Time Indexing, see PeopleTools, Development Tools, Search Technology, "Administering Real Time Indexing."