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 |