EAP: Brazil Localization: Payment Posting Abends At The Step AP_PSTCOMMON.HISTORIC.HIST-3K (Doc ID 2134812.1)

Last updated on MAY 11, 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

When attempting to run Payment Posting, the process abends at the step AP_PSTCOMMON.HISTORIC.HIST-3K.

STEPS:

1. Running Payment Posting.
2. Process abends at the step AP_PSTCOMMON.HISTORIC.HIST-3K:

"

Error Position: 1011 Return: 1400 - ORA-01400: cannot insert NULL into ("SYSADM"."PS_HISTOR_TEMP_BRL"."HIST_PART_BRL_3")
Failed SQL stmt:INSERT INTO PS_HISTOR_TEMP_BRL( BUSINESS_UNIT , VOUCHER_ID , UNPOST_SEQ , APPL_JRNL_ID , PYMNT_CNT , VOUCHER_LINE_NUM , DISTRIB_LINE_NUM , DST_ACCT_TYPE , VOUCHER_STYLE , CF_BAL_LINE_NUM , LEDGER , HIST_PART_BRL_1 , HIST_PART_BRL_2 , HIST_PART_BRL_3 , HIST_PART_BRL_4 , PROCESS_INSTANCE ) SELECT A.BUSINESS_UNIT , A.VOUCHER_ID , A.UNPOST_SEQ , A.APPL_JRNL_ID , A.PYMNT_CNT , A.VOUCHER_LINE_NUM , A.DISTRIB_LINE_NUM , A.DST_ACCT_TYPE , A.VOUCHER_STYLE , A.CF_BAL_LINE_NUM , A.LEDGER , A.HIST_PART_BRL_1 , ( SELECT B.HIST_PART_BRL_2 FROM PS_TMP_BRL_HIST2 B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.VOUCHER_ID = B.VOUCHER_ID AND A.UNPOST_SEQ = B.UNPOST_SEQ AND A.APPL_JRNL_ID = B.APPL_JRNL_ID AND A.PYMNT_CNT = B.PYMNT_CNT AND A.VOUCHER_LINE_NUM = B.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = B.DISTRIB_LINE_NUM AND A.DST_ACCT_TYPE = B.DST_ACCT_TYPE AND A.VOUCHER_STYLE = B.VOUCHER_STYLE AND A.CF_BAL_LINE_NUM = B.CF_BAL_LINE_NUM AND A.LEDGER = B.LEDGER AND A.PROCESS_INSTANCE = B.PROCESS_INSTANCE) , ( SELECT C.HIST_PART_BRL_3 FROM PS_TMP_BRL_HIST3 C WHERE A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.VOUCHER_ID = C.VOUCHER_ID AND A.UNPOST_SEQ = C.UNPOST_SEQ AND A.APPL_JRNL_ID = C.APPL_JRNL_ID AND A.PYMNT_CNT = C.PYMNT_CNT AND A.VOUCHER_LINE_NUM = C.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = C.DISTRIB_LINE_NUM AND A.DST_ACCT_TYPE = C.DST_ACCT_TYPE AND A.VOUCHER_STYLE = C.VOUCHER_STYLE AND A.CF_BAL_LINE_NUM = C.CF_BAL_LINE_NUM AND A.LEDGER = C.LEDGER AND A.PROCESS_INSTANCE = C.PROCESS_INSTANCE) , ( SELECT D.HIST_PART_BRL_4 FROM PS_TMP_BRL_HIST4 D WHERE A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.VOUCHER_ID = D.VOUCHER_ID AND A.UNPOST_SEQ = D.UNPOST_SEQ AND A.APPL_JRNL_ID = D.APPL_JRNL_ID AND A.PYMNT_CNT = D.PYMNT_CNT AND A.VOUCHER_LINE_NUM = D.VOUCHER_LINE_NUM AND A.DISTRIB_LINE_NUM = D.DISTRIB_LINE_NUM AND A.DST_ACCT_TYPE = D.DST_ACCT_TYPE AND A.VOUCHER_STYLE = D.VOUCHER_STYLE AND A.CF_BAL_LINE_NUM = D.CF_BAL_LINE_NUM AND A.LEDGER = D.LEDGER AND A.PROCESS_INSTANCE = D.PROCESS_INSTANCE ) , 345761 FROM PS_TMP_BRL_HIST1 A WHERE A.PROCESS_INSTANCE = 345761

O processo 345761 foi INTERROMPIDO na Etapa AP_PSTCOMMON.HISTORIC.HIST-TMP (SQL) - RC = 1400 (108,524)

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

"

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