Enterprise Service Automation (ESA) - PSFT (MOSC)

MOSC Banner

HR to FIN Employee bank account tables for Expenses to support NACHA encryption

edited Dec 15, 2022 6:14PM in Enterprise Service Automation (ESA) - PSFT (MOSC) 2 commentsAnswered

Hi,

Does anyone know which tables we need to load the employee bank account information besides PS_DIRECT_DEPOSIT and PS_DIR_DEP_DISTRIB for Expenses to be able to load the employee bank account from HR into FIN as encrypted.

We used custom SQR that would populate PS_DIRECT_DEPOSIT and PS_DIR_DEP_DISTRIB from HR to FIN. Need to understand which other table need to be populated from HR so that after running process (Travel and Expenses -> Manage Employee Information -> Load Employee Data. Check box Load Employee Bank Data), the bank account is populated as masked on Employee Profile page (Travel and Expenses -> Manage Employee Information -> Update Employee Detail. Page Bank Accounts).

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