Hi Boris Lekumovich,
We have raised a request using request form which will be causing SOD violations. Could you let us know, in which table the violation information will be stored for particular change request. Below screenshot for reference.
We need the table information for "Rule Violations". Please let me know
Many thanks in advance !
Regards,
Devani N
I have checked that column, but how do I fetch those values which in in XML format?
Works for me.
This might be related to the SQL Developer version you are using.
I'm using 17.3
Did you try Download or Editor buttons?
Yes, I have tried to download. But the file is empty.
Are you sure there are violations in that column? If my column is null, I get a blank screen as well. If my column has data in it, then I see the xml.
If you are sure there are violations in the column, you can try the following in sqlplus (to rule out sql developer as the issue):
SQL> set pagesize 0 echo off;
SQL> set linesize 30000 long 30000 longchunksize 30000 Trimspool on;
SQL> select violations from pv_change_request where id=38;
<?xml version="1.0" encoding="US-ASCII"?>
<simple-record xmlns="http://www.aveksa.com/schemas/policy">
<record rule-id="2" rule-name="SOD" rule-desc="" entitled-id="35085" user-ent-id="" first-name="John" last-name="Ataya" user-disp-name="Ataya, John" ent-id="300" ent-type="ent" ent-name="AFX Connector, Edit All" res-name="AFX Connector" act-name="Edit All" violating-ent-type="ent" violating-ent-id="300" violating-ent-name="" violating-res-name="" violating-act-name="" bucket-id="1" app-id="1" app-name="Aveksa" state="OP"/>
<record rule-id="2" rule-name="SOD" rule-desc="" entitled-id="35085" user-ent-id="" first-name="John" last-name="Ataya" user-disp-name="Ataya, John" ent-id="339" ent-type="ent" ent-name="Account, Edit All" res-name="Account" act-name="Edit All" violating-ent-type="ent" violating-ent-id="339" violating-ent-name="" violating-res-name="" violating-act-name="" bucket-id="2" app-id="1" app-name="Aveksa" state="OP"/>
</simple-record>
Thank you Diane,
I am able to view from sqlplus.
Regards,
Devani N
In PV_CHANGE_REQUEST view there is a VIOLATIONS column (in xml format) which lists the detected violations for a specific request