My Oracle Support Banner

R12 Generic Data Fix (GDF) Patch To Repopulate doc_sequence_id And doc_sequence_values In XLA_AE_HEADERS Of Events Upgraded From 11i To R12 (Doc ID 2157171.1)

Last updated on DECEMBER 20, 2023

Applies to:

Oracle Subledger Accounting - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

While upgrading accounting data from 11i, doc_sequence_id and doc_sequence_value are populated as NULL even when valid values exist on ap_invoices_all and ap_checks_all tables.
This causes inconsistent accounting.

Steps to reproduce:

  1. Log into Oracle Applications using a Payables responsibility
  2. Open the Invoice Workbench
  3. (N) Invoices > Entry > Invoices
  4. Query an Invoice
  5. Click on Reports - View Accounting
  6. Click on View Journal Entry from Subledger Journal Entry Lines
  7. The fields "Document Sequence Name" and "Document Sequence Number" are blank

 

Changes

 Upgrade transaction(s) from 11i to R12.

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.