Allocation Triggers Are Slow Because XREF_ALLOC_ NO Is VARCHAR Instead of Number (Performance Issue)
Last updated on APRIL 12, 2016
Applies to:Oracle Retail Allocation - Version 13.2.4 to 13.2.9 [Release 13.2]
Information in this document applies to any platform.
In Oracle Retail Allocation 13.2.x, the allocation triggers are slow because XREF_ALLOC_ NO is 'varchar' type instead of 'number'.
Steps to Reproduce:
- Create an allocation.
- Approve it.
- Note that the performance is slow.
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