EBS Customizations (MOSC)

MOSC Banner

Oracle API

Hi,

Good Day.

I would like to request assistance to create and develop a custom package/ procedure to write a logic to return the required columns from base tables based on employee_id and email, and also call this package from a concurrent program and generate the XML output.

Please see the requirements below:

Request Parameters:

- Employee ID

- UP Email


Response Fields:

-Fullname (Lastname, Firstname, Middle Name/Initial)

-Employee ID

-UP Mail

-Campus

-College, Unit, Or Office

-Category (Faculty/REPS/Admin/UP Contractual/Non-UP Contractual) - For Faculty members, can we also determine whether they are full-time or part-time?

-Employment Status (Active/Inactive)

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