Skip navigation

If you are using RWMS 16.0, you will be utilizing Oracle Forms Services 12c (12.2.1.0.0). Ensure that mandatory Forms patch 22184867 is installed to avoid FRM-93652 exception. O_Retail_clr.bmpReview Doc ID 2260556.1: FRM-93652 Exception Raised While Invoking User Class Editor Screen, for additional details.

 

Also issue has been reported on multiple different forms that throw DMS error with "Invalid user identifier or password. Re-enter. ORA-0000: normal, successful operation..." logged in ERROR_LOG table and after that the user session hangs. This has been reported for below GUI screens:

1. Inventory Management -> Confirm Paper Pick to Belt / Confirm Paper Pick to Pallet / Confirm Paper Unit Pick

2. Processing -> Order Consolidation / Packing / Resolve Trouble / Quality Assurance

3. Receiving -> Container Checking

4. Returns -> Return to Vendor

 

In order to address this issue, apply Oracle Forms Services 12c (12.2.1.0.0) patch 21534616. For further details regarding this Forms related issue, check Doc ID 2192436.1: Intermittent 12c Crashes with Segfault when Querying, or Saving Records - FRM-93652 - or FRM-40007: Invalid user identifier or password. Re-enter when Logging On

 

FRM-93652 exception has also been reported in a different application due to Linux OS level updates. Below note is provided for the same, in case if that too is required:

Doc ID 2288127.1: FRM-93652, FRM-93656 Errors After Linux Kernel OS Updates

O_Retail_clr.bmpWhen multiple users tried to access the RMS UI (Retail Merchandising System User Interface) application, severe performance issues were observed.

This was caused by few incorrect entries from the jazn-data.xml saved into the RMS OPSS schema.  This file contained definitions for incorrect

Please follow the instructions as given in  Solution Section of the  Doc ID 2287719.1 to resolve performance issue caused by incorrect policies.

Prior to release 14.0, In Oracle Retail Point of Service , overlapping promotions created in Retail Price Management (RPM) were exported as separate

Price Promotion events in the PricingExtract.xml. In release 14.0 and 14.1, price promotions event has been enhanced to support overlapping promotions

in a single event.

 

Example of the PricingExtract.xml that is extracted from RPM for an overlapping promotion:

 

<?xml version="1.0" encoding="UTF-8" ?>
<PricingImport Priority="0" FillType="FullIncremental" Version="1.0" Batch="1" CreationDate="2017-02-08T13:32:03.0Z" xsi:noNamespaceSchemaLocation="PricingImport.xsd" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<PriceChange ChangeType="ADD" ID="21210840" StartDate="2017-02-08" TemplateType="Default">
<Item ID="4322" TemplateType="Default">
<Price>192.5</Price>
</Item>
</PriceChange>

<PricePromotion ChangeType="ADD" ItemPriceCategory="Both" ID="330400" PromoCompID="336882" PromoCompDetlID="32276707" StartDateTime="2017-02-06T00:00:00.0Z" EndDateTime="2017-02-13T23:59:59.0Z" Type="PercentOff" Priority="1" TemplateType="Default">
<Name>promotions</Name>
<Description/>
<DiscountPercent>25</DiscountPercent>
<Item ID="4322" StartDateTime="2017-02-06T00:00:00.0Z">
<Price CurrencyCode="USD">131.25</Price>
</Item>
</PricePromotion>

<PricePromotion ChangeType="UPD" ItemPriceCategory="Both" ID="330400" PromoCompID="336882" PromoCompDetlID="32276707" StartDateTime="2017-02-06T00:00:00.0Z" EndDateTime="2017-02-13T23:59:59.0Z" Type="PercentOff" Priority="1" TemplateType="Default">
<Name>promotions</Name>
<Description/>
<DiscountPercent>25</DiscountPercent>
<Item ID="4322" StartDateTime="2017-02-06T00:00:00.0Z">
<Price CurrencyCode="USD">131.25</Price>
</Item>
<Item ID="4322" StartDateTime="2017-02-08T00:00:00.0Z">
<Price CurrencyCode="USD">144.37</Price>
</Item>
</PricePromotion>

</PricingImport>

 

Refer the following article which provides the details of the patch that needs to be applied in order for the import to process correctly on the Oracle

Retail Backoffice application so that the items ring up with the correct price on RPOS.

 

Version 14.1.x
Price Change Overlapping With a Promotion Sent From RPM Is Not Updated Correctly in Back Office (Doc ID 2244492.1)

 

Version 14.0.x
Import of PricingExtract in Back Office is Partially Processed when an Overlapping Promotion is Sent from RPM (Doc ID 2102011.1)
'UNITRETAIL' and 'IDISC' Amounts Incorrect for Items on Clearance and Simple Promotion in the RTLog (Doc ID 1957229.1)

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.