I have report that I am running in my production environment. When I copied this report in different domain with all the .FEX files that this report calls. I am getting different data outputs. Is it because internal names for the files change everytime you copy?
Did anybody ever have the same problem? How to get around this problem? Code for the report that is calling other FEX is as fllows:

  ---------------------------------------------------------------------
-SET &ECHO      = ON;
&INDT5='&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;';
&INDT7='&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;&|nbsp;';
-INCLUDE app/00_setting.fex
-INCLUDE app/01_billing.fex
-INCLUDE app/02_enrollment.fex
-INCLUDE app/03_fte.fex
-INCLUDE app/04_net_revenue.fex
 USE
  BILLAGG0  AS BILLAGG0
  ENRLAGG0  AS BILLAGG0
  FTE_AGG0  AS BILLAGG0
  TOTNETREV AS BILLAGG0
 END
-RUN
-INCLUDE app/10_total.fex
-INCLUDE app/11_assemble.fex
-*------------------------------------------------
 SET EMPTYREPORT=ON
 USE CLEAR
 USE
 WKRVAGG1  AS WKRVAGG6
 WKRVAGG2  AS WKRVAGG6
 WKRVAGG3  AS WKRVAGG6
 WKRVAGG4  AS WKRVAGG6
 WKRVAGG6  AS WKRVAGG6
 WKRVAGG7  AS WKRVAGG6
 WKRVAGG8  AS WKRVAGG6
 WKRVAGG9  AS WKRVAGG6
 WKRVAGG10 AS WKRVAGG6
 ENRLAGGT  AS WKRVAGG6
 ENRLAGGP  AS WKRVAGG6
 END
-RUN
-*---------------------------------------------------------------------
-SET &SORT   = ' ';
-SET &DISPBURST = IF &BURST EQ 'MAX.DISTRICTID' THEN '<DISTRICTID' ELSE
-                 IF &BURST EQ 'MAX.DIVISIONID' THEN '<DIVISIONID' ELSE
-	        	  IF &BURST EQ 'MAX.SCHOOLID'   THEN '<SCHOOLID'   ELSE ' ';
-*-RUN
-*-TYPE &SORT
-*-TYPE &BURST
-*-TYPE &DISPBURST
-*-RUN
-*-EXIT
 DEFINE FILE WKRVAGG6
 CP_DESC/A35  = IF CP EQ 'CP' THEN '                    Current Period' ELSE
                IF CP EQ 'PP' THEN '      Prior Periods' ELSE
                                   'Unknown Period';
 L2/A1        = IF LITM2 EQ ' ' THEN '~' ELSE EDIT(LITM2,'9');
 L3/A10       = IF LITM3 EQ ' ' THEN '~' ELSE EDIT(LITM3,'9999999999');
 LITMORD/A22  =
                IF LITM1 EQ 'Tuition'                THEN '01' ELSE
                IF LITM1 EQ 'Discounts'              THEN '02' ELSE
                IF LITM1 EQ 'Registration'           THEN '03' ELSE
                IF LITM1 EQ 'Other Revenue'          THEN '04' ELSE
                IF LITM1 EQ 'NET REVENUE'            THEN '05' ELSE
                IF LITM1 EQ 'FTE'                    THEN '06' ELSE
                IF LITM1 EQ 'License Capacity / %UE' THEN '07' ELSE
                IF LITM1 EQ 'Enrollments'            THEN '08' ELSE
                IF LITM1 EQ 'Net Enrollments'        THEN '09' ELSE
                IF LITM1 EQ 'New Enrollments'        THEN '10' ELSE
                IF LITM1 EQ 'Withdraws'              THEN '11' ELSE
                IF LITM1 EQ 'Enrollments Unsched.'   THEN '12' ELSE  EDIT(LITM1,'9999999999999999999999');
-*			                                              '*';
 COLPREFX/A10 = IF COLENT CONTAINS 'Ch' THEN 'Chg PY' ELSE
                IF COLENT CONTAINS '%'  THEN ' '      ELSE
			                                 'Total';
 COLLETTR/A1  = IF EDIT(COLENT,'$$$$$$9') NE ' ' THEN 'W' ELSE 'P';
 COLNUMBR/A2  = IF EDIT(COLENT,'$$$$$$9') NE ' ' THEN EDIT(COLENT,'$$$$$$9') ELSE
                IF EDIT(COLENT,'$$$$9')   EQ '0' THEN EDIT(COLENT,'$$$$$9')  ELSE
                                                      EDIT(COLENT,'$$$$99');
 COLPSTFX/A2  = IF COLENT CONTAINS '%' OR 'Ch' THEN '%' ELSE ' ';
 COLTITLE/A20 = ' ' || COLPREFX || (' '|COLLETTR || COLNUMBR || (' '|COLPSTFX));
 AMTF/P15.2   = IF LITM1 EQ 'License Capacity / %UE' AND COLENT OMITS '%'
                                       THEN (AMOUNT1)                       ELSE
                IF LITM1 EQ 'License Capacity / %UE'
                                       THEN (AMOUNT2/AMOUNT1)*100           ELSE
                IF AMOUNT2 EQ 0        THEN (AMOUNT1)                       ELSE
                IF COLENT CONTAINS '%' THEN (AMOUNT1/AMOUNT2)*100           ELSE
                                            (AMOUNT1-AMOUNT2)/AMOUNT2*100 ;
 fmt/A8       = IF COLENT CONTAINS '%' OR COLENT CONTAINS 'Ch' THEN 'D10.1%' ELSE 'D13CB';
 LITM1D/A25   = IF L2 EQ '~' THEN ' Total ' | EDIT(LITM1,'99999999999999999') ELSE LITM1;
 LITM2D/A25   = IF LITM2 EQ 'N/A' THEN ' ' ELSE LITM2;
 LITM3D/A1    = IF LITM3 EQ 'Infant' OR 'Infant I'      THEN 'A' ELSE
               	IF LITM3 EQ 'Toddler 1' OR 'Toddler I'  THEN 'B' ELSE
				IF LITM3 EQ 'Toddler 2' OR 'Toddler II' THEN 'C' ELSE
				IF LITM3 EQ 'Preschool'                 THEN 'D' ELSE
				IF LITM3 EQ 'UPK'                       THEN 'E' ELSE
				IF LITM3 EQ 'Kindergarten'              THEN 'F' ELSE
				IF LITM3 EQ 'School Age'                THEN 'G' ELSE
				IF LITM3 EQ 'Other'                     THEN 'H' ELSE
				IF LITM3 EQ 'NONE'                      THEN 'I' ELSE
				IF LITM3 EQ 'Null'                      THEN 'J' ELSE 'K';
FLAG/I1       = IF LITM2 EQ 'N/A' AND LITM3 EQ ' ' THEN 1 ELSE 0;
BLA/A1        = ' ';
COLCONCAT/A11 = COLPREFX | COLLETTR;
END

This message has been edited. Last edited by: Kerry,

Arif,

Is the data the same in both domains? Are they pointing to different data, perhaps?

quote:

Arif,

Is the data the same in both domains?

Data is same in both domains. both domains are in the same environment. Both domains are pointing baseapp datafloder on the same server (same metadata). Is it still going out of domain to call fex eventhough a copy of fex is available in the same domain?

Have you checked the internal names in the domain where the .fexes where copied? It is possible that they change name on a copy. This will happen if they already exist in the domain, even if it is in a different folder. I have noticed in 7.6.8 that sometimes WF creates a pop-up and asks if you want to overwrite, rename or cancel and other times it just copies and renames them.