Posts

Showing posts from June, 2017

How To Run Concurrent Program From Back end (Psql) and notify to USER

You can Run Concurrent program from backend by using FND_REQUEST.SUBMIT_REQUEST API. And By using FND_REQUEST.ADD_NOTIFICATION  API You can send notification mail to particular User. Below given script is used for one of my client place where we want to run concurrent program from backend. First you have to initialize apps by using API fnd_global.apps_initialize. script output gives you concurrent program request id. which you can check from front end. ******************************************************** create or replace procedure XXFNDREQPROC   AS v_request_id number; v_request_id1 number; v_request_id2 number; v_request_id3 number; v_request_id4 number; v_request_id5 number; v_notify_user  boolean; l_user_id NUMBER:=0; l_responsibility_id NUMBER:=55550; l_resp_appl_id NUMBER:=222; P_ORG_ID NUMBER; begin fnd_global.apps_initialize(l_user_id,l_responsibility_id,l_resp_appl_id); mo_global.init ('S'); v_notify_user := FND_REQUEST.ADD_NOTIFICAT...

How to insert/update short text attachment for AR transaction using API

Image
Below given script you can use to insert / update short text attachment for AR invoice. Kindly pass parameter TRX_Number value for which you want to add short text. ==================================================== DECLARE   l_rowid                ROWID;   l_attached_document_id NUMBER;   l_document_id          NUMBER;   l_media_id             NUMBER;   l_user_id              NUMBER;   l_category_id          NUMBER;   l_pk1_value            fnd_attached_documents.pk1_value%TYPE;   l_description          fnd_documents_tl.description%TYPE;   l_seq_num           NUMBER;   lv_short_text       VARCHAR2(1000);   lv_bill_address1    VARCHAR2(1000);   lv_bill_...

The big list of 59 free Twitter tools for marketers

Image
I use Tweetdeck as my main Twitter connection. Swayy to schedule interesting posts. ManageFlitter and JustUnfollow to manage my follows/unfollows and find new people to follow. Blog plugins for sharing my own stuf  , Interesting! I think that tool sounds really neat. :) Seems like favoriting is one of those areas that has yet to settle on best practices. If you can favorite some tweets to get more followers, it could very well be worth it. Neat that Target Pattern makes it so easy. The big list of 59 free Twitter tools for marketers Twitter Tools for Analytics 1.  My Top Tweet : Your Top 10 list of tweets Find anyone’s Top 10 tweets, ordered by engagement. 2.  Wildfire : Follower growth analysis Compare your follower growth to your competitors’s follower growth. Simple, helpful, enlightening. 3.  SocialBro : Analytics, optimization, and more A nearly all-in-one platform for all things Twitter. The free plan comes with anal...