Error when adding a Product to Catalog or Updating Section Details in iStore 12.1.2 - ORA-06550 (Doc ID 1296346.1)

Last updated on FEBRUARY 01, 2016

Applies to:

Oracle iStore - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

On iStore 12.1.2 version, Administrator  UI
When attempting to add product to a section,
the following error occurs.

Even after error, product was added to the section.

ERROR
-----------------------
ORA-06550: line 1, column 503:
PLS-00103: Encountered the symbol ";" when expecting one of the following:
( begin case declare end exception exit for goto if loop mod
null pragma raise return select update while with
<an identifier> <a double-quoted delimited-identifier>
<a bind variable> << continue close current delete fetch lock
insert open rollback savepoint set sql execute commit forall
merge pipe purge The symbol "exit" was substituted for ";" to continue.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login as iStore Administrator
2. iStore Merchant: Sites:Summary > Summary > select Catalog Tab
3. Add product(Click + ) > Select Add products to section
4. Apply to see the error

Note: The same error could occur when updating the Section Details.
iStore Merchant: Catalog: Hierarchy: Select a Section: Update
In Section Details, update any data and Apply the changes.

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