Flexfields

This appendix covers the following topics:

Overview of ASCP Flexfields

The following flexfields are used to enter penalty cost data at the appropriate levels for independent demands, items, and resources.

Penalty Cost Factor for Late Demands (at the demand level)

Defined via a flexfield in the Forecast Items form (for forecasts) or in the Scheduling region of the Sales Orders form (for sales orders). This will be stored in the table OE_ORDER_LINES_ALL and MRP_FORECAST_DATES.

Penalty Cost Factor for Late Demands (at the item level)

Defined via a flexfield in the Items form. This will be stored in the table MTL_SYSTEM_ITEMS.

Penalty Cost Factor for Late Demands (at the org level)

Defined via a flexfield in the Organizations Parameters form. This will be stored in the table MTL_PARAMETERS.

Penalty Cost Factor for Exceeding Material Capacity (at the item/vendor level)

Defined via a flexfield in the Supplier-Item Attributes form (in the header region). It will be stored in PO_ASL_ATTRIBUTES.

Penalty Cost Factor for Exceeding Material Capacity (at the item level)

Defined via a flexfield in the Items form. It will be stored in MTL_SYSTEM_ITEMS.

Penalty Cost Factor for Exceeding Material Capacity (at the org level)

Defined via a flexfield in the Organizations Parameters form. This will be stored in the table MTL_PARAMETERS.

Penalty Cost Factor for Exceeding Resource Capacity (at the resource level)

Defined via a flexfield in the Department Resources form. This will be stored in the table BOM_DEPARTMENT_RESOURCES.

Penalty Cost Factor for Exceeding Resource Capacity (at the org level)

Defined via a flexfield in the Organizations Parameters window. This will be stored in the table MTL_PARAMETERS.

Penalty Cost Factor for Exceeding Transportation Cap. (ship method level)

Defined via a flexfield in the Inter-location Transit Times form. It will be stored in MTL_INTERORG_SHIP_METHODS.

Penalty Cost Factor for Exceeding Transportation Capacity (at the org level)

Defined via a flexfield in the Organizations Parameters form. This will be stored in the table MTL_PARAMETERS.

Other APS flexfields are:

Aggregate Resource for a Resource

This is defined via a flexfield in the Department Resources form. It is based on the existing flexfield Aggregate Resource Id. It is stored in the table BOM_DEPARTMENT_RESOURCES.

Priority for Substitute Items

This is defined in the Substitute Components form. This is stored in the table BOM_SUBSTITUTE_COMPONENTS.

Priority for MDS Entries

This is defined via a flexfield in the Master Demand Schedule Entries form. It is stored in the table MRP_SCHEDULE_DATES.

Service Level (at the item level)

This is defined via a flexfield in the Items form. It is stored in the table MTL_SYSTEM_ITEMS.

Service Level (at the org level)

This is defined via a flexfield in the Organization Parameters form. It is stored in the table MTL_PARAMETERS.

Service Level (at the customer level)

This is defined via a flexfield in the Customer Entries form. It is stored in the table RA_CUSTOMERS.

Applying Flexfields to Different Versions of Oracle RDBMS

Oracle ASCP and Oracle Global Order Promising checks to whether you have existing flexfield. If you do, it does not overwrite your existing settings.

Transportation Capacity

Oracle ASCP and Oracle Global Order Promising provides fields in the Inter-Location Transit Time window for setting load weight and load volume.

Creating Demand Priority Flexfield Numbers Manually

To Create Demand Priority Flexfield Number Manually

  1. From system administrator responsibility, navigate to Application > Flexfields > Descriptive > Segments.

  2. Double-click Segments.

    The Descriptive Flexfield Segments window appears.

  3. For the Application field, click Find and select Oracle Master Scheduling/MRP MRP_SCHEDULE_DATES.

  4. Click Segments.

    The Segments Summary window appears.

  5. Click New.

    Fill in the fields as shown in the following table:

    Field Enter
    Name Demand Priority
    Window Prompt Demand Priority
    Column An attribute column (for example, attribute 10)
    Number 1

  6. Click Value Set.

    The Value Set window appears.

  7. For Value Set Name, click Find.

    The Find Value Sets window appears.

  8. From list of values, select 7/Number.

  9. Click OK.

To create Profile

  1. Changes responsibility to Application Developer. Select Profile.

  2. Fill in the fields as shown in the following table:

    Fields Enter
    Name MRP_DMD_PRIORITY_FLEX_NUM
    Application Select Oracle Master Scheduling/MRP from List of Values
    User Profile Name Same as Name
    Description MRP:demands flexfield attribute for demand priority

  3. Save and close this window.

  4. Switch responsibilities back to System Administrator.

  5. Select Profile > System.

    The Find System Profile Values screen appears.

  6. In the Profile filed, find the Profile MRP_DMD_PRIORITY_FLEX_NUM from the List of Values.

  7. Click Site.

  8. Click Find.

    The System Profile Values screen appears.

  9. In the site column, enter the number 10 (or whatever number you chose for column).