ECM: Financial Gateway Transaction ID (PS_PMT_DETAIL_TBL.PMT_ID) only stores 11 characters (Doc ID 1948149.1)

Last updated on MARCH 16, 2016

Applies to:

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

Symptoms

According to the delivered PeopleBooks, the Source Registration set up page contains 2 defined settings in the 'Payment Numbering Properties' section:

   - Payment ID Prefix: Designate an alphanumeric prefix to use to identify the source application of the payment.   (Total of 2 characters length)
   - Last Payment Number: Represents the payment identification number of the last payment that was sent by the source application. This value is automatically updated as payments are sent to Financial Gateway.   (Total of 10 characters length)

As a result, the Transaction ID Field (PS_PMT_DETAIL_TBL.PMT_ID), which is used as the Payment ID for Financial Gateway related payments that need further interface (dispatch, settlement, etc...) should contain values of up to 12 characters. However, when testing the delivered functionality, the system only creates 11 characters long values, instead of the expected 12.

This behavior started to occur after applying Patch 11589667 -- PSFT 1941443000-FMS FINANCIALS 9.1 BUNDLE #4


STEPS
  - Log into an FSCM 9.1 environment patched at least up to FIN Bundle #4 as User ID VP1
  - Navigate to: Financial Gateway > Administration > Source Registration
  - Open existing Source AP
  - Note the following fields:
       - Payment ID Prefix = AP (2 characters)
       - Last Payment Number = 0000000016 (10 characters)
  - Navigate to: Banking > Bank Accounts > External Accounts
  - Open the Bank Set ID = SHARE, Bank Code = USBNK, and Bank Account = CHK combination
  - Navigate to the Payment Methods tab
  - For the Payment Method =Electronic Funds Transfer, make sure to have the below settings:
       - Form ID = EFT1
       - Default = Y
       - Settle By = Financial Gateway
       - Layout = PAYMENTEIP
  - Navigate to: Vendors > Vendor Information > Add/Update > Vendor
  - Open Vendor ID USA0000010
  - Go to the Location tab, and click on the Payables link
  - At the 'Additional Payables Options' section, make sure to have the following set up:
       - Pay Method Options = Specify
       - Payment Method = Electronic Funds Transfer
       - Layout Options = Specify
       - Layout = PAYMENTEIP
  - Navigate to: Accounts Payable > Vouchers > Add/Update > Regular Entry
  - Enter a new Voucher with the following information:
       - Business Unit = US001
       - Voucher ID = NEXT
       - Voucher Style = Regular Voucher
       - Vendor ID = USA0000010
       - Invoice Number = GCS EFT Test PMT_ID
       - Invoice Date = August 27th 2014
       - Gross Invoice Amount = 1000
       - Tax Exempt Flag = Y
       - Estimated No of Invoice Lines = 1
  - Click on the ADD Button, and at the Invoice Information tab, continue defining the below values:
       - Pay Terms = 00
       - Account = 610000
  - Click on the Payments tab, and define the below values:
       - Gross Amount = 1000
       - Bank = USBNK
       - Account = CHK
       - Method = EFT
  - Click on the Voucher Attributes tab, and make sure to set up:
       - Approval = Virtual Approver
  - Save the changes
  - Log in the FSCM Online Application as User ID APS1
  - Navigate to: Accounts Payable > Vouchers > Approve > Approve Voucher
  - Open the Voucher ID created, select the 'Approve' radio button, and save the changes
  - Log in the FSCM Online Application as User ID VP1
  - Navigate to: Accounts Payable > Batch Processes > Vouchers > Voucher Posting
  - Create a new Run Control ID, select the Voucher ID created, and run the process
  - Navigate to: Accounts Payable > Payments > Pay Cycle Processing > Payment Selection Criteria
  - Create a brand new Pay Cycle, that will target the Voucher ID that needs to be paid
  - Navigate to: Accounts Payable > Payments > Pay Cycle Processing > Pay Cycle Manager
  - Open the newly create Pay Cycle and run Payment Selection, Payment Creation, and the Financial Gateway Electronic Payments process to Completion
  - Navigate to: Accounts Payable > Batch Processes > Payment > Payment Posting
  - Create a new Run Control ID, select the Payment ID generated, and run the process
  - Navigate to: Financial Gateway > Process Payments > Payment Dispatch
  - Perform a search, entering the necessary criteria, to display the Payment ID generated
  - At the 'Payments' section, click on the 'Additional Detail' tab
  - Confirm that the Transaction ID field contains a value of AP000000017, being only 11 characters long, instead of the expected 12


EXPECTED BEHAVIOR
According to the Source Registration AP configuration, the Transaction ID field (PS_PMT_DETAIL_TBL.PMT_ID) is the result of combining the Payment Prefix (AP, of 2 characters) and the Last Payment Number (10 characters value), totaling 12 character values in length. Instead, the Field stores values of only 11 characters long, and this is confusing to the users.

The Record Field PS_PMT_DETAIL_TBL.PMT_ID has been defined in Application Designer with a length of 15 characters, and that should be enough to allow the storage of 12 character long values for the Transaction ID field as per the AP Source Registration. If this is not to be done, then PeopleBooks need to be corrected, and so does it need to be modified the Last Payment Number field to store only 9 characters, instead of the current 10.  

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