My Oracle Support Banner

AP.9.2.PIR_SRF_DEIU Process Errors With Unique Constrain In "INSERT INTO PS_SRF_SRC_DT" When A Voucher Has 2 Funds That Roll Up To One TAS (Doc ID 2731335.1)

Last updated on DECEMBER 22, 2020

Applies to:

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

Symptoms

When a voucher that is supposed to be included in the PIR file has 2 funds that roll up to the same TAS., the PIR file creation process errors out with the following message

ORA-00001: unique constraint (SYSADM.PS_SRF_SRC_DT) violated Failed SQL stmt: INSERT INTO PS_SRF_SRC_DT ( PROCESS_INSTANCE , SRF_SRC_IS_BC , BATCH_SEQ_NUM , PAYM ENT_SEQ_NUM , SPS_TAS , SPS_BETC , SRF_DT_PAYMNT_ID , SUB_LEVEL_CD , ALLO_TR_AGENCY , AGENCY_ID1 , B EGIN_PERIOD_AVAIL , END_PERIOD_AVAIL , AVAIL_TYPE_CD , MAIN_ACCOUNT , SUB_ACCOUNT , MERCH_AMT_BSE )
VALUES ( 44 , 'N' , 1 , 1 , 'XXXXXXXX' , 'DISB' , 'ZZZZZZZZZZZZZZZZ' , ' ' , ' ' , '000' , '2020 ' , '2020' , ' ' , '0400' , '000' , ABC.DEF )

Process 44 ABENDED at Step PIR_SRF_DEIU.DDT00000.Step0030 (SQL) -- RC = 805


Steps to reproduce the issue :

  1. Enable Federal Payments on the Installation Options- Federal page
  2. Set up an NTDO ALC as a GWA reporter.
  3. Link the ALC to a bank account.
  4. Set up an EFT payment method with an SF1166TRVL layout as the default as well as an ACH payment method with a CTX layout.
  5. Set up Payment Restrictions for both layouts.
  6. Set up the bank and layouts on the PIR Definition page.
  7. Set up the pay cycle.-- – You must have a certifier with a Payment Schedule ID
  8. Set up a vendor with a remit bank account.
  9. Create, Approve, Budget Check, Post Voucher that has 2 lines with 2 different funds but the same TAS
  10. Pay the invoice by running the pay cycle. You must certify and reconcile too.
  11. Run PIR payment selection.
  12. Select the payments and add Voucher Number, Voucher Date, and Voucher Type in the PIR Workbench - AP>Review Accounts Payables>Payments>Pir workbench
  13. Run PIR file creation (Ap>Batch processes>Payment>PIR SRF File Creation)
  14. Choose app_engine (PIR_SRF_DEIU)
  15. Process errors out due to unique constraint error because voucher has 2 funds but one TAS

Check the replication document attached .

 

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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