Configurator Upgrade Case Study for Technical TroubleshootingConfigurator Upgrade Case Study for Technical Troubleshooting

Purpose of Document

 

Table changes between Xe and 9.1

Data repository for Configurator between B7 and B9: This document shall focus on transactional tables only

Object NameMember DescriptionSYSYRRef1st UBES/T2nd UBES/TOthers
F3201 Configurator Master Table 32 32 9.1 only R893201 Target R893201H Target Table Created by R893201
F32019 Configurator Master History Table 32 32 9.1 only          
F3209 Configurator Constants 32 32 co-exist     R893201H Source  
F3210W Segment Value Workfile 32 32 9.1 only          
F3211 Configurator Segment Detail 32 32 9.1 only R893201 Target R893201H Target Table created by R893201
F32119 Configurator Segment Detail History 32 32 9.1 only          
F3212 Configurator Routings File 32 32 co-exist          
F3215 Configurator Component Table 32 32 9.1 only R893201 Target R893201H Target Output Table for R893201 (Table Created by R893201)
F32159 Configurator Component History Table 32 32 9.1 only          
F3216 Configurator Price/Cost Table 32 32 9.1 only R893201 Target R893201H Target Table Created by R893201
F32169 Configurator Price/Cost History 32 32 9.1 only          
F3281 Rules Table Definition 32 32 co-exist          
F3282 Configured Item/Rules Table Cross Reference 32 32 co-exist          
F32821 Rules Table Value Definition 32 32 co-exist          
F3283 Rules Table Detail 32 32 co-exist          
F3290 Configured Item Information 32 32 9.1 only          
F3291 Configured Item Segments 32 32 co-exist R893201 Source     R893201* reports are running based on this file
F3292 Cross Segment Editing Rules 32 32 co-exist          
F32921 Cross Segment Editing Rules - Values 32 32 co-exist          
F32922 Cross Segment Editing Rules - Range 32 32 co-exist          
F3293 Assembly Inclusions Rules 32 32 co-exist          
F3294 Configured String History File 89 32 OBSOLETE          
F32941 Configured String Master 89 32 OBSOLETE          
F32942 Configured String Detail 89 32 OBSOLETE          
F32943 Configured String History - OneWorld 89 32 OBSOLETE - - - - R893201* reports are running based on this file
F32944 Configured String Master - OneWorld 89 32 OBSOLETE - - - - R893201* reports are running based on this file
F32945 Configured String Detail - OneWorld 89 32 OBSOLETE - - - - -
F3294Z Configured Batch Segments 89 32 OBSOLETE - - - - -
F3295 Segment Value History File 89 32 OBSOLETE - - - - -
F3296 Configurator Level/Sequence File 89 32 OSSOLETE - - - - R893201* reports are running based on this file
F32961 Configurator Cost/Price Adjustment File 89 32 OBSOLETE - - - - R893201* reports are running based on this file
F329611 Configurator Deetail Cost/Price Adjustment Table 89 32 OBSOLETE - - - - R893201* reports are running based on this file
F3296T Configurator Level Sequence File Table 89 32 OBSOLETE - - - - R893201* reports are running based on this file
F32GOP Configurator GOP 32 32 9.1 only          
F41021 Item Location File       R893201 Source R893201H Source To be updated with new configuration ID
F4201 Sales Order Header File       R893201 Source R893201H Source  
F4211 Sales Order Detail File       R893201 Source R893201H Source  
F42019 Sales Order Header History File           R893201H Source Exclude when it is R893201S
F42119 Sales Order Detail History File           R893201H Source Exclude when it is R893201S

Flow for Transaction Detail Data Creation

Below figure shows how conversion routines handle transaction detail files.

B8932001 Flow

Flow for Transaction Header Creation

Below figure shows how conversion routines handle transaction header files.

Conversion routines

F3215 Configurator Component Table

F3215 references F3296, F3296T and F4211

