User Maintained Data Parameters

Integration Parameters

The following table provides information about integration parameters. The first table is required for both Demantra and Planning implementations; the second table only applies to Planning implementations (values are ignored for Demantra integration).

The following table of parameters is applicable to both Demantra and Planning:

Parameter ID Description Default Value Format Where Used
Source_Instance The value of the source instance. Refer to Legacy collections in ASCP User Guide Text All legacy files
ATO_Forecast Values are:
1: Consume
2: Consume and derive
3: None
Refer to ASCP User Guide
2 Integer Item.dat
Base_Effective_Date The date to be used for any effective dates required by VCP but not effective dated in E1/PSFT THIS MUST BE A MONDAY YYYY-MM-DD   System Wide
Base_UOM_Count The unit of measure used as the base for counts.   Valid UOM UOM.dat
Base_UOM_Volume The unit of measure used as the base for Volumes.   Valid UOM UOM.dat
Base_UOM_Weight The unit of measure used as the base for Weights.   Valid UOM UOM.dat
Branch_Business_Group_Category The category code used to determine a branch's business group.   String TradingPartner (Organization)
Branch_Legal_Entity_Category The category code used to determine a branch's legal entity.   String TradingPartner (Organization)
Branch_Operating_Unit_Category The category code used to determine a branch's operating unit.   String TradingPartner (Organization)
Calendar_End_Offset The end date of calendars. The value should be longer than the longest plan in Oracle VCP. +750 Integer: >0 Calendar.dat: Calendar End Date
Calendar_Overwrite_Flag Whenever a calendar has changed or added in E1, user has to set this value to Y, otherwise N N Y/N Calendars
Customer_Class_Code_Category The Customer Category to be used for Customer Class   Valid category TradingPartner.dat- Customers
Days_Off The non working days in week. 2 Integer: <7 WorkDayPatterns.dat
Days_On The working days in a week. 5 Integer: <7 WorkDayPatterns.dat
Default_UOM_Type     Valid UOM type  
Demand_Class_Category The customer category used for Demand Class.   Valid category TradingPartner.dat Demandclasses.dat DemHistory.dat
Demantra_Field_Delimiter The delimiter used to combining multiple fields to form a single value for Demantra.   Char Demantra flat files
Demantra_Target_Date_Format The format of the dates in the transformed Sales order history file expected by Demantra (DemHistory.dat). This has to be set to DD-MON-YYYY YYYY-MM-DD String Demantra flat files
E1_Extract_Delimiter The delimiter used in the JD Edwards EnterpriseOne extracts to form category groups, operations codes, and other concatenated strings.
This parameter should not be one of the following:
: (Demantra concatenation)
~ (flat file delimiter)
'

