My Oracle Support Banner

PAConInvReviewPG: The Consolidated Invoice Review Page Returns no Consolidated Invoices after Applying Patch 32743216 and Unpublished Patch 32550967 (Doc ID 2832124.1)

Last updated on MARCH 05, 2022

Applies to:

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

Symptoms

After applying patch 32743216 and unpublished patch 32550967 and generating consolidated invoices, users are not able to find the invoice in the Consolidated Invoice Review page when they try to query for it.

Query used by the page:

SELECT * FROM (Select BILLING_GROUP,
BILL_GROUP_ID,
DRAFT_INVOICE_NUM,
TRANSFER_STATUS_CODE,
INVOICE_STATUS_CODE,
INVOICE_STATUS,
CHK_STATUS,
PA_DATE,
REQUEST_ID,
APPROVED_DATE,
APPROVED_BY_PERSON_ID,
APPROVED_BY_PERSON_NAME,
RELEASED_DATE,
RELEASED_BY_PERSON_ID,
RELEASED_BY_PERSON,
INVOICE_DATE,
RA_INVOICE_NUMBER,
TRANSFERRED_DATE,
TRANSFER_REJECTION_REASON,
GL_DATE,
SYSTEM_REFERENCE,
(pa_output_tax.GET_DRAFT_INVOICE_TAX_AMT(SYSTEM_REFERENCE)) TAX_AMOUNT,
CANCELED_FLAG,
CANCEL_CREDIT_MEMO_FLAG,
WRITE_OFF_FLAG,
ORG_ID,
INV_CURRENCY_CODE,
INV_RATE_TYPE,
INV_RATE_DATE,
INV_EXCHANGE_RATE,
BILL_TO_ADDRESS_ID,
BILL_TO_ADDRESS,
SHIP_TO_ADDRESS_ID,
SHIP_TO_ADDRESS,
CUSTOMER_ID,
CUSTOMER_NAME,
BILL_TO_CONTACT_ID,
BILL_TO_CONTACT,
SHIP_TO_CONTACT_ID,
SHIP_TO_CONTACT,
REMIT_TO_ADDRESS_ID,
REMIT_TO_ADDRESS,
CREDIT_MEMO_REASON_CODE,
INVOICE_AMOUNT,
DRAFT_INVOICE_NUM_CREDITED,
CONCESSION_FLAG,
ADD_INVOICE_GROUP,
PA_INVOICE_TAX_PKG.get_estimated_tax(null,null,null, dci.BILL_GROUP_ID,
dci.draft_invoice_num) EST_TAX
FROM PA_DRAFT_CONSOLIDATED_INV_V DCI
order by BILL_GROUP_ID,
DRAFT_INVOICE_NUM) QRSLT WHERE ((bill_group_id, draft_invoice_num) IN
(SELECT di.bill_group_id, di.consolidated_inv_num FROM pa_draft_invoices_all
di where 1=1 )
 AND invoice_amount BETWEEN NVL(null,invoice_amount) AND
NVL(null,invoice_amount) AND ( UPPER(BILLING_GROUP) like UPPER(:1) AND
(BILLING_GROUP like :2 OR BILLING_GROUP like :3 OR BILLING_GROUP like
:4 OR BILLING_GROUP like :5)))

 

Steps to Reproduce:

1.  Project Billing Super User
2.  Billing | Consolidated Invoice Review | Query for a newly generated consolidated invoice or just do a wide open 'Find' - No invoices are returned

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.