My Oracle Support Banner

EAP: Financial Sanction Validation Fails -- (158,10836) AP_SDN_VAL.MAIN.Step04 (Doc ID 1668684.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

Running the Financial Sanction Validation (AP_SDN_VAL) process on PSUNIX for 250,000 Vendors.  System has been optimized.  Chunk Size is set to 25,000 so 15 jobs are created.  When on Bundle #23, this scenario worked fine. The Financial Sanction Validation ran to success without any problems.

However, after applying Release 9.1 Bundle #24, which has Bug 13936488 -- AP:FINANCIAL SANCTION VALIDATION PROCESS GOES TO NO SUCCESS ON PSUNX SERVER incorporated into it, an error occurs on the stdout file.

ERROR
09.59.46 .(AP_SDN_VAL.MAIN.Step04) (PeopleCode)
2013-10-10-10.04.53.013280 AePcdExecutePeopleCode 188 Exception logged:RC=100.
2013-10-10-10.04.53.013436 GetNextStateRecord 68 Exception logged: RC=3.

Integration Gateway: General Connection Failed (158,10836)
AP_SDN_VAL.MAIN.GBL.default.1900-01-01.Step04.OnExecute PCPC:427 Statement:6
2013-10-10-10.04.53.013479 DoStepActions 1853 Exception logged: RC=100.

Process 4693838 ABENDED at Step AP_SDN_VAL.MAIN.Step04 (PeopleCode) -- RC = 8 (108,524)

The SQL/PeopleCode trace has the following information:

3 0.000146 ErrorReturn-> 10836 - Integration Gateway: General Connection Failed (158,10836) AP_SDN_VAL.MAIN.GBL.default.1900-01-01.Step04.OnExecute PCPC:427 Statement:6
17169 10.04.53 0.000068 <<< end Nest=00 AP_SDN_VAL.MAIN.GBL.default.1900-01-01.Step04.OnExecute Dur=306.908333 CPU=5.920000 Cycles=32
17170 10.04.53 0.017927 Cur#6.8833.KCTFSTST RC=0 Dur=0.000001 Rollback

STEPS
1. Apply Release 9.1 Bundle #24
2. Navigate to Set Up Financials/Supply Chain > Install > Installation Options > Overall page
3. Click on the Financial Sanctions Options hyperlink
4. Validation Options set to Payables/eSettlements = Enables at Installation
5. Navigate to Banking > Financial Sanctions > Import Financial Sanctions List
6. Run the IMPORT_FILES process to import the SDN file
7. Navigate to PeopleTools > Search Engine > Record-Based Indexes
8. Build the Indexes for SDN_SEARCH_ADDR and SDN_SEARCH_NAME
9. Navigate to Vendors > Vendor Information > Maintain > Financial Sanctions Validation
10. Check Pre-Process in chunks and enter Chunk Size
11. Run the AP_SDN_VAL process on PSUNIX
12. Process will abend at the above Step with the above error

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.