My Oracle Support Banner

Unable To Close Channel Revenue Management Period For Ledger With Multiple Operating Units. (Doc ID 2772015.1)

Last updated on FEBRUARY 06, 2023

Applies to:

Oracle Trade Management - Version 12.2.8 and later
Information in this document applies to any platform.


On : 12.2.8 version, Budget Postings

Unable to Close Channel Revenue Management (CHRM) Period for Ledger with Multiple Periods.

Customer has ledger with multiple operating units and where CHRM is configured to 2 Operating units.
Now when Users are trying to close CHRM Period using "Control Channel Periods" and changing status from Open to Close, System throws up the following error message-

You have encountered an unexpected error. Please contact your System Administrator for assistance.

Log Files shows following message:

Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT 'Y' unProcessedTrx
FROM xla_events evt,
xla_transaction_entities_upg te
WHERE evt.application_id = 682
AND evt.event_status_code IN ('I', 'U')
AND evt.process_status_code IN ('I', 'U', 'R', 'D', 'E')
AND evt.entity_id = te.entity_id
AND te.ledger_id = :1
AND evt.event_date <= (SELECT end_date
  FROM gl_period_statuses a ,
  ozf_sys_parameters_all b
  WHERE a.application_id = 682
  AND a.set_of_books_id = b.set_of_books_id
  AND b.set_of_books_id = :2
  AND NVL(a.adjustment_period_flag,'N') = 'N'
  AND a.closing_status = 'O'
  AND a.period_name = :3)

## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row




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

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