Unaccounted Transactions Report and Sweep not Working in R12 for New Operating Units (Doc ID 458211.1)

Last updated on SEPTEMBER 02, 2008

Applies to:

Oracle Payables - Version: 12.0.0
This problem can occur on any platform.
APXTRSWP.rdf

Symptoms

The Unaccounted Transaction Report shows No Data in R12. 

Or

The Unaccounted Transaction Sweep is not sweeping unaccounted transactions in R12.

Changes

The problem ONLY occurs for NEW operating units created in R12.

Run the following queries to verify if you have new operating unit/Org in R12 that will cause this problem:

select org_id, set_of_books_id, accounting_method_option
from ap_system_parameters_all
where org_id = &new_org_id;

If the query returns accounting_method_option = NULL for the new org, you are likely encountering this bug.

select organization_id, org_information_context,ORG_INFORMATION2, ORG_INFORMATION3
from HR_ORGANIZATION_INFORMATION
where ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
and organization_id = &new_org_id;

If the query returns different values for organization_id and ORG_INFORMATION2 you are likely encountering this bug.

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