My Oracle Support Banner

R12: IBY: Format Payment Instructions Completing In Error Exception "No Corresponding LOB Data Found" Was Identified in the Request Log. (Doc ID 2870277.1)

Last updated on JUNE 28, 2022

Applies to:

Oracle Payments - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

Format Payment Instructions concurrent request is failing.

Format Payment Instructions Completing In Error.

Concurrent Request Log shows the following:

Exception "No Corresponding LOB Data Found".

 

The issue is reproducible as follow:

  1. Log into Oracle Applications using a Payables responsibility.
  2. Open the "Payments Dashboard" OAF Page.
    (N) Payments > Entry > Payments Manager
  3. Submit a New Payments Process Request.
  4. Review the Format Payment Instructions concurrent request Log file; it shows the Error/Exception described above.

 

Customer was using a customized output template for their Payment Instructions.

MOS Document "R12: AP/IBY: The Extract Identity Template has No File Attached : Internal Error to Payment Server: No corresponding LOB data found" was followed with NO success.  The custom template was loaded successfully.

An output of the "EBS Payments (IBY) Funds Disbursement Analyzer Report" (IBYFD Analyzer) executed for the Payment Process Request (PPR) linked to the problem Payment Instruction, shows the following information regarding the custom template:

▼XDO_TEMPLATES
TEMPLATE_ID APPLICATION
_ID
APPLICATION_
SHORT_NAME
TEMPLATE_CODE DS_APP_
SHORT_NAME
DATA_SOURCE_CODE TEMPLATE_
TYPE_CODE
DEFAULT_
LANG
DEFAULT_
TERRITORY
TEMPLATE_
STATUS
USE_ALIAS
_TABLE
DEPENDENCY
_FLAG
START_DATE END_DATE OBJECT_VERSION
_NUMBER
CREATION_DATE
 
7232 673 IBY XXMFP_AP_WF_XML_CK IBY IBY_FD_INSTRUCTION_1_0 RTF en US E N P 2022-01-05 08:21:38    7 2022-01-05 08:23:42

▼XDO_LOBS
LOB_TYPE LOB_CODE FILE_NAME LANG. TERRITORY XDO_FILE_TYPE FILE_STATUS FILE_CONTENT_TYPE PROGRAM CRE.DATE LAST_UPD.DATE
 
TEMPLATE_SOURCE XXMFP_AP_WF_XML_CK MFP_WF_AP_Check_Template_Linux_01052022.rtf en US RTF E application/rtf   2022-01-05 08:23:43 2022-01-05 09:01:34
TEMPLATE XXMFP_AP_WF_XML_CK MFP_WF_AP_Check_Template_Linux_01052022.xsl en US XSL-FO E text/xml RTF2XSLParser 5.6.3 2022-01-05 08:23:43 2022-01-05 09:01:34

 

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
 A. Bounce the Apache/middle-tier server(s) and clear cache after loading the custom template.
 B. Check for Invalid Characters
 C. Review / Confirm the data in the tables and views involved with the Payment Instruction concurrent program and the custom output template associated.
 D. Check the template information via the WebUI.
 E. Edit / Review the actual template file(s)
References


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