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 28, 2018

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.
*** Checked for Currency: Jan 10, 2017 ***

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.

Error:
[1] Wrong field values or value types detected in field Item.
Please re-enter your field values. If you need additional assistance, please refer to the documentation. (SBL-UIF-00299)

[2]The value entered in field Product of buscomp TNT SHM Order Item does not  match any value in the bounded pick list TNT SHM Picklist Specific  Product. (SBL-DAT-00225)

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
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.