Skip to the content.

IBY Payment Process Request Details – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™. Oracle EBS module: Payments · all Payments reports

Overview

Payment manager process request details including statuses, paid or rejected documents, amounts and rejection eror messages

Run this report in Excel in seconds: download Blitz Report™ free (your first 30 reports are free) or try it in the online demo.

Report Parameters

Operating Unit, Payment Process Request, Payment Process Request Status, Payment Status, Request Creation Date From, Request Creation Date To, Request Created By, Internal Bank Account, Trading Partner, Rejected or Failed Only, Exclude Removed Documents, Expand Error Details, Exchange Rate Type, Show Invoice Distributions, Hierarchy Segment, Hierarchy

Oracle EBS Tables Used

fnd_flex_value_norm_hierarchy, iby_payments_all, gl_daily_conversion_types, ce_bank_accounts, iby_validation_sets_vl, iby_pay_service_requests, ap_invoice_distributions_all, iby_transaction_errors, xxen_report_org_access

Report Categories

Enginatics, R12 only

AP Invoices and Lines, AP Accounted Invoice Aging, AP Invoice Upload, AP Supplier Upload, CE Bank Statement and Reconciliation, AP Invoice Payments, GL Account Distribution Analysis, AR Customer Upload

Running This SQL Without Blitz Report

The SQL source can be run in any SQL client. Some Oracle EBS SQL reports in this library use functions from the utility package xxen_util – install it first. Blitz Report™ adds parameters, Excel output with pivots, scheduling and security on top.

Download & Import Options

Resource Link
Excel Example Output IBY Payment Process Request Details 25-Jan-2021 024851.xlsx
Blitz Report™ XML Import IBY_Payment_Process_Request_Details.xml
SQL Source IBY Payment Process Request Details.sql
Full Report on Enginatics www.enginatics.com/reports/iby-payment-process-request-details/

IBY Payment Process Request Details - Case Study & Technical Analysis

Executive Summary

The IBY Payment Process Request Details report provides a deep dive into the “Payment Process Request” (PPR) in Oracle Payments (IBY). A PPR is the central object that groups invoices for payment. This report details the lifecycle of a payment batch: which invoices were selected, which were rejected (and why), the status of the payment file generation, and the final payment amounts. It is a critical tool for the Accounts Payable department to manage mass payment runs.

Business Use Cases

Technical Analysis

Core Tables

Key Joins & Logic

Key Parameters


© Enginatics GmbH