My Oracle Support Banner

PKG_CONSOLE_UPDATE_AUDIT.P_CMN_FIELDS_U Not Adding Correct Audit Detail (Doc ID 2947102.1)

Last updated on JULY 13, 2023

Applies to:

Oracle Life Sciences Argus Safety - Version 8.2.3.1 and later
Information in this document applies to any platform.

Goal

When amending a common field e.g. E2B_ICON for Case Seriousness via the database backend package/function PKG_CONSOLE_UPDATE_AUDIT.P_CMN_FIELDS_U. The update completes fine but the audit details displayed in Argus User Interface (UI) are incomplete

Steps to reproduce:

Run an update such as below (to change E2B_ICON to enabled for Case Assessment > Seriousness field):

  

  

The field is correctly updated.

[Utilities] > Logs > View Audit Log

Search for Category = Case Fields and changes made on the date of the above update.

Note, there is a 'Changed' entry recorded by the 'System' user (although the context was not set to this user), clicking on the 'Actions' icon to view details there is no detail at all associated with the change made.

When change is made via the UI the audit is correct/complete i.e.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.