Configuring Projects GL Reconciliation Solution for E-Business Suite 11.5.10
Projects GL Reconciliation solution is supported by default for E-Business Suite V12 and PeopleSoft V90 adaptors. To support this solution for E-Business Suite V11510 adaptor, you must perform the steps below. These steps include adding a join in the PLP GL reconciliation ODI interfaces
The additional join is required for E-Business Suite V11510 adaptor because sub-ledger accounting was introduced from E-Business Suite V12 onwards and the joins between Projects and GL source tables in E-Business Suite V11510 and V12 are different.
To Configure Projects GL Reconciliation Solution for E-Business Suite 11.5.10:
In ODI Designer Navigator, connect to your ODI repository.
Navigate to BI Apps Project, then Mappings, then PLP, then PLP_Project_GLReconciliationFact.
Source Wizard dialog box will open up. Click on Interfaces tab and search for LKP_W_GL_ACCOUNT_D. Select the lookup interface under PLP folder, give it an alias: LKP_W_GL_ACCOUNT_D, check the Use Temporary Interface as Derived Table (Sub-Select) option and click OK. Press NO when ODI prompts "Do you want to perform Automatic Mapping?"
Click on "Interfaces" tab and search for LKP_W_GL_ACCOUNT_D. Select the lookup interface under PLP folder, give it an alias: LKP_W_GL_ACCOUNT_D, check the "Use Temporary Interface as Derived Table (Sub-Select)" option and Click Ok. Press NO when ODI prompts "Do you want to perform Automatic Mapping?"
Add two joins:
- A join between W_GL_LINKAGE_INFORMATION_G and LKP_W_GL_ACCOUNT_D.
- A join between W_PROJ_COST_LINE_F and LKP_W_GL_ACCOUNT_D.
Expand Joins section on Quick-Edit tab and click on Add Joins.
After all three temp interfaces are modified and saved, navigate to PLP_Project_GLReconciliationFact, then Packages, then PLP_Project_GLReconciliationFact, then Scenarios. Right-click scenario PLP_PLP_PROJECT_GLRECONCILIATIONFACT and click Regenerate.