PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Unable to use GetNextNumberWithGapsCommit() on PSWLINSTMAX in PT8.47.07

edited Dec 13, 2011 7:58AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 2 commentsAnswered
We're trying to change the code which is used to increment the worklist instance number in the application package PT_WF_WORKLIST to make use of Getnextnumberwithgapscommit() on the table PSWLINSTMAX in PT8.47.07. While testing the code, we've observed that the function is expanded as "UPDATE PS_PSWLINSTMAX" instead of "UPDATE PSWLINSTMAX". The record definition is having the SQL table name as PSWLINSTMAX. This function works fine with all application tables but it doesn't work in PeopleTools tables.
Can anyone suggest that is there any other prerequisite on using this function against PeopleTools tables?

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

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center