Column AliasDD ItemColumn DescriptionMapping
CFGID* ConfigurationIDNumber                    Configuration ID Number
  • (Row Level) Computed Configuration ID (increment whenever new order is determined)
  • (Order Level) 0 (Hard Coded)
CFGCID* ComponentIDNumber                        Component ID Number
  • (Row Level) Computed Component ID per Configuration ID determined starts with 1
  • (Order Level) B3200370.mnComponentIDNumber (CFGCID) - {B3200370.mnComponentIDNumber (CFGCID) -1} to make this ID unique
CFGPID ParentIDNumber                           Parent ID Number
  • (Row Level)
    • - F3296T.CFGPID
    • - Or computed value when F3296T.CFGPID is blank
  • (Order Level) B893296.mnComponentIDNumber (CFGPID)
ITM* IdentifierShortItem                      Item Number - Short
  • (Row Level) F3296T.ITM
  • (Order Level) B3200370.mnIdentifierShortItem (ITM)
MCU CostCenter                               Business Unit
  • (Row Level) F3296T.MCU
  • (Order Level) B3200370.szCostCenter (MCU)
DSC1 DescriptionLine1                         Description
  • (Row Level)
    • F3296T.DSC1
    • F4211.DSC1
  • (Order Level) B3200370.szDescriptionLine1 (DSC1)
QNTY QtyRequiredStandard                      Quantity - Standard Required Quantity
  • (Row Level) F3296.QNTY
  • (Order Level) 0 (Hard Coded)
UOM UnitOfMeasureAsInput                     Unit of Measure as Input
  • (Row Level) F3296T.UOM
  • (Order Level) Blank (Hard Coded)
FOVQ FixedOrVariableQuantity                  Fixed Or Variable Quantity
  • (Row Level) V (Hard Coded)
  • (Order Level) Blank (Hard Coded)
ATMU ConfiguratorQuantityMult                 Configurator Quantity Multiplier
  • (Row Level) F3296.ATMU
  • (Order Level) 0 (Hard Coded)
SO03 SalesOrderStatus03                       Configurator Print Flag
  • (Row Level)
    • 1 when F3296.SO03 = Y
    • 0 when F3296.SO03 = N
    • F3296.SO03 (when SO03 is neither Y nor N)
  • (Order Level) Blank (Hard Coded)
LNTY LineType                                 Line Type
  • (Row Level) F3296.LNTY
  • (Order Level) Blank (Hard Coded)
KIT ItemNumberShortKit                       Parent (short) Item Number
  • (Row Level) F3215.KIT = F3215.ITM (when F32943 exists)
  • (Order Level) F3215.ITM
UITM ItemNoUnknownFormat                      Item Number - Unknown Format Entered
  • (Row Level) F4211.LITM
  • (Order Level) Blank (Hard Coded)
CFGSID* UniqueConfigurationID                    Unique Configuration ID
  • (Row Level) B893211.szUniqueConfigurationID (CFGSID)
  • (Order Level) CFGSID.F3215
COMM CommittedHS                              Committed (H/S)
  • (Row Level)
If F4211.COMM = 'K'
   F3215.COMM = K
Else
   If Related Order = Work Order
       F3215.COMM = N
   Else
       F3215.COMM = F4211.COMM
  • (Order Level) Blank (Hard Coded)
LOCN Location                                 Location
  • (Row Level) F4211.LOCN
  • (Order Level) Blank (Hard Coded)
LOTN Lot                                      Lot/Serial Number
  • (Row Level) F4211.LOTN
  • (Order Level) Blank (Hard Coded)
SY ProductCode                              Product Code
  • (Row Level) 42 (Hard Coded)
  • (Order Level) 32 (Hard Coded)
ECST AmountExtendedCost                       Amount - Extended Cost
  • (Row Level) F4211.ECST
  • (Order Level) 0 (Hard Coded)
FEC AmountForeignExtCost                     Amount - Foreign Extended Cost
  • (Row Level) F4211.FEC
  • (Order Level) 0 (Hard Coded)
