Items not Found in Search Results After Running Incremental Index (Doc ID 2899235.1)

Last updated on SEPTEMBER 28, 2022

Applies to:

Symptoms

Items not found in Search results after running Incremental Index

The issue can be reproduced at will with the following steps:
       1. Navigate : Items > Define Items and Attributes > Purchasing Attributes
       2. Enter Item ID 10099
       3. Inactivate Vendor ID SCM0000002
       4. Save
       5. Run Search Index EP_PV_MASTERITEMVENDOR_SD with Full Index Option
       6. Navigate : Items > Define Items and Attributes > Define Item
       7. Enter Item ID 10099
       8. Click Purchasing Attributes
       9. Inactivate the other vendor SCM0000003
       10. Save
       11. Navigate : Items > Define Items and Attributes > Define Item
       12. Enter Item ID 10099
       13. Click Purchasing Attributes
       14. Activate the vendor SCM0000003
       15. Save
       16. Run the Query
              SELECT * FROM PS_PV_ITEMVNDR_STG where inv_item_id ='10099' ORDER BY LASTSESUPD_DTTM DESC;
              PV_SES_ACTION updated to “D” for both vendors. This is the root cause
       17. Navigate : PeopleTools > Search Framework > Administration > Schedule Search Indexes
              Run Increment Index for EP_PV_MASTERITEMVENDOR_SD
       18. Navigate : eProcurement > Create Requisition
              Search Item 10099
       Issue : No search results found for "10099".

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.