* used by sql
&
>
<
| Char Wherever JD Edwards EnterpriseOne extracts concatenated strings.
Field_Delimiter Delimiter used when combining multiple fields together to form a single value. + Char
The value cannot be : or a Demantra restricted character
Whenever multiple fields are combined to form single field.
Flat_File_Quote_Delimiter The quote character used in flat files. This parameter must correspond with JD Edwards EnterpriseOne/PeopleSoft integration constants. """" String  
Item_Default_Category The item category group used to determine the category_name for items.   Valid category Item.dat
CategorySet.dat
Item_Format To load the data into VCP using different Item formats.
The following are the valid Item formats.
1 ItemCode
2 ItemName
3 AlternateItemId
The default value is ItemCode.
Reserved for Future enhancement
  ItemCode ItemName AlternateIt emId All tables referencing Item
Reserved for Future enhancement
Master_Branch This parameter is used when a branch code is needed. For example,\; calendar codes for suppliers and customers which have a branch code in JD Edwards EnterpriseOne but not in Oracle EBS.
All items used by forecasting or planning must be set up in this branch, with category codes associated to items.
  A JD Edwards Enterprise One branch code CalendarAssignment-SupplierShip, item, Trading Partners - Customers, Trading Partners - Organization, Trading Partners - Suppliers
Operating_Unit_Category The customer category that contains the Operating Unit.   Valid category Demand History, List Price, Price History, Trading Partner Site - Customer
Price_List_Name The name associated with the price list generated from Customer.xml. STANDARD_PRICE String Price List
Quarterly_Calendar_Type The quarterly calendar type. 3 Values are:
1: 445
2: 544
3: Month
4: 13
Periods
Calendar.dat: Quarterly Calendar Type
Sales_Channel_Category The customer category that contains the Sales Channel.   Valid Category Sales Channel.dat
DemHistory.dat
Use_Branch_based_Categories This parameter specifies whether or not branch categories are associated with items in the branch. No Yes/No Category.dat
Work_Start_Day This parameter specifies the calendar's work start day.   Values are:
1 Monday
2 Calendar Start
Calendar.dat: Week

The following table describes planning parameters:

Parameter ID Description Default Value Format Where Used
ABC_field_name This parameter determines which JD Edwards EnterpriseOne ABC fields to use as ABC codes in Oracle EBS. ABCS ABCS, ABCI, ABCM Item.dat
Acceptable_Early_Delivery This parameter specifies the Acceptable Early Delivery in days.   Integer Item.dat
Acceptable_Rate_Decrease This parameter specifies the Acceptable Rate Decrease.   Real Item.dat
Acceptable_Rate_Increase This parameter specifies the Acceptable Rate Increase.   Real Item.dat
ASN_Autoexpire_Flag The ASN (Advanced Shipment Notice) Auto expire Flag.
Values are:
1: ASN auto-expired
2: ASN not auto- expired
2   Item.dat
Average_Discount Average Discount   Average Discount Item.dat
Base_Time_UOM The Base Time Unit of Measure HR    
Budget_Constrained   2 1, 2 Item.dat
Built_In_WIP Values are:
1: Yes
2: No
1 1,2 Item.dat
Carrying_Cost_%_of_standard_cost The carrying cost as a percentage of cost.   Real Item.dat
Change_Over_Category The category code used to determine an item's set up code.   String OperationResource
Component_Rounding_Direction       BOMComponent.dat
Consigned_Flag   2 1, 2 Item.dat
Continuous_Transfer Continuous inter- organizational transfers.
Values are:
1: Yes
2: No
3: Use Global Value
  1, 2, 3 Item.dat
Convergence Convergent Supply Consumption Pattern
Values are:
1: Series
2: Parallel
3: Use Global Value
    Item.dat
Cost_to_determine_default_transport_cost The parameter specifies which transporting method cost fields are used to determine the default transport type. costPerWeightUnit CostPerWeig htUnit, CostPerVolu meUnit, or flatRatePerTr ip ShipmentMethod.dat
CP_Company_Name The default value for Collaboration Company Name (reserved for future use)     Reserved for future use
Create_Supply_Flag   1   Item.dat
Critical_Component_Flag       Item.dat
Days_Max_Inv_Supply       Item.dat
Days_Max_Inv_Window       Item.dat
Days_TGT_Inv_Supply       Item.dat
Days_TGT_Inv_Window       Item.dat
Default_Assignment_Set The sourcing assignment set.   String ItemSourcing
Default_Forecast_Designator Where there is no forecast designator associated with a customer/group then this is the forecast designator to be used   Text Demand Forecast
Default_Planner_Numb Assigned when a planner number for an item is unidentified. This planner number must be set up in JD Edwards EnterpriseOne with at least one item loaded into planning.   Number Items.dat
Default_TimeUOM        
Default_UOM_Type The default unit of measure used when the unit of measure type is null or missing. Count   UOM.dat
Demand_Lateness_Cost_%_ of_standard_cost The penalty associated with late demands as a percentage of cost.   Real Item.dat
Demand_Satisfied_Date_Field This parameter points to the field used for the Demand Satisfied Date field.   <null>
startDate
endDate
Demand Forecast.dat
Divergence Divergent Supply Feeding Pattern Values are:
1: Series
2: Series with MTQ
3: Use Global Value
  1, 2, 3 Item.dat
Effective_From_Date_Offset This parameter determines effective dates and other fields that need to be set prior to the current date and time.      
Effective_To_Date_Offset This parameter determines effective dates and other fields that need to be set to a future date.     Resource Group
Effectivity_Control   1   Item.dat
End_Assembly_Pegging Values are:
A - Full pegging
B - End assembly/full pegging
I - Net by project/ ignore excess
N - None
X - Net by project/net excess
Y - End assembly pegging.
    Item.dat
End_Assembly_Pegging_Flag Values are:
A: Full pegging
B: End assembly or full pegging
I: Net by project or ignore excess
N: None
X: Net by project or net excess
Y: End assembly pegging
B A, B, I, N, X, Y Item.dat
Exception_Excess_Days The period of time to calculate excess inventory.   Integer Item.dat
Exception_Over- promised_Days     Integer Item.dat
Exception_Shortage_Days The period of time to calculate material shortages.   Integer Item.dat
Expense_Account     Text Item.dat
Forecast_Confidence_Percentage The confidence percentage. The value of this parameter must be less than or equal to 100.      
Forecast_Demand_Lateness _Cost_% The percentage of cost incurred when a demand is not filled on time. <null> Real DemandForecast.dat
Forecast_Demand_Satisfied_ Date_Field Date to be used for satisfy date EndDate StartDate or EndDate DemandForecast.dat
Forecast_Horizon   <null>   Item.dat
Forecast_MAD Mean absolute deviation of the forecast compared to actual values.     DemandForecast.dat
Forecast_Probability A value between 0 and 1, which weights the probability of this forecast. 1 0 to 1 DemandForecast.dat
Full_Pegging   1 1, 2 Item.dat
Inherit_phantom_op-sequence_flag Values are:
1, 2, used in Trading Partners - Organization
  1, 2 Trading Partners - Organization, Trading Partners - Customers, Trading Partners - Suppliers
Internal_Source_Ranking_off set This parameter is added to is added to inter-organizational records so that inter- organizational and supplier rankings do not overlap. 0 Numeric SourcingRule.dat
Internal_Transfers_Customer The customer associated with internal transfers. The value can be <null>, but if populated it must be a valid JD Edwards EnterpriseOne customer and it must be extracted.   String SalesOrder.dat
Inventory_Asset_Flag   N Integer Item.dat
Inventory_Item_Flag   1 Integer Item.dat
Inventory_Planning_Code Values are:
3 - MRP planning
4 - MPS planning
6 - Not planned
7 - MRP and DRP planning
8 - MPS and DRP planning
9 - DRP planning
Refer to ASCP User Guide
6   Item.dat
Item_Substitution_Substitution_Set Substitutions name to be applied to substitutions imported from E1. ITEMSUBST_1 Text Item Substitutions
Item_Substitution_Partial_Fulfillment_Flag   2 Integer Item Substitutions
Manufactured_Cumm_Total_Lead_Time The manufactured pre- processing lead-time.   Integer Item.dat
Manufactured_Postprocessing_Lead_Time The manufactured ppst-processing lead- time.   Integer Item.dat
Manufactured_Preprocessing_Lead_Time The manufactured pre- processing lead-time.   Integer Item.dat
Model_Department_Level At what level are departments to be modeled at? The options a Branch or WorkCenter Branch Branch or WorkCenter Dept Resource
MRP_Calculate_ATP_Flag Values are:
1: Yes
2: No
2 1, 2 Item.dat
MRP_Safety_Stock_Percent       Item.dat
Order_Cost_%_of_standard_cost The order cost as a percentage of cost.   Real Item.dat
Pick_Components_Flag   N Y, N Item.dat
PIP_Flag       Item.dat
Phantom_Routings_Flag   2 Text Items, Dept_Resource
Planning_Exception_Set   CATCHALL Text DepartmentResource.dat
Publish_Plan_Name The name used to publish plans to JDE EnterpriseOne. ORCL-APS String Purchase Plan
Detailed Production Plan
Deployment Plan
Purchased_Cumm_Total_Lead_Time The purchased lead- time.   Integer Item.dat
Purchased_Postprocessing_Lead_Time The purchased postprocessing lead- time.   Integer Item.dat
Purchased_Preprocessing_Lead_Time The purchased pre- processing lead-time.   Integer Item.dat
Reduce_MPS Automatically deletes entries in a time period. Values are
1: None
2: Past due
3: Within demand time fence
4: Within planning time fence.
  1, 2, 3, 4, <null> Item.dat
Release_Time_Fence_Code The release time fence code 1   Item.dat
Release_Time_Fence_Days Release time fence time     Item.dat
Repetitive_Type A flag that indicates whether or not the item is repetitive. Values are:
1: Yes
2: No
1 1, 2 Item.dat
Repetitive_Variance_Days     Integer Item.dat
Replenish_To_Order_Flag A flag that specifies that an item is planned as replenish to order. Values are:
Y
N
N Y, N Item.dat
Resource_Balance_Flag A flag that indicates whether or not a resource is load is balanced. 2 1, 2 DepartmentResource.dat
Resource_Costing_Basis Indicates if resource costs are based on Machine or Labor costs. Machine Machine or Labor DepartmentResource.dat
Resource_Excess_Type The period of time to calculate resources over- utilization. 180   DepartmentResource.dat
Resource_Over_Util_Cost_% A percentage of resource costs as a penalty for over- utilization.     DepartmentResource.dat
Resource_Over_Utilization_ % Over Utilization Percent 101 Real DepartmentResource.dat
Resource_Shortage_Type The period of time to calculate resource over- utilization. 180   DepartmentResource.dat
Resource_Under_Utilization_ % Under Utilization Percent 0 Real DepartmentResource.dat
Resource_UOM A resource's unit of measure in a model.     DepartmentResource.dat
Resource_UOM_Class_Type       DepartmentResource.dat
Resource_User_Time_Fence The number of days that planning generates an exception message.     DepartmentResource.dat
Revision Item revision code     Item.dat
Revision_Quantity_Control_Code Values are:
1: Not under revision quantity control
2: Under revision quantity control
1 1, 2 Item.dat
Routing_CTP_Flag A flag that indicates that this routing is used in an ATP calculation. 2 1, 2 Routing.dat
Safety_Stock_Bucket_Days       Item.dat
Safety_Stock_Code Values are:
1: User-defined quantity
2: User-defined percentage, or mean absolute debytion
1 1, 2 Item.dat
Serial_Number_Control_Code   2   Item.dat
Service_Level       Item.dat
Setting_To_Use_On_Round_Up The value to be used when roundToWholeNumbers is set to “U” 1 1 or 2 Item.dat
Set Up Category     String RoutingOperation
Shrinkage_Rate Percentage of shrinkage for this item 0 0 to 100 Item.dat
SO_Authorization_Flag       Item.dat
SO_CTO_Flag This flag indicates that configure to order is available.
Values are:
1: Yes
2: No
2 1, 2 SalesOrder.dat
SO_Demand_Visible   Y Y, N SalesOrder.dat
SO_Forecast_Visible   Y Y, N SalesOrder.dat
SO_Reservation_Type Values for this parameter are:
1 Soft reservation
2 Hard reservation
3 Supply order reservation
1 1, 2, 3 SalesOrder.dat
SS_Penalty_Cost_%_of_standard_cost The penalty associated with breaching safety stock as a percentage of cost.   Real Item.dat
Substitution_Window The Substitution Window for the Item     Item.dat
Supplier_Cap_Over_Utilization_Cost_%_of_standard_cost The cost as a percentage of cost for over capacity on a supplier.   Real Item.dat
Supplier_Source_Ranking_offset This parameter is added to supplier records so that inter-organizational and supplier rankings do not overlap.      
Supply_Onhand_VMI_Flag     <null>,1, 2 SupplyOnhand.dat
Valid_QOH_Status_Codes The status codes used to calculate Quantity on Hand. Available, Pegged String SupplyOnhand.dat
WO_Lateness_Cost_% Work order lateness cost percent as a percentage of itemPrice. This parameter is required to minimize cost.   Real WorkOrderSupply.dat
Work_Order_Resource_Supply_Type   1   Work Order Resource Requirements