Developing a New Knowledge Module 2

g. Click the Details tab. Scroll down and select the Insert Audit Records command.
Click the icon several times to move the command up and place it right after the Create Audit Table step, as shown in the next screen. Click Save, and then close the tab.

h. Verify that your new knowledge module, IKM Oracle UI – Audit, appeared in the Knowledge Modules tree.


2. Modify the interface INT-EXP-FF-RT to be executed with your newly created knowledge module. You will need to duplicate the existing interface, rename it, and then change the IKM entry to use IKM Oracle UI-Audit.
a. On the Projects tab, right-click the interface INT-EXP-FF-RT and select Duplicate. Click Yes on the Confirmation screen.




b. Double-click the interface Copy of INT-Exp-FF-RT. Change the name of the interface to INT-Exp-FF-RT-Audit, as shown in the screen. Click the Flow tab.






c. On the Flow tab, click Target (ODI_STAGE)-Target + Staging Area to open the IKM Selection section. Select IKM Oracle UI – Audit. Ensure that in the IKM Selection
section, FLOW_CONTROL and STATIC_CONTROL options are set to false, as shown in the screen. Click the Save button, and then close the tab.





To execute your new interface, select the interface and click the Execute button .
Click OK. Click Yes to save your interface. Click OK again to start the execution.







d. Click the Operator tab to open ODI Operator. Click to open the All Executions node. If necessary, click the Refresh icon , find your new interface session, and view the session steps.

e. Scroll down and double-click the Create Audit Table step. View the content of the Definition and Code tabs for this step. Close the tab.