OraFAQ Forum: SQL & PL/SQL » Query is not running from 11.2.0.3 to 11.2.0.4

Home » SQL & PL/SQL » SQL & PL/SQL » Query is not running from 11.2.0.3 to 11.2.0.4 (11.2.0.4)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Query is not running from 11.2.0.3 to 11.2.0.4 [message #646549]

Mon, 04 January 2016 04:30

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Hi All,

We are using clarity PPM tool which contains the NSQL (intern SQL queries). One query is running from application(clarity) side which is calling to 11.2.0.3 database. Same query is not running from application side after oracle upgrade to 11.2.0.4. Producing the following error.
/forum/fa/12956/0/

/forum/fa/12956/0/

Please advice on this if anybody have an idea.

Attachment: Error.jpg
(Size: 17.67KB, Downloaded 1446 times)

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646550 is a reply to message #646549]

Mon, 04 January 2016 04:33

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Do you not think it would helpful to show us the actual query?
Also do you get the same result if you run the query using sqlplus on both DBs?

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646552 is a reply to message #646550]

Mon, 04 January 2016 05:01

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

In 11.2.0.4 there is a fix for Bug that ORA-00979 was NOT raised in earlier versions when it should have been. (ID 13486825)

Bit me on a one query when I updated. Was solved by correcting the affected query.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646554 is a reply to message #646552]

Mon, 04 January 2016 06:33

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Please find the query as below.The output is same in both the DBs. Mean time I will check the below mentioned Bug Id from oracle support.

SELECT /*+ noparallel */
	BMS_DATE_KEY KEY,
	BMS_DATE BMS_DATE,
	SCHEDULED SCHEDULED,
	ACTUAL ACTUAL,
	OVERDUE OVERDUE,
	OBS_ID OBS,
	CPM_ID CPM,
	CFR_ID CFR,
	PROJ_ID PROJ,
	PROG_M_ID PROG_M_ID,
	LM_ID LM_ID,     
	IS_ACTIVE IS_ACTIVE,
	RECORD_TYPE RECORD_TYPE,
	CURRENCY CURRENCY

FROM
(
	SELECT 	BMS_DATE_KEY
			, BMS_DATE
			, SCHEDULED
			, OVERDUE
			, ACTUAL
			, :param_branch_unit_id	OBS_ID
			, :param_eri_cpm 		CPM_ID
			, :param_eri_cfr 		CFR_ID
			, :param_eri_proj_num	PROJ_ID
			, :param_eri_prog 		PROG_M_ID
			, :param_eri_lm 		LM_ID
			, :param_is_active 		IS_ACTIVE
			, :param_record_type		RECORD_TYPE
			, :param_proj_currency 	CURRENCY
	FROM
		(
      WITH INV AS
      (
        SELECT /*+ ordered */
          INV.ID
        FROM
          INV_INVESTMENTS 		INV 
          INNER JOIN 		ODF_CA_PROJECT 			OP 	ON 	INV.ID = OP.ID 
            AND ((:param_eri_proj_num IS NULL) OR (OP.ERI_PROJ_NUMBER = :param_eri_proj_num))
            AND ((:param_eri_prog IS NULL) OR (OP.ERI_PMO_MANAGER = :param_eri_prog))
            AND ((:param_eri_lm IS NULL) OR (OP.eri_line_manager = :param_eri_lm))
            AND ((:param_eri_cfr IS NULL) OR (OP.ERI_CFR = :param_eri_cfr))
          INNER JOIN	PRJ_OBS_ASSOCIATIONS	ASSOC	ON	INV.ID = ASSOC.RECORD_ID 
            AND ASSOC.TABLE_NAME = 'SRM_PROJECTS' 
          INNER JOIN	PRJ_OBS_UNITS_FLAT 		FLAT 	ON	ASSOC.UNIT_ID = FLAT.UNIT_ID
						AND (FLAT.BRANCH_UNIT_ID = :param_branch_unit_id)
          INNER JOIN	PRJ_OBS_UNITS 			UNT		ON  ASSOC.UNIT_ID = UNT.ID
        WHERE 1=1
          AND ((:param_is_active IS NULL) OR (INV.IS_ACTIVE = :param_is_active))
          AND ((:param_eri_cpm IS NULL) OR (INV.MANAGER_ID = :param_eri_cpm))
          AND		INV.ID in (select object_instance_id from odfsec_project_v2 where user_id = 1)
      )
			SELECT /*+ ordered */
				PERIOD.CODE BMS_DATE_KEY
				, PERIOD.NAME BMS_DATE
				, SUM(NVL2(ACTUAL_DATE, 0, DECODE(NVL(FD_STATUS, 0), 5, 0, DECODE(NVL(BMS_PAST_DUE, 1), 0, C_PLAN_BILL, 1, 0, 0)))) AS SCHEDULED
				, SUM(NVL2(ACTUAL_DATE, 0, DECODE(NVL(FD_STATUS, 0), 5, 0, DECODE(NVL(BMS_PAST_DUE, 0), 0, 0, 1, C_PLAN_BILL, 0)))) AS OVERDUE
				, SUM(NVL2(ACTUAL_DATE, C_ACT_BILL, 0)) AS ACTUAL
			FROM			INV
        INNER JOIN ODF_CA_SAP_FD			FD	ON	FD.ODF_PARENT_ID = INV.ID
        INNER JOIN	ODF_CA_SAP_BI			BI ON	BI.ODF_PARENT_ID 	= FD.ID
          AND NVL(BI.ACTUAL_DATE, BI.PLAN_DATE) IS NOT NULL
          AND NVL(BI.ACTUAL_DATE, BI.PLAN_DATE) >= NVL(:param_from_date, TRUNC(ADD_MONTHS(SYSDATE, -1), 'MM'))
          AND NVL(BI.ACTUAL_DATE, BI.PLAN_DATE) <= NVL(:param_to_date, TRUNC(ADD_MONTHS(SYSDATE, 12), 'MM'))
          AND ((:param_record_type IS NULL) OR (BI.RECORD_TYPE = :param_record_type))
          AND NVL(BI.C_CURRENCY_CODE, 'USD') = :param_proj_currency
        RIGHT OUTER JOIN	ODF_CA_EGCT_GRAPHING_PERIOD PERIOD 	ON	PERIOD.CODE = TO_CHAR(NVL(BI.ACTUAL_DATE, BI.PLAN_DATE), 'YYYY/MM')
          AND	EGCT_PERIOD_TYPE = 'bms_graph'
			WHERE	PERIOD.CODE >= TO_CHAR(NVL(:param_from_date, ADD_MONTHS(SYSDATE, -1)), 'YYYY/MM')
			AND		PERIOD.CODE <= TO_CHAR(NVL(:param_to_date, ADD_MONTHS(SYSDATE, 12)), 'YYYY/MM')
			GROUP BY PERIOD.CODE, PERIOD.NAME
		)
) BIG
WHERE	1=1

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646555 is a reply to message #646554]

Mon, 04 January 2016 07:23

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

What do you mean the output is the same? Isn't it erroring out in one?

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646556 is a reply to message #646552]

Mon, 04 January 2016 07:30

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

+1

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646580 is a reply to message #646556]

Mon, 04 January 2016 22:29

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

The output is same in both the databases means before and after upgrade.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646585 is a reply to message #646580]

Tue, 05 January 2016 03:34

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Still don't know what you mean.
Upgrade of what to what?

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646586 is a reply to message #646585]

Tue, 05 January 2016 03:37

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Oracle upgrade from 11.2.0.3 to 11.2.0.4

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646590 is a reply to message #646586]

Tue, 05 January 2016 03:48

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

Could you try writing an explanation that consists of more than one sentence at a time?

Are both DBs now 11.2.0.4?
Did the one that got upgraded throw this error while it was still 11.2.0.3?

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646591 is a reply to message #646586]

Tue, 05 January 2016 03:58

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

Quote:

One query is running from application(clarity) side which is calling to 11.2.0.3 database. Same query is not running from application side after oracle upgrade to 11.2.0.4.

If I understand you, the query did run under 11.2.0.3 but after upgrading to 11.2.0.4 it started throwing the ORA-00979 GROUP BY error. This is expected behaviour as ThomasG told you here.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646602 is a reply to message #646591]

Tue, 05 January 2016 06:39

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Yes. It is working in 11.2.0.3 and not in 11.2.0.4.

Thank you very much for your solution.

We have checked that the query works after changing the parameter "optimizer_features_enable" to 11.2.0.3 for temporary work around.

Please let me know does it not effect in other places?

Is there any permanent solution for this defect.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646603 is a reply to message #646552]

Tue, 05 January 2016 06:42

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

ThomasG wrote on Mon, 04 January 2016 11:01

Was solved by correcting the affected query.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646604 is a reply to message #646603]

Tue, 05 January 2016 06:45

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

No Thomas.

We have not corrected the query but we have changed the parameter "optimizer_features_enable" to 11.2.0.3.

Please provide the permanent solution.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646605 is a reply to message #646603]

Tue, 05 January 2016 06:51

gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK

Senior Member

gazzag wrote on Tue, 05 January 2016 12:42

ThomasG wrote on Mon, 04 January 2016 11:01
Was solved by correcting the affected query.

The permanent solution is to rewrite the query correctly.

[Edit: clarification]

[Updated on: Tue, 05 January 2016 06:52]

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646607 is a reply to message #646605]

Tue, 05 January 2016 07:03

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

It is working in 11.2.0.3 and also working in 11.2.0.4 from SQL plus.

It is working in 11.2.0.3 from application side but not working in 11.2.0.4 from application side.

Please advice on this.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646625 is a reply to message #646607]

Tue, 05 January 2016 22:11

ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

You have to correct the query. We can't do it for you, since we don't have your tables.

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646630 is a reply to message #646625]

Wed, 06 January 2016 00:14

grpatwari
Messages: 288
Registered: June 2008
Location: Hyderabad

Senior Member

Please find the table structures as below.

CREATE TABLE "INV_INVESTMENTS" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"ODF_OBJECT_CODE" VARCHAR2(30 BYTE) NOT NULL ENABLE, 
	"NAME" VARCHAR2(240 BYTE), 
	"CODE" VARCHAR2(60 BYTE) NOT NULL ENABLE, 
	"DESCRIPTION" VARCHAR2(2286 BYTE), 
	"IDEA_ID" NUMBER, 
	"PROCESS_CODE" VARCHAR2(30 BYTE), 
	"STAGE_CODE" VARCHAR2(30 BYTE), 
	"GOAL_CODE" VARCHAR2(30 BYTE), 
	"ALIGNMENT" NUMBER(5,0), 
	"RISK" NUMBER(5,0), 
	"STATUS_INDICATOR" NUMBER(5,0), 
	"STATUS_COMMENT" VARCHAR2(2286 BYTE), 
	"PROGRESS" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE, 
	"STATUS" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE, 
	"MANAGER_ID" NUMBER, 
	"CURRENCY_CODE" VARCHAR2(3 BYTE), 
	"APPROVEDBY_ID" NUMBER, 
	"APPROVEDTIME" DATE, 
	"IS_REQUIRED" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE, 
	"PRIORITY" NUMBER(5,0) DEFAULT 10, 
	"IS_ACTIVE" NUMBER DEFAULT 1 NOT NULL ENABLE, 
	"PURGE_FLAG" NUMBER, 
	"SLICE_STATUS" NUMBER(5,0), 
	"TRACK_MODE" NUMBER(5,0) DEFAULT 0, 
	"TRACK_ASSGN_ONLY" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE, 
	"CHARGECODEID" NUMBER(10,0), 
	"IS_OPEN_FOR_TE" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE, 
	"BASELINE_ID" NUMBER(10,0), 
	"RSF_OBS_UNIT" NUMBER(10,0), 
	"AGGR_BUDGET_COST" FLOAT(126), 
	"AGGR_BUDGET_COST_TSV" BLOB, 
	"AGGR_FORECAST_COST" FLOAT(126), 
	"AGGR_FORECAST_COST_TSV" BLOB, 
	"AGGR_ACTUAL_COST" FLOAT(126), 
	"AGGR_ACTUAL_COST_TSV" BLOB, 
	"AGGR_ETC" FLOAT(126), 
	"AGGR_ETC_TSV" BLOB, 
	"AGGR_EAC" FLOAT(126), 
	"AGGR_EAC_TSV" BLOB, 
	"AGGR_BASELINE_WORK" FLOAT(126), 
	"AGGR_BASELINE_WORK_TSV" BLOB, 
	"AGGR_ACTUAL_WORK" FLOAT(126), 
	"AGGR_ACTUAL_WORK_TSV" BLOB, 
	"AGGR_BDGT_BENEFIT" FLOAT(126), 
	"AGGR_BDGT_BENEFIT_TSV" BLOB, 
	"SLA_COMPLIANCE" NUMBER, 
	"LAST_AGGREGATED_DATE" DATE, 
	"CBK_TYPE" VARCHAR2(20 BYTE), 
	"BILL_EXPENSE_TYPE" VARCHAR2(20 BYTE), 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER NOT NULL ENABLE, 
	"SCHEDULE_START" DATE, 
	"SCHEDULE_FINISH" DATE, 
	"SYNC_INV_N_BDG_DATES" NUMBER(5,0) DEFAULT 0 NOT NULL ENABLE, 
	"LABOR_ETC_CURVE" BLOB, 
	"LABOR_ETCSUM" FLOAT(126), 
	"LABOR_ACT_CURVE" BLOB, 
	"LABOR_ACTSUM" FLOAT(126), 
	"LABOR_EAC_CURVE" BLOB, 
	"LABOR_EACSUM" FLOAT(126), 
	"LABOR_BASELINE_CURVE" BLOB, 
	"LABOR_BASESUM" FLOAT(126), 
	"LABOR_VARIANCE_CURVE" BLOB, 
	"LABOR_VARIANCESUM" FLOAT(126), 
	"ENTITY_CODE" VARCHAR2(60 BYTE), 
	"ODF_SS_LABOR_BASE" NUMBER, 
	"ODF_SS_LABOR_ACT" NUMBER, 
	"ODF_SS_LABOR_EAC" NUMBER, 
	"ODF_SS_LABOR_ETC" NUMBER, 
	"ODF_SS_LABOR_VARIANCE" NUMBER, 
	"TARGET_MANAGER_ID" NUMBER, 
	"ASSGN_POOL" NUMBER(10,0) DEFAULT 0 NOT NULL ENABLE, 
	 CONSTRAINT "INV_INVESTMENTS_PK" PRIMARY KEY ("ID")
  ) ;

