Transactions Workbench Issue: Datafix: Incomplete Bills Receivable Created Events Prevent Period Close (Doc ID 2082706.1)

Last updated on JANUARY 14, 2016

Applies to:

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

Symptoms

Issue:
======

There are large volume of historic Incomplete BR_CREATE events that are preventing period close
Non postable records in AR_TRANSACTION_HISTORY_ALL are having event stamped.
.
Analysis:
=======
Event_id is incorrectly stamped for Non postable records in TH records in the
AR_TRANSACTION_HISTORY_ALL Table.

Fix Approach:
============
1. Event_id has to be made null.
2. Orphan events have to be deleted.

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