Customizing Oracle EBS Applications Continued
In this article, we will use an RMA Label (developed using XML Publisher report) as an example to send an email to customers with a button click in EBS.
Join the DZone community and get the full member experience.Join For Free
In my previous article, we learned about showing an XML publisher report as an embedded region in the Oracle Applications framework page. In this current article, we will use the same page and add a button using the OA framework to send it via email.
High-Level Steps for Implementation
- Designing a label in XML Publisher report with a client-specific format.
- Add buttons to existing business functions (such as RMA Label Screen) using personalization to send an email.
I’m using the following for my setup:
- Oracle EBS 12.2.8 release
- Setup Oracle JDeveloper with OAF Extension (10.1.3.4) project and workspace
- Putty and FileZilla FTP tool
- Design Label using XML Publisher
I won’t be going through the setup of these prerequisites—setting up JDeveloper and Designing Labels is reasonably straightforward. Please get in touch with me in case you need any help regarding the prerequisites.
In the Oracle Database, create a new procedure to submit a concurrent program (created in the previous steps) with the email address provided in the delivery options. Here is the code:
Develop the Oracle Application framework page to email the PDF output based on an email address captured on the screen.
- Launch JDeveloper and create a new page by going to OA Components > Page. Use the Application Module (ReturnLabelAM) created previously.
- Class Name: ReturnLabelEmailCO
- Page Name: ReturnLabelEmailPG
- Create a method in the Application Module (seen below) to call the PLSQL function created above and call this method from the EmailController file.
The next steps will be to deploy your locally developed Java components/ OAF page to the application server.
- Login to Unix box on the server using putty and go to
- Create new Directories (same as your package structure in JDeveloper)
mkdir -p xx/oracle/apps/csd/returns/server #directoryto hold server components
mkdir -p xx/oracle/apps/csd/returns/webui #directoryto hold webui components
chmod 777 xx/oracle/apps/csd/returns/server #setpermission to read/write/exec
chmod 777 xx/oracle/apps/csd/returns/webui #setpermission to read/write/exec
- Login to FileZilla and move the files to the locations above
- Review the files as seen below for
- Review the files as seen below for
- Login to putty and go to
$JAVA_TOP, run the below command to generate a
customall.jarfile. Take a backup of the existing
customall.jarfile present at this location:
- it prompts you to enter an APPS (database user name) and password. Once entered, it will generate a
customall.jarfile on the server.
- Import the OAF page into oracle Repository using the below command from putty, while connecting to the middle tier
Bounce application services on the middle tier of EBS, so Oracle can pick the
customall.jar file on run time execution.
Personalize the Oracle Application Screen to add an email button.
- Add a button to the screen where you want to trigger the email. For demonstration purposes, the Depot Repair screen has been used. Use the personalization feature to add an email button and set the properties as below. Note the Destination URL, which calls the custom page developed.
- Click the RMA email button. Clicking this button calls the XML publisher Concurrent Program (
XX_DEPOT_RMA) and sends an email.
In this article, we learned about extending Oracle Applications to add email functionality using Oracle standards. You can use the same approach and extend any Oracle-provided screen to add more functionality. I hope you find this article useful for your business requirements
Opinions expressed by DZone contributors are their own.