My Oracle Support Banner

R12: PA: Causing Revenue Distributed Flag Not Updating To "Y' For Non-billable Transactions (Doc ID 2191196.1)

Last updated on AUGUST 10, 2018

Applies to:

Oracle Project Billing - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.2.4 version, Invoices

Invoice generation unprocessed expenditure items

24411463 patch causing revenue distributed flag no updating to "Y' for non-billable transactions

We recently received one off patch 24411463:R12.PJB.B. to resolve a performance related problem. This patch is causing a data issue where the revenue distributed flag is not set to "Y" in the pa_expenditure_items_all table even though the distribution lines are in the pa_cust_rev_dist_lines_all table at accepted status.

We received an unofficial version of this patch and had applied it to two other test environments. In these environments the revenue distributed flag is being set correctly but our official patch has the problem.

When we compare the files between the two one of the programs has a different version:

Good environment:
$Header paisql.lpc 120.55.12010000.229 2016/08/29 09:17:40 nihreddy ship $

Bad environment:
$Header: paisql.lpc 120.55.12010000.231 2016/08/30 09:31:34 nihreddy ship $

The issue can be reproduced at will with the following steps:
1. Run Generate Draft Revenue

The issue has the following business impact:
Users need to either roll back the patch applied immediately or have another one off solution to fix the program.
They also immediately need a data fix. They are in the process of month end reporting and all of their project reconciliation reports are affected.


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.