Import Negotiation Program Not Considering Attr_group_seq_number In Pon_auc_attributes_interface

(Doc ID 2020963.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Sourcing - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

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.


 -- Steps
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'.


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