Last updated on JANUARY 14, 2016
Applies to:Oracle Advanced Pricing - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 version, Price List
One can add an attachment to price list lines. Find that when using + to copy the price list line above,
the record is copied but the attachment is not copied to the new record.
Expect that the attachment will be copied with the record above.
The issue can be reproduced at will with the following steps:
Responsibility: Application Developer
1. Set up the Document Entity
Navigate to: Attachments > Document Entities
Entity Name: Price List Lines
Application: Advanced Pricing
2.Set up the Document Category
Navigate to: Attachments > Document Categories
Default Datatype: Short Text
Application: Order Management
Name: Create Price Lists
3. Open Attachment Functions and query for the form: QPXPRLST
Navigate to: Attachments > Attachment Functions
User Name: Create Price Lists
Enabled is checked
Click on Blocks
Add Block name: LIST_LINES
Method: Allow Change
Secured by: Organization
Choose Entities (button) with the LIST_LINES entry highlighted
Entity: Price List Lines
Display Method: main entity
Include in Indicator is checked
All privileges = Always
Choose Primary Key Field (tab)
B. Test by Adding an attachment to a price list line & copy this record.
Responsibility: Order Management Super User
4. Create a price list or query an existing price list
Navigate to: Pricing > Price Lists > Price List Setup
5. Add price list line and attachment
Enter a price list line.
Add an attachment to a price list line via the paperclip and save.
6. Add a line under the line you added an attachment to.
While the new line is selected, press Shift + F6 to copy the above line.
The line will be copied, but the attachment from the above line will not be copied.
This applies to every price list and price list line.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms