Symptom
- When trying to "import by name" a table like "AX.AX_SLE_LINES" from Oracle Applications via Oracle Applications Data Store, the table is missing one column: SET_OF_BOOKS_ID
Reproducing the Issue
Environment:
- OS: Windows 2003 SP1
- Data Integrator version 11.7.3.3
- Oracle General Ledger Rapid Mart version 11.5.1.3
- Oracle Applications version 11.5.10.2
- Oracle DB version 10.2.0.2
- Use "import by name" to import a table like "AX_SLE_LINES", with owner "AX" from Oracle Applications via an Oracle Applications Data Store
Cause
- When you import tables into Data Integrator repository via Oracle Apps Data Store their definition is read from Oracle Apps Object Library (FND_TABLES, FND_COLUMNS) and the column in question does not exist in those tables
Resolution
- Oracle Apps do not expose AX.AX_SLE_LINES.SET_OF_BOOKS_ID column in the Object Library tables (FND_TABLES, FND_COLUMNS) read by Oracle Apps Data Store to Rapid Mart. So this is expected behavior for Data Integrator Rapid Marts, especially when customizing the pre-build solution by adding extra tables,etc
- Solution:
1. By using an Oracle Database datastore, the table definition is read from the database library directly, hence SET_OF_BOOKS_ID column shows up.2. A more complex approach which requires more experience with the product is to export the Oracle Apps Data Store to an .atl file, modify the file content using notepad to add the missing column in the table metadata definition.
- Note: This resolution can be applied to any Oracle Apps with metadata missing, when one needs to apply Rapid Mart customization. The AX.AX_SLE_LINES table is not used by any Rapid Marts.
Keywords
Rapid Mart, Oracle Applications
Header Data
| Released On | 31.03.2009 09:56:35 | ||
| Release Status | Released to Customer | ||
| Component | EIM-DI Data Integrator, Composer | ||
| Priority | Normal | ||
| Category | How To | ||
| Database |
| ||
| Operating System |
|
No comments:
Post a Comment