Oracle APPS Account Payables Create Payment API
Hello, In this tutorial, I am going to share an unknown method for creating paymanets on Oracle EBS Account Payables. Since there isn’t any public API provided by Oracle, as developers we are investing into new methods. There is a…
Oracle EBS Service Invocation Framework (Business Events – SIF)
In this tutorial, I am going to invoke an external test web service with SIF. SIF mechanism is based on events, therefore we are going to define business events and subscriptions. After that, we can raise events in pl/sql. You…
Oracle APPS Integrated SOA Gateway Publishing Web Service
Hello, In this tutorial, I am going to explain how to publish web services with Integrated SOA Gateway. Integrated SOA Gateway is an external module which can be installed on Oracle EBS. We can publish web services with pl/sql in a…
Time Difference in Oracle SQL
Hello, You can find time difference between two times by using to_char and to_date sql functions. Use to_char(sysdate, ‘sssss’) in order to calculate seconds from midnight.
|
1 2 3 |
select to_char(sysdate, 'sssss') from dual; |
TO_CHAR(SYSDATE,’SSSSS’) ———————— 42881 1 row selected. We can also convert seconds to time with…
PL/SQL File to Blob
Hello, Converting physical files into binary data type is an important requirement. In this tutorial, I am going to explain converting files into blob data type. Basically, Oracle has two large object data types. BLOB (Binary Large Object): Used for keeping…