My Oracle Support Banner

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


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