PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Do we have any details on what FirstInsertWithCommit function does?

edited Nov 28, 2017 3:16PM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered

If someone can provide details on what FirstInsertWithCommit peoplecode function does?  One example is  as below

FirstInsertWithCommit("INSERT INTO PS_EOAW_IDS (EOAWCOUNTERNAME, EOAWCOUNTER) VALUES (:1, :2)", "EOAW_HIS_COMM", 1); Which is used in EOAW_COMMENT AE process. It's mostly known issue that EOAW_COMMENT process running long in 9.2. During our internal analysis we have found 90% time (for example, in our recent run it took around 9 hrs but out of which only 10 min of time spent in SQLs. Remaining time spent in the application side) spent in the application side. Not sure what's causing this slowness in the application side. So part of it want to understand what this function does. If someone can explain would be helpful

Tagged:

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