My Oracle Support Banner

IMPL Print Receivables Transactions Completed With Error No Log Info Found (Doc ID 2548450.1)

Last updated on DECEMBER 10, 2019

Applies to:

Oracle Fusion Receivables Cloud Service - Version 11.13.19.01.0 and later
Information in this document applies to any platform.

Symptoms

Print Receivables Transactions program completing in error.

Log shows:

AR_ESS_PLSQL_WRAPPER_PKG.PRINT_INVOICES(+)
AR_ESS_PLSQL_WRAPPER_PKG.PRINT_INVOICES(+)
AR_ESS_PLSQL_WRAPPER_PKG.PRINT_INVOICES(+)

Aflog shows the below error:

[2019-04-22T08:23:48.6539+00:00] [apps] [WARNING:1] []
[ar.plsql.ar_mo_global_cache.get_org_attributes] [APPS_USER_ID:
823028F6E47C0C87E050230A125A273E] [APPS_USER_NAME:
xxxxx] [APPS_TERRITORY: US] [APPS_ENCODED: N]
[APPS_DB_INSTANCE: 1] [APPS_SESSION_ID: 871A79856FA762C1E053965F230ACB91]
[APPS_PRODUCT: AR] [APPS_SOURCE:
ar.plsql.ar_mo_global_cache.get_org_attributes] [APPS_JOB_REQUEST_ID: 202621]
[APPS_JOB_DEFINITION_NAME: TransactionPrintProgramEss]
[APPS_JOB_PACKAGE_NAME:
oracle.apps.ess.financials.receivables.transactions.shared]
[APPS_JOB_DEFINITION_APPLICATION: AR] Exception: arp_util.set_data_security[[
ORA-01422: exact fetch returns more than requested number of rows

The same issue was also found with the below programs:

Customer Statement

Create accounting

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
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.