R12: AP: After Upgrade to Oracle RDBMS to 19C, Error ORA-24263 Raises While Running Custom Concurrent Program to Transfer Files Through FTP from Oracle to Destination Server
(Doc ID 2955767.1)
Last updated on JUNE 15, 2023
Applies to:
Oracle Payables - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
Error ORA-24263 while running custom concurrent program to transfer files through FTP from Oracle to destination server.
Custom program to transfer files between Oracle and third party tool.
The certificate between Oracle server and destination server is valid with expiration date of 2025.
Log file of the failing concurrent program shows the following:
+---------------------------------------------------------------------------+
Payables: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
XXBCF_IMGNOW_FCOPY: XXBCF_IMAGENOW_FILECOPY_TO_EBS
+---------------------------------------------------------------------------+
Current system time is 16-MAY-2023 10:27:48
+---------------------------------------------------------------------------+
[16-MAY-2023 10:27:48]: **Starts**
[16-MAY-2023 10:27:49]: **SQL error and free**
[16-MAY-2023 10:27:49]: ORACLE error 24263 in FDPSTP
Cause: FDPSTP failed due to ORA-24263: Certificate of the remote server does not match the target address.
ORA-06512: at "SYS.UTL_TCP", line 63
ORA-06512: at "SYS.UTL_TCP", line 314
ORA-06512: at "APPS.XXBCF_IMAGENOW_UTILS",
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
step3.1
syst_name:OSTG
dirpath:/usr/tmp/OSTG
dirname:EBS_APPLPTMP
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 16-MAY-2023 10:27:49
+---------------------------------------------------------------------------+
Payables: Version : 12.2
Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.
XXBCF_IMGNOW_FCOPY: XXBCF_IMAGENOW_FILECOPY_TO_EBS
+---------------------------------------------------------------------------+
Current system time is 16-MAY-2023 10:27:48
+---------------------------------------------------------------------------+
[16-MAY-2023 10:27:48]: **Starts**
[16-MAY-2023 10:27:49]: **SQL error and free**
[16-MAY-2023 10:27:49]: ORACLE error 24263 in FDPSTP
Cause: FDPSTP failed due to ORA-24263: Certificate of the remote server does not match the target address.
ORA-06512: at "SYS.UTL_TCP", line 63
ORA-06512: at "SYS.UTL_TCP", line 314
ORA-06512: at "APPS.XXBCF_IMAGENOW_UTILS",
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
step3.1
syst_name:OSTG
dirpath:/usr/tmp/OSTG
dirname:EBS_APPLPTMP
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
No completion options were requested.
Output file size:
0
+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 16-MAY-2023 10:27:49
+---------------------------------------------------------------------------+
Changes
Upgraded RDBMS to 19c
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 |