AEXP AmountExtendedPrice                      Amount - Extended Price
  • (Row Level) F4211.AEXP
  • (Order Level) 0 (Hard Coded)
FEA AmountForeignExtPrice                    Amount - Foreign Extended Price
  • (Row Level) F4211.FEA
  • (Order Level) 0 (Hard Coded)
SOCF UserAddedComponent                       User Added Component
  • (Row Level)
    • F3296T.SOCF
    • 0 when F3296T = Blank
  • (Order Level) Blank (Hard Coded)
WADL WriteAttachedDetailLine                  Write Attached Detail Line
  • (Row Level) 1 (Hard Coded)
  • (Order Level) Blank (Hard Coded)
CIDN ConfiguredItemDestination                Transaction Type
  • (Row Level) 0 (Hard Coded)
  • (Order Level) 0 (Hard Coded)
ITC IssueTypeCode                            Issue Type Code
  • (Row Level) F3296T.ITC
  • (Order Level) Blank (Hard Coded)
OPSQ SequenceNoOperations                     Sequence Number - Operations
  • (Row Level) F3296T.OPSQ
  • (Order Level) 0 (Hard Coded)
ATOT AtoLineType                              Configurator Rule Type
  • (Row Level) F3296.ATOT
  • (Order Level) Blank (Hard Coded)
ATO# AtoRuleNumber                            Configurator Rule Number
  • (Row Level) F3296.ATO#
  • (Order Level) 0 (Hard Coded)
ATOS AtoSeqNumber                             Configurator Sequence Number
  • (Row Level) F3296.ATOS
  • (Order Level) 0 (Hard Coded)
PDDJ ScheduledPickDate                        Date - Scheduled Pick
  • (Row Level) F4211.PDDJ
  • (Order Level) 0 (Hard Coded)
URCD UserReservedCode                         User Reserved Code  
URDT UserReservedDate                         User Reserved Date  
URAT UserReservedAmount                       User Reserved Amount  
URAB UserReservedNumber                       User Reserved Number  
URRF UserReservedReference                    User Reserved Reference  
USER UserId                                   User ID F3296.USER
PID ProgramId                                Program ID F3296.PID
JOBN WorkStationId                            Work Station ID F3296.JOBN
UPMJ DateUpdated                              Date - Updated F3296.UPMJ
TDAY TimeOfDay                                Time of Day F3296.TDAY
RULUKID RuleUniqueKeyIDInternal                  Rule Unique Key ID (Internal)  
RUKIDLIN RuleUniqueKeyLineage                     Rule Unique Key Lineage  

Note:
If F3296.SO03 = 'N'
   F3215.SO03 = '0'
Else
  If F3296.SO03 = 'Y'
       F3215.SO03='1'
  Else
      F3215.SO03 = F3296.SO03
  End If
End If

Tag File (F3296T) gets fetched based on F3296.DOCO, DCTO, KCOO and LNID

Sales Order Detail (F4211) is fetched based on F4211.DOCO, DCTO, KCOO and LNID

F3211 Configurator Segment Detail

F3211 references F3215 and F3291

Column AliasDD ItemColumn DescriptionOthers
CFGID ConfigurationIDNumber                    Configuration ID Number
  • (Row Level) F3215.CFGID
  • (Order Level) 0 (Hard Coded)
CFGCID ComponentIDNumber                        Component ID Number
  • (Row Level) F3215.CFGCID
  • (Order Level) B3200370.mnComponentIDNumber (CFGCID) - {B3200370.mnComponentIDNumber (CFGCID) -1} to make this ID unique
PEL ParentSegmentNumber                      Number - Parent Segment Number (Row Level) F3291.PEL
(Order Level) B3200350.mnSegmentNumber (PEL)
SGVL SegmentValue                             Segment Value
  • (Row Level) 
    • Each Segment Value from F32943.CF01 and CF02
    • So the number of data from F3211 is total number of data from F3215 * (Number of Segment in F32942.CF01 and CF02)
  • (Order Level) B3200350.szSegmentValue (SGVL)