CREATE TABLE "ODF_CA_PROJECT" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER NOT NULL ENABLE, 
	"PARTITION_CODE" VARCHAR2(30 BYTE) DEFAULT 'NIKU.ROOT', 
	"OBJ_REQUEST_CATEGORY" VARCHAR2(30 BYTE), 
	"APL_ASSIGN_COST" NUMBER, 
	"APL_BUDGET" NUMBER, 
	"APL_CLOSEABLE_KPI" NUMBER, 
	"APL_RUC" NUMBER, 
	"APL_UGM_PCT" NUMBER, 
	"CPAR_REGION" VARCHAR2(600 BYTE), 
	"ERC_APL_CLOSE_DATE" DATE, 
	"ERC_APL_PROJ_STAT" NUMBER, 
	"ERC_APL_PROJ_TYPE" NUMBER, 
	"ERC_APL_SAP_CREATE" DATE, 
	"ERC_BMS_REMINDER" VARCHAR2(750 BYTE), 
	"ERC_CBB" NUMBER, 
	"ERC_CBM" NUMBER, 
	"ERC_SCORECARD_OPTOUT" NUMBER, 
	"ERI_ACR" NUMBER, 
	"ERI_APL_CURAPR_CMNTS" VARCHAR2(600 BYTE), 
	"ERI_APL_FIN_APR_BGT" NUMBER, 
	"ERI_APL_FIN_CMNTS" VARCHAR2(198 BYTE), 
	"ERI_APL_FIN_PLN_REV" NUMBER, 
	"ERI_APL_PRJ_UMI_PCT" NUMBER, 
	"ERI_APL_TPR_APR_BGT" NUMBER, 
	"ERI_APL_TPR_CMNTS" VARCHAR2(147 BYTE), 
	"ERI_APL_TPR_PLN_REV" NUMBER, 
	"ERI_ASSN_SPEC_T" VARCHAR2(600 BYTE), 
	"ERI_CAT_APPR_DT" DATE, 
	"ERI_CATEGORY_APPR" NUMBER, 
	"ERI_CATEGORY_APPROV" NUMBER, 
	"ERI_CAT_NULL_TEST" NUMBER, 
	"ERIC_CLOSURE_INITIAT" NUMBER, 
	"ERIC_CUSTOMER_ACCPT" NUMBER, 
	"ERIC_CUSTOMER_HANDOV" NUMBER, 
	"ERI_CFR" NUMBER, 
	"ERIC_INTERNAL_HANDOV" NUMBER, 
	"ERIC_MS6_APPROVED" NUMBER, 
	"ERIC_POP_INITIATED" NUMBER, 
	"ERIC_PROJECT_BUDGET" NUMBER, 
	"ERIC_PROJECT_TEAM" NUMBER, 
	"ERIC_PROJ_SPEC" VARCHAR2(900 BYTE), 
	"ERIC_REQ_APPRV_TG3" NUMBER, 
	"ERIC_REQ_APPRV_TG4" NUMBER, 
	"ERIC_REQ_APPRV_TG5" NUMBER, 
	"ERI_CSR" NUMBER, 
	"ERIC_SUPPORT_ACCPT" NUMBER, 
	"ERIC_TG1_APPRVD" NUMBER, 
	"ERIC_TG1_APPRV_REQ" NUMBER, 
	"ERIC_TG2_APPROVED" NUMBER, 
	"ERIC_TG2_APPRVL_REQ" NUMBER, 
	"ERIC_TG3_APPROVED" NUMBER, 
	"ERIC_TG4_APPROVED" NUMBER, 
	"ERIC_TG5_APPROVED" NUMBER, 
	"ERI_CUST_SPONSOR" VARCHAR2(300 BYTE), 
	"ERI_DOC_ASSGN_SPEC" VARCHAR2(900 BYTE), 
	"ERI_DOC_FIN_REPORT" VARCHAR2(900 BYTE), 
	"ERI_DOC_OTHCOMP_REFS" VARCHAR2(900 BYTE), 
	"ERI_DOC_PRJ_PAGER" VARCHAR2(900 BYTE), 
	"ERI_DOC_STAT_RPRT" VARCHAR2(900 BYTE), 
	"ERI_DOC_TG2_DECSN" VARCHAR2(900 BYTE), 
	"ERI_DOC_TG2_PRESENT" VARCHAR2(900 BYTE), 
	"ERI_DOC_TG5_DECSN" VARCHAR2(900 BYTE), 
	"ERI_DOC_TG5_PRESENT" VARCHAR2(900 BYTE), 
	"ERI_ERIDOC_FLDR" VARCHAR2(900 BYTE), 
	"ERI_EVAL_SCORE" NUMBER, 
	"ERI_EXEC_BASELINE" NUMBER, 
	"ERI_EXISTS_BL" NUMBER, 
	"ERI_FCP_NUMBER" VARCHAR2(60 BYTE), 
	"ERI_FINAL_PAYOUT" NUMBER, 
	"ERI_FIN_MGT_SCORE" NUMBER, 
	"ERI_FIN_RPT_T" VARCHAR2(600 BYTE), 
	"ERI_HIDE_SUBPAGES" NUMBER, 
	"ERI_HI_PROF_PFM" NUMBER, 
	"ERI_INT_STAT_T" VARCHAR2(600 BYTE), 
	"ERI_KAM_VP" NUMBER, 
	"ERI_LINE_MANAGER" NUMBER, 
	"ERI_MISS_OPTOUT" NUMBER, 
	"ERI_MORE_ID" VARCHAR2(60 BYTE), 
	"ERI_MS6_ACT_DATE" DATE, 
	"ERI_MS6_COMPLETE" NUMBER, 
	"ERI_MS6_PLAN_DATE" DATE, 
	"ERI_OPT_OUT_TG1" NUMBER, 
	"ERI_OPT_OUT_TG3" NUMBER, 
	"ERI_OPT_OUT_TG4" NUMBER, 
	"ERI_PLAN_ACCURACY" NUMBER, 
	"ERI_PMO_MANAGER" NUMBER, 
	"ERI_PRJ_COORDINATOR" NUMBER, 
	"ERI_PRJ_LEVEL" VARCHAR2(30 BYTE), 
	"ERI_PRJ_SCOPE_DET" CLOB, 
	"ERI_PROJ_BUDGET" NUMBER, 
	"ERI_PROJ_CATEGORY" VARCHAR2(30 BYTE), 
	"ERI_PROJ_CONTOLLER" NUMBER, 
	"ERI_PROJ_KILL" VARCHAR2(30 BYTE), 
	"ERI_PROJ_MARGIN" NUMBER, 
	"ERI_PROJ_PHASE" VARCHAR2(30 BYTE), 
	"ERI_PROJ_SC_APPR_DT" DATE, 
	"ERI_PROJ_SC_CFR" NUMBER, 
	"ERI_PROJ_SC_CFR_APPR" DATE, 
	"ERI_PROJ_SC_COMP" NUMBER, 
	"ERI_PROJ_SC_CPM" NUMBER, 
	"ERI_PROJ_SC_CPM_APPR" DATE, 
	"ERI_PROJ_SPEC_T" VARCHAR2(600 BYTE), 
	"ERI_PSP" NUMBER, 
	"ERI_SC_APPROVAL" DATE, 
	"ERI_START_PROPSC" NUMBER, 
	"ERI_SUB_PM1" NUMBER, 
	"ERI_SUB_PM2" NUMBER, 
	"ERI_SUB_PM3" NUMBER, 
	"ERI_TG1_ACT_DATE" DATE, 
	"ERI_TG1_COMP" NUMBER, 
	"ERI_TG2_ACT_DATE" DATE, 
	"ERI_TG2_COMPLETE" NUMBER, 
	"ERI_TG3_ACT_DATE" DATE, 
	"ERI_TG3_COMPLETE" NUMBER, 
	"ERI_TG4_ACT_DATE" DATE, 
	"ERI_TG4_COMPLETE" NUMBER, 
	"ERI_TG5_ACT_DATE" DATE, 
	"ERI_TG5_COMPLETE" NUMBER, 
	"ERI_UMIMPRV_CMNTS" VARCHAR2(600 BYTE), 
	"KPI_2_PLNNO_ACTNO" NUMBER, 
	"KPI_2_REVISE_PLN_CST" VARCHAR2(300 BYTE), 
	"KPI_3_DUE_WTH15_DAYS" NUMBER, 
	"KPI_3_LAST_INT_DATE" DATE, 
	"KPI_3_NOPLAN_FINDATE" NUMBER, 
	"KPI_3_NOTOVER_PRJTOT" NUMBER, 
	"KPI_3_OVER_PRJ_TOT" NUMBER, 
	"KPI_3_PRJ_FIN_DATE" DATE, 
	"KPI_3_REVISE_FIN_DT" DATE, 
	"ERI_PROJ_NUMBER" VARCHAR2(60 BYTE), 
	"PROJ_PROP_C_STATUS" VARCHAR2(30 BYTE), 
	"EGCT_PROJ_CURRENCY" VARCHAR2(30 BYTE), 
	"EGCT_SAP_PROPSC_GOV" NUMBER, 
	"EGCT_CBL_BUDGET" NUMBER, 
	"EGCT_CBL_UMMRGN" NUMBER, 
	"EGCT_CBL_FINISH" DATE, 
	"ERI_TG4_SUBMITTED" NUMBER, 
	"EGCT_FINAL_REP_PPT" VARCHAR2(600 BYTE), 
	"EGCT_PROJ_SPEC_PPT" VARCHAR2(600 BYTE), 
	"EGCT_PROJECT_TYPE" VARCHAR2(30 BYTE), 
	"EGCT_OBS_INTERNAL" NUMBER, 
	"EGCT_ERICOLL_SITE" VARCHAR2(900 BYTE), 
	"EGCT_NULL_NUMBER" NUMBER, 
	"EGCT_NULL_PERCENT" NUMBER, 
	"CBL_SERV_UM" NUMBER, 
	"NULL_CURRENCY" VARCHAR2(30 BYTE), 
	"NULL_MONEY" NUMBER, 
	"NULL_MONEY_CURRENCY" VARCHAR2(25 BYTE), 
	"VC_STATUS" VARCHAR2(30 BYTE), 
	"KPI_3_STATUSKEYCOLOR" VARCHAR2(30 BYTE), 
	"ERI_DOC_TG3_PRESENT" VARCHAR2(900 BYTE), 
	"ERI_DOC_TG4_PRESENT" VARCHAR2(900 BYTE), 
	"ERI_DOC_SUPP_NAME_1" VARCHAR2(180 BYTE), 
	"ERI_DOC_SUPP_NAME_2" VARCHAR2(180 BYTE), 
	"ERI_DOC_SUPP_NAME_3" VARCHAR2(180 BYTE), 
	"ERI_DOC_SUPP_LINK_1" VARCHAR2(900 BYTE), 
	"ERI_DOC_SUPP_LINK_2" VARCHAR2(900 BYTE), 
	"ERI_DOC_SUPP_LINK_3" VARCHAR2(900 BYTE), 
	"ERI_STRATEGIC" NUMBER, 
	"STR_INT_FLAG" VARCHAR2(30 BYTE), 
	"FIN_INT_FLAG" VARCHAR2(30 BYTE), 
	"ERI_PO_MANAGER" NUMBER, 
	"DEAL_ID" VARCHAR2(60 BYTE), 
	"EGMT_PRACTICE" VARCHAR2(30 BYTE), 
	"OBJ_STATUS_REPORTING" VARCHAR2(30 BYTE), 
	"ERI_PRGRM_WF_STAT" VARCHAR2(30 BYTE), 
	"ERI_PRJ_CCB_LEAD" NUMBER, 
	"ERI_ONE_ENTRY_FORM" VARCHAR2(900 BYTE), 
	"ERI_ONE_ENTRY_FORM_T" VARCHAR2(900 BYTE), 
	"ERI_DET_PROJ_PLAN" VARCHAR2(900 BYTE), 
	"ERI_CPL_REPORT" VARCHAR2(900 BYTE), 
	"ERI_CPL_REPORT_T" VARCHAR2(900 BYTE), 
	"ERI_OHS_PLAN" VARCHAR2(900 BYTE), 
	"ERIC_DOC_HANDOVER" VARCHAR2(900 BYTE), 
	"ERI_PROV_ACC_CHKLST" VARCHAR2(900 BYTE), 
	"ERI_FINAL_ACC_CHKLST" VARCHAR2(900 BYTE), 
	"ERI_AUDIT_REPORT" VARCHAR2(900 BYTE), 
	"ERI_MSDP_TGMS_CHKLST" VARCHAR2(900 BYTE), 
	"ERI_MSDP_CHKLIST_T" VARCHAR2(900 BYTE), 
	"ERI_TG_PRESENT_T" VARCHAR2(900 BYTE), 
	"ERI_TG5_PRESENT_T" VARCHAR2(900 BYTE), 
	"ERI_KNOWLEDGE_BASE" VARCHAR2(900 BYTE), 
	"ERI_TG1_PRESENTATION" VARCHAR2(900 BYTE), 
	"ERI_REV_CODE_KEY_DOC" VARCHAR2(12 BYTE), 
	"ERI_SOL_CM" NUMBER, 
	"CBL_CSC_BGT" NUMBER, 
	"CBL_CSC_BGT_CURRENCY" VARCHAR2(25 BYTE), 
	"CBL_PSF_BGT" NUMBER, 
	"CBL_PSF_BGT_CURRENCY" VARCHAR2(25 BYTE), 
	"CBL_QTC_BGT" NUMBER, 
	"CBL_QTC_BGT_CURRENCY" VARCHAR2(25 BYTE), 
	"ERI_CBL_REV" NUMBER, 
	"ERI_CBL_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"ERI_SDM" NUMBER, 
	"ERI_DECISION" VARCHAR2(60 BYTE), 
	"ERI_DATE_HANDOVER" DATE, 
	"ERIC_MOM_HAND_SUP" CLOB, 
	"CREATE_NEW_PLAN" NUMBER, 
	"ERI_CUS_SUP_HOV_CHK" VARCHAR2(750 BYTE), 
	"ERI_COMMENT" VARCHAR2(600 BYTE), 
	"ERI_PRT_OF_PMIP" VARCHAR2(30 BYTE), 
	"ERI_SCORE_STATUS" NUMBER, 
	"ERI_MOD_BY" NUMBER, 
	"ERI_MOD_DATE" DATE, 
	"ERI_ACCEPTANCE_PLAN" VARCHAR2(900 BYTE), 
	"CHANGE_REQUEST_URL" VARCHAR2(1500 BYTE), 
	"OPEN_CR_INDICATOR" NUMBER, 
	"PROCESS_PROG_FLAG" NUMBER, 
	"ERI_IS_PLTI" NUMBER, 
	"ERI_IS_CPL" NUMBER, 
	"ERI_BASELINE_PLAN" NUMBER, 
	"ERI_PLTI_NOMINATOR" NUMBER, 
	"ERI_FAS_APPROVED" DATE, 
	"ERI_FAC_DATE" DATE, 
	"ERI_EARLY_START" NUMBER, 
	"ERI_OP_CHECK" NUMBER, 
	"SS" VARCHAR2(1500 BYTE), 
	"ERI_CEM" NUMBER, 
	"EGCT_IND_SOCIETY" VARCHAR2(30 BYTE), 
	"EGCT_ORIGIN_BR" VARCHAR2(750 BYTE), 
	 CONSTRAINT "ODF_CA_PROJECT_PK" PRIMARY KEY ("ID")
   );

 CREATE TABLE "PRJ_OBS_ASSOCIATIONS" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"UNIT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"TABLE_NAME" VARCHAR2(30 BYTE) NOT NULL ENABLE, 
	"RECORD_ID" NUMBER(18,0) NOT NULL ENABLE, 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER(10,0) NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER(10,0) NOT NULL ENABLE, 
	 CONSTRAINT "PRJ_OBS_ASSOCIATIONS_PK" PRIMARY KEY ("UNIT_ID", "TABLE_NAME", "RECORD_ID")
     ) ;

   CREATE TABLE "PRJ_OBS_UNITS_FLAT" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"UNIT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"BRANCH_UNIT_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER(10,0) NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER(10,0) NOT NULL ENABLE
   );

 CREATE TABLE "PRJ_OBS_UNITS" 
   (	"ID" NUMBER(10,0) NOT NULL ENABLE, 
	"TYPE_ID" NUMBER(10,0) NOT NULL ENABLE, 
	"UNIQUE_NAME" VARCHAR2(60 BYTE), 
	"PARENT_ID" NUMBER(10,0), 
	"NAME" VARCHAR2(360 BYTE), 
	"DEPTH" NUMBER(10,0), 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER(10,0) NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER(10,0) NOT NULL ENABLE
   );

