My Oracle Support Banner

R12: AP/IBY: Create Accounting Fails with "XLA-95251: The journal entry cannot be saved" and "ORA-01702: a view is not appropriate here" (Doc ID 2920370.1)

Last updated on JANUARY 14, 2024

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Subledger Accounting - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

When running Create Accounting the process fails and the log file shows:

Error. = ORA-20001: -: XLA-95251: The journal entry cannot be saved. Please inform your system admiministrator or support representative that:
The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-01702: a view is not appropriate here.
-: XLA-95251: The journal entry cannot be saved. Please inform your system admiministrator or support representative that:

The Accounting Program for Oracle Subledger Accounting cannot successfully save the entry for technical reasons. ORA-01702: a view is not appropriate here.
ERROR: XLA_AP_CANNOT_INSERT_JE =ORA-01702: a view is not appropriate here
SQL - Insert into xla_ae_line_acs

When the _enable_Front_End_View_Optimization parameter is set.

To run Create Accounting:

Changes

Verify the option is set by issuing the following command in SQL*Plus:

then the parameter is not set.

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