Error On Stock Ledger Screen
(Doc ID 2725848.1)
Last updated on JULY 25, 2022
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version NA and laterInformation in this document applies to any platform.
Symptoms
Getting below error when try to search Stock ledger with the different opening balance and closing balance the following error occurs.
"SQL error during statement preparation. Statement: SELECT MonthDataEO.CASH_DISC_AMT, MonthDataEO.CLASS AS CLASS11, MonthDataEO.CLEAR_MARKDOWN_RETAIL, MonthDataEO.CLS_STK_COST, MonthDataEO.CLS_STK_RETAIL, MonthDataEO.COST_VARIANCE_AMT, MonthDataEO.CUM_MARKON_PCT, MonthDataEO.CURRENCY_IND, MonthDataEO.DEAL_INCOME_PURCH, MonthDataEO.DEAL_INCOME_SALES, MonthDataEO.DEPT, MonthDataEO.EMPL_DISC_RETAIL, MonthDataEO.EOM_DATE, MonthDataEO.FRANCHISE_MARKDOWN_RETAIL, MonthDataEO.FRANCHISE_MARKUP_RETAIL, MonthDataEO.FRANCHISE_RESTOCKING_FEE, MonthDataEO.FRANCHISE_RETURNS_COST, MonthDataEO.FRANCHISE_RETURNS_RETAIL, MonthDataEO.FRANCHISE_SALES_COST, MonthDataEO.FRANCHISE_SALES_RETAIL, MonthDataEO.FREIGHT_CLAIM_COST, MonthDataEO.FREIGHT_CLAIM_RETAIL, MonthDataEO.FREIGHT_COST, MonthDataEO.GROSS_MARGIN_AMT, MonthDataEO.HALF_NO, MonthDataEO.HTD_GAFS_COST, MonthDataEO.HTD_GAFS_RETAIL, MonthDataEO.INTER_STOCKTAKE_SALES_AMT, MonthDataEO.INTER_STOCKTAKE_SHRINK_AMT, MonthDataEO.INTERCOMPANY_IN_COST, MonthDataEO.INTERCOMPANY_IN_RETAIL, MonthDataEO.INTERCOMPANY_MARGIN, MonthDataEO.INTERCOMPANY_MARKDOWN, MonthDataEO.INTERCOMPANY_MARKUP, MonthDataEO.INTERCOMPANY_OUT_COST, MonthDataEO.INTERCOMPANY_OUT_RETAIL, MonthDataEO.LOC_TYPE, MonthDataEO.LOCATION, MonthDataEO.MARGIN_COST_VARIANCE, MonthDataEO.MARKDOWN_CAN_RETAIL, MonthDataEO.MARKUP_CAN_RETAIL, MonthDataEO.MARKUP_RETAIL, MonthDataEO.MONTH_NO, MonthDataEO.NET_SALES_COST, MonthDataEO.NET_SALES_NON_INV_COST, MonthDataEO.NET_SALES_NON_INV_RETAIL, MonthDataEO.NET_SALES_NON_INV_RTL_EX_VAT, MonthDataEO.NET_SALES_RETAIL, MonthDataEO.NET_SALES_RETAIL_EX_VAT, MonthDataEO.OPN_STK_COST, MonthDataEO.OPN_STK_RETAIL, MonthDataEO.PERM_MARKDOWN_RETAIL, MonthDataEO.PR"
Steps To Recreate
1. Navigation - Tasks > Finance > Stockledger >Search.
2. Search for a dept and location combination
3. In results section select some record which have different value for opening and closing balances.
4. Note the above error.
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! |
In this Document
Symptoms |
Changes |
Cause |
Solution |
References |