SupplierProducts
The Supplier Products resource is used to view, create, update, and delete supplier products.
Columns
| Name | Type | Description |
| AcceptableEarlyDays | String | Number of days before which the planning process will not reschedule the sales order. For example, if the due date on the original sales order is 10-JUN, and if the Acceptable Early Days is 3, and if the new due date is less than or equal to 13-JUN, then the planning process will not suggest rescheduling. |
| AccountingRuleValue | String | Value that indicates the accounting rule to identify special revenue recognition rules for an item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Accounting Rules task. |
| AllowExpressTransactionsFlag | Bool | Contains one of the following values: true or false. If true, then deliver all distributions for this item with one data entry transaction if the quantity to deliver equals the balance on the purchase order line. If false, then do not deliver all distributions for the item with one data entry transaction, even if the quantity to deliver equals the balance on the purchase order line. |
| AllowPurchasingDocumentDescriptionUpdateFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to update the purchasing document description. If false, then do not allow the update. |
| AllowMaintenanceAssetFlag | Bool | Contains one of the following values: true or false. If true, then maintainable assets can be defined for the item. If false, then maintainable assets can not be defined for the item. This attribute does not have a default value. |
| AllowSubstituteReceiptsFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to receive a defined substitute instead of the item. If false, then do not allow this substitution. |
| AllowSuspendFlag | Bool | Contains one of the following values: true or false. If true, then allow suspending a service contract. If false, then do not allow suspending a service contract. |
| AllowTerminateFlag | Bool | Contains one of the following values: true or false. If true, then allow permanently stopping a service contract. If false, then do not allow permanently stopping a service contract. |
| AllowUnorderedReceiptsFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to receive the item without a purchase order. If false, then do not allow this receipt. |
| TransactionConversionValue | String | Value that indicates the conversion method used for units of measure associated with an item. A list of accepted values is defined in the lookup type EGP_ITEM_CONVERSIONS. |
| AutomaticallyExpireASNFlag | Bool | Contains one of the following values: 1 or 0. If 1, then automatically expire the advance shipment notice. If 0, then do not automatically expire the advance shipment notice. |
| AssetCategoryId | String | Value that uniquely identifies the key flexfield structure for an asset category. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Key Flexfields task. |
| AssetTrackedFlag | Bool | Contains one of the following values: true or false. If true, then the item is classified as an asset item. If false, then the item is not classified as an asset item. |
| AutoCreatedConfigurationFlag | Bool | Contains one of the following values: true or false. If true, then item is automatically created. If false, then item is not automatically created. |
| StartingLotPrefix | String | Prefix associated when the lot number are automatically created for an item. |
| SerialStartingPrefix | String | Prefix associated when serial numbers are automatically created for an item. |
| BackOrderableFlag | Bool | Contains one of the following values: true or false. If true, then backorder the item if available-to-promise (ATP) fails. If false, then do not backorder the item. |
| BackToBackEnabledFlag | Bool | Contains one of the following values: true or false. If true, then enable the item for back-to-back ordering. If false, then do not enable the item for back-to-back ordering. |
| BaseItemValue | String | Value that uniquely identifies the model to use when creating an assemble-to-order configuration. |
| BatchId | String | Value that uniquely identifies an item batch. |
| BuildInWIPFlag | Bool | Contains one of the following values: true or false. If true, then create discrete jobs or repetitive assemblies in Oracle Manufacturing Cloud. If false, then discrete jobs are not created. |
| BulkPickedFlag | Bool | Contains one of the following values: true or false. If true, then pick items in bulk. If false, then do not pick items in bulk. |
| BundleId | String | Value to uniquely identify the grouping of packs for import. |
| DefaultBuyerValue | String | Value indicating the default buyer that can be associated with the item. |
| CarryingCostPercentage | String | Percent of unit cost that represents the internal cost to stock one unit for one year. |
| CASNumber | String | Value that indicates the Chemical Abstracts Service (CAS) registry number which uniquely identifies a chemical substance. |
| CheckMaterialShortageFlag | Bool | Contains one of the following values: true or false. If true, then check for material shortages for the item. If false, then do not check for material shortages for the item. |
| ChildLotEnabledFlag | Bool | Contains one of the following values: true or false. If true, then use lot control on the item during the transaction if parent lot is specified. If false, then do not use lot control on the item during the transaction. |
| ChildLotPrefix | String | Alphabetic prefix to add to the child lot. |
| ChildLotStartingNumber | String | First number to use in a sequence of numbers for the child lot. |
| ChildLotFormatValidationFlag | Bool | Contains one of the following values: true or false. If true, then make sure the child lot numbers conform to the child lot parameters. If false, then do not make sure the child lot numbers conform to the child lot parameters. |
| CollateralFlag | Bool | Contains one of the following values: true or false. If true, then the item is collateral. If false, then the item is not collateral. |
| ProvisioningEnabledFlag | Bool | Contains one of the following values: true or false. If true, then item is eligible for electronic fulfillment by the service fulfillment manager. If false, then item is not eligible for electronic fulfillment. |
| ConsignedFlag | Bool | Contains one of the following values: 1 or 0. If 1, then the item resides at your location but the supplier owns it. If 0, then the item resides at your location and you own it. |
| ContainerItemFlag | Bool | Contains one of the following values: true or false. If true, then use containers to ship items. If false, then do not use containers to ship items. |
| ContractManufacturingFlag | Bool | Contains one of the following values: true or false. If true, then use the item in contract manufacturing. If false, then do not use the item in contract manufacturing. |
| CopyLotAttributeFlag | Bool | Contains one of the following values: true or false. If true, then the child lot inherits the parent lot attributes. If false, then the child lot does not inherit the parent lot attributes. |
| CostingEnabledFlag | Bool | Contains one of the following values: true or false. If true, then item costs are reported and accounted. If false, then item costs are not reported and accounted. |
| CreateSupplyFlag | Bool | Contains one of the following values: true or false. If true, then suggest supply for this item. If false, then do not suggest supply for this item. |
| CreatedBy | String | CreatedBy of SupplierProducts |
| CreationDate | Datetime | CreationDate of SupplierProducts |
| CustomerSelfServiceEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is enabled for customer self service. If false, then the item is not enabled for customer self service. This attribute does not have a default value. |
| CumulativeManufacturingLeadTime | String | Number of days required to manufacture the item, including the adjusted, cumulative, total lead time for the component that requires the longest time to assemble. The application subtracts the lead time offset of the operation to adjust each component. |
| CumulativeTotalLeadTime | String | Number of days required to assemble the item, including the adjusted, cumulative, total lead time for the component that requires the longest time to assemble. |
| CustomerOrderEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item can be ordered by external customers at this point of time. If false, then the item cannot be ordered by external customers at this point of time. |
| CustomerOrderFlag | Bool | Value that indicates whether to allow an item to be ordered by external customers. Contains one of the following values: true or false. If true, then item can be ordered by external customers. If false, then item cannot be ordered by external customers. |
| CycleCountEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is scheduled for automatic cycle count. If false, then the item is not cycle counted. |
| DaysEarlyReceiptAllowed | String | Number of days that you can receive the item before the promise date occurs without warning or rejection. |
| DaysLateReceiptAllowed | String | Number of days that you can receive the item after the promise date occurs without warning or rejection. |
| DaysOfCover | String | Number of days of cover for the item. The application multiplies days of cover by the average demand to calculate the safety stock level. |
| DefaultGradeValue | String | Value that indicates default grade for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Grades task. |
| IncludeInRollUpFlag | Bool | Contains one of the following values: true or false. If true, then item is included in the cost rollup. If false, then item is not included in the cost rollup. |
| DefaultLotStatusValue | String | Value that indicates the default lot status for the item. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Statuses task. |
| DefaultSerialStatusValue | String | Value that indicates the default serial status of the item. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Statuses task. |
| DefaultShippingOrganizationValue | String | Value that identifies the primary shipping organization. |
| DefectTrackingOnFlag | Bool | Contains one of the following values: true or false. If true, then defects of the item are tracked. If false, then defects of the item are not tracked. |
| DemandPeriod | String | Number of days to use when calculating the average daily demand. |
| DemandTimeDays | String | Point in time to ignore forecast demand and to consider only sales order demand when calculating gross requirements. |
| ItemDescription | String | Description of the part, item, product, or service. |
| DimensionUOMValue | String | Unit of measure to use for item dimensions. Review and update the value for this attribute using the Setup and Maintenance work area, and the Units of Measures task. |
| DownloadableFlag | Bool | Contains one of the following values: true or false. If true, then the customer can download the item; for example, the item is a software upgrade. If false, then the customer cannot download the item; for example, the item is a desktop computer. |
| PositiveDeviationFactor | String | Maximum positive deviation for the transaction. This deviation is the maximum allowed value that is greater than the secondary quantity that product management manages from the default conversion factor. |
| NegativeDeviationFactor | String | Maximum negative deviation for the transaction. This deviation is the maximum allowed value that is less than the secondary quantity that product management manages from the default conversion factor. |
| ElectronicFormatFlag | Bool | Contains one of the following values: true or false. If true, then the item exists only in electronic format. If false, then the item does not exist only in electronic format. |
| EligibilityRuleFlag | Bool | Contains one of the following values: true or false. If true, then the item can be made available to customers based on specific requirements and constraints; for example, the customer may need to be a member of the loyalty program, or live in a certain state, or be in good financial standing with the company, or not be locked into an existing contract to be eligible for an offer. If false, then the item can be made available to customers even if they do not meet specific requirements. |
| EnableGenealogyTrackingFlag | Bool | Contains one of the following values: true or false. If true, then item is enabled for genealogy tracking. If false, then item is not enabled for genealogy tracking. This attribute does not have a default value. |
| EngineeredItemFlag | Bool | Contains one of the following values: true or false. If true, then the item is engineered by the customer in house. If false, then the item is not engineered by the customer in house. This attribute does not have a default value. |
| WarehouseEquipmentFlag | Bool | Contains one of the following values: 1 or 0. If 1, then the item is equipment. If 0, then the item is not equipment. |
| EventFlag | Bool | Contains one of the following values: true or false. If true, then the item is an event. If false, then the item is not an event. |
| ExpirationActionValue | String | Value that indicates the default action to be taken for this item when the lot expires or the lot fails a quality check. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lot Expiration Actions task. |
| ExpirationActionInterval | String | Number of days the application adds to the expiration date before taking an action on the lot. |
| FinancingAllowedFlag | Bool | Contains one of the following values: true or false. If true, then customer can finance this item. If false, then customer cannot finance this item. |
| FixedDaysSupply | String | Number of days to use to modify the size and timing of each planned order quantity. |
| FixedLeadTime | String | Number of days required to assemble an item independent of the sales order quantity, such as setup time or teardown time. |
| FixedLotSizeMultiplier | String | Multiplier to use, in units for each day, for each fixed lot quantity or each repetitive rate. |
| FixedOrderQuantity | String | Quantity to use to modify the size of each planned order quantity or each repetitive daily rate. |
| ForecastHorizon | String | Time period to use when forecasting demand for the item. |
| ProcessingDays | String | Number of days required to procure or manufacture the item. |
| GradeControlFlag | Bool | Contains one of the following values: true or false. If true, then the item is grade controlled in addition to lot controlled. If false, then the item is not grade controlled. |
| HazardousMaterialFlag | Bool | Contains one of the following values: true or false. If true, then the item is hazardous. If false, then the item is not hazardous. |
| HoldDays | String | Number of days to add to the lot creation date that determines when you can release the lot. |
| FormattedDescription | String | Text description of the part, item, product, or service that includes hypertext tags. |
| OrderManagementIndivisibleFlag | Bool | Contains one of the following values: true or false. If true, then allow orders in fractions of an item. If false, then do not allow orders in fractions of an item. |
| TransferOrdersEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item can be ordered on an internal requisition. If false, then item cannot be ordered based on an internal requisition. |
| InternallyTransferableFlag | Bool | Contains one of the following values: true or false. If true, then the item can be ordered by internal customers. If false, then the item cannot be ordered by internal customers. |
| InternalVolume | String | Volume of the container or vehicle. This is an internal value. |
| InventoryAssetFlag | Bool | Contains one of the following values: true or false. If true, then the item is valued as an asset in inventory. If false, then the item is not valued as an asset in inventory. |
| InventoryCarryPenalty | String | Value that indicates the penalty for jobs that are not completed before their scheduled finish date. |
| InventoryItemFlag | Bool | Contains one of the following values: true or false. If true, then the item can be stocked and transacted. If false, then the item cannot be stocked and transacted. |
| ItemId | String | Value that uniquely identifies the part, item, product, or service. |
| InvoiceCloseTolerancePercentage | String | Percent tolerance to use when closing the purchase order shipment for invoicing. |
| InvoiceEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item can be invoiced in Oracle Receivables Cloud. If false, then the item cannot be invoiced. |
| InvoiceMatchOptionValue | Int | Value that indicates the type of match used for purchase order. A list of accepted values is defined in the lookup type EGP_POINV_MAT_OPTION. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| InvoicedFlag | Bool | Contains one of the following values: true or false. If true, then item can be invoiced at this point of time in Oracle Receivables Cloud. If false, then item cannot be invoiced at this point of time. |
| InvoicingRuleValue | String | Value that indicates invoicing rule to determine the period in which an invoice is sent. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Invoicing Rules task. |
| ProductCategoryCode | String | Abbreviation that identifies the category of a product. Review and update the value for this attribute using the Product Information Management work area, and the Manage Catalogs task. |
| ProductCategoryName | String | Name of the category of a product. Review and update the value for this attribute using the Product Information Management work area, and the Manage Catalogs task. |
| ItemNumber | String | Name or number of the part, item, product, or service. |
| LastUpdateDate | Datetime | LastUpdateDate of SupplierProducts |
| LastUpdatedBy | String | LastUpdatedBy of SupplierProducts |
| LeadTimeLotSize | String | Quantity to use when computing the processing lead time. |
| ListPrice | String | List price of the item. |
| LongDescription | String | Text description of the part, item, product, or service. |
| LotDivisibleFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to allocate, reserve, or move partial lot quantities. If false, then do not allow the application to allocate, reserve, or move partial lot quantities. |
| LotMergeEnabledFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to merge multiple lots into one lot for an item that lots control. If false, then do not allow this merge. |
| LotSplitEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the lot-controlled item can be split into many lots. If false, then the lot-controlled item cannot be split into many lots. |
| LotStatusEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item lot is status controlled at the lot level. If false, then the item lot is not status controlled. |
| LotSubstitutionEnabledFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to substitute a lot in the transaction. If false, then do not allow this substitution. |
| LotTranslateEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item lots can be translated. If false, then the item lots cannot be translated. |
| MarketPrice | String | Value that indicates the market price of the item which is printed on the purchase order lines. |
| MaturityDays | String | Number of days to add to the lot creation date to determine the lot maturity date. |
| MaximumMinMaxQuantity | String | Minimum quantity for minimum-maximum planning. |
| MaximumLoadWeight | String | Maximum load weight of the container or vehicle. You can specify a value for this attribute only if any one of the attributes VehicleItemFlag or ContainerItemFlag is set to true. |
| MaximumOrderQuantity | String | Maximum order quantity or repetitive rate in units for each day. |
| MinimumMinMaxQuantity | String | Minimum quantity for minimum-maximum planning. |
| MinimumFillPercent | String | Minimum percent to fill the container or vehicle before shipping. |
| MinimumLicenseQuantity | String | Minimum number of licenses the customer must order for the item. |
| MinimumOrderQuantity | String | Minimum order quantity of the item. |
| MRPCalculateATPFlag | Bool | Contains one of the following values: true or false. If true, then calculate and print available-to-promise (ATP) on the planning detail report. If false, then do not calculate and print. |
| MaterialTransactionEnabledFlag | Bool | Contains one of the following values: true or false. If true, then transactions can be performed on the item. If false, then transactions cannot be performed on the item. |
| UseApprovedSupplierFlag | Bool | Contains one of the following values: true or false. If true, then require an approved supplier. If false, then do not require an approved supplier. |
| NegativeMeasurementError | String | Maximum negative difference to allow between the cycle count quantity and the on-hand quantity that the application monitors. |
| NegotiationRequiredFlag | Bool | Contains one of the following values: true or false. If true, then you require negotiation. If false, then you do not require negotiation. |
| OperationSlackPenalty | String | Value that indicates, in units per day, the operation slack penalty for items having lag time between operations. |
| OrderCost | String | Fixed costs that are associated with placing a sales order for the item. |
| OrderableOnWebFlag | Bool | Contains one of the following values: true or false. If true, then allow the customer to order the item from the web. If false, then do not allow the customer to order the item from the web. |
| OrganizationCode | String | Abbreviation that identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| OrganizationId | String | Value that uniquely identifies the organization. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Inventory Organizations task. |
| OutsideProcessServiceFlag | Bool | Contains one of the following values: true or false. If true, the item can be processed in an outside facility. If false, the item cannot be processed in an outside facility. This attribute does not have a default value. |
| OverReturnTolerance | String | Value that indicates the amount of the shipment you can exceed at the time of receiving or receipt creation. |
| OverShipmentTolerance | String | Value that indicates the amount of the shipment that you can exceed at the time of ship confirmation. |
| OvercompletionToleranceValue | String | Value that indicates the acceptable percent or quantity of assemblies that are allowed to be over completed. |
| PaymentTermsValue | String | Value that indicates a valid payment terms code. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Payment Terms task. |
| PickComponentsFlag | Bool | Contains one of the following values: true or false. If true, then items can be picked from the finished goods inventory. If false, then items cannot be picked from the finished goods inventory. |
| PickingRuleValue | String | Value that indicates the picking rule that defines the order in which subinventories, locators, lots, and revisions are picked. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Picking Rules task. |
| Planner | String | Value indicates the material planner for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Material Planners task. |
| PlanningTimeDays | String | Days to add to the planning time fence. Use this attribute as an option when you define the time fence. |
| PositiveMeasurementError | String | Maximum positive difference to allow between the cycle count quantity and the on-hand quantity that the application monitors. |
| PostprocessingDays | String | Number of days required to receive a purchased item into inventory from the supplier receipt. |
| ProcurementBusinessUnitName | String | Name of the procurement business unit. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Business Units task. |
| PreprocessingDays | String | Value that indicates the days that must be added to purchasing or manufacturing lead time to place an order. |
| PriceTolerancePercentage | String | Maximum price percent over the normal price range of the item. For example, if the tolerance percent is 5, then the maximum acceptable price on the purchase order is 5% over the requisition price. In this example, a purchase order price that is 5% above the requisition price is not acceptable, and you cannot approve the purchase order. |
| PrimaryUOMValue | String | Unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. |
| ProcessCostingEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is used in costing module of the process manufacturing. If false, then do not use the item in costing module of the process manufacturing. |
| ProcessExecutionEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is used as an ingredient, product, or by-product in a production batch. If false, then do not use the item as ingredient, product, or by-product in a production batch. |
| ProcessQualityEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is used in quality module of the process manufacturing. If false, then do not use the item in quality module of the process manufacturing. |
| ProcessSupplyLocatorId | String | Value that indicates the locator from which the item is normally consumed as an ingredient in process manufacturing. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Locators task. |
| ProcessSupplySubinventoryValue | String | Value that indicates a subinventory from which the item is normally consumed as an ingredient in process manufacturing. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Subinventories task. |
| ProcessYieldLocatorId | String | Value that indicates locator in which you place the results of a production batch. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Locators task. |
| ProcessYieldSubinventoryValue | String | Value that indicates a subinventory in which you place results of a production batch. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Subinventories task. |
| ProductUploadId | String | Value that uniquely identifies the product upload through which products are uploaded. |
| PurchasableFlag | Bool | Contains one of the following values: true or false. If true, then allow the application to add the item to the purchase order. If false, then do not allow the addition. |
| PurchasingFlag | Bool | Contains one of the following values: true or false. If true, then the item is purchased and received. If false, then the item is not purchased and received. |
| PurchasingInputTaxClassificationValue | String | Value that indicates the tax code to use when calculating tax based on location and tax codes. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Tax Codes task. |
| QuantityReceivedTolerancePercentage | String | Maximum percent of the quantity received to allow that is greater than the expected receipt quantity. For example, if the expected receipt quantity is 10, and if QuantityReceivedTolerancePercentage is 20, then allow a received quantity of up to 12. |
| ReceiptCloseTolerancePercentage | String | Percent tolerance to use when closing the purchase order shipment for receipt. |
| RecipeEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item is used in recipes and formulas in process manufacturing. If false, then do not use the item in recipes and formulas. |
| ReleaseTimeDays | String | Additional days to be added to the release time fence. |
| RepairLeadtime | String | Time taken to repair the part at the supplier site. |
| RepairYield | String | Yield in the repair process when you upgrade or repair a defective part. |
| AssembleToOrderFlag | Bool | Contains one of the following values: true or false. If true, the item is generally built for sales order demand and a final assembly work order is created based on sales order details. If false, then assembly work order is not created for the item. |
| RequiresFulfillmentLocationFlag | Bool | Contains one of the following values: true or false. If true, then the fulfilment location of the item is required. If false, then the fulfilment location of the item is not required. |
| RequiresItemAssociationFlag | Bool | Contains one of the following values: true or false. If true, then the item association for the item is required. If false, then the item association for the item is not required. |
| ReservableFlag | Bool | Contains one of the following values: 1 or 0. If 1, then create material reservations for the item. If 0, then do not create material reservations for the item. |
| RestrictLocatorsFlag | Bool | Contains one of the following values: 1 or 0. If 1, then restrict the transactions of the item from the locator. If 0, then do not restrict the transactions of the item from the locator. |
| RestrictSubinventoriesFlag | Bool | Contains one of the following values: 1 or 0. If 1, then restrict the transactions of the item from the subinventory. If 0, then do not restrict the transactions of the item from the subinventory. |
| RetestInterval | String | Number of days after the creation date before retesting the lot. |
| RMAInspectionRequiredFlag | Bool | Value that indicates that items returned from customers will be inspected. This is an internal value. Contains one of the following values: 1 or 0. If 1, then inspection is needed for items returned by customers. The item then must be separately transferred to inventory. If 0, then Inspection is not needed for items returned by customers. |
| ReturnableFlag | Bool | Contains one of the following values: true or false. If true, then the item can be returned by external customers. If false, then the item cannot be returned by external customers. |
| RevisionQuantityControlFlag | Bool | Contains one of the following values: 1 or 0. If 1, then the item is under revision control and it includes inventory attributes. If 0, then the item is not under revision control and it includes inventory attributes. |
| RoundingControlTypeFlag | Bool | Contains one of the following values: 1 or 0. If 1, then round the quantity on an internal requisition when converting between the unit of measure on the requisition line and the item on the unit of issue. If 0, then do not resolve the unit of issue to an integer. This attribute does not have a default value. Setting this attribute to 0 might result in a fractional amount. |
| RoundingFactor | String | Factor to use when rounding the quantity on an internal requisition. This rounding occurs when converting the unit of measure on the requisition line to the unit of measure on the unit of issue. This factor makes sure that the unit of issue resolves to an integer, and not to a fractional amount. |
| SalesAccountId | String | Account used when tracking a sales item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Keyflex Fields task. |
| SecondaryUOMValue | String | Secondary unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Units of Measures task. |
| SerialStatusEnabledFlag | Bool | Contains one of the following values: true or false. If true, then transactions on the item are restricted to the subinventory. If false, then transactions on the item are not restricted to the subinventory. |
| ServiceBillingEnabledFlag | Bool | Contains one of the following values: true or false. If true, then enable the billing service. If false, then do not enable the billing service. |
| ServiceDuration | String | Value that indicates the duration for an item to fulfil a service contract. The value of this attribute depends on the value of ServiceDurationTypeValue. You can update the value for ServiceDuration if the value for ServiceDurationType is either variable or fixed. |
| ServiceDurationPeriodValue | String | Value that indicates the duration for an item to fulfil a service contract. A list of accepted values are the units of measures belonging to units of measure classes for time. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. The value of this attribute depends on the value for ServiceDurationTypeValue. You can update the value for ServiceDuration if the value for ServiceDurationType is either variable or fixed. |
| ServiceStartDelay | String | Value that specifies the delay in starting a service after a milestone. |
| EnableContractCoverageFlag | Bool | Contains one of the following values: true or false. If true, then the item can be included in a service contract. If false, then the item cannot be included in a service contract. |
| ShelfLifeDays | String | Number of days that each lot is active. |
| ShipModelCompleteFlag | Bool | Contains one of the following values: true or false. If true, then ship each configuration derived from this configuration model only when the required quantities for each component, option, and item that the configuration references is available. If false, then ship the configuration even if one or more of these quantities is not available. |
| ShippableFlag | Bool | Contains one of the following values: true or false. If true, then the application can ship the item to the customer. If false, then the application cannot ship the item. This attribute does not have a default value. For example, the item is a service agreement that you do not physically ship. |
| ShrinkageRate | String | Average amount of material you expect to lose when manufacturing or storing the item. |
| TransactionEnabledFlag | Bool | Contains one of the following values: true or false. If true, then allow transactions in Oracle Order Management Cloud. If false, then do not allow transactions in Order Management. The transaction in Order Management identifies the type of transaction in each application where the budget control transaction starts. |
| SourceSubinventoryValue | String | Value that indicates a subinventory from which the item is normally consumed. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Subinventories task. |
| SpokeSystemCode | String | Abbreviation that identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| SpokeSystemId | String | Value that uniquely identifies the spoke system. Review and update the value for this attribute using the Product Information Management work area, and the Manage Spoke Systems task. |
| ProductNumber | String | Name or number of the spoke part, item, product, or service. |
| ProductDescription | String | Description of the spoke part, item, product, or service. |
| ProductActionDate | Date | Date and time when an action was taken on the product. |
| ProductActionMessage | String | Text indicating the message to a supplier on taking an action on the product. |
| ProductStatus | String | Status of the product. |
| StandardCoverageValue | String | Value that indicates the coverage template associated with the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Coverage Times task. |
| StartingLotNumber | String | Starting number associated with the lot numbers when they are automatically created for an item. |
| SerialStartingNumber | String | Starting number associated with the serial numbers when they are automatically created for an item. |
| StandardLotSize | String | Quantity of a particular item that is ordered from the plant or a supplier, or issued as a standard quantity to the production process. Oracle Cost Management Cloud uses this value to calculate unit costs for sub-elements with a lot basis type. |
| StockEnabledFlag | Bool | Contains one of the following values: true or false. If true, then the item can be stocked in inventory. If false, then the item cannot be stocked in inventory. |
| StyleItemFlag | Bool | Contains one of the following values: true or false. If true, then the item is a style item. If false, then the item is not a style item. This attribute does not have a default value. |
| StyleItemNumberValue | String | Name or number of the corresponding style item. |
| SubcontractingComponentValue | String | Value that indicates the subcontracting type associated with the item when it is used as a subcontracting component in chargeable subcontracting. Values include Prepositioned and Synchronized. A list of accepted values is defined in the lookup type EGP_SUBCONT_COMPONENT. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| SupplierId | String | Value that uniquely identifies the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task. |
| OutputTaxClassificationCodeValue | String | Value that indicates a tax code to use when calculating the tax based on the location and tax codes. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Tax Codes task. |
| TaxableFlag | Bool | Contains one of the following values: true or false. If true, then the supplier charges a tax on the item. If false, then the supplier does not charge a tax on the item. |
| Template | String | Name of the template to apply to the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task. The default template is set at the item class. |
| TransactionId [KEY] | String | Value that uniquely identifies the product row in staging. |
| UNNumberValue | String | Value indicating the United Nations identification number used for international trade purposes. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage UN Numbers task. |
| UnderReturnTolerance | String | Value that indicates the lower limit of the received quantity to be considered as full receipt. |
| UnderShipmentTolerance | String | Value that indicates the lower limit of the quantity of shipment which can be shipped at the time of ship confirmation. |
| UnitHeightQuantity | String | Height of the item. |
| UnitLengthQuantity | String | Length of the item. |
| IssueUOMValue | String | Unit of measure to use when issuing the item from inventory. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. |
| UnitVolumeQuantity | String | Volume of one item. |
| UnitWeightQuantity | String | Weight of one item. |
| UnitWidthQuantity | String | Width of the item. |
| VariableLeadTime | String | Time taken to produce one unit of an assembly. |
| VehicleItemFlag | Bool | Contains one of the following values: true or false. If true, then use vehicles to ship items. If false, then do not use vehicles. |
| VMIFixedOrderQuantity | String | Fixed quantity to reorder in the inventory that the vendor manages. |
| ReplenishmentMaximumDaysOfSupply | String | Maximum days of supply to allow before replenishing the item. |
| ReplenishmentMaximumOrder | String | Maximum quantity to allow on the sales order for the item. |
| ReplenishmentMinimumDaysOfSupply | String | Minimum days of supply to allow before replenishing the item. |
| ReplenishmentMinimumOrder | String | Minimum quantity to allow on the sales order or repetitive rate in the number of units for each day. |
| VolumeUOMValue | String | Unit of measure to use for the item volume. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. |
| WeightUOMValue | String | Unit of measure to use for the item weight. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. |
| WIPSupplyLocatorId | String | Value that indicates the supply locator from which to issue (push) or backflush (pull) an item to work in process. This is an internal value. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Locators task. |
| WIPSupplySubinventoryValue | String | Value that indicates the primary subinventory from which to issue (push) or backflush (pull) an item to work in process. A list of accepted values is defined in the lookup type EGP_WIP_SUP_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| QuantityReceivedToleranceAction | String | Value that identifies the method to use when planning the safety stock for the item. A list of accepted values is defined in the lookup type EGP_RECEIPTACTIONVS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| EnforceShipToLocationValue | String | Value that indicates an option to control whether the supplier can deliver to a location that differs from the ship-to location defined on the purchase order. A list of accepted values is defined in the lookup type EGP_RECEIPTACTIONVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ReceiptDateActionValue | String | Value that indicates the action to be performed when the receive date is outside the range defined by the Days Early Receipt Allowed or Days Late Receipt Allowed values. Valid values include None, Reject, and Warning. A list of accepted values is defined in the lookup type EGP_RECEIPTACTIONVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| LotControlValue | String | Value that indicates the ability to use lot numbers during material transactions for tracking the batches of an item. A list of accepted values is defined in the lookup type EGP_LOT_CONTROL_CODE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| LotExpirationControlValue | String | Value that indicates how long items in a given lot remain available. A list of accepted values is defined in the lookup type EGP_SHELF_LIFE_CODE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| SerialGenerationValue | String | Value that indicates the number assigned to each unit of an item and is used to track the item. A list of accepted values is defined in the lookup type EGP_SERIAL_NUMBER_CONTROL_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ReplenishmentSourceTypeValue | String | Value that determines how to replenish inventory that the requests have depleted. A list of accepted values is defined in the lookup type EGP_SOURCE_TYPES. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| StockLocatorControlValue | String | Value that indicates the physical area within a subinventory where you store material, such as a row, aisle, bin, or shelf. A list of accepted values is defined in the lookup type EGP_LOCATOR_CONTROL_CODE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| PlanningTimeFence | String | Point in time to use when applying restrictions on planning recommendations. A list of accepted values is defined in the lookup type EGP_TIME_FENCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| DemandTimeFence | String | Point in time to use when applying restrictions on demand recommendations. A list of accepted values is defined in the lookup type EGP_TIME_FENCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| StructureItemTypeValue | String | Value that indicates the type of bill of material the item can possess. Values include standard, model, planning, and other. A list of accepted values is defined in the lookup type EGP_BOM_ITEM_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ATPComponentsValue | String | Value that indicates additional components to be included in the bill of material for assemble-to-order (ATO) or pick-to-order (PTO) items in available-to-promise (ATP) checking. A list of accepted values is defined in the lookup type EGP_ORDATPCHECKVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ATPValue | String | Value that indicates whether to check the available-to-promise (ATP) or capable-to-promise (CTP) status when placing demand. Contains one of the following values: Yes or No. If Yes, then check ATP when placing demand for this item. If No then do not check ATP when placing demand for this item. |
| WIPSupplyTypeValue | String | Value that indicates the supply type for components. A list of accepted values is defined in the lookup type EGP_WIP_SUP_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| InventoryPlanningMethodValue | String | Value that indicates the type of planning that will be used for the item. A list of accepted values is defined in the lookup type EGP_MATERIAL_PLANNING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| PlanningMakeBuyValue | String | Value that determines whether your organization manufactures or buys the item. A list of accepted values is defined in the lookup type EGP_PLANNING_MAKE_BUY. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| BillingTypeValue | String | Value that indicates the billing types. Values include M, L, or E, where M indicates material, L indicates labor, and E indicates expense. The contract uses the billing type to define the discount percent. A list of accepted values is defined in the lookup type EGP_MATERIAL_BILLABLE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| UserItemTypeValue | String | Type of item. A list of accepted values is defined in the lookup type EGP_ITEM_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| PlanningMethodValue | String | Value that uniquely identifies the method to use when planning demand for the item. A list of accepted values is defined in the lookup type EGP_PLANNING_CODE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ForecastControlValue | String | Value that uniquely identifies the type of forecast demand to use for the item. A list of accepted values is defined in the lookup type EGP_ATO_FORECAST_CONTROL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ReleaseTimeFence | String | Point in time to use when releasing a planned sales order that references a discretely planned item as work in process or as a purchase requisition. A list of accepted values is defined in the lookup type EGP_RELEASE_TIME_FENCE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| OvercompletionToleranceTypeValue | String | Value that indicates the type of over completion tolerance. Valid values include Percent or Amount. A list of accepted values is defined in the lookup type EGP_OVER_TOLTYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| EffectivityControlValue | String | Value that indicates how to calculate lead time based on Date, Model, or Unit Number. A list of accepted values is defined in the lookup type EGP_BOM_EFFEC_CTRL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| RecoveredPartDispositionValue | String | Value that indicates the process for returning defective or unused parts to a warehouse consolidation point. A list of accepted values is defined in the lookup type EGP_RECOVERED_PART_DISP_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| WebStatusValue | String | Web status of the item. Valid values are Enabled, Published, and Unpublished. |
| ServiceRequestEnabledValue | String | Contains one of the following values: true or false. If true, then a service request can be created for the item. If false, then a service request cannot be created for the item. |
| DefaultSalesOrderSourceTypeValue | String | Default source type to use for the sales order. A list of accepted values is defined in the lookup type EGP_ORDDEFSOSRCVS_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ConfiguratorModelTypeValue | String | Value that indicates the behavior of the configurable models in the configurator. A list of accepted values is defined in the lookup type EGP_CONFIG_MODEL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| TrackingUOMValue | String | Unit of measure of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Units of Measures task. |
| PricingUOMValue | String | Value that indicates the unit of measure that is used to determine pricing for an item. A list of accepted values is defined in the lookup type EGP_ITEM_PRICING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| DefaultingControlValue | String | Value that indicates how the conversion between primary and secondary units of measure is handled. Valid values are Default, Fixed, and No Default. You can provide the value of Defaulting Control depending on the value of the Tracking Unit of Measure attribute. If the Tracking Unit of Measure is Primary and Secondary, then the Defaulting Control can be provided. Otherwise, the Defaulting Control cannot be provided. |
| ReleaseAuthorizationRequiredValue | String | Type of authorization required before creating the sales order. A list of accepted values is defined in the lookup type EGP_MSI_GP_RELEASE_AUTH. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ForecastTypeValue | String | Value that uniquely identifies the type of demand for the item. A list of accepted values is defined in the lookup type EGP_ATO_FORECAST_CONTROL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| MatchConfigurationOptionValue | String | Value that indicates the capability to match one of existing configurations of the models. Values include Standard, Container, or Null. A list of accepted values is defined in the lookup type EGP_CONFIG_MATCH. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| CreateConfiguredItem | String | Value that indicates whether the configured bill of materials can be created based on item or sourcing. A list of accepted values is defined in the lookup type EGP_CONFIG_ORG. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ChildLotParent | String | Value that determines how to create child lot numbers for the item. A list of accepted values is defined in the lookup type EGP_PARENT_CHILD_GEN_TYPE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| PackTypeValue | String | Value of the pack type, also known as trade item unit descriptor (TIUD), that describes the hierarchy level of the global trade item number (GTIN). Hierarchy is used as the link between different levels of a product (item) logistical chain. A list of accepted values is defined in the lookup type EGP_PACK_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| SalesProductTypeValue | String | Value that indicates the type of sales product. Domain values include Goods, Subscription, Coverage, and Training. A list of accepted values is defined in the lookup type QSC_SALES_PRODUCT_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| MatchApprovalLevelValue | String | Status of the match approvals. Values include PO or Receipt. A list of accepted values is defined in the lookup type EGP_MAT_APPR_LEV. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| AssetClassValue | String | Contains one of the following values: true or false. If true, then the asset is movable, and needs to be brought into the shop for repairs. If false, then the asset is not movable. |
| ServiceDurationTypeValue | String | Type of duration for an item that fulfills a service contract. A list of accepted values is defined in the lookup type EGP_SERV_DUR_TYPE_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ServiceStartTypeValue | String | Type of service start rule to use for an item that fulfills a service contract. A list of accepted values is defined in the lookup type EGP_SERV_START_TYPE_CODE. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| SafetyStockPlanningMethodValue | String | Value that identifies the method to use when planning the safety stock for the item. A list of accepted values is defined in the lookup type ORA_EGP_SAFETY_STK_PLN_METHOD. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ItemStatusValue | String | Status of the transaction activity for the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Statuses task. |
| LifecyclePhaseValue | String | Name of lifecycle phase of the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Lifecycle Phases task. |
| ItemClass | String | Name of the item class. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Item Classes task. |
| Keyword | String | Keyword of SupplierProducts |
| ReceiptRoutingValue | String | Value that indicates the action to be performed when the item is received. A list of accepted values is defined in the lookup type EGP_RECEIPTROUTVS_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ContainerTypeValue | String | Value that indicates the type of container used for shipping the item. A list of accepted values is defined in the lookup type EGP_CONTAINER_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| HazardClassValue | String | HazardClassValue of SupplierProducts |
| SourceOrganizationValue | String | SourceOrganizationValue of SupplierProducts |
| ForcePurchaseLeadTimeFlag | Bool | Contains one of the following values: true or false. If true, then the purchasing lead time for the item is enforced as a hard constraint. If false, then the purchasing lead time for the item is not enforced as a hard constraint. This attribute does not have a default value. |
| CategoryCode | String | Abbreviation that identifies the catalog category. Review and update the value for this attribute using the Product Information Management work area, and the Manage Catalogs task. |
| GLN | String | Number used to uniquely identify trading parties and locations across the global data synchronization network (GDSN). |
| GTIN | String | Value that indicates the global trade item number. This attribute is used to identify the trade items developed by GS1 (comprising the former EAN International and Uniform Code Council). |
| ProductUploadName | String | Name of the product upload through which products are uploaded. |
| AssetTrackedValue | String | Value that indicates how asset tracking is done. A list of accepted values is defined in the lookup type ORA_EGP_ASSET_TRACKING. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| ReplacementTypeValue | String | Value that indicates whether the item is field or customer replaceable. A list of accepted values is defined in the lookup type ORA_EGP_SERVICE_REPLACE_TYPE. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. |
| BuyerEmailAddress | String | Email of the default buyer that can be associated with the item. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Buyers task |
| SupplierName | String | Name of the supplier. Review and update the value for this attribute using the Supplier Portal work area, and the Manage Suppliers task. |
| ExpenditureTypeValue | String | Default type of expenditure to be used in project-driven supply chain transactions. Review and update the value for this attribute using the Setup and Maintenance work area, and the Manage Expenditure Types task. The default value is Null. |
| CommonSupplyProjectDemandFlag | Bool | Contains one of the following values: True or False. If True, then the material can be planned, picked, and issued from common inventory if sufficient inventory does not exist in project inventory. If False, then the material cannot be planned, picked, or issued from common inventory even if sufficient inventory does not exist in project inventory. The default value is False. |
| EnableIotFlag | Bool | Contains one of the following values: True or False. If True, then the asset can be enabled for Internet of Things (IoT). If False, then the asset cannot be enabled for IoT. The default value is False. |
| HardPeggingLevelValue | String | Type of pegging considered by the planning engine during the supply and demand netting process. A list of accepted values is defined in the lookup type ORA_EGP_HARD_PEGGING_LEVEL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is None. |
| PackagingStringValue | String | Value that indicates the packaging of an item. Review and update the value for this attribute using the Item work area, and the Edit Item page. |
| CreateSupplyAfterDate | Date | Date after which the supply for the item is considered while generating planned orders. |
| CreateFixedAssetValue | String | Attribute that indicates when the item is asset-capitalized. Values include At Receipt, At Invoice, and Null. A list of accepted values is defined in the lookup type ORA_EGP_FIXED_ASSET. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is null. |
| UnderCompletionToleranceTypeValue | String | Value that identifies the undercompletion tolerance type. Values include Percentage, Quantity, and Null. A list of accepted values is defined in the lookup type ORA_EGP_UNDER_COMP_TOL. Review the value for this attribute using the Setup and Maintenance work area, and the Manage Standard Lookups task. The default value is null. |
| UnderCompletionToleranceValue | String | Attribute that indicates the acceptable percent or quantity of assemblies that're allowed to be under completion. |