Import Negotiation Program Not Considering Attr_group_seq_number In Pon_auc_attributes_interface
Last updated on JUNE 01, 2016
Applies to:Oracle Sourcing - Version 12.2.4 and later
Information in this document applies to any platform.
On Applications 12.2.4:
Find that when create negotiation through API, value of column 'attr_group_seq_number' provided in table 'pon_auc_attributes_interface' is not considered by 'Import Negotiations' Program while creating section in PON_AUCTION_SECTIONS.
-- Expected Behaviour
Expect the program to consider as inserted through API.
The issue can be reproduced at will with the following steps.
1. Use the API to create RFI header and corresponding attributes for ‘Requirements’ section in application frontend.
Note the below:
attr_group_seq_number is ‘10’ for section name : 'Additional Information' in Interface table pon_auc_attributes_interface.
attr_group_seq_number is ‘20’ for section name : 'Category Manager Information' in Interface table pon_auc_attributes_interface.
2. See from the sourcing application under 'Requirements' section of RFI header:
Attribute 'Category Manager Information' is appearing first and then 'Additional Information'.
As per the upload, 'Additional Information' should appear before the 'Category Manager Information'.
3. Run below query from back end:
Select * from PON_AUCTION_SECTIONS where auction_header_id=3321;
ATTR_GROUP_SEQ_NUMBER column shows sequence 10 for 'Category Manager Information' and 20 for 'Additional Information'.
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