Latest YouTube Videos
Learn how to install Oracle Database 23ai Free on Windows. This is a great way to explore the features of Oracle 23ai Database.
——————
SQL Harmony allows you to connect to your fusion instance and execute SQL Queries. Check out the igh level features of the tool.
——————
Data Pipeline enables you to orchestrate end to end processes in EPM. Learn how to invoke a Pipeline from Groovy.
——————
Dependent List of Values helps you to control the BI Publisher Report parameters based on value of another parameter while exeucuting the reports.
——————
Learn how to attach a list of values to a BI Publisher report parameter. This helps the user to select from a pre-defined list rather than type the value in.
——————
Data Pipeline enables you to perform cross pod file operations easily. There are in-built job types available to move, copy, unzip, rename and delete files.
——————
Latest Blogs
Check out the latest blogs on Oracle ERP, EPM and other related topics.
-
Triggers in XML Data Template
Today I wanted to show you how to define triggers in XML Data Template. This is in continuation to my blog on generating XML Report from XML Data Template. Check the same here. So here is my requirement: Populate a temporary table with the data based on the parameters passed…
-
Oracle External Table
Lets take a look at Oracle External Table. This is a very useful concept for Oracle / Oracle Apps Developers. External Tables Oracle External Table enables you to access data from external sources as if the data were in a table. To simplify, you can have a data file in the Unix…
-
GL Journal Import for Multiple Journal Sources
In my previous post on how to Submit GL Import from PL/SQL. The example given in that blog was for importing Journals pertaining to one particular Journal Source. What if you had multiple Journal Source like ‘Receivables‘,’Payables‘ etc? How will you submit the gl import and make sure that the journals pertaining…
-
Update Supplier Payment Method
Hey all.. This is in continuation to my blog on “Create Payment Method API“. Let us take a look at how to update payment method using APIs. API => iby_disbursement_setup_pub.update_external_payee My requirement was to update the payment method for all the supplier sites that has payment method as “EFT” but no…
-
Increase IntegrationServer JVM memory
This post has an update available. Click Here IntegrationServer JVM Memory Settings In this post we will look at how to change the IntegrationServer JVM Memory Settings. It is a very basic topic that most of you might be aware of. However, for beginners this will be helpful. Recommended Settings…
-
Remittance Advice Email ID for Supplier
Remittance Advice Remittance Advice provides information about the invoices that are being paid as part of a payment. It is very common to deliver the document to the supplier’s email id. You can retrieve the email id to which the Remittance Advice will be delivered from IBY_EXTERNAL_PAYEES_ALL Table. You can use the…
-
Create Payment Method for Supplier in R12
You are going looking for the Payment Method and Payment Method changes in AP_SUPPLIERS and AP_SUPPLIER_SITES_ALL Tables and you don’t find any. You are disappointed and frustrated. Well don’t you worry, I possibly have the cure for that. Payment Method for suppliers in R12 can be seen in the below…
-
TCA API – Create Customer Account / Party and Customer Profile
The following code snippet can be used to create: 1. Customer Account 2. Party Associated with the Customer Account 3. Customer Profile We can use one API to create all the 3 entities in Oracle Apps R12. I am using a custom table that holds the customer details. Hope this helps.…
-
Generate Positive Pay or ACH output in a Specified Directory
Let us look at how we can generate the Positive Pay File / ACH Output in a particular directory on your server. As always, this will be mostly screenshots so that it makes it easier for you to understand. Navigate to Payables Manager > Setup > Payment > Payment Administrator…