GLCOEXCHILD module: Transfer Balances for Single Ledger to Accounting Hub Reporting Cloud Service Errors with ORA-06508: COULD NOT FIND PROGRAM UNIT APPS.GL_FUSION_TRANSFER_PKG (Doc ID 2182656.1)

Last updated on MARCH 23, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.
GLCOEXCHILD module: Transfer Balances for Single Ledger to Accounting Hub Reporting Cloud Service
EBS Fusion Coexistence

Symptoms

On : 12.1.3 version, Setup forms and programs

ACTUAL BEHAVIOR
---------------------------
When running GLCOEXCHILD module: Transfer Balances for Single Ledger to Accounting Hub Reporting Cloud Service,
the following error is displayed in the log file

ERROR
-----------------------
2016.07.20 18:03:15:-- Issue in SQL Stmt - java.sql.SQLException: ORA-04063: package body "APPS.GL_FUSION_TRANSFER_PKG" has errors
ORA-06508: PL/SQL: could not find program unit being called: "APPS.GL_FUSION_TRANSFER_PKG"

Additional info: The Oracle database version is 10.2.0.5.0.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Go to the responsibility: General Ledger
2. Navigate to Other > GL Fusion Cloud Register Page > Setup Fusion Accounting Hub Reporting Cloud Service Page 1 > Setup Fusion Accounting Hub Reporting Cloud Service: Advanced Options Page 2
3. Select the Ledger and Period to Initialize Balance Transfer
4. Click Apply
5. The GLCOEXCHILD module: Transfer Balances for Single Ledger to Accounting Hub Reporting Cloud Service is launched and it completes in error
6. Check the log file

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms