Payables and Cash Management - EBS (MOSC)

MOSC Banner

SYS.ROS_FND_USERS table in R12

edited Apr 10, 2017 3:05AM in Payables and Cash Management - EBS (MOSC) 3 commentsAnswered

Hi All,

I am doing retrofitment for custom package from 11i R12.

And i found below code with the table SYS.ROS_FND_USERS they are using .

***************************************************************************************************

SELECT prf.full_name

      INTO lv_usuario

      FROM hr.per_all_people_f prf

      WHERE prf.person_id =

        (SELECT employee_id FROM sys.ros_fnd_users WHERE user_id = p_user_id

        );

***************************************************************************************************

As there is no table available in R12 with the name SYS.ROS_FND_USERS it is not getting compiled.

Could someone please suggest me how can i can replace SYS.ROS_FND_USERS table in this part for proceeding further.

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