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

Oracle HCM Inquiry Personal Payment Method and Bank Account

in Reporting and Analytics for HCM

Hi Oracle SME's,

Here is our inquiry, since moving to redwood we noticed that the bank account and personal payment method has been separated. We just need a query to help us pull and correlate both tables.

Here is an example as to why we would need this query.

  • Personal Payment Method 1 is attached to Bank Account #1 from January 1, 2024 to August 1, 2024
  • Personal Payment Method 1 is then later attached to Bank account #2 from August 2, 2024 to December 31 , 2024
  • Personal Payment Method 1 is then later attached to Bank account #3 from January 1, 2025 to End of time.

Since there is an effective dates on the personal payment method we need to verify which bank account it was attached to at a certain point in time, as what we are seeing backend is that

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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