Order Management - EBS (MOSC)

MOSC Banner

Sales Order UDA table is not populating in the Right Sequence for Multirow

edited Oct 20, 2015 1:23PM in Order Management - EBS (MOSC) 5 commentsAnswered

Hi,

I am populating the Sales Order UDA by sql program, but after the Data is processed the data is not appearing in the same sequence.

Sample Query:

1st ) Inserting the unique key value with 'CREATE'  and running the 'Import User Defined Attributes' program

INSERT INTO OE_HEADERS_EXT_IFACE_ALL

  ( TRANSACTION_ID ,ATTR_GROUP_ID, HEADER_ID,ENTITY, PROCESS_STATUS,                DATA_SET_ID, ROW_IDENTIFIER, ATTR_GROUP_INT_NAME,ATTR_INT_NAME, ATTR_DISP_VALUE,TRANSACTION_TYPE,ATTR_GROUP_TYPE,DATA_LEVEL_ID , DATA_LEVEL_NAME,ORG_ID)

  VALUES

  ( mtl_material_transactions_s.nextval,p_attr_grp_id, p_order_header_id ,'ADMIN_DEFINED', 1, p_data_set_id,mtl_material_transactions_s.nextval , 'XXONT_HDR_SPECIFICATION_AG','XXONT_HDR_GLOSSARY_TERM_ATR',rec.tag ,'CREATE','OE_HEADER_ATTRIBUTES_EXT', 66001, 'ORDER_HEADER',p_organization_id);

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center