AGIS: Balancing Accounts Search Page Throws ORA-01756: 'Quoted string not properly terminated' (Doc ID 1960624.1)

Last updated on DECEMBER 18, 2015

Applies to:

Oracle General Ledger - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Oracle Financials Common Modules - Version 12.1.3 to 12.2 [Release 12.1 to 12.2]
Information in this document applies to any platform.
Advanced Global Intercompany System (AGIS)
Balancing Accounts Search (BalAcctsSearchPG.xml)

Symptoms

AGIS: on attempting to use Balancing Accounts Search to retrieve details of accounting relationships, after clicking 'Go' button, an Error Page is displayed:

ERROR:
'You have encountered an unexpected error. Please contact the System Administrator for assistance
Click here for exception details'

Drilldown further into Exception Details, the page shows:

 

The issue can be reproduced at will with the following steps:

1. AGIS Responsibility > Setup > Accounting > Balancing Accounts Search

2. Enter the Search details > Hit 'Go' button

3. See the Error message on the screen

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