Human Capital Management - EBS (MOSC)

MOSC Banner

Exclude terminate assignment in list of values

edited Dec 11, 2023 1:38PM in Human Capital Management - EBS (MOSC) 3 commentsAnswered ✓

Dear Oracle Community,

I would like to request assistance on how to exclude terminated assignments when I search for a position on the web page.


Please see the Value Sets for your reference.


Value Set Name: UP_HR_ASSIGNMENTS_FOR_PERSON_V2

List Type: List of Values

Security Type: No Security

Format Type: Char

Maximum Size: 250

Validation Type: Table


Validation Table Information

Table Application: Human Resources

Table Name: PER_ALL_ASSIGNMENTS_F PAF, PER_POSITIONS_V PPV, PER_ASSIGNMENT_STATUS_TYPES PAST, FND_USER FU


Table Columns: PPV.NAME

Type: Char

Size: 250


ID: PAF.ASSIGNMENT_ID

Type: Number

Size: 30


Where/Order By:

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