Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
unable to query the rejected transaction details from the approval related tables
Summary:
We have a requirement to report on the approval transactions (approved/rejected) and we have built the query based on hrc_txn_fnd_bpm_task_vl and hcm_fusion_soainfra tables.. We can only see the data in hcm_fusion_soainfra tables. For approved transactions it is working fine, however for the rejected txns, the data is not present in hrc_txn_fnd_bpm_task_vl tables.. also there is an archive process which will be scheduled, does any one have idea of the archive tables in fusion and can we report on those tables. And will we get both approved and rejected transactions from those archive tables?
0