KIT ItemNumberShortKit                       Parent (short) Item Number
  • (Row Level) F3215.KIT
  • (Order Level) F3215.ITM
CFGSID UniqueConfigurationID                    Unique Configuration ID
  • (Row Level) F3215.CFGSID
  • (Order Level) F3215.CFGSID
ATSA SaveSegment                              Configurator Save Segment
  • (Row Level) F3291.ATSA
  • (Order Level) B3200350.cSaveSegment (ATSA)
CNUM NumericYN                                Numeric (Y/N)
  • (Row Level) F3291.CNUM
  • (Order Level) B3200350.cNumericYN (CNUM)
    • 1 (when B3200350.cNumericYN = Y)
    • 0 (when B3200.50.cNumericYN = N)
URCD UserReservedCode                         User Reserved Code  
URDT UserReservedDate                         User Reserved Date  
URAT UserReservedAmount                       User Reserved Amount  
URAB UserReservedNumber                       User Reserved Number  
URRF UserReservedReference                    User Reserved Reference  
USER UserId                                   User ID  
PID ProgramId                                Program ID  
JOBN WorkStationId                            Work Station ID  
UPMJ DateUpdated                              Date - Updated  
TDAY TimeOfDay                                Time of Day  

Note:
B3200370 and B3200350 are written whenever it reads new row from B7.F3296
B3200370 - CacheProcessSegementValues (Cache Process Segement Value)
B3200350 - CacheProcessAllComponents (Cache Process All Components)

F3216 Configurator Price/Cost Table

F3216 references F3296, F32961 and F329611

Column AliasDD ItemColumn DescriptionOthers
CFGID ConfigurationIDNumber                    Configuration ID Number F3215.CFGID
CFGCID ComponentIDNumber                        Component ID Number F3215.CFGCID
SEQN SequenceNumber2                          Sequence Number F329611.SEQN
DSC1 DescriptionLine1                         Description F32961.DSC1
LNTY LineType                                 Line Type F32961.LNTY
PRU PriceRollUpFlag                          Price Roll Up Flag 1 when F329611.PRU = Y
0 when F329611.PRU <> Y
SOCF UserAddedComponent                       User Added Component 0
FOVQ FixedOrVariableQuantity                  Fixed Or Variable Quantity V (Hard Coded)
ATMU ConfiguratorQuantityMult                 Configurator Quantity Multiplier 0 (Hard Coded)
ECST AmountExtendedCost                       Amount - Extended Cost F32961.ECST
FEC AmountForeignExtCost                     Amount - Foreign Extended Cost 0 (Hard Coded)
AEXP AmountExtendedPrice                      Amount - Extended Price F32961.AEXP
FEA AmountForeignExtPrice                    Amount - Foreign Extended Price 0 (Hard Coded)
ATOT AtoLineType                              Configurator Rule Type X (Hard Coded)
ATO# AtoRuleNumber                            Configurator Rule Number 0 (Hard Coded)
ATOS AtoSeqNumber                             Configurator Sequence Number 0 (Hard Coded)
LNID LineNumber                               Line Number F329611.LNID
AKID PriceHistoryAltKey                       Price History Alternate Key 0 (Hard Coded)
URCD UserReservedCode                         User Reserved Code  
URDT UserReservedDate                         User Reserved Date  
URAT UserReservedAmount                       User Reserved Amount  
URAB UserReservedNumber                       User Reserved Number  
URRF UserReservedReference                    User Reserved Reference  
USER UserId                                   User ID  
PID ProgramId                                Program ID  
JOBN WorkStationId                            Work Station ID  
UPMJ DateUpdated                              Date - Updated  
TDAY TimeOfDay                                Time of Day  


Note:

F3201 Configurator Master Table

F3201 references all reference tables above.

