CN Manual Payment Upload – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Creates, updates and deletes Incentive Compensation manual payments - the Excel equivalent of the Manual Payments tab of the Paysheet Detail page (Payments, Payment Batches).

A manual payment adjusts a resource’s paysheet in an unpaid payment batch for one plan element. The paysheet must already exist and must not be locked or submitted for approval. A recoverable payment is recovered from future earnings.

Each change writes the same system note on the paysheet as the Paysheet Detail page. Text entered in Reason is added as a user note on the paysheet, once per paysheet and text.

Existing manual payments are downloaded with Upload Mode Create, Update. Only the Payment Amount and Recoverable flag of an existing manual payment can be changed; to move it to another plan element, delete it and create a new one.

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

Upload Mode, Operating Unit, Payment Batch, Pay Period, Resource Name, Unpaid Batches Only

Oracle EBS Tables Used

cn_payment_transactions_all, cn_payruns_all, cn_period_statuses_all, hr_all_organization_units_vl, jtf_rs_salesreps, jtf_rs_resource_extns_vl, cn_quotas_all, mo_glob_org_access_tmp

Report Categories

Enginatics, R12 only, 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 Example
Blitz Report™ XML Import CN_Manual_Payment_Upload.xml
SQL Source CN Manual Payment Upload.sql
Full Report on Enginatics www.enginatics.com/reports/cn-manual-payment-upload/

© Enginatics GmbH