My Oracle Support Banner

ECM: Empty <Ctry> tag due to the coding in method GetTwoDigitCountryCode from AppPackage TR_FORMAT.Payment.SCT3Formatter which is ignoring the last value from the array of countries (Doc ID 2846684.1)

Last updated on APRIL 05, 2022

Applies to:

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

Symptoms

Empty <Ctry> tag due to the coding in method GetTwoDigitCountryCode from AppPackage TR_FORMAT.Payment.SCT3Formatter which is ignoring the last value from the array of countries.

Steps:

   1. Find country which is last in the PS_COUNTRY_TBL.
   - On DEMO, last country is SRB – Republic of Serbia

   2. Create a new SRB Supplier (Navigation: Suppliers > Supplier Information > Add/Update > Supplier > Identifying Information)

2.1 Vendor Address Setup:
   - Vendor Country = SRB

2.2 Location setup > Payable Options > Additional Payable Optios:
   - Bank: FRBNK
   - Account: CHQ3
   - Currency: EUR
   - Payment Method: EFT

2.3 Location setup > Payable Options > Supplier Bank Account: Country: SRB

   3. External Bank Account Setup (Navigation: Banking > Bank Accounts > External Accounts > External Accounts):

   - Bank: FRBNK
   - Bank Account: CHQ3
   - Payment Method: EFT
   - Form_ID: EFT2
   - Settle through: Financial Gateway
   - Layout: SEPA_CT_03

   4. Update Layout SEPA_CT_03 in Layout Catalog to following set-up (Navigation: Banking > Administer Bank Integration > Layout Catalog):

   - Transformation program type: AE Transform
   - Transformation Program Name: PMT_SCT03_XF
   - Grouping Rule: BANK

   5. Create a Voucher for the newly created EFT SRB Supplier (Navigation: Accounts Payable > Vouchers > Add/Update > Regular Entry > Invoice Information).

   6. Pay the voucher through Express Payment.
   7. Process Financial Gateway Electronic Payments.
   8. Run Payment Dispatch (Navigation: Financial Gateway > Process Payments > Payment Dispatch).
   9. Review the XML:
   - The <Ctry> </Ctry tag is empty while it should contain country code for Serbia.

Note: Since the method is present in many Formatters then the same issue can be reproducible with other formatters as well, e.g: SCTFormatter, BaseFormatter, C2BSwiftFormatter etc.

NOTE: In the <images, examples, video > and/or the attached document, user details/company name/address/email/ telephone number all represent a fictitious sample from the Oracle Demo Version Database.

Any similarity to actual companies or actual persons, living or dead, is purely coincidental and is in no way intentional on the part of Oracle

 

 

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
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.