Skip to main content

Hi team,

My objective is to create an application message from the database itself through the PLSQL access provider using the method "plsqlap_server_api". 

Can someone let me know the steps to do it using already defined core packages? (how to locate method plsqlap_server_api in an existing package etc.)

As an example, when it comes to the ‘send invoice’ function on the customer invoice page can we trigger the application message for the invoice through the DB? 

 

Thank you.

@Tharani Ariyawansa 

You can create a custom event to monitor for inserts on invoice_tab and then in the event action you can write a short PL/SQL block to create an application message.

I have an example of calling a REST endpoint. In this case, the application message is created with JSON as attachment and then via routing rule / routing address is being sent to the REST endpoint.

Maybe it helps.

 

Reply


Terms & ConditionsCookie settings