My Oracle Support Banner

Import Bank Returns Process Does Not Create Receipts In Receivables After Upgrading to 22A (Doc ID 2852819.1)

Last updated on MARCH 01, 2022

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.22.01.0 and later
Oracle Fusion Financials for the Americas - Version N/A and later
Information in this document applies to any platform.

Symptoms

After upgrading to 22A, Import Bank Returns for Customer Payments does not spawn Receipt Batch (API) and receipts are not created in Oracle Receivables Cloud Service.
Following query results show the records failing during validation.

Error:The company registration number {COMPANY_INSCRIPTION_NUMBER} has not been set as the property's tax record. Please enter a valid company registration number

SELECT error_code, count(*)
FROM fusion.JL_BR_AR_RET_INTERFACE_EXT_ALL
WHERE FILE_CONTROL='<File_control for the failed job>'
GROUP BY error_code;

ERROR_CODE COUNT(*)
================
JL_COMPANY_INSCRIPTION_INVALID 2579
JL_COMPANY_NAME_INVALID 69 

Changes

 22A includes feature to check Legal Reporting Unit Alternate Name check.

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


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