CREATE TABLE "ODF_CA_SAP_FD" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER NOT NULL ENABLE, 
	"PARTITION_CODE" VARCHAR2(30 BYTE) DEFAULT 'NIKU.ROOT' NOT NULL ENABLE, 
	"NAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, 
	"CODE" VARCHAR2(90 BYTE) NOT NULL ENABLE, 
	"ODF_PARENT_ID" NUMBER NOT NULL ENABLE, 
	"ODF_CNCRT_PARENT_ID" NUMBER NOT NULL ENABLE, 
	"AEN_ID" NUMBER, 
	"AGG_C_AC_CS" NUMBER, 
	"AGG_C_AC_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_AC_RV" NUMBER, 
	"AGG_C_AC_RV_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_AS_CS" NUMBER, 
	"AGG_C_AS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_BDGT" NUMBER, 
	"AGG_C_BDGT_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_CM_CS" NUMBER, 
	"AGG_C_CM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_CO_CS" NUMBER, 
	"AGG_C_CO_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_CO_HW" NUMBER, 
	"AGG_C_CO_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_COS" NUMBER, 
	"AGG_C_COS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_CO_SW" NUMBER, 
	"AGG_C_CO_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_DF_RV" NUMBER, 
	"AGG_C_DF_RV_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_NS" NUMBER, 
	"AGG_C_NS_CS" NUMBER, 
	"AGG_C_NS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_NS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_NS_HW" NUMBER, 
	"AGG_C_NS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_NS_SW" NUMBER, 
	"AGG_C_NS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_OB_CS" NUMBER, 
	"AGG_C_OB_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_ORDBK" NUMBER, 
	"AGG_C_ORDBK_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_PL_CS" NUMBER, 
	"AGG_C_PL_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_PL_RV" NUMBER, 
	"AGG_C_PL_RV_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_RUC" NUMBER, 
	"AGG_C_RUC_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_UM" NUMBER, 
	"AGG_C_UM_CS" NUMBER, 
	"AGG_C_UM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_UM_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_WIP" NUMBER, 
	"AGG_C_WIP_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_AC_CS" NUMBER, 
	"AGG_P_AC_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_AC_RV" NUMBER, 
	"AGG_P_AC_RV_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_AS_CS" NUMBER, 
	"AGG_P_AS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_BDGT" NUMBER, 
	"AGG_P_BDGT_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_CM_CS" NUMBER, 
	"AGG_P_CM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_CO_CS" NUMBER, 
	"AGG_P_CO_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_CO_HW" NUMBER, 
	"AGG_P_CO_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_COS" NUMBER, 
	"AGG_P_COS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_CO_SW" NUMBER, 
	"AGG_P_CO_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_DF_RV" NUMBER, 
	"AGG_P_DF_RV_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_NS" NUMBER, 
	"AGG_P_NS_CS" NUMBER, 
	"AGG_P_NS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_NS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_NS_HW" NUMBER, 
	"AGG_P_NS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_NS_SW" NUMBER, 
	"AGG_P_NS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_OB_CS" NUMBER, 
	"AGG_P_OB_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_ORDBK" NUMBER, 
	"AGG_P_ORDBK_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_PL_CS" NUMBER, 
	"AGG_P_PL_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_PL_RV" NUMBER, 
	"AGG_P_PL_RV_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_RUC" NUMBER, 
	"AGG_P_RUC_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_UM" NUMBER, 
	"AGG_P_UM_CS" NUMBER, 
	"AGG_P_UM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_UM_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_WIP" NUMBER, 
	"AGG_P_WIP_CURRENCY" VARCHAR2(25 BYTE), 
	"ASSIGNMENT_ID" VARCHAR2(90 BYTE), 
	"BUDGET_INP" NUMBER, 
	"BUDGET_INP_CURRENCY" VARCHAR2(25 BYTE), 
	"BUY_CUST_CODE" VARCHAR2(30 BYTE), 
	"C_ACT_CST" NUMBER, 
	"C_ACT_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"C_ACT_REV" NUMBER, 
	"C_ACT_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"C_ASS_CST" NUMBER, 
	"C_ASS_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"C_BUDGET" NUMBER, 
	"C_BUDGET_CURRENCY" VARCHAR2(25 BYTE), 
	"C_COMM_CST" NUMBER, 
	"C_COMM_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"C_COS" NUMBER, 
	"C_COS_CS" NUMBER, 
	"C_COS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"C_COS_CURRENCY" VARCHAR2(25 BYTE), 
	"C_COS_HW" NUMBER, 
	"C_COS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"C_COS_SW" NUMBER, 
	"C_COS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"C_DEFER_REV" NUMBER, 
	"C_DEFER_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"C_NS" NUMBER, 
	"C_NS_CS" NUMBER, 
	"C_NS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"C_NS_CURRENCY" VARCHAR2(25 BYTE), 
	"C_NS_HW" NUMBER, 
	"C_NS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"C_NS_SW" NUMBER, 
	"C_NS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"C_ORDBKD" NUMBER, 
	"C_ORDBKD_CS" NUMBER, 
	"C_ORDBKD_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"C_ORDBKD_CURRENCY" VARCHAR2(25 BYTE), 
	"C_PLAN_CST" NUMBER, 
	"C_PLAN_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"C_PLAN_REV" NUMBER, 
	"C_PLAN_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"CPM_ID" NUMBER, 
	"C_RUC" NUMBER, 
	"C_RUC_CURRENCY" VARCHAR2(25 BYTE), 
	"C_UM" NUMBER, 
	"C_UM_CS" NUMBER, 
	"C_UM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"C_UM_CURRENCY" VARCHAR2(25 BYTE), 
	"CURRENCY_CODE" VARCHAR2(30 BYTE), 
	"CUST_CODE" VARCHAR2(39 BYTE), 
	"CUST_DESC" VARCHAR2(210 BYTE), 
	"CUST_PO_NO" VARCHAR2(60 BYTE), 
	"CUST_UNIT" VARCHAR2(150 BYTE), 
	"C_WIP" NUMBER, 
	"C_WIP_CURRENCY" VARCHAR2(25 BYTE), 
	"DAYS_TO_BILL" NUMBER, 
	"DOCUMENT_NUMBER" VARCHAR2(90 BYTE), 
	"ESS" VARCHAR2(60 BYTE), 
	"KPI_EPCQ" VARCHAR2(30 BYTE), 
	"KPI_3_DUE_WTH15_DAYS" NUMBER, 
	"KPI_3_REVISE_FIN_DT" DATE, 
	"KPI_3_STATUSKEYCOLOR" VARCHAR2(30 BYTE), 
	"N_ACT_CST" NUMBER, 
	"N_ACT_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"N_ACT_REV" NUMBER, 
	"N_ACT_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"N_ASS_CST" NUMBER, 
	"N_ASS_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"N_BUDGET" NUMBER, 
	"N_BUDGET_CURRENCY" VARCHAR2(25 BYTE), 
	"N_COMM_CST" NUMBER, 
	"N_COMM_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"N_COS" NUMBER, 
	"N_COS_CS" NUMBER, 
	"N_COS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_COS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_COS_HW" NUMBER, 
	"N_COS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"N_COS_SW" NUMBER, 
	"N_COS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"N_DEFER_REV" NUMBER, 
	"N_DEFER_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"NETWORK" VARCHAR2(36 BYTE), 
	"N_NS" NUMBER, 
	"N_NS_CS" NUMBER, 
	"N_NS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_NS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_NS_HW" NUMBER, 
	"N_NS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"N_NS_SW" NUMBER, 
	"N_NS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"N_ORDBKD" NUMBER, 
	"N_ORDBKD_CS" NUMBER, 
	"N_ORDBKD_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_ORDBKD_CURRENCY" VARCHAR2(25 BYTE), 
	"N_PLAN_CST" NUMBER, 
	"N_PLAN_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"N_PLAN_REV" NUMBER, 
	"N_PLAN_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"N_RUC" NUMBER, 
	"N_RUC_CURRENCY" VARCHAR2(25 BYTE), 
	"N_UM" NUMBER, 
	"N_UM_CS" NUMBER, 
	"N_UM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_UM_CURRENCY" VARCHAR2(25 BYTE), 
	"N_WIP" NUMBER, 
	"N_WIP_CURRENCY" VARCHAR2(25 BYTE), 
	"OBJECT_NUMBER" VARCHAR2(90 BYTE), 
	"P_ACT_CST" NUMBER, 
	"P_ACT_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"P_ACT_REV" NUMBER, 
	"P_ACT_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"PARENT_FD" VARCHAR2(90 BYTE), 
	"PARENT_WBS_ELEMENT" VARCHAR2(90 BYTE), 
	"P_ASS_CST" NUMBER, 
	"P_ASS_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"P_BUDGET" NUMBER, 
	"P_BUDGET_CURRENCY" VARCHAR2(25 BYTE), 
	"P_COMM_CST" NUMBER, 
	"P_COMM_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"P_COS" NUMBER, 
	"P_COS_CS" NUMBER, 
	"P_COS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"P_COS_CURRENCY" VARCHAR2(25 BYTE), 
	"P_COS_HW" NUMBER, 
	"P_COS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"P_COS_SW" NUMBER, 
	"P_COS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"P_DEFER_REV" NUMBER, 
	"P_DEFER_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"PD_STATUS" NUMBER, 
	"PLANNED_FINISH" DATE, 
	"PLANNED_START" DATE, 
	"P_NS" NUMBER, 
	"P_NS_CS" NUMBER, 
	"P_NS_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"P_NS_CURRENCY" VARCHAR2(25 BYTE), 
	"P_NS_HW" NUMBER, 
	"P_NS_HW_CURRENCY" VARCHAR2(25 BYTE), 
	"P_NS_SW" NUMBER, 
	"P_NS_SW_CURRENCY" VARCHAR2(25 BYTE), 
	"PO_DATE" DATE, 
	"PO_NUMBER" VARCHAR2(90 BYTE), 
	"P_ORDBKD" NUMBER, 
	"P_ORDBKD_CS" NUMBER, 
	"P_ORDBKD_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"P_ORDBKD_CURRENCY" VARCHAR2(25 BYTE), 
	"P_PLAN_CST" NUMBER, 
	"P_PLAN_CST_CURRENCY" VARCHAR2(25 BYTE), 
	"P_PLAN_REV" NUMBER, 
	"P_PLAN_REV_CURRENCY" VARCHAR2(25 BYTE), 
	"PROFIT_CENTER" VARCHAR2(30 BYTE), 
	"PROJECT_TYPE" VARCHAR2(24 BYTE), 
	"P_RUC" NUMBER, 
	"P_RUC_CURRENCY" VARCHAR2(25 BYTE), 
	"PSP" NUMBER, 
	"P_UM" NUMBER, 
	"P_UM_CS" NUMBER, 
	"P_UM_CS_CURRENCY" VARCHAR2(25 BYTE), 
	"P_UM_CURRENCY" VARCHAR2(25 BYTE), 
	"P_WIP" NUMBER, 
	"P_WIP_CURRENCY" VARCHAR2(25 BYTE), 
	"RA_KEY" VARCHAR2(18 BYTE), 
	"REGION" VARCHAR2(33 BYTE), 
	"RELATED_PD_NUMBER" VARCHAR2(90 BYTE), 
	"RELATED_PD_OBJECT" VARCHAR2(90 BYTE), 
	"RELATED_SO_NUMBER" VARCHAR2(90 BYTE), 
	"RELATED_VC_NUMBER" VARCHAR2(90 BYTE), 
	"RELATED_VC_OBJECT" VARCHAR2(90 BYTE), 
	"ROW_TYPE" VARCHAR2(30 BYTE), 
	"SAP_CREATE_DATE" DATE, 
	"SAP_FIN_DATE" DATE, 
	"SO_GRP_CODE" VARCHAR2(9 BYTE), 
	"SO_GRP_CODE_DESC" VARCHAR2(60 BYTE), 
	"SOLD_TO_PARTY" VARCHAR2(60 BYTE), 
	"SO_OFFICE" VARCHAR2(12 BYTE), 
	"UDF1" VARCHAR2(60 BYTE), 
	"UDF10" DATE, 
	"UDF11" NUMBER, 
	"UDF12" NUMBER, 
	"UDF2" VARCHAR2(60 BYTE), 
	"UDF3" VARCHAR2(30 BYTE), 
	"UDF4" VARCHAR2(30 BYTE), 
	"UDF5" VARCHAR2(42 BYTE), 
	"UDF6" VARCHAR2(42 BYTE), 
	"UDF7" VARCHAR2(42 BYTE), 
	"UDF8" VARCHAR2(42 BYTE), 
	"UDF9" DATE, 
	"UM_CS_PCT" NUMBER, 
	"UM_PCT" NUMBER, 
	"WBS_LEVEL" NUMBER, 
	"WBS_STATUS" VARCHAR2(30 BYTE), 
	"FD_STATUS" NUMBER, 
	"C_ESTA_ACT" NUMBER, 
	"C_ESTA_ACT_CURRENCY" VARCHAR2(25 BYTE), 
	"ERI_ESTA_STATUS" VARCHAR2(30 BYTE), 
	"P_CLS_BCKLG" NUMBER, 
	"P_CLS_BCKLG_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_CL_BK" NUMBER, 
	"AGG_P_CL_BK_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_CL_BK" NUMBER, 
	"AGG_C_CL_BK_CURRENCY" VARCHAR2(25 BYTE), 
	"N_CLS_BCKLG" NUMBER, 
	"N_CLS_BCKLG_CURRENCY" VARCHAR2(25 BYTE), 
	"C_CLS_BCKLG" NUMBER, 
	"C_CLS_BCKLG_CURRENCY" VARCHAR2(25 BYTE), 
	"P_UNB_SALES" NUMBER, 
	"P_UNB_SALES_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_P_UB_SS" NUMBER, 
	"AGG_P_UB_SS_CURRENCY" VARCHAR2(25 BYTE), 
	"AGG_C_UB_SS" NUMBER, 
	"AGG_C_UB_SS_CURRENCY" VARCHAR2(25 BYTE), 
	"N_UNB_SALES" NUMBER, 
	"N_UNB_SALES_CURRENCY" VARCHAR2(25 BYTE), 
	"C_UNB_SALES" NUMBER, 
	"C_UNB_SALES_CURRENCY" VARCHAR2(25 BYTE), 
	 CONSTRAINT "ODF_CA_SAP_FD_PK" PRIMARY KEY ("ID")
    );

