SQL Query Example On How To Get Flow Instance Name Linked With The EFT Payments And The Element Group (Doc ID 2483858.1)

Last updated on MAY 08, 2023

Applies to:

Goal

We need an SQL query to get Flow Instance Name link with the EFT.

Details:
We need the scripts or table name links to get the flow name of "Make EFT Payments".
In this Process run how many employees are paid using this Flow Instance.

Currently we have a custom report which generates the EFT file process and send it to the Bank.
Query 1: Now our requirements are based on the Flow Instance Name we need to get which are all the employees are paid for that Flow Instance based on the Flow instance (report parameter).
Q1.1 We are unable to get the link between the flow instance and payment tables.

Basically what we are looking, we were starting processing for three scenarios.
1. Normal Payroll Run (End of 25th of every month)
2. End of Service - Terminated Employees ( Using Quick Pay)
3. Special Allowances - Like Business Travel (Every Month).

Assume we have three Flow Instance Name (Nov BTR Payroll Run, Nov EOS Quick Pay & Nov Payroll Run).

Query 2. Now we have a custom report to send the Payment details to the Bank. Bankers are requested us to provide one Transaction Code like
Every Payroll as SAL, Allowances as ALW & Terminated Employees for EOS.
In order to Achieve, we are using three different Make EFT payments and some time we will combine all in One.
Q2.1 So what we are looking if we get the Element Group when we do the Calculate payroll it could help us. But we are unable to find which table holds on the Element Group. If you provide the Element Group table name it should be very helpful for us.

Query 3. The last question, If possible how do we link this element group with the EFT Payments. If you have any link provide us.

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.