Column AliasDD ItemColumn DescriptionOthers
CFGID ConfigurationIDNumber                    Configuration ID Number
  • (SO) B3200370.mnConfigurationIDNumber (CFGID)
  • (WO) B3200370.mnConfigurationIDNumber (CFGID)
  • (End of Data)  0 (Hard Coded)
KCOO CompanyKeyOrderNo                        Order Company (Order Number)
  • (SO) B3200370.szCompanyKeyRelated (KCOO)
  • (WO) * (Hard Coded)
  • (End of Data) "CFGID" (Hard Coded)
DOCO DocumentOrderInvoiceE                    Document (Order No, Invoice, etc.)
  • (SO) B3200370.mnUniqueKeyIDInternal
  • (WO) B3200370.szRelatedPoSoNumber
  • (End of Data) 0 (Hard Coded)
DCTO OrderType                                Order Type
  • (SO) B3200370.szRelatedOrderType
  • (WO) B3200370.szUnused
  • (End of Data) Blank (Hard Coded)
SFXO OrderSuffix                              Order Suffix
  • (SO) F4201.SFXO
  • (WO) * (Hard Coded)
  • (End of Data) Blank (Hard Coded)
LNID LineNumber                               Line Number
  • (SO) B3200370.mnLineNumber (LNID)
  • (WO) 0 (Hard Coded)
  • (End of Data) 0 (Hard Coded)
CFGCID ComponentIDNumber                        Component ID Number
  • (SO) B3200370.mnComponentIDNumber (CFGCID)
  • (WO) B3200370.mnComponentIDNumber (CFGCID)
  • (End of Data) (Last CFGID + 1)
SY ProductCode                              Product Code
  • (SO) 42 (Hard Coded)
  • (WO) 32 (Hard Coded)
  • (End of Data) "NEXT" (Hard Coded)
AN8 AddressNumber                            Address Number
  • (SO) F4201.AN8
  • (WO) F4201.AN8
  • (End of Data) 0 (Hard Coded)
SHAN AddressNumberShipTo                      Address Number - Ship To
  • (SO) F4201.SHAN
  • (WO) 0 (Hard Coded)
  • (End of Data) 0 (Hard Coded)
EMCU CostCenterHeader                         Business Unit - Header
  • (SO) F4201.HMCU
  • (WO) Blank (Hard Coded)
  • (End of Data) Blank (Hard Coded)
CO Company                                  Company
  • (SO) F4201.CO
  • (WO) F4201.CO
  • (End of Data) Blank (Hard Coded)
CRRM CurrencyMode                             Currency Mode-Foreign or Domestic Entry
  • (SO) F4201.CRRM
  • (WO) F4201.CRRM
  • (End of Data) Blank (Hard Coded)
CRCD CurrencyCodeFrom                         Currency Code - From
  • (SO) F4201.CRCD
  • (WO) F4201.CRCD
  • (End of Data) Blank (Hard Coded)
CRDC CurrencyCodeTo                           Currency Code - To
  • (SO) F4201.CRDC
  • (WO) F4201.CRDC
  • (End of Data) Blank (Hard Coded)
URCD UserReservedCode                         User Reserved Code  
URDT UserReservedDate                         User Reserved Date  
URAT UserReservedAmount                       User Reserved Amount  
URAB UserReservedNumber                       User Reserved Number  
URRF UserReservedReference                    User Reserved Reference  
USER UserId                                   User ID  
PID ProgramId                                Program ID  
JOBN WorkStationId                            Work Station ID  
UPMJ DateUpdated                              Date - Updated  
TDAY TimeOfDay Time of Day  

Note:  End of data to save off Next Number one row is to be inserted into F3201.

To discuss this information further with Oracle experts and industry peers, we encourage you to review, join or start a discussion in the E1 Manufacturing Community.

To look at upcoming or archived Advisor Webcasts please see Advisor Webcast Details Document 1450327.1 if your topic is not currently scheduled please suggest it.