R12: PA: Causing Revenue Distributed Flag Not Updating To "Y' For Non-billable Transactions

Last updated on MARCH 08, 2017

Applies to:

Symptoms

On : 12.2.4 version, Invoices

ACTUAL BEHAVIOR
---------------
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 $

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

BUSINESS IMPACT
-----------------------
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.

Cause