Skip to Main Content

PeopleSoft Enterprise

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-00904: "SPN": invalid identifier

795298Oct 24 2010 — edited Nov 2 2010
Team

I am caught in a situation and I am reaching out for support. I am importing the scripts on datamover and I am receiving this error:

File: Data MoverSQL error. Stmt #: 0 Error Position: 2293 Return: 904 - ORA-00904: "SPN": invalid identifier
Failed SQL stmt:INSERT INTO PS_INSTALLATION (COMPANY, MIN_STD_HRS, MAX_STD_HRS, EMPLID_LENGTH, STD_HRS_DEFAULT, STD_HRS_FREQUENCY, TEMP_SSN_MASK, COMMIT_AFTER, POSITION_MGMT, COUNTRY, COMP_FREQUENCY, EMPLID_LAST_EMPL, NON_EMPLOYEE_LAST, DEMAND_ID_LAST, POSN_NBR_LAST, GRIEVANCE_NBR_LAST, INCIDENT_NBR_LAST, CLAIM_NBR_LAST, FILE_CREATE_LAST, ROE_NBR_LAST, CAN_CMA, CAN_IND_SECTOR, MULTI_STEP_GRADE, FSA_CLAIMS, BENEFIT_ADMINISTRN, START_EVENT_DT, EXCHNG_TO_CURRENCY, EXCHNG_TO_RT_TYPE, HR, AM, AP, AR, GL, BD, PC, PO, INV, BI, OM, PUBLIC_SECTOR, RETROPAY_SEQ_LAST, RETRODED_SEQ_LAST, RETRO_DEDUCTIONS, TL, AUTO_EE_TAX, SAME_ST_LCL_RSDNCE, FMLA_ADMINISTRN, BAL_ID_FOR_CAL_YR, MAX_ROWS_SCROLL, PA, CAR_LAST, BEN_BILLING, COBRA_ADMINISTRN, LAST_TL_CONTRCTR, ORGCHART, COBRA_EMPLID_LAST, FSA_CLAIM_NBR_LAST, FSA_CRY_CLAIM_LAST, US, CAN, GER, FRA, UK, JPN, BEL, NLD, ESP, MEX, AUS, MYS, NZL, SGP, HKG, INSTALLED_PAY_GBL, IND, BRA, CHN, THA, INSTALLED_PAY_NA, INSTALLED_PAY_INT, USE_POINTS_SW, USE_RTCD_GROUP_SW, ROWSECCLASS, ILL_NBR_LAST_GER, FED, FP_FLAG, GVT_PAY_BASIS, ACCT_CD_LAST, CPS_TRANS_ID_LAST, CHE, ITA, ALLW_CONC_CALCCONF, PIN_NUM_LAST, GP_CST_INSTALL_IND, AP_INVNO_PREFIX, AP_INVNO_LAST, ST, ILL_NBR_LAST_NLD, ADJ_TL_FINAL_CHK, ADJ_TL_ONL_CHK, ADJ_TL_REV_ADJ, REFRSH_TL_JOB_CHG, REFRSH_TL_PRECALC, PSEBENEFITS, PSECOMP, PSEPAY, PSEPROFILE, PSERECRUIT, CCU, PSEA, INSTALLED_GP_AUS, INSTALLED_GP_BRA, INSTALLED_GP_CAN, INSTALLED_GP_CHE, INSTALLED_GP_CHN, INSTALLED_GP_DEU, INSTALLED_GP_ESP, INSTALLED_GP_FRA, INSTALLED_GP_HKG, INSTALLED_GP_IND, INSTALLED_GP_ITA, INSTALLED_GP_JPN, INSTALLED_GP_MEX, INSTALLED_GP_MYS, INSTALLED_GP_NLD, INSTALLED_GP_NZL, INSTALLED_GP_SGP, INSTALLED_GP_THA, INSTALLED_GP_UK, INSTALLED_GP_USA, PSECOMP_MGR, PSEPROFILE_MGR, PSERECRUIT_MGR, EPW, FO_PBM, AUTO_JOB_END, AUTO_JOB_SUSPEND, TEMP_ASSGN_ID_LAST, EHC, EPG, EPU, APS_AUS, DI, RP, INSTALLED_GP_ARG, INSTALLED_GP_IRL, INSTALLED_GP_TWN, TL_MOBILE, PSEPERF_MANAGEMENT, AA_ENABLED_JPN, INSTALLED_PAY_PPS, AV, SA, SG, HGA, ELM, PS_GL_VERSION, ADP, RSRW, CSS, HMCF_VALID_CACHE, HMCF_CACHE_RETAIN, HMCF_EIP_LIMIT, LAST_OSHA_CASE_NBR, GVT_NFC_INDICATOR, MILITARY, BEN_DED_CLS_ORDER, TBH_SEQ_LAST, ENC_TRIGGER, LAST_SP_ID_ASSIGN, UPD_INCUMB_LMT, INSTALLED_OWS, OWS_SEQ_LAST, SAIP, HP_ENFORCE_RTBC, HP_KK_BUDGET_PROC, ARG, TMOD, SPN) VALUES (:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, TO_DATE(:26,'YYYY-MM-DD'), :27, :28, :29, :30, :31, :32, :33, :34, :35, :36, :37, :38, :39, :40, :41, :42, :43, :44, :45, :46, :47, :48, :49, :50, :51, :52, :53, :54, :55, :56, :57, :58, :59, :60, :61, :62, :63, :64, :65, :66, :67, :68, :69, :70, :71, :72, :73, :74, :75, :76, :77, :78, :79, :80, :81, :82, :83, :84, :85, :86, :87, :88, :89, :90, :91, :92, :93, :94, :95, :96, :97, :98, :99, :100, :101, :102, :103, :104, :105, :106, :107, :108, :109, :110, :111, :112, :113, :114, :115, :116, :117, :118, :119, :120, :121, :122, :123, :124, :125, :126, :127, :128, :129, :130, :131, :132, :133, :134, :135, :136, :137, :138, :139, :140, :141, :142, :143, :144, :145, :146, :147, :148, :149, :150, :151, :152, :153, :154, :155, :156, :157, :158, :159, :160, :161, :162, :163, :164, :165, :166, :167, :168, :169, :170, :171, :172, :173, :174, :175, :176, :177, :178, :179)

Any idea why? In case you need to know, I am running PT8.50 on Oracle database and HRMS 9.1. Be Blessed
This post has been answered by Soundappan on Oct 28 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 30 2010
Added on Oct 24 2010
52 comments
3,062 views