Thursday, August 9, 2012

How to find the Package/Procedure/View associated with A WEBADI Integrator

Hi,

At times we want to know what is the name of the pacakge/procedure/view assciated with a WEBADI. I stuggle to get this information for long and finally got the answer, posting the same for easy reference.

Query to find the View Name :

SELECT bct.user_name
FROM   apps.bne_contents_tl bct,
              apps.bne_contents_b bcb,
              apps.bne_integrators_tl bit
WHERE bit.integrator_code = bcb.integrator_code
AND     bcb.content_code = bct.content_code
AND     bit.user_name = <your_integrator_name>;

Query to find Package/procedure associated with WEBADI Interface ( For UPDATE/UPLOAD metedata type WEBADI) :

select ba.attribute2
 from   apps.bne_attributes ba,
        apps.bne_param_lists_b bplb,
        apps.bne_interfaces_b  bib,
        apps.bne_integrators_tl bit
 where  bib.upload_param_list_code = bplb.param_list_code
 and    bib.integrator_code = bit.integrator_code
 and    ba.attribute_code = bplb.param_list_code || '_ATT'
 and    bit.user_name = <integrator_user_name>



Hope this will be handy.




DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM

Friday, June 1, 2012

Emailing Concurrent Program Output via email

Hi,

In the fast moving and evergrowing world each user wants the application to be smart robust and prompt.In most of the cases a user submits a report and clicks repetaedly on SRS window to see if the same got completed. He may use the on completion option where he can give his/her username and they will get notified at the registered email addree with their user account ( fnd_users.email_address).

One another way to get the output is to create a shell script and place the unix script in custom top.So that whenever the program is completed user will get an email with output as attachment.

However, there needs to be some setup to be done for that
 a) Create a lookup which will containg the Concurrent Program user name and the subscriber(email id) combo.( Concurrent Program Name as Lookup Code and Email ID as meaning if there is only one person to be informed about a concurrent program,you may also add muliple email id as firstemail@email.com;secondemail@email.com and so on in the meaning field as long as same is supported.) or keep the combo as

Lookup Code    Lookup Meaning    Description    Tag
10                     10                           Program1      firstemail@email.com
20                     20                           Program1      secondemail@email.com
30                     30                           Program2      thirdemail@email.com

and so on in lookup tables.

The Host script will ask for four parameters namely:

a) Request ID ( of the concurrent program whose output you want to get as attachment usually it will be fnd_global.conc_request_id)
b) Attachment Type : 'LOG/OUT' depending if you want logfile or output file
c) Subject : Hard Code this value depenidng on your need like Output of Program1 run on <SYSDATE>
d) Email Id :  As derived from above lookup.

Please find complete demo at :



DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM

Saturday, May 5, 2012

User Hook Implementation - A Sample Example

Please find a post about implemention user hooks.

http://www.scribd.com/doc/92476006/User-Hook-Implemantation-Sample-Example

Please find the package scipts attached.

CREATE OR REPLACE PACKAGE XXC_HR_USER_HOOK_PKG AUTHID CURRENT_USER AS
PROCEDURE XXC_LOA_RESTRICT_OVERBOOKING(p_pto_exceeds_entit_warning IN BOOLEAN);
END PACKAGE XXC_HR_USER_HOOK_PKG;

CREATE OR REPLACE PACKAGE BODY XXC_HR_USER_HOOK_PKG AS
PROCEDURE XXC_LOA_RESTRICT_OVERBOOKING(p_pto_exceeds_entit_warning IN BOOLEAN)
IS
lc_profile_option_value apps.fnd_profile_option_values.profile_option_value%TYPE;
BEGIN
 IF(p_pto_entit_exceeds_entit_warning)
 THEN
  BEGIN
   SELECT fpov.profile_option_value
   INTO lc_profile_option_value
   FROM apps.fnd_profile_options fpo,
    apps.fnd_profile_option_values fpov
   WHERE fpo.profile_option_id = fpov.profile_option_id
   AND fpo.profile_option_name = 'XXC_LOA_RESTRICT_OVERBOOKING'
   AND fpo.level_id = 10003      -- 10003 is value for Responsibility level
   AND fpo.level_value_id = fnd_profile.value('RESP_ID');
 
  
  EXCEPTION
   WHEN OTHERS THEN
    lc_profile_option_value := 'N';
  END;
 
  IF (lc_profile_option_value = 'Y')
  THEN
   RAISE_APPLICATION_ERROR(-20003,fnd_message.get_message('XXC','XXC_HR_EMP_LOA_NOT_ENTITLED'));
  END IF;
 END IF;
