R12: PA: Causing Revenue Distributed Flag Not Updating To "Y' For Non-billable Transactions
Last updated on MARCH 08, 2017
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:
$Header paisql.lpc 120.55.12010000.229 2016/08/29 09:17:40 nihreddy ship $
$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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms