Quote Lines Are Updated Based On New Configured Model Rules When Placing Order

(Doc ID 2032613.1)

Last updated on SEPTEMBER 02, 2016

Applies to:

Oracle Quoting - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

 

The following error is returned when placing an order in ENTERED status (from a copied quote) that contains a configured model

 
  The model configurations in the quote have been validated.
  The following model configurations are Invalid or Incomplete: 1.0.
  Please review the quote prior to placing it as an order.

 

Also, the Quote Lines are updated to reflect the most recent Bill of Materials for the model

Expected behaviour would be for the order be created successfully and no updates made to the Quote Lines


Testcase Details:
1. Environment Profiles/Parameters
----------------------------------------
ASO: Configuration Effective Date = Configuration Creation Date
ASO: Copy Configuration Effective Date = Yes
ASO : Default Order State = Entered

OM System Parameter :
"Configuration Effective Dates" : System Date till Pick Release

2. Original Quote Number 19679
(Quote is configured)
------------------------------
select c.quote_number, b.config_header_id, b.config_revision_num,
a.config_model_lookup_date,
a.effective_date, a.config_date_created
from cz_config_hdrs a,
aso_quote_line_details b,
aso_quote_headers_all c,
aso_quote_lines_all d
where c.quote_header_id = d.quote_header_id
and d.quote_line_id = b.quote_line_id
and c.order_id is NULL
and b.config_header_id is NOT NULL
and a.config_hdr_id = b.config_header_id
and a.config_rev_nbr = b.config_revision_num
and c.quote_number = 19679



QUOTE_NUMBER CONFIG_HEADER_ID CONFIG_REV.. CONFIG_MODEL_LOOKUP_DATE EFFECTIVE_DATE    CONFIG_DATE_CREATED
19679                5043444               1                   04-FEB-15                              04-FEB-15             04-FEB-15
19679                5043444               1                   04-FEB-15                              04-FEB-15             04-FEB-15
19679                5043444               1                   04-FEB-15                              04-FEB-15             04-FEB-15
 


3. Copy Quote 19679 to create new quote number : 19838

QUOTE_NUMBER CONFIG_HEADER_ID CONFIG_REV.. CONFIG_MODEL_LOOKUP_DATE EFFECTIVE_DATE CONFIG_DATE_CREATED
19838              5183460                 1                   04-FEB-15                             04-FEB-15          20-FEB-15
19838              5183460                 1                   04-FEB-15                             04-FEB-15          20-FEB-15
19838              5183460                 1                   04-FEB-15                             04-FEB-15          20-FEB-15


-> Note CONFIG_MODEL_LOOKUP and _DATE EFFECTIVE_DATE are 04-FEB-15 in the copied quote



4. Place an order in ENTERED status

5. Order cannot be placed and error message is returned:

The model configurations in the quote have been validated.
The following model configurations are Invalid or Incomplete: 1.0.
Please review the quote prior to placing it as an order.


6. The Configuration on quote number 19838 is updated and a new revision of the configuration created, revision 2.  Quote lines are updated to reflect the latest model configuration

QUOTE_NUMBER CONFIG_HEADER_ID CONFIG_REV.. CONFIG_MODEL_LOOKUP_DATE EFFECTIVE_DATE CONFIG_DATE_CREATED
19838              5183460                  2                   20-FEB-15                             20-FEB-15         20-FEB-15
19838              5183460                  2                   20-FEB-15                             20-FEB-15         20-FEB-15



Need to be able to successfully place order from  quote 19838 without any changes to the configuration.

Cause

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 hundreds of Community platforms