Changes
for the Errors :
1.
SDE_ORA_GL_LinkageInformation_Extract
Cause : Temp Tablespace
Problem
Solution : Added 30GB in
Temp Tablespace in both (Apps and Datawarehouse) database for 1 year of data
(Required more tempspace for more years of load)
2.
SDE_ORA_GLSegmentDimension
Error : Value larger than
specified precision allowed for this column.
Temp Solution : Alter
column SEGEMENT_VAL_CODE size to 150 from 50.
Solution : Check the SR
for the solution
3.
SDE_ORA_CodeDimension_FND_Flex_Mcat
Error : 1- The Task was
not added in Parameters file
2- $$PROD_CAT_SET_ID1 - Inventry
Solution : add the task to
the parameter file (copy the other task parameter having similar name and paste
it to the file with the required name).
And $$PROD_CAT_SET_ID = 1 and $$INV_PROD_CAT_SET_ID = 1
4.
SDE_ORA_EmployeeExpenseFact_FP_Full
Need
Patch on EBS – Patch 11i.FIN_PR/11i.OIE.I family Pack (Not required)
Solution
– Inactive Subject Area Employee Expense
5.
SDE_ORA_PeggingDetailsFact and
SDE_ORA_PeggingDetailsFact_ASCP
Error :
Invalid Identifier
Solution
: Inactive the Task
6.
SDE_ORA_Project_Hierarchy
and SDE_ORA_Project
(Subjaect
Are – Planing Analysis)
Error :
Invalid Identifier
Solution
: Inactive the Task
7.
SIL_GLSegmentDimension
Error :
Index creation failed
Solution
: Create Index manually and mark the task as completed
8.
Subject Area : Supply Chain – BOM Item
Tasks : SDE_ORA_BOMHeaderDimension
SDE_ORA_BOMHeader_Auxillary
SDE_ORA_BOMItem_Fact
ERROR : Invalid Identifier
Solution : Patch required on EBS
9.
SDE_ORA_ProductDimension_Derive_Full
Error : Value too large
Solution : Double the column length in
mapping and in target table.
10.
SDE_ORA_CustomerAccountDimension_Full
Error : Value too large
Solution : Double the column length in
mapping and in target table.
11.
SDE_ORA_SalesProductDimension_Full
Error : Value too large
Solution : Double the column length in
mapping and in target table
12.
SDE_ORA_CustomerFinincialProfileDimension_ProfileAmts_Full
Error : Value too large
Solution : Double the column length in
mapping and in target table
13.
SIL_BOM_ItemFact_Full
Error : An error occurred executing
the stored procedure
PLS
– 00201 : identifier ‘COMPUTE_BOUNDS_ORA11i’ must be declared
Solution : Navigate to the
OracleBI\dwrep\Informatica\Stored_Procedure
Folder and copy the codes of
COMPUTE_BOUNDS_ORA11i.sql and compile(run) into the
Dataware House database.
14.
$$SET_OF_BOOKS_TYPE_LIST = ‘N’
15.
Subject Area - SDE_ORA_ProductDimension_Full
Task : SDE_ORA_ProductCategories_Resolve
Error : [Error(transformation error)]
Solution :
Remove default value [Error(transformation error)] from port created_by_ID and
change_by_ID from the update stratigy Upd_Strategy_W_ORA_Product_DS_Tmp_Ins_upd
16.
SDE_ORA_GLBalanceFact
Error : ORA-01488 Value larger than specified precision allowed
for this column
17.
SDE_ORA_UOMConversionGeneral_InterClass
Cause : Taking long time to
run (40-50 min) and then failing without any error
Source table –
MTL_UNITS_OF_MEASURE
MTL_UOM_CLASS_CONVERSIONS
Changes as
per SR :
Cause : Succeeded in Informatica monitor but
failed in DAC
Solution : Delete the Parameter $$YEAR_START
from mappings and from the Tasks
a.
PLP_ARXactGroupAccount_A2_Load
b.
PLP_GLCogsGroupAccount_A2_Load
c.
PLP_GLOtherGroupAccount_A2_Load
d.
PLP_GLRevenGroupAccount_A2_Load
