Increasing Code Coverage to Include Catch Blocks [Salesforce]

In Salesforce, it can sometimes be frustrating driving your Apex Class & Trigger Code Coverage up to get beyond the 75%, 80%, or 85%+ marks.  Some of the more difficult parts of that process can be covering all scenarios to achieve this. In particular, this post focuses on code not executed within the try-catch constructs count against the overall Code Coverage calculations. With a simple refactor, we can remedy that without changing the underlying functionality of the core class — just the test class. The try-catch we will start with before our changes have the following format: try { // … Read More

Adding a Wait / Sleep / Pause for Salesforce Unit Testing

There are certain scenarios where there are timing issues that cannot be avoided in Salesforce. For instance: in a trigger handler class, you may have to institute some logic to only execute a block of code if certain conditions are met such as an object hasn’t been modified in the last X seconds, perhaps even due to some 3rd party packages your organization has adopted that requires you to work around timing. Or something has a very short cache life in order to prevent many back-to-back SOQL calls. But then when it comes time to test that class, how do … Read More

Ensuring Trust with Blockchain

An Alternative to Using an Oracle BI Publisher Data Table for a One Line Table

Blockchain is a transformative technology that will revolutionize the way information is exchanged across the globe. It stands on the four pillars of Consensus, Provenance, Immutability, and Finality which ensures TRUST in all forms of economic exchanges of value and information. The existence of uncertainty and distrust in all forms of economic exchanges has resulted in tremendous inefficiencies and disruptions between all participants of an economic system, e.g. insufficient trust and information sharing can lead to inefficiency and infectiveness in a bank’s operation as the same information is duplicated across all participants like bank, auditors, regulators, and insurers in the network … Read More

How to Bypass Validation from Apex Across Objects [Salesforce]

If your Salesforce org has Triggers and Apex, you’ve probably run into the issue of hitting Validation Rules (VRs) when your Apex code tries to insert or update a record. The example below is across two objects and how you can solve for it. Let’s say you have an object called Positions and another object called Applicants. There is a lookup field on Applicants to the Position object. On the Positions object, you have a date field called Last Interview Date to identify the latest date an applicant was interviewed. Due to the relationship between Applicants and Positions only being … Read More

A Work-Around for Salesforce Bulk API v2.0 (in Dell Boomi)

Summary: Salesforce Bulk API Usage, though it offers performance benefits over regular APIs is a scarce resource for organizations. It is important to conserve and optimally use the Bulk API. ——- The Dell Boomi Salesforce connector does not support the Bulk API v2.0 (which essentially makes a determination automatically whether to use the regular or bulk API) at the time of writing. This feature is sought-after in the forums since organizations hit their Bulk API usage limits frequently. Processing much lower volumes of documents through the Bulk API (Bulk API accepts 10,000 documents in a single go) may be a wasted … Read More

A Guide to the Changes at the Analytics and Data Summit 2018 (Formerly BIWA Summit)

Changes at Analytics and Data Summit 2018 (Formerly BIWA Summit)

What a year for the BIWA User Community and Oracle Spatial & Graph Special Interest Group (SIG)! Both groups have expanded their leadership teams, as well as rebranding and moving the date of their flagship event, the Analytics and Data Summit (formerly known as the Oracle Business Intelligence, Warehousing, and Analytics (BIWA) Summit.  As a new member of the board of both BIWA and the Summit, we wanted to let you in on the exciting changes, and what they mean to you. The BIWA User Community was founded in 2006 as a special interest group (SIG) of the Independent Oracle User Group (IOUG) … Read More

Lambda Functions with Newer Version of boto3 than Available by Default

During development of an AWS Lambda function utilizing the recently released AWS Cost Explorer API, the latest version of boto3 and botocore was discovered to be unavailable in the Lambda execution environment. The Lambda execution environment supported version of an AWS SDK can lag behind the latest release found on GitHub, which can cause supportability issues when writing Lambda code attempting to use the most recently added features of AWS SDKs. This blog post will explore using boto3 1.4.8 and botocore 1.8.0 despite (at the time of this writing) the Lambda execution environment defaulting to boto3 1.4.7 and botocore 1.7.37. This … Read More

Oracle E-Business Suite (EBS) Analyzers

It’s month end close and something is preventing close. You open a service request (SR) with Oracle and begin narrowing down what the problem is. If this is not an issue you’ve seen before, you and the analyst might have to narrow down where the issue even is. If this is something you’ve seen before, you might be wishing you’d had an easy way to identify this before close rolled around again. Oracle’s E-Business Suite Support Analyzers offer a way to get ahead of potential problems before the day of month end close. Oracle provides analyzers for different areas–payables, receivables, … Read More