EGM 9.2 : Grants > Grants Portal> Transaction Inquiries > Invoice & Payment Inquiry Is Not Displaying the Data Under the Unpaid Invoices and Payment Received Section for Some Awards Even When There Are Unpaid Invoices or Received Payments (Doc ID 2832421.1)

Last updated on JULY 05, 2023

Applies to:

Symptoms

After applying the fix for <Bug 32650776>, the Invoice and Payment Inquiry Page is not displaying the data under the Unpaid Invoices and Payment Received section for some awards even when there are unpaid invoices or when there are any payments received for the invoices.

Replication Steps

The grants, contracts, billing, and AR are all from one BU whereas the Project is in another BU. This is the key difference between the replication steps in the earlier <bug 32650776> vs this SR

1. Set Up Financials/Supply Chain > Install > Installation Options - Grants Portal - Project is selected as Transaction Source.
2. Create a Proposal.
3. Submit Proposal.
4. Generate an Award. When generating an award, choose the "Add to Grants Portal Security" option.
5. Activate the Contract.
6. Post Project Budgets.
7. Create an Expense transaction.
8. Run CA_BI_INTFC to process the BIL rows pertaining to the expense transactions.
9. Run Billing Interface.
10. Run Finalize and Print invoices (BIVC000).
11. Load AR pending Items.
12. Run GM_PT_STAGE. Grants > Grants Portal > Staging Data > Staging Award/Project Data.
13. Review the Grants > Grants Portal> Transaction Inquiries > Invoice & Payment Inquiry. The invoice information is NOT displayed in the Unpaid Invoices section. This is incorrect. 
14. Process Pending Items in AR.
15. Create a Deposit.
16. Create the Payment worksheet and apply the payment to the Pending item. Process payment. The ITEM_STATUS for the ITEM is now 'C'.
17. Run GM_PT_STAGE. Grants > Grants Portal > Staging Data > Staging Award/Project Data.
18. Review the Grants > Grants Portal> Transaction Inquiries > Invoice & Payment Inquiry. The invoice is completely removed from this page. This is incorrect. The information about the payment and invoice should be displayed in the Payment Received Section. This is incorrect.

Before the replication steps, the GM_PT_AWD_TRN is having data pertaining to the award and after applying the fix the data is completely wiped off for this award and this should not happen.

Replication Screenshots 

Cause

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