My Oracle Support Banner

MDB Publish Remains in Ongoing State With Implementation Class Not Found Errors for com.ofs.fsapps.alm.mdb.MDBPaymentPattern (Doc ID 2853148.1)

Last updated on JULY 18, 2023

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 8.1.1 and later
Oracle Financial Services Data Integration Hub - Version 8.1.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI / AAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Enterprise Performance Management (EPM)
Oracle Financial Services Data Integration Hub (DIH)

Symptoms

On OFSAA 8.1.1.1, MDB Publish is not getting completed and it remains in ongoing state. In the MD publish log, the log ends with the below message:

ERROR

[11-09-21 10:02:44 AM][INFO ] [MDBPublishImpl][publish]---------------------- Calling implementation class [com.ofs.fsapps.alm.mdb.MDBPaymentPattern] for [2501] ---------------------- ----------------------

MDB publish gets stuck here and in the User Interface the status remains in ongoing state.

ALM is not being implemented, only FTP.

As a workaround to publish other apps metadata, did the below:
1) Stop all the OFSAA services along with webserver.
2) Update mdb_publish_execution_dtl set status ='C' , publish_end_time=sysdate where status ='O';
commit;
3) Update MDB_POP_IMPL_LIST set include ='N' where class_name like '%alm%';
commit;
4) re-trigger MDB publish.

The issue can be reproduced at will with the following steps:
1. Navigate to metadata browser screen and trigger MDB publish by selecting the infodom.

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.