Import or Update a Large Number of Coverage Items for Price Lists

Use file-based data import to import and update a large number of coverage and covered items for price lists.

Improve efficiency. Import a large number of coverage and covered items all at the same time.

Before Update 25B, if any of your price lists included a coverage item or a covered item, then you couldn't batch. Instead, you had to import your price lists one at a time or import the price lists that didn't have a coverage item or covered item separately in its own batch. You can now include these items on the new QP_PL_COVERED_ITEMS_INT worksheet when you import a batch of price lists.

Specify these attributes that are specific to coverages on the QP_PL_COVERED_ITEMS_INT worksheet of the PriceListsImportBatchTemplate.xlsm file:

  • Covered Item Level
  • Covered Item Number
  • Coverage UOM Code
  • Coverage UOM Name

For example:

xxxxxxxxxxxxxx

You must also include the coverage item on the QP_PRICE_LIST_ITEMS_INT worksheet. For example, if you include this covered item on the QP_PL_COVERED_ITEMS_INT worksheet:

SOURCE_PRICE_LIST_ID SOURCE_PRICE_LIST_ITEM_ID SOURCE_PL_COVERED_ITEM_ID COVERED_ITEM_LEVEL_CODE COVERED_ITEM_NUMBER PRICING_UOM_CODE PRICING_UOM_NAME COVERAGE_UOM_CODE COVERAGE_UOM_NAME ACTION_TYPE_CODE
1001 10004 90001 ALL_ITEMS   Ea Each YR YEAR ORA_ADD

Then you must reference that coverage item on the QP_PRICE_LIST_ITEMS_INT worksheet:

OPERATION_CODE

 SOURCE_PRICE_LIST_ID SOURCE_PRICE_LIST_ITEM_ID ITEM_LEVEL_CODE ITEM_NUMBER ITEM_ID PRICING_UOM PRICING_UOM_CODE PRIMARY_PRICING_UOM LINE_TYPE_CODE
CREATE 1001 10004 ITEM 1YR_LIM_WAR   YEAR YR Y ORA_BUY

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

You can use various operations across worksheets with coverage items and covered items, such as CREATE, UPDATE, NO-OP, and END-INSERT.

Key Resources

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

  • Manage File Import and Export (FND_MANAGE_FILE_IMPORT_AND_EXPORT_PRIV)
  • Import Price Lists (QP_PRICE_LIST_IMPORT_PRIV)
  • Import Approved Price Lists (QP_PRICE_LIST_APPROVED_IMPORT_PRIV)

These privileges were available before this update.