My Oracle Support Banner

Error Record With Retry Status Are Not Getting Reprocessed By File Request Status Update Batch Job (Doc ID 2656972.1)

Last updated on APRIL 14, 2020

Applies to:

Oracle Financial Services Revenue Management and Billing - Version 2.8.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 2.8.0.0.0 version, MICC Transfer to TSC

ACTUAL BEHAVIOR
---------------
Error Record with Retry status are not getting reprocessed by File Request Status update batch job

1) While executing the File Request Status update batch job, getting an error for missing RESPONSE_OBJECT column in CI_FILE_REQUEST_DETAIL table. 
Workaround was to add the RESPONSE_OBJECT column in CI_FILE_REQUEST_DETAIL physical table . After applying this work around, File Request Status update batch job executed successfully.
2) After successful execution of File Request Status update batch job, records are getting updated to RET (Retry) status, but Retry count remain 0.
3) While tried re-executing the File request Processing batch job to process the Retry records, batch job went in ERROR.

Getting these issues after recent installation of below mentioned patches


Patch Number Description Comments
30130487 FORWARD PORT: BUSINESS SERVICE (C1-PAYMENTSTAGEUPLOAD) - ISSUE ON MULTIPLE TENDERS
30315213 FORWARD PORT: ENHANCEMENT IN FILE REQUEST TYPE
30411554 NO OPERATION CONFIGURED FOR CM-PBPER-BO UNDER REQUEST TYPE CM-EOCPB-PERCRT
30457544 FORWARD PORT: TRANSACTION UPLOAD THROUGH FILE REQUEST TYPE ISSUE - CI_TXN_HEADER
30547980 FILE IS NOT GETTING MOVED IN AN ERROR DIRECTORY AND FILE STATUS REMAIN PENDING
30655752 C1-FTRAN - FILE HAVING ERROR RECORDS IS GETTING SEARCHED WITH 2 STATUSES ( 'PENDING' AND 'ERROR' )
30130487 FORWARD PORT: BUSINESS SERVICE (C1-PAYMENTSTAGEUPLOAD) - ISSUE ON MULTIPLE TENDERS
 

EXPECTED BEHAVIOR
-----------------------
No mandatory filter criteria to search on File Upload Dashboard

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.