EAP Brazilian Localization: Payment Posting abends at Step AP_PSTPYMNT.BH200.BH200-5 when canceling IR (1708) Withholding (Doc ID 1925585.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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

Symptoms

Brazil Localization -- When attempting to cancel a Withholding Payment, Payment Posting abends at Step AP_PSTPYMNT.BH200.BH200-5 with an error.

ERROR
Return: 1400 - ORA-01400: cannot insert NULL into ("EMDBO"."PS_PMTVCH_WTHD4"."VLR_DED_DEP_BRL")
Failed SQL stmt: INSERT INTO PS_PMTVCH_WTHD4 (PROCESS_INSTANCE , BUSINESS_UNIT , VOUCHER_ID , PYMNT_CNT , WTHD_ENTITY , WTHD_TYPE , WTHD_JUR_CD , WTHD_CLASS , WTHD_RULE , WTHD_BASIS_AMT , WTHD_AMT , TXN_CURRENCY_CD , POSTING_DATE , POST_STATUS_WTHD , CREATE_PAY_FLG , BASE_CURRENCY , WTHD_BASIS_AMT_BSE , WTHD_AMT_BSE , WTHD_DECL_DATE , WTHD_AMT_ENT , ENT_CURRENCY_CD , ENT_RT_TYPE , ENT_RATE_MULT , ENT_RATE_DIV , WTHD_BASIS_AMT_ENT , BU_REGIST_ID , VNDR_REGIST_ID , APPL_VENDOR_SETID , APPL_VENDOR_ID , APPL_VNDR_LOC , APPL_ADDR_SEQ_NUM , WTHD_PYMNT_CNT , ORG_WTHD_BASIS_ENT , WTHD_SURCHRG_AMT , ADDL_SRCHRG_AMT , WTHD_BRL_TYPE , WTHD_ACCTG_BRL , WTHD_CESS_AMT ,WTH_SRCHRG_AMT_BSE , ADD_SRCHRG_AMT_BSE , WTHD_CESS_AMT_BSE) SELECT 11356 , A.BUSINESS_UNIT , A.VOUCHER_ID , 4 , A.WTHD_ENTITY , A.WTHD_TYPE , A.WTHD_JUR_CD , A.WTHD_CLASS , A.WTHD_RULE , A.WTHD_BASIS_AMT , A.WTHD_AMT , A.TXN_CURRENCY_CD , A.POSTING_DATE , A.POST_STATUS_WTHD , A.CREATE_PAY_FLG , A.BASE_CURRENCY , A.WTHD_BASIS_AMT_BSE , A.WTHD_AMT_BSE , A.WTHD_DECL_DATE , A.WTHD_AMT_ENT , A.ENT_CURRENCY_CD , A.ENT_RT_TYPE , A.ENT_RATE_MULT , A.ENT_RATE_DIV , A.WTHD_BASIS_AMT_ENT , A.BU_REGIST_ID , A.VNDR_REGIST_ID , A.APPL_VENDOR_SETID , A.APPL_VENDOR_ID , A.APPL_VNDR_LOC , A.APPL_ADDR_SEQ_NUM , A.WTHD_PYMNT_CNT , A.ORG_WTHD_BASIS_ENT , A.WTHD_SURCHRG_AMT , A.ADDL_SRCHRG_AMT , A.WTHD_BRL_TYPE , A.WTHD_ACCTG_BRL , A.WTHD_CESS_AMT , A.WTH_SRCHRG_AMT_BSE , A.ADD_SRCHRG_AMT_BSE , A.WTHD_CESS_AMT_BSE FROM PS_PYMNT_VCHR_WTHD A WHERE A.BUSINESS_UNIT = 'BGAP1' AND A.VOUCHER_ID = '00000035' AND PYMNT_CNT = 2

Process 11356 ABENDED at Step AP_PSTPYMNT.BH200.BH200-5 (SQL) -- RC = 1400 (108,524)

Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC = %s

PSAESRV completed service request at 13.13.29 2014-08-28

STEPS
1. Create a Voucher with IR Withholding
2. Pay the IR Withholding Schedule
3. Run Payment Posting
4. Cancel the Payment
5. Run Payment Posting for the Payment Cancellation

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