Excel Add-In for Oracle Fusion Cloud SCM

Build 26.0.9770

ReplenishmentPolicyComparisons

Returns comparisons of suggested and in-force policy measures for inventory replenishment.

Columns

Name Type SupportedFinders Description
PlanId [KEY] Long PrimaryKey The unique identifier of the plan.
PlanName String The name of the plan.
SegmentId [KEY] Long PrimaryKey The unique identifier of the segment.
SegmentName String The name of the segment.
InventoryItemId [KEY] Long PrimaryKey The unique identifier of the inventory item.
ItemName String The name of the item.
OrganizationId [KEY] Long PrimaryKey The unique identifier of the organization.
LocationName String The name of the location.
PolicyType Int The type of policy.
PolicyTypeName String The name of the policy type.
PolicyUOM Int The unit of measure in which policies are defined or calculated.
PolicyUOMName String The name of the unit of measure in which policies are defined or calculated.
PolicyReviewStatus Int The status of the policy comparison review process.
PolicyReviewStatusName String The name of the status of the policy comparison review process.
AverageDailyDmdPrior Int The prior average daily demand value.
AverageDailyDmdSuggested Int The suggested average daily demand value.
SsQuantityPrior Int The prior safety stock value.
SsQuantitySuggested Int The suggested safety stock value.
SsDaysPrior Int The prior safety stock value in days.
SsDaysSuggested Int The suggested safety stock value in days.
MinimumQuantity Int The minimum quantity value.
MinimumQuantityAdjusted Int The adjusted minimum quantity value.
MinimumQuantityDeviation Int The deviation in minimum quantity value.
MinimumQuantityPrior Int The prior minimum quantity value.
MinimumQuantityPriorType Int The type of prior minimum quantity value.
MinimumQuantitySuggested Int The suggested minimum quantity value.
MinimumDays Int The minimum policy value in days.
MinimumDaysAdjusted Int The adjusted minimum policy value in days.
MinimumDaysDeviation Int The deviation in minimum days policy value.
MinimumDaysPrior Int The prior minimum policy value in days.
MinimumDaysPriorType Int The type of prior minimum policy value in days.
MinimumDaysSuggested Int The suggested minimum policy value in days.
MaximumQuantity Int The maximum quantity value.
MaximumQuantityAdjusted Int The adjusted maximum quantity value.
MaximumQuantityDeviation Int The deviation in maximum quantity value.
MaximumQuantityPrior Int The prior maximum quantity value.
MaximumQuantityPriorType Int The type of prior maximum quantity value.
MaximumQuantitySuggested Int The suggested maximum quantity value.
MaximumDays Int The maximum policy value in days.
MaximumDaysAdjusted Int The adjusted maximum policy value in days.
MaximumDaysDeviation Int The deviation in maximum days policy value.
MaximumDaysPrior Int The prior maximum policy value in days.
MaximumDaysPriorType Int The type of prior maximum policy value in days.
MaximumDaysSuggested Int The suggested maximum policy value in days.
RopDays Int The reorder point value in days.
RopDaysAdjusted Int The adjusted reorder point value in days.
RopDaysDeviation Int The deviation in reorder point days value.
RopDaysPrior Int The prior reorder point value in days.
RopDaysPriorType Int The type of prior reorder point value in days.
RopDaysSuggested Int The suggested reorder point value in days.
RopQuantity Int The reorder point value.
RopQuantityAdjusted Int The adjusted reorder point value.
RopQuantityDeviation Int The deviation in reorder point value.
RopQuantityPrior Int The prior reorder point value.
RopQuantityPriorType Int The type of prior reorder point value.
RopQuantitySuggested Int The suggested reorder point value.
EoqPrior Int The prior economic order quantity value.
EoqSuggested Int The suggested economic order quantity value.
OrderQuantityPrior Int The prior order quantity value.
OrderQuantitySuggested Int The suggested order quantity value.
ParLevel Int The par level value.
ParLevelAdjusted Int The adjusted par-level value.
ParLevelDeviation Int The deviation in par-level value.
ParLevelPrior Int The prior par-level value.
ParLevelPriorType Int The type of prior par-level value.
ParLevelSuggested Int The suggested par-level value.
ParMaximum Int The par maximum value.
ParMaximumAdjusted Int The adjusted par maximum value.
ParMaximumDeviation Int The deviation in par maximum value.
ParMaximumPrior Int The prior par maximum value.
ParMaximumPriorType Int The type of prior par maximum value.
ParMaximumSuggested Int The suggested par maximum value.
UpdateStatus Int The update status of the policy comparison row.
FinalMinimumQuantity Int The final minimum quantity value.
FinalMaximumQuantity Int The final maximum quantity value.
FinalROPQuantity Int The final reorder point value.
FinalMinimumDays Int The final minimum value in days.
FinalMaximumDays Int The final maximum value in days.
FinalROPDays Int The final reorder point value in days.
FinalParLevel Int The final par-level value.
FinalParMaximum Int The final par maximum value.
MaximumDaysPriorTypeName String The name of the type of prior maximum days policy value.
RopQuantityPriorTypeName String The name of the type of prior reorder point value.
MaximumQuantityPriorTypeName String The name of the type of the prior maximum quantity value.
MinimumQuantityPriorTypeName String The name of the type of prior minimum quantity value.
MinimumDaysPriorTypeName String The name of the type of prior minimum days policy value.
RopDaysPriorTypeName String The name of the type of prior reorder point policy value.
ParLevelPriorTypeName String Name of prior par-level value type.
ParMaximumPriorTypeName String Name of the type of prior par maximum value.
CreatedBy String User who created the policy comparison records.
CreationDate Datetime Date when the policy comparison records were created.
LastUpdatedBy String User who most recently updated the policy comparison records.
LastUpdateDate Datetime Date when the user most recently updated the policy comparison records.
PlannerCode String Abbreviation that identifies the planner responsible for the item.
NotesIndicator String Value that indicates whether notes are present for the item.
Finder String The name of the finder method used to search and filter records.

Copyright (c) 2026 CData Software, Inc. - All rights reserved.
Build 26.0.9770