PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Define Query to Delete SBO

Hello All

I have created a SBO query to delete the changed rows

Example:

1:user created a row  Value1 = 12345,  this Value1 is part of Component Search key so we have indexed it and pushed to ES server (Full Index).

2:user deleted or changed the Value1 to 99999 , so SBO query is written to check whether any row is updated or deleted from Audit table and  ran the PTSF_GENFEED (Incremental index).

Now Value1 is deleted from ES Server but the new updated Value which is 99999 is not updated in ES Server.

How to achieve this ? And Whether SBO runs first before it push the incremental index ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center