Posts

Showing posts from July, 2017

Query to get custom Form personalization List

Query : Select Distinct A.Id,                 A.Form_Name,                 A.Enabled,                 C.User_Form_Name,                 D.Application_Name,                 A.Description,                 Ca.Action_Type,                 Ca.Enabled,                 Ca.Object_Type,                 ca.message_type,                 ca.message_text   from FND_FORM_CUSTOM_RULES   a,        FND_FORM                b,        FND_FORM_TL             c,     ...

API to insert notes in AR transactions

To insert notes into AR transaction kindly used ARP_NOTES_PKG.insert_p API. This API will take record variable as input parameter. we need to assigned value to it as shown in below given script. ================================================ DECLARE   l_notes_rec ar_notes%rowtype; begin   --apps initialize   mo_global.init('AR');   mo_global.set_policy_context('S', '204');   --    l_notes_rec.customer_trx_id        := 1545557; -- Customer_trx_id   l_notes_rec.note_type              := 'MAINTAIN';   l_notes_rec.text                   := 'Test for AR note';   l_notes_rec.customer_call_topic_id := NULL;   l_notes_rec.call_action_id         := NULL;   l_notes_rec.customer_call_id       := NULL;  -- call API to insert note    ARP_NOTES_PKG.insert_p(l_notes_rec); ...

Query to get concurrent Manager status from backend

Image
SELECT   t.user_concurrent_queue_name AS "Concurrent Manager Name",          b.max_processes AS "Actual Processes",          b.running_processes AS "Target Processes",          b.concurrent_queue_name, b.cache_size,          b.min_processes, b.target_processes, b.target_node, b.sleep_seconds,          b.diagnostic_level, b.manager_type, b.enabled_flag, t.description     FROM fnd_concurrent_queues_tl t, fnd_concurrent_queues b    WHERE b.application_id = t.application_id     AND b.concurrent_queue_id = t.concurrent_queue_id     AND b.enabled_flag = 'Y'     AND t.LANGUAGE = USERENV ('LANG')     --and  t.user_concurrent_queue_name like 'Out%' ORDER BY b.max_processes DESC;

Bing Ads

Image
Bing Ad's are similar to Google AdWords but on a different Search Engine, that of course being Bing and Yahoo!. It works in the same way as AdWords on a Pay Per Click basis. If you do use Google AdWords as a form of your online advertising then you will be very familiar with the Pay Per Click model. It uses very similar tools to help and research your keywords. The best thing is that you can import your AdWords campaign over to Bing very easily with a tool inside your Bing account. Bing was slow to start the platform of Pay Per Click and the last of the Three major Search Engines to start Pay Per Click. It was not until 2006 that Bing started its Pay Per Click Ad's. Then at the start of early 2010 Bing announced that it would be setting up a joint venture with Yahoo! to run their Pay Per Click Ad's. Bing Ad's Pay Per Click model works in the same way as AdWords it takes the maximum the advertiser is willing to pay per click along with the CTR (Cli...

Concurrent Program Incompatibilities

Image
How to add incompatibilities for concurrent program : 1. Navigate to system Administrator Responsibility. Concurrent -> Program -> Define 2. Query concurrent program to which you want to add incompatibilities. 3. click on "Incompatibilities" button from bottom of screen,  it will open new form to add incompatible program or set to this concurrent program.  4. We can add or remove incompatible program list for our concurrent program using this screen.  suppose i want to add same program as incompatible program to "Invoice Print Preview Report" program. simply we need to add one more line with program details. we can select value for scope as "Set" or "Program".   5. There are two types of program incompatibilities, “Global” incompatibilities, and “Domain” incompatibilities.  You can define a concurrent program to be globally incompatible with another program that is, the two programs cannot be run simultaneously at all; or y...