My Oracle Support Banner

Unable to Update Price List Lines Using 'Flagged Rows' option (Doc ID 2770597.1)

Last updated on APRIL 26, 2021

Applies to:

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

Symptoms

ACTUAL BEHAVIOR  
---------------
We are trying to use the excel system generated upload to update the price list.
It did not fire the QP: Bulk Import of Price List and price list are not updated.
It does work if "All Rows" option is selected.

Steps to reproduce
------------------
1. Login as "Oracle Pricing User" responsibility
2. Select "Lists" tab
Select "Update Price List"
Select "Go"
3. Parameters
Integrator: QP Manage Price Lists
Layout: QP Manage Price Lists
Content: QP Manage Price Lists Content
Mapping: QP Manage Price Lists Content Mapping
4. Content Parameters
List Header IDs: 1817075
Update Headers: <un-checked>
Update Lines: <checked>
5. Primary Parameters
Integrator: QP Manage Price Lists
6. It opens Excel 2019 window
7. Change Unit Price on 2 of the lines to 25
See the flag on these 2 lines
8. >Oracle >Upload
Upload Parameters:
Rows to Upload: Flagged Rows
Validate Before Upload: <checked>
Commit Rows: All Rows
Automatically Submit Import: <checked>
9. Select 'Upload'
Confirmation
- Data imported, concurrent program triggered, please refer QP: Bulk Import concurrent program logs
- 2 row(s) successfully uploaded.
10. Run queries:
select * from QP_INTERFACE_LINES_HEADERS
select * from QP_INTERFACE_LIST_LINES
select * from QP_INTERFACE_PRICING_ATTRIBS
select * from QP_INTERFACE_QUALIFIERS
select * from QP_INTERFACE_ERRORS
> all queries shows no record
11. Price Lists, query price list
the price list lines still has the old unit price
12. Back in Excel window
Change the unit price on 2 of the lines
See flag checked
13. Upload Parameters
Rows to Upload: All Rows
14. Select 'Upload'
Confirmation
- Data imported, concurrent program triggered, please refer QP: Bulk Import
concurrent program logs
- 25 row(s) successfully uploaded.
15. Price Lists, query price list
the price list lines shows unit price updated to 25

WORKAROUNDS
===========
On Upload Parameters, select Rows to Upload: All Rows

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.