FND_REQUEST.SUBMIT_REQUEST in custom schema

Hello,

We are facing issue while submitting the FND_REQUEST.SUBMIT_REQUEST in custom schema.

created Synonyms and provided EXECUTE grant for FND_REQUEST.SUBMIT_REQUEST in custom schema.

 

In order to work FND_REQUEST.SUBMIT_REQUEST in custom schema we need to create any direct /indirect objects in custom schema or else we need to give any grants. Please assist on this.

We are upgraded database from 12c to 19c.

Applications upgraded from 12.1.3 to 12.2.9

We used the below code in the CUSTOM schema. In the APPS schema, it's working fine.

DECLARE

lv_req_id NUMBER := 0;

l_option_return BOOLEAN;