R12:CE: The Bank Account Transfers Page Is Crashing Due Multiple Roles (Doc ID 3064864.1)

Last updated on DECEMBER 26, 2024

Applies to:

Goal

Why Simple search on Bank Account Transfer page crashes when the user has a Person attached to the User?

If for the same user, the person is removed from the user, the page is working fine.

The conditions slowing down the query are
AND cep_standard.check_ba_security(pt.source_legal_entity_id, 'CEBAT') = 1
AND cep_standard.check_ba_security(pt.destination_legal_entity_id, 'CEBAT') = 1

specifically, the code line l_row := DBMS_SQL.FETCH_ROWS(l_cursor_id) inside check_ba_security function.

Responsibility Cash Management, Responsibility > Open Bank Transfer page> choose Search by Bank Account Number > enter a number and press Search

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.