Thursday 30 August 2012

Using Mobile Devices with Oracle E-Business Suite


Support for iPhones and iPads
Oracle offers several official iPhone apps that are related to the E-Business Suite, including:
●● Oracle Business Approvals for Managers
●● Oracle Business Indicators
●● Maintenance Workbench for Oracle Enterprise Asset Management
●● Oracle CRM On Demand Integration Pack for Oracle E-Business Suite (Opportunity to Quote)
Apple has indicated that all existing iPhone apps will work transparently on the iPad as well.  Oracle teams who currently produce iPhone apps will be only too-pleased to justify their purchase of iPads to do these certifications.

Using smartphones and mobile devices with EBS self-service apps
●● Some E-Business Suite products offer web-based screens that can be accessed by standards-compliant browsers.  These products have HTML-screens, are built using OA Framework, and are sometimes referred to as "Self-Service Web Applications" (SSWA).
●● If a mobile browser is standards-compliant (e.g. passes the latest Acid test), it might work with the E-Business Suite's self-service HTML screens.  However, if you experience any issues with a mobile browser that cannot be reproduced on a certified desktop browser, our recommendation would be to use a desktop browser instead.

Latest Acid Test URL: http://acid3.acidtests.org/

Using smartphones and mobile devices with EBS Forms-based apps
Some E-Business Suite products run in Oracle Forms.  These Forms-based products require the use of Sun's Java Runtime Engine (JRE) to run.  Oracle tests the Sun JRE with Windows-based desktop clients.  Oracle does not test any mobile Java clients with E-Business Suite Forms-based products.

Using standards-compliant mail clients to approve Workflow notifications
Oracle Workflow is a key part of the E-Business Suite's technology stack.  It can be configured to send emails (via SMTP) that notify E-Business Suite users that certain EBS transactions are awaiting their approval.  E-Business Suite end-users can respond to those notification emails by clicking on a link in those emails, or responding with an email containing certain keywords in the body of a reply.
We would expect standards-compliant email clients to be able to handle Workflow notification emails properly, including email clients on mobile devices.  Some mobile email clients are unable to handle standards-based emails, and other email clients may truncate long Workflow notification emails.  These issues may prevent certain email clients on mobile devices from handling Workflow notifications properly.

Cheers !!!!!!!!!!!
Malay Khawas

Thursday 2 August 2012

Purge Concurrent Request and/or Manager Data


Ensure "Purge Concurrent Request and/or Manager Data, FNDCPPUR,"  is run at regular intervals with "Entity" parameter as "ALL".  A high number of records in FND_CONCURRENT tables can degrade the performance.
Functions of FNDCPPUR: It purges data on FND_CONCURRENT tables and log/output files.

Name: Purge Concurrent Request and/or Manager Data
Short Name: FNDCPPUR
Description: Purges Concurrent requests and/or Concurrent Manager data and log/output files

Parameter Listing:
1. Entity: ALL
2. Mode: Age
3. Mode Value : 10
4. Oracle ID: NULL
5. User Name: NULL
6. Responsibility Application: NULL
7. Responsibility: NULL
8. Program Application: NULL
9. Program: NULL
10. Manager Application: NULL
11. Manager: NULL
12. Report: Y
13. Purge Other: Y

For slow performance of "Purge Concurrent Request and/or Manager Data" set the system profile option "Concurrent: Force Local Output File Mode" to "Yes" and then retest. You may get a better performance of the program.

As per our recent purging strategy we are running “Purge Concurrent Request and/or Manager Data” concurrent request everyday at 21:30:00.
Short Name: FNDCPPUR
This request basically deletes data from FND_CONC related tables and log/out files from physical file system, but I have noticed that this request is not performing the task as required. Even we do have log files older than 2-3 Months.

As per Note ID: 822368.1 we have following workarounds(Oracle Apps Version: 11.5.10.2)
1. Apply patch#7834670
2. Set Profile option “Concurrent: Force Local Output File Mode” value to Yes (As of now value is No)
3. Retest the issue

Cheers !!!!
Malay