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 AUGUST 28, 2023
Applies to:
Oracle Payments - Version 12.2.10 and laterInformation 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:
The issue is reproducible as follow:
- Log into Oracle Applications using a Payables responsibility.
- Open the "Payments Dashboard" OAF Page.
(N) Payments > Entry > Payments Manager - Submit a New Payments Process Request.
- 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:
| 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 |
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 |
| 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 |