troubleshooting Question

Error in creating a view.

Avatar of Kamal Agnihotri
Kamal AgnihotriFlag for United States of America asked on
Oracle Database
8 Comments1 Solution219 ViewsLast Modified:
I am trying to create a view using the code below and I am getting error, ora-00904: "ACTUAL_END_DATE": invalid identifier.

I have modified the table_Names so that they do not represent the actual tables.

create or replace view reqs_11 as
select i.user_dm8_cd, i.div_cd, i.itmz_ln_lnum, i.actg_ln_lnum, i.hdr_lnum, i.doc_num, i.titl, i.fisc_year, i.doc_dt,
  i.dtyp_cat, i.fund, i.prog_cd, i.psp_cd, i.orig_doc_dt, max(i.last_modf_dt), i.scty_prnc_nm, i.nm_of_prsn, i.stae_of_line,
  i.dtyp_dfnd_hd4, i.rcvd_qy, i.unpr, i.doc_type_cd, i.fund_cd, i.bbfy, i.ebfy, i.dscr, i.ln_desc, i.oplk, i.bdob_cd,
  i.orgn_cd, i.orgn_grp_cd, i.doc_stus, i.clsd_dt, i.rqsd_am, i.clsd_am, i.dllr_am, i.clsd_lnam, i.fisc_mnth, i.acty_cd,
  i.acty_nm, i.asgn_dt, i.ctrc_splt, i.orig_asgt_dt, i.last_asgt_dt, i.bdob_nm, i.uf_requ_date, i.size_of_smal_busn,
  i.addr_cd, i.duns_plus_fr_num, i.perd_perf_stdt, i.perd_perf_endt, i.prod_svc_cd, i.prod_svc_dscr, i.prod_svc_nm,
  i.offc_typ, i.offc_id, dlvr_dt, i.duns_num, i.tax_idnt_num, i.agre_num, i.agre_lnum, i.last_usr_id, i.proj_cd,
  i.user_dm5_cd, i.sec_class_cd, i.doc_key, i.div_nm, i.orgn_grp_nm, i.prog_nm, i.user_dm8_nm, i.orgn_nm, i.cmdt_cd, i.cmdt_nm,
  i.bdob_cat_cd, i.bdob_cat_nm, orgn_clas_cd, orgn_clas_nm, orgn_cat_cd, orgn_cat_nm, sbob_cd, sbob_nm, vend_cd,
  i.vend_nm, i.user_dm1_cd, i.asgt_stus, i.addr_nm, i.sub_proj_cd, i.sub_proj_nm,
  w.mlst_stus as status, w.mlst_num as milestone_number, w.mlst_dscr as description, w.mlst_stdt as start_date,
  w.cmpl_dt as completion_date, w.estm_cmpd_dt as expected_end_date, w.mlst_actl_endt as actual_end_date
from vw_iq i, vw_wkld_asgn w
Where i.doc_key = w.doc_key (+)
Group by i.user_dm8_cd, i.div_cd, i.itmz_ln_lnum, i.actg_ln_lnum, i.hdr_lnum, i.doc_num, i.titl, i.fisc_year, i.doc_dt,
  i.dtyp_cat, i.fund, i.prog_cd, i.psp_cd, i.orig_doc_dt, i.scty_prnc_nm, i.nm_of_prsn, i.stae_of_line,
  i.dtyp_dfnd_hd4, i.rcvd_qy, i.unpr, i.doc_type_cd, i.fund_cd, i.bbfy, i.ebfy, i.dscr, i.ln_desc, i.oplk, i.bdob_cd,
  i.orgn_cd, i.orgn_grp_cd, i.doc_stus, i.clsd_dt, i.rqsd_am, i.clsd_am, i.dllr_am, i.clsd_lnam, i.fisc_mnth, i.acty_cd,
  i.acty_nm, i.asgn_dt, i.ctrc_splt, i.orig_asgt_dt, i.last_asgt_dt, i.bdob_nm, i.uf_requ_date, i.size_of_smal_busn,
  i.addr_cd, i.duns_plus_fr_num, i.perd_perf_stdt, i.perd_perf_endt, i.prod_svc_cd, i.prod_svc_dscr, i.prod_svc_nm,
  i.offc_typ, i.offc_id, dlvr_dt, i.duns_num, i.tax_idnt_num, i.agre_num, i.agre_lnum, i.last_usr_id, i.proj_cd,
  i.user_dm5_cd, i.sec_class_cd, i.doc_key, i.div_nm, i.orgn_grp_nm, i.prog_nm, i.user_dm8_nm, i.orgn_nm, i.cmdt_cd, i.cmdt_nm,
  i.bdob_cat_cd, i.bdob_cat_nm, orgn_clas_cd, orgn_clas_nm, orgn_cat_cd, orgn_cat_nm, sbob_cd, sbob_nm, vend_cd,
  i.vend_nm, i.user_dm1_cd, i.asgt_stus, i.addr_nm, i.sub_proj_cd, i.sub_proj_nm,
  status, milestone_number, description, start_date, completion_date, expected_end_date, actual_end_date;
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros