Display Checkmarks for Yes values in APEX report.

Working with Apex report, I have a table with an "active" flag column that generally stores values in either Y or N.In an Apex report, its better if it displays as green checkmark for Y & X for N, instead of displaying the literal letter. So here it is I am gonna show you how you can implement all this. I wrote few couple of custom classes utilizing the Font Awesome icon library.

I implement these two CSS classes into my global CSS file:

.check-Y:before {

 content: "\f00c";

 color: green;

}

.check-N:before {

 content: "\f00d";

 color: red;

}

The values for the content attributes can be gotten from the Font Awesome cheatsheet (ignore the &#X characters).

 You can see in image shown below. I added the following HTML expression in my APEX report ACTIVE coloumn:

When the report executes, the HTML expression will return either check-Y or check-N, thus referencing the classes with the green check mark or the red X.

Create Apex based Application for your Business from Abacasys.

Send service related queries @ info@abacasys.com or Call us @ +1-678-666-0125

Oracle releases its Biggest-ever Security update: Around 159 flaws removed

Oracle released its largest- ever set of security patches, mentioning much critical vulnerability in software & hardware products that can be exploited remotely & main part without credentials. Beating the previous record of 248 in January, this year in July 2016 oracle latest patch update resolves 276 security fixes.

In July update Company’s insecure Java framework receives fixes for 13 issues, 9 of which are exploitable remotely. Sun systems product suite & Oracle’s Fusion Middleware receive the most of the patches, with 39 & 34 each respectively.

Enterprise business applications such as JD Edwards, E-Business Suite, Siebel CRM & others are in the list those got the patch.

MySQL database gets 22 security updates & 9 fixes are available for the flagship Oracle Database.Among all critical vulnerabilities, five are evaluated as having high regular vulnerabilities scoring score of 9.8. 

Company said that they received reports that attackers had succeeded in hacking Oracle customers who failed to apply patches that are available & strongly recommended the updates the applied immediately.

"Oracle systems are complex and multi-component, not speaking about numerous customizations every company usually has," said by ERPScan.

For regural updates visit our Blog & for services Visit Abacasys

Building an Apex 5 Search Screen

APEX - explore the possibilities...

Building an Apex 5 Search Screen 

Search screens have always been a main feature of APEX applications, & there are many ways they can be implemented. Designing an interactive report gives the user a large amount of search & filter options, but can be slow & all the features many not be required. If you create a classic report page, you can mention that you would like a search bar. This is a much execution which obtains a text field page item and then uses the value entered into it in LIKE clause in the query. Second option is to make a search bar from start. Close to the one generated by the classic report wizard, but now you have full control over which columns are already searched & can also easily add any other filters you like.

Few days back I was asked to create Google Search by a user.  This is a very common request for me & mostly comes from users being used to the fast, predictive searching available on Search Engine Google.com. It could be tough to explain to the users that Google took many years & huge amount of money to develop their search tools and this is not possible for a small organization.

Predictive search bars

The main feature to duplicate is the predictive issue in the search bar and I didn’t have to do much work to get this working. By using a Text field with autocomplete item and supplying the database column you are searching. The field will predict what you are searching for based on what you have already typed.

As you type, the results are reduced on what you have entered.

Refresh Results

Another great feature we might want to duplicate from Google search is the automatically updating results set. Using dynamic actions we can make something similar in APEX.

A dynamic action with an event ‘Key Release’ should be attached to your autocompleting text field. This will fire every time a character is typed into the field. Just add a refresh true action that refreshes a classic report region containing the results. You may also need to upper the text entered so that the search brings back all the expected results. 

Further typing into the search field cut the number of results displayed. Now there is no need to show ‘search’ as now that the report refreshes automatically.

We can take this significantly further and add more filters to our search page which also cause the report to refresh when changed, giving the user a way to search data that feels a bit more modern than a regular search bar.

For Daily Updates keep Visiting Abacasys

Lunched Application Management Pack 13.1.1.1 for EM 13c

AMP or Application Management Pack 13.1.1.1 for Oracle E-Business suite is launched and available. This E-Business Suite plug-in for Oracle Enterprise Manager Cloud Control 13c can be used to handle Oracle Business Suite 11.5.10.2, 12.0, 12.1 and 12.2 environments.

Updates includes

Compatibility:  Enterprise Manager 13c includes several updates including a new Fusion Middleware technology stack, Edition Based Redefinition support and Alta skin user interface.

Hybrid cloud Management:

It Manage & Monitor E-Business Suite environments on Oracle Cloud & On-premise. These capabilities are delivered as EM command line interface to manage, provision, backup, clone, migrate, patch & lift-and-shift E-Business Suite on Oracle Cloud.

System Management:

-          Real User Experience Insight (RUEI) regions added up in E-Business Suite Summary Dashboard

-          Automated host aliasing

Change management:

-          Deploy recommended E-Business Suite Technology stack patches, including Database and webLogic Server patches by using EM patch plans.

-          Customization management: Now you can view the inventory of customizations in an Oracle E-Business suite environment.  You can Download or View a spreadsheet of discovered customization by customization type.

-          Cloning:  You can save cloning interview process as template that can be used in future purpose for smart clone for 12, 12.2x procedure.

For More Updates Keep Visiting our Blog & For Oracle based Services Visit Abacasys website

Abacasys wishes Happy Eid Mubarak

Services offered by Abacasys

Service Offered by Abacasys

why should you Take Remote DBA Service ?

Remote DBA service

Before I start to let you know what is a role of DBA experts , let me first tell you about what Remote DBA service are. Remote DBA service is considered the most effective as well as the most affordable solutions to the database management challenges of today . DBA services provide business houses – small, medium, or large scale, enough room for carrying out the critical business operations without any concern of their critical database being tampered with or lost. It is here where the need of remote DBA experts comes into play.

DBA experts provide a shared skill pool for the business. You can also   ask a DBA expert for DBA support that is cheaper than the service provided by the full-time DBA experts. 

Customer Application Development:

We have a team of Remote DBA experts , that provides the service deliver the right variety of its application to cater to the needs of their clients with the right combination of domain and technology. Our professionals , besides monitoring and responding to alerts, are tuned specifically for custom databases and are competent enough to take care of projects, and provide the suitable architecture along with valuable advice on designing.

We make sure that our clients do not have sleepless nights out of concerns pertaining to database management as they know that their critical data is being monitored round the clock.

Remote DBA  Services 

The Reason Behind why should you Take Remote DBA Service ?

First of all, let me explain to you what is Remote DBA service, Remote DBA service is the process of handling a database from a remote location , or you can say Regularly a remote DBA firm will have a Servicedesk capacity from which all administrations are performed. In Abacasys we have employees who are specialists in their field with expensive specialty learning to guarantee their clients get answers when they require them.

Remote DBAs log in to your database and systems to perform selected duties  depends on upon projects. Generally , the Remote DBA services firm has a unique issue tracking system that transparently records all work performed on clients database so that they should know  what amount of work is done on their database with proper report either hourly or on the daily basis .

Now let’s comes to point  Why should you use Remote DBA ?

If you already have a DBA staff ,Wouldn't they want to have a group of kindred DBAs accessible to them day or night to work together with, go on an errand when they're overburden, or pose a question around a particular feature?

Why Abacasys Remote DBA services ?

The answer is quite simple ,Bcz we really are different. We don't compromise in favor of short term profits. Our clients stay with us for a long time  we always ready to their systems work better and better  for less and less.  Things we do centers around a superior remote DBA experience.

People , process and tools (Our Team )

We hire people who had the good experience and are experts in their fields. We don’t  outsource DBA support from another company. People around you doesn’t change , including the Product Manager who will be responsible for your account.  We mainly focus on the process that makes remote DBA work well. We handle project management , monitoring response and side by side we took feedback from our clients.

Now a day’s it’s all about the tools you used. Experts in our company  spent quality time in R&D  so that if we can detect major issues before they become a critical problem , then our clients have smoother running systems and lots of time could be saved . we also focus mainly on our remote access methods and documentation .

Flexible Pricing Models 

Our pricing  model is very flexible you can check it here by filling a simple form.

Contact Abacasys today and know how can we help your organization .