Recognized Revenue Incorrectly Reversed
(Doc ID 1984213.1)
Last updated on OCTOBER 10, 2018
Applies to:Oracle Media Intellectual Property Management - Version 184.108.40.206 and later
Information in this document applies to any platform.
How to populate the DB system context / cache so the IPLS_DISTRIBUTION_ACCOUNTING.ISREVENUERECOGNIZABLE function returns the right value for recognizable licenses?
Revenue for a few licenses (which were already recognized) were reversed. However, after restarting the server, getting null value from ."pls_Business_Rule.brpkgrevrecdealstatus". below is the query.
The below function is returning "N" for all the licenses:
When exectuting the below query in production region, it is returning NULL:
Whereas, when executing the below query, it returns 7833 (which is the license status for "Confirmed" a revenue recognizable status):
Usually, when loading the context/cache using the below scripts, it works fine:
Now, even after excuted the above script, the function returns "N" for the licenses:
And, the below query still returns NULL:
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