AR-ARLPLB: -1732 ORA-01732: data manipulation operation not legal on this view

If you're use ebs 11.5 - 12.X;



Problem:


AR-ARLPLB: arlval returned FALSE.
AR-ARLPLB: Error in main.
AR-ARLPLB: -1732 ORA-01732: data manipulation operation not legal on this view



Solution:

Set optimizer_secure_view_merging to false.

This can be done by running the following in SQLPLUS :


SQL>alter system set optimizer_secure_view_merging=false;


RDBMS parameter optimizer_secure_view_merging = FALSE, which is a mandatory
init.ora parameter using Oracle applications was not correctly set.

Ref:Oracle Receivables Lockbox: Known Issues and Patches [ID 1358497.1]


Try and be happy:)