Oracle Business Intelligence Applications ETL Data Lineage Guide for Release 7.9.6.4 (Doc ID 1527475.1)

Last updated on APRIL 18, 2023

Applies to:

Purpose

Oracle Business Intelligence Applications provides a Data Lineage sheet.  The information provided in this document includes instructions on how to use this guide. This sheet explains the mapping of product to the DAC Execution Plans. Use this as a starting point to identify the appropriate physical fact table, and use following sheets in subsequent tabs to trace ETL data lineage.

This document applies to Oracle Business Intelligence Applications version 7.9.6.4.

Scope

This document is provided for information purposes only, and the contents hereof are subject to change without notice. This document is not warranted to be error-free, nor is it subject to any other warranties or conditions, whether expressed orally or implied in law, including implied warranties and conditions of merchantability or fitness for a particular purpose. We specifically disclaim any liability with respect to this document, and no contractual obligations are formed either directly or indirectly by this document. This document may not be reproduced or transmitted in any form or by any means, electronic or mechanical, for any purpose, without our prior written permission.

Please also note that not all Source Table and Source Column information is accurate. This is not a bug with the data lineage but we cannot provide that information. It is best to review the SQL Override to understand the true source.

Also note that the Spreadsheet requires the use of macros.

Copyright 2013, Oracle. All Rights Reserved.

Details

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