Pricing Archive Entity is Not Working As One Finds Submitted Job Gets No Data Found - 0 Records Archived

(Doc ID 2079037.1)

Last updated on DECEMBER 04, 2017

Applies to:

Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


When attempting to archive pricing data, the following error occurs.

ERROR
No Data Found - 0 Records Archived


STEPS
The issue can be reproduced at will with the following steps:

1. Responsibility = Oracle Pricing Manager
2. Archive Purge Pricing Entities > Archive Entity
3. Enter Parameters:
  archive name: CL01
  source system: QP
  entity type: surcharge list
  entity: Cost Labor Other

  under lines to archive:
  all lines: not checked
  product context: Item
  Product Attribute Custom Category
  Product Attribute Value From: 2ASM
  Start Date Active: null
  End Date Active: 14-Oct-14

4. View selected records shows:
Name: Labor Other
Modifier No: 41534
Start Date 30-Jul-10
End Date 14-Oct-14

5. Submit request
    Completes in warning and Log shows error:
       QPXARCVB module: Archive Pricing Entity
        ...
       No Data Found - 0 Records Archived



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms