Hospitality: Reprice Throws Wrong Field Values Error Under Event Orders (SBL-UIF-00299) (SBL-DAT-00225)
(Doc ID 2017809.1)
Last updated on FEBRUARY 03, 2022
Applies to:
Siebel Hospitality - Version 8.1.1.11 [IP2013] to 8.1.1.14.5 [IP2014] [Release V8]Information in this document applies to any platform.
Symptoms
When users click the Reprice button on the Event Orders, an error displays.
STEPS
The issue can be reproduced with the following steps:
1. Launch the Hospitality Open UI application using HOSADMIN / HOSADMIN on the Sample database.
2. Go to Orders > Event Orders:
Perform a query in All Event Orders across Organizations.
3. Select an Event Order with multiple Functions:
Type=BEO
Order #= 130258-2199753
Property=Horizon Hotels
Quote= 2SIA-1B58N
Status=Event Check
Account=Anderson Hotel
4. Go to a Function that has multiple Line Items:
Function= Keynote Address
Items:
17" TV, List Price=$200.00
SXGA 3300 Lumens LCD Projector, List Price=$250.00
Small Category, Product Type=Category, List Price=$2.00
5. In Columns Displayed, expose the "Grouping" column.
6. Make sure Products (Items) are assigned different Groupings.
7. Press the Reprice button.
Error: Column FCST_QTY_FLG in table S_ORDERITM_TNTX cannot be null.
8. Press Undo to remove Error Message.
9. Check Forecast Qty column, ensuring a value exists.
10. Press the Reprice button.
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 |