Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Payment Source and positon costing Column Query
in HCM Extract
Hi,
I am currently working in a requirement to get the below column
However, I couldn't find the payment reference, source, and position costing and tax reporting unit in the query.
Can anyone help me with this?
Payroll Statutory Unit | Tax Reporting Unit | Payment Status | Payment Source | Payment Type | Payment Method | Prepayment Action ID | Payroll | Person Number | Payroll Relationship Number | First Name | Last Name | Person Name | Payment Reference | Bank Name | Account Number | Account Name | Account Type | Payment Amount | Payment Date | Currency | Position Costing |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Here is the query I am currently working on,
SELECT DISTINCT
PPP.PRE_PAYMENT_ID PRE_PAYMENT_ACTION_ID
Tagged:
0