G-Invoicing: In-Flight Orders (IFO) Performance Missing in ECC Dashboard - ORA-01403: No Data Found
(Doc ID 3034579.1)
Last updated on SEPTEMBER 05, 2024
Applies to:
Oracle Project Billing - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
In-Flight Orders (IFO) performance is not being pulled. In-Flight Orders (IFO) performance is not showing in the View Performance History page.
The original issue was logged under Bug 36563048 (G-INV IFO PERFORMANCE MISSING IN ECC DASHBOARD - ERRORS WITH ORA-01403). One off patch 36592636:R12.PA.C was released for the fix. Applied the patch, but the issue is not resolved.
Run the following query which will show the error in the table.
select perfh.perf_number, perfd.perf_process_status, perfd.error_desc, perfh.*, perfd.*
from pa.pa_proj_ginv_perf_header perfh, pa.pa_proj_ginv_perf_detail perfd
where perfh.perf_header_id = perfd.perf_header_id
and perfh.perf_number = &perf_number
order by 1;
perfd.error_desc shows the value of, error ORA-01403: no data found.
-----------
Replication Steps after one off patch 36592636:R12.PA.C applied.
1. Create IFO in G Invoicing (Other statutory type).
2. Run Intragovernmental Orders Interface Program to pull the IFO into EBS from G-Invoicing.
3. Run Intragovernmental Performance Interface Program with Get Performance List option.
4. Run ECC Load using Projects G-Invoicing ECC Data Load with the Incremental Option.
5. Verify IFO in ECC Dashboard to ensure it is created.
6. Associate the Project to the IFO Order in ECC Dashboard.
7. Perform Update Agreement and Submit for Approval.
8. Run ECC Load using Projects G-Invoicing ECC Data Load with the Incremental Option.
9. Verify the Performance from View Performance History Page. No Performance is showing.
10. Run Intragovernmental Performance Interface Program with the Get Performance List option
11. Queried from performance table and noticed that performance exists in the table with error description (error ORA-01403: no data found).
Query run:
select perfh.perf_number, perfd.perf_process_status, perfd.error_desc, perfh.*, perfd.*
from pa.pa_proj_ginv_perf_header perfh, pa.pa_proj_ginv_perf_detail perfd
where perfh.perf_header_id = perfd.perf_header_id
and perfh.perf_number = &perf_number
order by 1;
perfd.error_desc shows the value of, error ORA-01403: no data found.
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 |
Cause |
Solution |
References |