EXCEPTION
 WHEN OTHERS THEN
  RAISE_APPLICATION_ERROR(-20003,SQLCODE||SQLERRM);
END XXC_LOA_RESTRICT_OVERBOOKING;
END XXC_HR_USER_HOOK_PKG;

 
 

DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM

Tuesday, April 24, 2012

Post Approval FYI Notification in Oracle 11i

Hi,

One of the major limitation of Oracle Workflow specifically with HRSSA ( Human Resource ) is that the FYI notification which is send post approval does not contains any details.

This is an unpublished bug in 11i and the resolution is only provided by oracle in R12.1.3 however you can configure a custom alert which would send email to all intended recipients containg required details.

I have been able to achieve the same and will share the same in my nest post. Wait till then and do let me know if you have other ways of achieving the same.





DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM

How to convert a Discovere Report in XML Publisher Report

Hi,

With the onset of Oracle Fusion the world has really become a global place and slowly and gradually XML is becoming the most easy source of data transfer between applications.

A lot of organisations have been heavily depending on Discoverer Reports and it could be a cumbersome task if they want to migrate to R12 and Fusion as Discovere as a tool is becoming less popular and extinct with each passing day.

However, ther is one good news that you can now convert your Discovere Reports with al its complications, custom valusets,functions, formula columns etc into a simple XML Report by using the Export Facility which allows you to export the entire report in a xml data xource which can then  be used to create a XML Report.

I will provide a sample demo in my upcoming post.

Take care till then..

Please find the complete documentation at
http://www.scribd.com/doc/90961892/Discoverer-Reports-to-XML-Report




DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM

Monday, April 23, 2012

Business Events in Oracle Applications

Hi,

It is after a very long break that I am writing a post, this time about a very powerful and very lesser known feature namely Business Events System. Business Events are often confused with Oracle Workflow. There are almost  600 delivered Business Events in Oracle Applications in 11i and probably the number goes to 900 for R12.

An event can be defined as any transaction activity having specific importance like employee creation, assignment update, gl period close, gl period reopened, fa asset creation, fa asset retire etc and many more.

Now, since Oracle Application s has numerous forms and tables and so to keep the data in sync at time on performing a certain action child tables needs to be updated , this is usually done by calling the Business Events, Business Events ( referred as BE from here on) are capable of performing any of the below task :

a) Call Custom PL/SQL Code
b) Send Notification
c) Call Workflow.

They are usually embedded in seeded API and called as wf_raise.event.

Each Business Event can be have one or more Business Event Subscriptions.Whenever the Business Events gets called the business event subscriptions are executed.

There are a lot of seeded Business Events which can be searched under Workflow Administrator-> Business Events.

In 11i there are some business events whixh do not get fired from forms as they are using row and tale handlers and not seeded API. For example the people and assignment form uses row and table handlers in 11i and any event based on them does not gets automatically triggered, this limitation has anyhow overcome in R12.

I will give a sample code along with implementation step of a Business Event Implemantation for Ready Reference.Bye till then.....

Do let me know how you feel about this article.

Please find sample example in following link :
http://www.scribd.com/doc/90971721/Business-Events-in-Oracle-Applications-A-Sample-Implementation



DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM

Sunday, May 1, 2011

WEBADI - A sample Implementation

Hi Friends,

As promised earlier please find a smal tutorial on How To Use WEBADI for Integration.

I have uploadedthe same into Scribd account and the same can be downloaded from the below link


   http://www.scribd.com/doc/54304471/WEBADI-A-Sample-Implementation



Please have a look and do let me know in case you feel any areas of improvements.


DISCLAIMER: PLEASE NOTE THAT THE VIEWS PUBLISHED HERE ARE OF THE AUTHOR OWN AND THE RESULTS AND OBSERVATIONS MAY VARY DEPENDING UPON THE APPLICATION VERSION.THESE ARE AUTHOR'S PERSON EXPERIENCES WHICH HE HAS SHARED FOR GENERAL AWARENESS. IF YOU FIND ANYTHING WHICH SEEMS INCORRECT/UNAPPROPRIATE PLEASE FEEL FREE TO WRITE AT ASHISH1234U@GMAIL.COM