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 SEPTEMBER 12, 2024

Applies to:

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

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