Oracle Revenue Management and Billing (ORMB): Invalid Packagebody - PKG_RMB_DELETE_BILL
(Doc ID 2541769.1)
Last updated on FEBRUARY 10, 2020
Applies to:
Oracle Financial Services Revenue Management and Billing - Version 2.4.0.1.0 and laterInformation in this document applies to any platform.
Goal
On : 2.4.0.1.0 version, IP - Installation Upgrade Proc
RMB: invalid packagebody - PKG_RMB_DELETE_BILL
With ORMB version 2.4.0.1 and in the process of applying roll up and recent security patches.
Below were applied on one of the non-prod instances and seeing one extra INVALID package body.
Can it be confirmed whether any action is need on an invalid object?
As per guide “Oracle_Revenue_Management_and_Billing_Database_Administrator's_Guide.pdf”
Grant Permissions to the DBMS_LOCK Package and Recompile Database Objects
Steps for solution-
Linux:
export ORACLE_SID=[DB_NAME]
sqlplus /nolog conn sys as sysdba
grant EXECUTE, DEBUG on DBMS_LOCK to ;
@?/rdbms/admin/utlrp.sql;
By following above guide package body valid now, please confirm its a correct resolution from your end.
Solution
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
| Goal |
| Solution |
| References |