My Oracle Support Banner

Security Filter For Rejected Reconciliations Report In Account Reconciliation Cloud Service (ARCS) (Doc ID 2489526.1)

Last updated on JANUARY 15, 2020

Applies to:

Oracle Account Reconciliation Cloud Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 You are trying to create Security Filter for "Rejected Reconciliations" report In Account Reconciliation Cloud Service (ARCS) following "Administering Oracle Account Reconciliation Cloud" -> Part IV Performing Other Tasks in Account Reconciliation Cloud -> Generating Custom Reports -> Creating a Query  

https://docs.oracle.com/en/cloud/saas/account-reconcile-cloud/adarc/admin_reports_create_query_102x21b40b3e.html

After you added $ARM_SECURITY_CLAUSE$ in the WHERE CLAUSE statement you receiving an Error when trying to validate: 

Error

ORA-00904: "RECONCILIATIONEO"."RECONCILIATION_NAME"

invalid identifier.

 

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


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