My Oracle Support Banner

PeopleSoft Forms And Approval Builder: CI Integration Giving SQL Error (Doc ID 2375072.1)

Last updated on MARCH 17, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


Configured a new Fluid Form using Design Tile for HCM Payroll for one time payments.This Form is configured using Form to CI Mapping component to use delivered Component Interface CI_PY_PSHUP_LOAD.

Below SQL error occurs when clicking on View Forms.

 A SQL error occurred. Please consult your system log for details.

PSAPPSRV.20931 (631) 1-2 14.06.02 0.000076 SQL error. Function: Record.SelectByKey
 Error Position: 1154
 Return: 1841 - ORA-01841: (full) year must be between -4713 and +9999, and not be 0
 Statement: select pu_source,to_char(creation_dt,'yyyy-mm-dd'),company,paygroup,to_char(pay_end_dt,'yyyy-mm-dd'),off_cycle,to_char(earns_begin_dt,'yyyy-mm-dd'),to_char(earns_end_dt,'yyyy-mm-dd'),emplid,empl_rcd,seqno,pu_txn_type,pu_txn_status,page_num,line_num,addl_nbr,sepchk,deptid,jobcode,position_nbr,acct_cd,gl_pay_type,pu_distribute,erncd,addl_pay_shift,addl_seq,addlpay_reason,oth_hrs,hourly_rt,ok_to_pay,disable_dir_dep,state,locality,tax_periods,tax_method,ded_taken,ded_subset_id,ded_taken_genl,ded_subset_genl,business_unit,comp_ratecd,tax_class,one_time_cd,ctx_class,plan_type,benefit_plan,dedcd,ded_class,ded_calc,ded_rate_pct,pu_amt,manual_check,paycheck_nbr,ded_slstx_class,ex_doc_id,ex_doc_type,ex_line_nbr,currency_cd,override_only,grossup,vc_plan_id,vc_payout_prd_id,gb_group_id,applid,to_char(award_date,'yyyy-mm-dd'),eim_key,to_char(payout_dt,'yyyy-mm-dd'),pu_txn_manual_chg,to_char(check_dt,'yyyy-mm-dd'),oprid,garnid,garn_one_time_cd,garn_priority,garn_ded_calc,garn_ded_pct,garn_ded_amt,cmpny_fee_pct,cmpny_fee_amt,payee_fee_pct,payee_fee_amt,py_garn_exempt,work_psd_cd,res_psd_cd from ps_pshup_txn where pu_source=:1 and creation_dt=to_date(:2,'YYYY-MM-DD') AND COMPANY=:3 AND PAYGROUP=:4 AND PAY_END_DT=TO_DATE(:5,'YYYY-MM-DD') AND OFF_CYCLE=:6 AND EARNS_BEGIN_DT IS NULL AND EARNS_END_DT IS NULL AND EMPLID=:7 AND EMPL_RCD=:8 AND SEQNO=:9
 Original Statement: %SelectByKey(:1)

The issue can be reproduced at will with the following steps:
1.Create a new Form using Design Form Tile
2.Configure the Form to CI.Now Go to My Forms Tile
3.Click Fill Out a New Form
4.Select your Form from Popup: Error occurs


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.