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 laterOracle 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 |