Match And Reserve Matches Against Old Revision Rather Than No Match (Doc ID 337533.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Symptoms

Find that the match functionality is matching the config to an old revision.

EXPECTED BEHAVIOR
Expect match to select the most current revision only

STEPS
1. Actions>Match within a sales order line

BUSINESS IMPACT
Due to this issue, you cannot match the items to the most current revision.

VERIFICATION
Verified the issue as noted below:

The debug shows match is occurring:

populate_bcol: source data
populate_bcol: line_id top_model ato link_to plan_level
populate_bcol: 3013 3013 A 3013 LN PAL P 0 BI 1 WS OQ 1 UOM EA creation 2 Match Y
ENTERING OE_CONFIG_UTIL.UPDATE_MFG_COMP_SEQ_ID
EXITING OE_CONFIG_UTIL.UPDATE_MFG_COMP_SEQ_ID...
populate_bcol: processed data
populate_bcol: line_id top_model ato link_to plan_level
populate_bcol: going to check for invalid model setup
populate_bcol: preparing information for v_match_flag_tab
populate_bcol: going to call cto_match_config.evaluate_n_pop_match_flag
Evaluate_N_Pop_Match_Flag:BEGIN Evaluate_N_Pop_Match_Flag
Evaluate_N_Pop_Match_Flag:custome matc value=>2
Evaluate_N_Pop_Match_Flag:Converting into sparse record structure indexed by line_id
Evaluate_N_Pop_Match_Flag:original amtch flag=>Y
LINE_ID => MATCH_FLAG
3013 => Y
populate_bcol: populating match flag from results
populate_bcol: done populating match flag from results
populate_bcol: 3013 3013 A 3013 LN PAL 3013 P 0 BI 1 WS OQ 1 UOM EA creation 2 Match Y
populate_bcol: bcol 3013....
populate_bcol: success in populate bcol
Create_And_Link_Item: After Populate_Bcol
Create_And_Link_Item: REUSE Section
Create_And_Link_Item: copy bcol to bcol_gt
Create_And_Link_Item: copied bcol to bcol gt rows 10
Create_And_Link_Item: querying Reuse Flag
Create_And_Link_Item: Reuse item Reuse Flag N Config Creation 2
Create_And_Link_Item: deleted from bcso_b as reuse is not applicable or doesnt exist 0
Create_And_Link_Item: Match section
Create_And_Link_Item: Done Match section
Create_And_Link_Item: Done Match section 1
CREATE_AND_LINK_ITEM going to call CTO_MATCH_CONFIG perform_match
perform_match flag =>Yfor line_id =>3013
entered Check_config_match=>
matched item=>26162
perform_match: Updated possible similar models to Y : 0
CREATE_AND_LINK_ITEM done perform_match
CREATE_AND_LINK_ITEM:: perform match data x_match_found Yx_top_matched_item_id 26162
CREATE_AND_LINK_ITEM Top Model Match Success
CREATE_AND_LINK_ITEM Top Match 26162
Create_And_Link_Item: Going to Synch up BCOL with data from BCOL_GT for matched info
Create_And_Link_Item: Synch up BCOL with data from BCOL_GT for matched info rows 10

Cause

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