My Oracle Support Banner

Selecting the Credit Note From the Quantity Review List From Invoice Matching Tab Throwing an Error (Doc ID 2375929.1)

Last updated on MARCH 21, 2018

Applies to:

Oracle Retail Invoice Matching - Version 14.0.2 and later
Information in this document applies to any platform.

Symptoms

Selecting the credit note from the quantity review list from invoice matching tab throwing an error , if a credit note is lying in the discrepancy table,selecting the credit note from the quantity review list throwing the below error.



Steps To Recreate:

1. Login to ReIM Application.

2. Navigate to Quantity Review List --> Credit Memo - Quantity --> Try to resolve the Quantity Discrepancy .

3.While clicking on Quantity Difference --> (1)

Getting the following error (on the screen) :

An error occurred while retrieving quantity discrepancy details for order.

4. Check the log file, it shows below details

2018-02-01 11:23:26,926 ERROR [[ACTIVE] ExecuteThread: '0' for queue: 'weblogic.kernel.Default (self-tuning)'] com.retek.reim.foundation.rms12.OrderBean - error.retrieving_qty_discrepancy_details_by_order

com.retek.reim.merch.utils.ReIMException: An error occurred while retrieving quantity discrepancy details for order.

at com.retek.reim.foundation.AOrderBean.readQtyDiscrepancyDetailsByPO(AOrderBean.java:1718)

at com.retek.reim.services.QuantityReviewService.getQuantityDiscrepancies(QuantityReviewService.java:63)

at oracle.retail.reim.services.ui.discrepancyResolution.impl.QuantityReviewListUIService.setQuantityReviewListHeaderAndDetailInfo(QuantityReviewListUIService.java:295)

at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

.....

Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "QTY_ORDERED": invalid identifier

 

.......

Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.