Performance issue when creating relationships using TCA API
(Doc ID 386479.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Trading Community - Version 11.5.10 to 184.108.40.206 [Release 11.5]
Information in this document applies to any platform.
API HZ_RELATIONSHIP_V2PUB.create_relationship package
1. When creating relationships using TCA API, you find a performance issue with HZ_RELATIONSHIP_V2PUB.create_relationship package.
2.The most expensive SQL statement in the trace file is :
Select level, relationship_id, subject_id, object_id, status, start_date,
end_date, subject_table_name, subject_type
hz_relationships where relationship_id <> :b3 start with object_id = :b7 and
object_table_name = :b6 and object_type = :b5 and direction_code = 'p' and
relationship_type = :b4 and relationship_id <> :b3 and start_date <= :b2
and end_date >= :b1 and status='a' connect by object_id = prior subject_id
and object_type = prior subject_type and object_table_name = prior
subject_table_name and direction_code = 'p' and relationship_type = :b4 and
relationship_id <> :b3 and start_date <= prior end_date and end_date >=
prior start_date and start_date <= :b2 and end_date >= :b1 and status='a'
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