DAC errors and solutions while doing Full Load first time for the BI Apps (OBIA)

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