Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

Why does the Cash Advance "Add" view require EMPLID to already be present on a cash advance?

edited Jun 8, 2018 6:27AM in Enterprise Service Automation (ESA) - PSFT (MOSC) 3 commentsAnswered ✓

I was having some issues using the Cash Advance Add pages (Employee and T&E), and dug into it a little.

Employee SS component is TE_ADVANCE and search record EX_ADV_ADD_VW

SELECT c.authorized_oprid

, a.advance_id

, a.advance_name

, b.name

, a.emplid

, a.adv_status

, a.creation_dt

  FROM ps_ex_adv_hdr a

  , ps_personal_data b

  , ps_ex_ee_auth_tbl c

WHERE a.adv_status = 'PND'

   AND b.emplid = a.emplid

   AND c.emplid = a.emplid

   AND c.ee_auth_level <> 'V'

T&E component is TE_ADVANCE2 and Search record EX_ADV2_ADD_VW

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center