Human Capital Management - EBS (MOSC)

MOSC Banner

Restrict employees by Grade

edited Mar 16, 2017 3:40AM in Human Capital Management - EBS (MOSC) 6 commentsAnswered ✓

Hello Experts

We have a requirement to restrict employees by Grade. Responsibility A users should be able to see only those employees who are in Grade 1.

I tried defining a custom rule as below but did not work. After I updated the security profile when I ran security list maintenance program getting an error

:ASSGT.GRADE_NAME not in

(select name from PER_GRADES where name not in ('A.-', 'B.-', 'C.-'))

Error:

**Starts**14-MAR-2017 16:24:36 **SQL error and free**14-MAR-2017 16:24:37 ORACLE error 1008 in FDPSTP Cause: FDPSTP failed due to ORA-01008: not all variables bound ORA-06512: at "SYS.DBMS_SQL", line 1707 ORA-06512: at "APPS.PAY_PYUCSLIS_PKG", line 1208 ORA-06512: at "APPS.PAY_PYUCSLIS_PKG", line 1566 ORA-06512: at "APPS.PAY_P14-MAR-2017 16:24:37

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

EBS HCM 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