My Oracle Support Banner

R12 GL: SLA Secondary/ALC Ledger Historic Upgrade Program Ending in Error (Doc ID 2537214.1)

Last updated on APRIL 28, 2020

Applies to:

Oracle General Ledger - Version 12 and later
Information in this document applies to any platform.

Symptoms

 R12 version, General Ledger

ACTUAL BEHAVIOR

------------------------

R12 GL: SLA Secondary/ALC Ledger Historic Upgrade program ending with below error.

UPG_MAIN procedure start time: 14-APR-2019 12:44:27
g_start_date:
g_currency_conversion_date:
validate_recovery_mode procedure start time: 14-APR-2019 12:44:27
validate_recovery_mode procedure end time: 14-APR-2019 12:44:27
insert_data procedure start time: 14-APR-2019 12:44:27
validation failed: invalid request_id, worker 1 generated REQUEST_ID 0
SQL exception raised in upg_main is = 1 User-Defined Exception

The issue can be reproduced at will with the following steps:

  1. Login to subledger responsibility
  2. View/Submit a New request
  3. Run the Program- 'SLA Secondary/ALC Ledger Historic Upgrade'
  4. Program ends with error

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


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