Unapplied and Unresolved Receipts Register report completing with Error

 "Unapplied and Unresolved Receipts" report is the replacement for "Unapplied Receipt Register". When tried to run "Unapplied and Unresolved Receipts" report for the first time, its completed with below error.

Its not a BIDI char set

Its not a BIDI language

Error executing cursor. ORA-06502: PL/SQL: numeric or value error: NULL index table key value 

ORA-06512: at "APPS.FA_RX_PUBLISH", line 2205 

ORA-06512: at line 1

Unable to execute cursor

To resolve this issue Oracle Provided data fix as mentioned in Note "Unapplied and Unresolved Receipts Register Cannot Be Submitted (Doc ID 866105.1)"

Please make sure that you will do testing in test instance.

As per Oracle the error occurs because the concurrent_program_id is null for the reports having report_ids 492 and 493.

1. Please run the following sql

select report_id, application_id, concurrent_program_id,
last_update_date,concurrent_program_name
from fa_rx_reports
where report_id in (492,493);

2. If the query results concurrent_program_id as NULL then please run the following update statement:

Update fa_rx_reports farr
set concurrent_program_id =
(Select concurrent_program_id
From fnd_concurrent_programs
Where application_id = farr.application_id
And concurrent_program_name = farr.concurrent_program_name);

3. Then run the report.