Error when configuring PL/SQL Access Provider.

Hi, 

Did you refer this knowledge article when trying to troubleshoot? 

You can start by testing the plsql ping with the following:

SELECT utl_http.request((SELECT value FROM PLSQLAP_ENVIRONMENT_TAB t WHERE t.name = 'CONN_STR') || '?test=true') FROM dual;

Thanks,

Hi,

the topic is blocked for me, when i run this select  its return that 

“sys.dbms_network_acl_admin does not exist”

Hi @Matheus.Avancera 

Please try granting EXECUTE privilege on DBMS_NETWORK_ACL_ADMIN to Application Owner and IFSSYS and then try again. 

You can use following query to see the users who already has the privilege:

SELECT grantee, privilege
  FROM sys.dba_tab_privs
 WHERE owner = 'SYS'
   AND table_name = 'DBMS_NETWORK_ACL_ADMIN'
   AND privilege = 'EXECUTE';

Thanks,

 @Matheus.Avancera - Please run the following grants

grant execute on sys.DBMS_NETWORK_ACL_ADMIN to IFSAPP;

 grant execute on sys.DBMS_NETWORK_ACL_ADMIN to IFSSYS;

 grant execute on sys.DBMS_NETWORK_ACL_UTILITY to IFSAPP;

 grant execute on sys.DBMS_NETWORK_ACL_UTILITY to IFSSYS;

Hi,

i executed de permissions for IFSAPP and IFSSYS, run the select and the permissions are OK fot both users, but i have de the same error.

Try the below steps:

• Run Prepare as SYS 

EXEC Prepare_SYS.Dbagrant('&APPOWNER’);

• Run as App-Owner 

exec Installation_SYS.Grant_Ifssys(TRUE);   

exec Fndbas_Installation_API.Post_Installation_Data;  

• Refresh Dictionary and security cache. 
• Enable the below oracle queues within ‘Solution Manager>Monitoring>Oracle Queues>Oracle Queues’ screen.

BATCH_PROC_QUEUE_MAIN

BATCH_PROC_RESP_QUEUE

FND_TRK_LU_DMO_Q

Hi, eu runned out all steps, but still have problems, any more ideas?

You can reach-out to IFS through a case. It would be easier to troubleshoot in the environment itself. 

thank you

@Matheus.Avancera you can try below as well.

1. Run dbagrant.sql as SYS 
2. Deploy Installation.apy to Appowner 
3. Run grantifssys.sql as Appowner
4. Run installer for the extended server.