PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Running two app engines at the same time that use/update the same table

edited Jan 22, 2020 9:23AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 3 commentsAnswered

I hope this makes sense:

I have two different app engines that update the same table. If I run both app engines at the same time, is the processing/updating compartmentalized to each app engine? Or will the updates from one affect the other's process?

For example:

App engine AppEngA inserts a bunch of rows to table PS_MyTableA. The table has a field to indicate whether the row was processed, it gets inserted as 'U'. When the app engine is finished it updates the field to indicate it's been processed: it updates all rows with SQL that says if the field = 'U', set it to 'P'. There really isn't any field (such as process id) to identify what process inserted the rows.

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