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 directory and you can have a […]
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 to all the sources are […]
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 Bank Information. You may download […]
Unix Tips for Oracle Apps Developers
Just thought of sharing few Unix tips. Mailing without an attachment: email_ids=”sysadmin@testemail.com analyst@testemail.com” echo “GL Daily Interface Completed.” | mailx -s “GL Daily Interface” $email_ids You can also use the email id directly like below: echo “GL Daily Interface Completed.” | mailx -s “GL Daily Interface” sysadmin@testemail.com Mailing with an attachment: email_ids=”sysadmin@testemail.com analyst@testemail.com” echo “GL Daily […]
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 below query to find the […]