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
Note:
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:
PLP_Project_GLReconciliationFact.SQ_AGG_CDL_AMOUNTS
PLP_Project_GLReconciliationFact.SQ_W_PROJ_GL_RECNCLIATION_F_A ("Cost Distributions with mismatch" dataset)
PLP_Project_GLReconciliationFact.SQ_W_PROJ_GL_RECNCLIATION_F_U
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?"
Source Wizard dialog box will open up.- 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.
W_GL_LINKAGE_INFORMATION_G.GL_ACCOUNT_ID = LKP_W_GL_ACCOUNT_D.INTEGRATION_ID AND W_GL_LINKAGE_INFORMATION_G.DATASOURCE_NUM_ID = LKP_W_GL_ACCOUNT_D.DATASOURCE_NUM_ID
W_PROJ_COST_LINE_F.COST_GL_ACCOUNT_WID=LKP_W_GL_ACCOUNT_D.ROW_WID AND W_PROJ_COST_LINE_F.CR_GL_ACCOUNT_WID=LKP_W_GL_ACCOUNT_D.ROW_WID
W_PROJ_COST_LINE_F.COST_GL_ACCOUNT_WID = COALESCE(LKP_W_GL_ACCOUNT_D.ROW_WID,#ETL_UNSPEC_NUM) OR W_PROJ_COST_LINE_F.CR_GL_ACCOUNT_WID = COALESCE(LKP_W_GL_ACCOUNT_D.ROW_WID,#ETL_UNSPEC_NUM)
Repeat the steps a. to e. for all the following three temp interfaces:
PLP_Project_GLReconciliationFact.SQ_AGG_CDL_AMOUNTS
PLP_Project_GLReconciliationFact.SQ_W_PROJ_GL_RECNCLIATION_F_A ("Cost Distributions with mismatch" dataset only. Do not add joins in "Journal Lines with mismatch" dataset)
PLP_Project_GLReconciliationFact.SQ_W_PROJ_GL_RECNCLIATION_F_U