Need Table Storing Bank's "Active" Flag from Personal payment Methods Screen — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need Table Storing Bank's "Active" Flag from Personal payment Methods Screen

edited Aug 13, 2025 4:13PM in Reporting and Analytics for HCM 1 comment

Hello,

I'm trying to locate the backend table that stores the "Active" flag status displayed on the Personal Payment Methods > Bank Information screen in Oracle HCM (Self-Service). Specifically, I want to determine which bank accounts or personal payment methods are currently active or inactive.

If there's no direct "Active" flag stored in the database, I would appreciate any suggestions on how to identify inactive bank accounts or payment methods, possibly via end dates, status codes, or related flags across tables like PAY_PERSONAL_PAYMENT_METHODS_F, CE_BANK_ACCOUNTS etc.

Any guidance, including table/column names or sample queries, would be greatly appreciated.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!