AP:AP_APY1099 ABENDS AT STEP AP_APY1099.COPYB100.INSCOPYB, 1099-MISC CORRECTION (Doc ID 2143434.1)

Last updated on MAY 27, 2016

Applies to:

PeopleSoft Enterprise FIN Payables - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms



ISSUE:
---------
AP_APY1099 abends with the following error

ERROR:
-----------


-- 08.34.03 ............(AP_APY1099.COPYB100.InsCopyb) (SQL)
INSERT INTO PS_WTHD_1099_COPYB (WTHD_RPT_ID , WTHD_SETID , WTHD_CNTL_ID ,
WTHD_TYPE , PAYER_TIN , PAYEE_TIN , VENDOR_ID , PAYEE_NAME1 , PAYEE_NAME2 ,
WTHD_VOID_FLG , WTHD_CORR_FLG , CALENDAR_YEAR , SEQ_NBR , CUSIP_NBR ,
PAYER_NAME1 , PAYER_NAME2 , PAYER_ADDRESS1 , PAYER_ADDRESS2 , PAYER_ADDRESS3
, PAYER_ADDRESS4 , PAYER_CITYSTZIP , PAYER_PHONE , PAYEE_ADDRESS1 ,
PAYEE_ADDRESS2 , PAYEE_ADDRESS3 , PAYEE_ADDRESS4 , PAYEE_CITYSTZIP ,
SECOND_TIN , WTHD_BOX1 , WTHD_BOX2 , WTHD_BOX3 , WTHD_BOX4 , WTHD_BOX5 ,
WTHD_BOX6 , WTHD_BOX7 , WTHD_BOX8 , WTHD_BOX09 , WTHD_BOX9 , WTHD_BOX10 ,
WTHD_BOX13 , WTHD_BOX14 , WTHD_BOX15 , WTHD_BOX15A , WTHD_BOX15B , WTHD_BOX16
, WTHD_BOX17 , WTHD_BOX18 , WTHD_BOX3I , WTHD_BOX8G , WTHD_BOX09G ,
COUNTRY_PAID , FOREIGN_TAX_PAID , TIN_TYPE , BOND_PREMIUM , MARKET_DISCOUNT ,
PRIVATE_BOND_INT , TAX_EXMPT_INTEREST , BOND_PREMIUM_TAXEX , FATCA_INDICATOR)
VALUES ('US_REPORT' , 'OHS' , 'INTEGRIS' , '1099' , '731192764' , '446746738'
, '0001079342' , 'STOKESBERRY DAVID' , ' ' , 'N' , 'Y' , 2014 , 2 , ' ' ,
'INTEGRIS HEALTH INC' , ' ' , '3300 NORTHWEST EXPRESSWAY' , ' ' , ' ' , ' ' ,
'OKLAHOMA CITY, OK 731124418' , '(405) 949-3085' , '3366 NW EXPRESSWAY SUITE
300' , ' ' , ' ' , ' ' , 'OKLAHOMA CITY, OK 73112' , 'N' , 0 , 0 , 0 , 0 ,
0 , 0 , 0 , 0 , 0 , 'N' , 0 , 0 , 0 , 0 , 0 , 0 , 0 , ' ' , 0 , ' ' , ' ' , 0
, ' ' , 0 , 'S' , 0 , 0 , 0 , 0 , 0 , ' ')
/
-- Row(s) affected: 0
-- 08.34.03 Process 6227230 ABENDED at Step AP_APY1099.COPYB100.InsCopyb (Action SQL) -- RC = 805
ROLLBACK


STEPS:
----------
1. Create vouchers
2. Pay vouchers
3. Post payments
4. Run post withholding
5.Run withholding post
6. Run withholding post report

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