CREATE TABLE "ODF_CA_SAP_BI" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER NOT NULL ENABLE, 
	"PARTITION_CODE" VARCHAR2(30 BYTE) DEFAULT 'NIKU.ROOT' NOT NULL ENABLE, 
	"NAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, 
	"CODE" VARCHAR2(90 BYTE) NOT NULL ENABLE, 
	"ODF_PARENT_ID" NUMBER NOT NULL ENABLE, 
	"ODF_CNCRT_PARENT_ID" NUMBER NOT NULL ENABLE, 
	"ACTUAL_DATE" DATE, 
	"BILL_DATE" DATE, 
	"BILLING_STATUS" VARCHAR2(18 BYTE), 
	"BMS_BI_STATUS" VARCHAR2(3 BYTE), 
	"BMS_DUE_15_DAYS" NUMBER, 
	"BMS_PAST_DUE" NUMBER, 
	"BMS_REVISED_SCHEDMST" DATE, 
	"BPI_NUMBER" VARCHAR2(51 BYTE), 
	"BP_NUMBER" VARCHAR2(57 BYTE), 
	"C_ACT_BILL" NUMBER, 
	"C_ACT_BILL_CURRENCY" VARCHAR2(25 BYTE), 
	"C_CURRENCY_CODE" VARCHAR2(9 BYTE), 
	"C_PLAN_BILL" NUMBER, 
	"C_PLAN_BILL_CURRENCY" VARCHAR2(25 BYTE), 
	"LAST_SAP_BI_UPDATE" DATE, 
	"MS_ACTUAL_DATE" DATE, 
	"MS_CREATED_BY" VARCHAR2(90 BYTE), 
	"MS_CREATED_ON" DATE, 
	"MS_FIXED_DATE" DATE, 
	"MS_NAME" VARCHAR2(210 BYTE), 
	"MS_NUMBER" VARCHAR2(45 BYTE), 
	"MS_USAGE_CODE" VARCHAR2(90 BYTE), 
	"N_ACT_BILL" NUMBER, 
	"N_ACT_BILL_CURRENCY" VARCHAR2(25 BYTE), 
	"N_CURRENCY_CODE" VARCHAR2(30 BYTE), 
	"N_PLAN_BILL" NUMBER, 
	"N_PLAN_BILL_CURRENCY" VARCHAR2(25 BYTE), 
	"PLAN_DATE" DATE, 
	"RECORD_TYPE" VARCHAR2(9 BYTE), 
	"SAP_TEXT_DATE" DATE, 
	"SO_ITEM_NUMBER" VARCHAR2(90 BYTE), 
	"SO_NUMBER" VARCHAR2(81 BYTE), 
	"WBS_ELEMENT_NUMBER" VARCHAR2(90 BYTE), 
	"P_CURRENCY_CODE" VARCHAR2(30 BYTE), 
	"P_ACT_BILL" NUMBER, 
	"P_ACT_BILL_CURRENCY" VARCHAR2(25 BYTE), 
	"P_PLAN_BILL" NUMBER, 
	"P_PLAN_BILL_CURRENCY" VARCHAR2(25 BYTE), 
	 CONSTRAINT "ODF_CA_SAP_BI_PK" PRIMARY KEY ("ID")
    ) ;

CREATE TABLE "ODF_CA_EGCT_GRAPHING_PERIOD" 
   (	"ID" NUMBER NOT NULL ENABLE, 
	"CREATED_DATE" DATE NOT NULL ENABLE, 
	"CREATED_BY" NUMBER NOT NULL ENABLE, 
	"LAST_UPDATED_DATE" DATE NOT NULL ENABLE, 
	"LAST_UPDATED_BY" NUMBER NOT NULL ENABLE, 
	"PARTITION_CODE" VARCHAR2(30 BYTE) DEFAULT 'NIKU.ROOT' NOT NULL ENABLE, 
	"NAME" VARCHAR2(240 BYTE) NOT NULL ENABLE, 
	"CODE" VARCHAR2(90 BYTE) NOT NULL ENABLE, 
	"PAGE_LAYOUT" VARCHAR2(50 BYTE) NOT NULL ENABLE, 
	"EGCT_PERIOD_TYPE" VARCHAR2(30 BYTE), 
	"ODF_ENTITY_CODE" VARCHAR2(30 BYTE), 
	"ODF_PERIOD_TYPE" VARCHAR2(30 BYTE), 
	"ODF_PERIOD_START" NUMBER, 
	"ODF_PERIOD_END" NUMBER, 
	 CONSTRAINT "ODF_CA_EGCT_GRAPHING_PERIOD_PK" PRIMARY KEY ("ID")
    );

select count(*) from INV_INVESTMENTS; --14227
select count(*) from ODF_CA_PROJECT; --13914
select count(*) from PRJ_OBS_ASSOCIATIONS; --27238
select count(*) from PRJ_OBS_UNITS_FLAT; --14557
select count(*) from PRJ_OBS_UNITS; --3248
select count(*) from ODF_CA_SAP_FD; --1838369
select count(*) from ODF_CA_SAP_BI; --8802581
select count(*) from ODF_CA_EGCT_GRAPHING_PERIOD; --280

Report message to a moderator

Re: Query is not running from 11.2.0.3 to 11.2.0.4 [message #646641 is a reply to message #646630]

Wed, 06 January 2016 03:35

cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester

Senior Member

If it works in SQLplus but not in the app then I can only assume the version you are running in SQLplus isn't actually the same as the one the application is using.
Oracle doesn't care where the query came from when checking syntax.

Report message to a moderator

Previous Topic:	XML parsing error-ORA-06512
Next Topic:	NVL Function

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 25 19:27:45 CDT 2024