Hi,
I've been trying for some days now to gain access to the audit trail of a process executed in the Oracle Process Server 10.1.3.1.
What I am ultimately aiming at is modifying the audit trail (adding semantic information to the messages passed).
An example:
<inputVariable>
<part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="payload"><ns1:myLoanProcessProcessRequest xmlns:ns1="http://xmlns.oracle.com/myLoanProcess">
<ns1:SSN>123456781</ns1:SSN>
<ns1:email>demo@oracle.com</ns1:email>
<ns1:customerName>Raj</ns1:customerName>
<ns1:loanAmount>10000.0</ns1:loanAmount>
<ns1:carModel>Mercedes</ns1:carModel>
<ns1:carYear>1998</ns1:carYear>
<ns1:creditRating/>
</ns1:myLoanProcessProcessRequest>
</part>
</inputVariable>
would need to be modified so that it looks like
<inputVariable>
<part xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" name="payload"
sawsdl:modelReference="someOntology.owl#CarRequest" bia:source="dbx:myTable">
<ns1:myLoanProcessProcessRequest xmlns:ns1="http://xmlns.oracle.com/myLoanProcess">
<ns1:SSN>123456781</ns1:SSN>
<ns1:email>demo@oracle.com</ns1:email>
<ns1:customerName>Raj</ns1:customerName>
<ns1:loanAmount>10000.0</ns1:loanAmount>
<ns1:carModel>Mercedes</ns1:carModel>
<ns1:carYear>1998</ns1:carYear>
<ns1:creditRating/>
</ns1:myLoanProcessProcessRequest>
</part></inputVariable>
For that I would need to do the following (all done inside a Java program):
(1) Retrieve the complete audit trail from the database
(2) Do my modifications with some XML API (not a problem)
(3) Store the modified audit trail back to the database
From what I was able to gather so far:
- The audit trail is either stored in audit_trail or audit_details
- It isn't stored as raw xml, but rather compressed (somehow the solution in
1788164 didn't work for me - it doesn't insert the uncompressed XML data into the new table)
- There exists some kind of Java API that allows me to retrieve audit data?
So, summing it up: What I want to do is retrieve the Audit XML file as I get it when looking at the audit trail from the BPEL console, then modify it and save it back - how do I do it?
Thanks a lot for your time,
Florian
edit: spelling