EAP WTHD16 : 1099 REPORT AP_APY1099 ABENDS AT STEP AP_APY1099.EVAL_AMT.STEP01 (Doc ID 2208091.1)

Last updated on DECEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 and later
Information in this document applies to any platform.

Symptoms

For a 1099 applicable Vendor/Supplier with multiple Locations with Class = 7 (Non Employee Compensation) and same TIN #, TIN Type and Withholding Address but one of the Locations has additional information like Date of Birth, Certification Expiration etc , the 1099 Report AP_APY1099 process abends at Step AP_APY1099.EVAL_AMT.Step01 when 'Include Non Employee Compensation' is checked.

STEPS
1.  Setup a 1099 applicable Vendor/Supplier with multiple Locations for Class 07. The locations have the same TIN # and Withholding Address seq number

Vendor SHARE/0000000049
Loc 1 - Withholding Class = 07, TIN # 123456789, Withholding Address Seq # 1
Loc 2 - Withholding Class = 07, TIN # 123456789, Withholding Address Seq # 1 , Birth date = 1/1/1975 , Certification Expiry Date = 1/1/2017

2.  Enter Withholding Adjustment as follows:

Vendor SHARE/0000000049
Loc 1 - Withholding Class = 07, Amount = 25000
Loc 2 - Withholding Class = 07, Amount = 35000

3. Setup  Withholding 1099 Job with following details:

Check Include Manual Overrides
Type of File/Retunr: Original/Correction
Include Non Employee Compensation is checked.

4.  Run Withholding 1099 Job process

The process failed with following error:

SQL error. Function:  SQLExec

Error Position:  264

Return:  1427 - ORA-01427: single-row subquery returns more than one row

 Statement:  select count(*), sum(c_rec.wthd_basis_amt)from
ps_wthd_to_snd_dtl c_rec where c_rec.wthd_rpt_id = :1 and c_rec.wthd_setid =
:2 and c_rec.wthd_cntl_id = :3 and c_rec.wthd_type = :4 and  c_rec.payer_tin
= :5 and c_rec.line_no = :6 and c_rec.send_status = 'o' and 1= (SELECT 1 FROM
PS_WTHD_TO_SND_DTL D WHERE C_REC.WTHD_RPT_ID = D.WTHD_RPT_ID AND
C_REC.WTHD_SETID = D.WTHD_SETID AND C_REC.WTHD_CNTL_ID = D.WTHD_CNTL_ID AND
C_REC.WTHD_TYPE = D.WTHD_TYPE AND C_REC.PAYER_TIN = D.PAYER_TIN AND
C_REC.SEND_STATUS = D.SEND_STATUS AND C_REC.VENDOR_SETID = D.VENDOR_SETID AND
C_REC.VENDOR_ID = D.VENDOR_ID AND D.LINE_NO = 7 AND D.WTHD_BASIS_AMT <> 0)
GROUP BY C_REC.LINE_NO

 Original Statement:  SELECT COUNT(*), SUM(C_REC.WTHD_BASIS_AMT)FROM
PS_WTHD_TO_SND_DTL C_REC WHERE C_REC.WTHD_RPT_ID = :1 AND C_REC.WTHD_SETID =
:2 AND C_REC.WTHD_CNTL_ID = :3 AND C_REC.WTHD_TYPE = :4 AND  C_REC.PAYER_TIN
= :5 AND C_REC.LINE_NO = :6 AND C_REC.SEND_STATUS = 'O' AND 1= (SELECT 1 FROM
PS_WTHD_TO_SND_DTL D WHERE C_REC.WTHD_RPT_ID = D.WTHD_RPT_ID AND
C_REC.WTHD_SETID = D.WTHD_SETID AND C_REC.WTHD_CNTL_ID = D.WTHD_CNTL_ID AND
C_REC.WTHD_TYPE = D.WTHD_TYPE AND C_REC.PAYER_TIN = D.PAYER_TIN AND
C_REC.SEND_STATUS = D.SEND_STATUS AND C_REC.VENDOR_SETID = D.VENDOR_SETID AND
C_REC.VENDOR_ID = D.VENDOR_ID AND D.LINE_NO = 7 AND D.WTHD_BASIS_AMT <> 0)
GROUP BY C_REC.LINE_NO
2016-11-23-12.11.12.640213  AePcdExecutePeopleCode [191] Exception logged:
RC=100.
2016-11-23-12.11.12.640214  GetNextStateRecord [68] Exception logged: RC=3.

SQL error in Exec. (2,280)
AP_APY1099.EVAL_AMT.GBL.default.1900-01-01.Step01.OnExecute
Name:Calc_Pymnt_Amt  PCPC:2455  Statement:37

Called from:AP_APY1099.EVAL_AMT.GBL.default.1900-01-01.Step01.OnExecute Statement:154
2016-11-23-12.11.13.639430  DoStepActions [1956] Exception logged: RC=100.

Process 14234 ABENDED at Step AP_APY1099.EVAL_AMT.Step01 (PeopleCode) -- RC = 8 (108,524)

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms