Journal Import From AP And AR Fails After Enhancement Patch 32908194 Applied To Implement BETCs Based On Funding Group Functionality (Doc ID 2794962.1)

Last updated on AUGUST 11, 2023

Applies to:

Symptoms

On : 12.2.x version

Payables Transfer Journal Entries to GL is failing in Journal Import after applying Patch 32908194

Applied Patch 32908194: ADD FUNDING GROUP TO, BETC, AND TAS/BETC MAPPING FORMS

Payables and Receivables Transfer Journal Entries to GL are both failing on Journal Import after applying Patch 32908194

Receiving below error in Journal Import:

Below is from Payables Journal Import
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: -6503 sqlerrml: 70
sqlerrmc:
ORA-06503: PL/SQL: Function returned without value
ORA-06512: at "APPS
sqlerrp: sqlerrd: 0 0 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: Process logging off database and exiting ...

Below is from Receivables Journal Import
****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-01403: no data found
  
sqlerrp: sqlerrd: 0 1 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************SHRD0044: Process logging off database and exiting ...
+---------------------------------------------------------------------------+
 

ERROR
-----------------------
ORA-01403 ORA-06503




STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Oracle Applications
2. Submit Payables Transfer Journal Entries to GL which submits Journal Import automatically.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, accounting is not happening.

Changes

 Patch 32908194:R12.FV.C applied

Cause

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