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 […]
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 […]
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 tables: IBY_EXTERNAL_PAYEES_ALL IBY_EXT_PARTY_PMT_MTHDS We know […]
UTL_MAIL to Send Email form PL/SQL
Let us see how we can utilize UTL_MAIL to send Email form PL/SQL. Using the UTL_MAIL package is pretty straight forward. Check the below example. [sql] begin utl_mail.send( sender => ‘oracle@mydomain.com’, recipients => ‘user1@mydomain.com,user2@mydomain.com’, subject => ‘Test Mail from my Instance’, message => ‘Test message’ ); end; [/sql] As you can see there are 4 […]
Submit GL Journal Import From PLSQL
GL Journal Import GL Journal Import is used to import journals from sub ledgers and external systems into Oracle GL. We can do it manually or programatically. This post describes how to call the GL Journal Import from plsql procedure. We will be looking at importing AR (Receivable) Journal Entries. Pre Requisite step is to […]