My Oracle Support Banner

Archive Data Model for WF Tables (Doc ID 2420395.1)

Last updated on NOVEMBER 29, 2019

Applies to:

Oracle Fusion Payables Cloud Service - Version 11.12.1.0.0 and later
Oracle Fusion Global Human Resources Cloud Service - Version 11.13.18.05.0 to 11.13.18.05.0 [Release 1.0]
Information in this document applies to any platform.

Goal

Requirement is to create a custom payment remittance report to show the payment details with approval details.

To achieve this, report combines IBY_PAYMENTS_ALL A with FIN_FUSION_SOAINFRA.WFTASK B by joining A.PAYMENT_SERVICE_REQUEST_ID=B.IDENTIFICATIONKEY to get approval details.

But the result is giving a blank report.

Also, while checking the data in FIN_FUSION_SOAINFRA.WFTASK, there is no data for the specified IDENTIFICATIONKEY.

is there is any alternative table?
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution


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