What gets Measured, gets Gamed!

Goodhart, Bad Intentions!

Peter Drucker famously said “What gets measured, gets managed“. This is largely true. You can only improve what you measure. However, there’s another conniving little force that takes place when a metric is known to those being measured. The Goodhart Law states that when a measure becomes a target, it ceases to be a good measure. This is because when people know they are being judged on a particular measure, they do everything in their power to improve upon that metric.

There is a (in)famous story of a company that measured time spent customer support calls. This measure was chosen to improve customer resolution speeds. The top rated customer service representative for this company had unbelievable speeds of resolution. Most his calls lasted less than 1/3rd of the time it took other people in the department. It was only when the management looked much deeper into his workflow (in order to learn and improve others) that they realized that the reason he had such short call times was that he simply hung-up on customers after giving them a single potential solution – without waiting for them to try out the solution and let him know if the issue was actually resolved. The poor customers simply had to call back and talk to someone else who would really solve their problem – while taking a hit on their own closure speed metric!

Or take my favourite example of my car company’s service arm (I won’t name the company cause I still need to get my car serviced). They have a system where after each service, their customer satisfaction team calls the customer to ask for their rating. They have a target to get a rating of 9 and above. Every time I get my car serviced, I get a call from them asking for a rating. If I give a rating below 9, they offer all sorts of discounts and freebies and request me to give a higher rating when the “actual” customer satisfaction team calls! They game the system by simply pre-empting the ratings call!

Performance Ratings

The Goodhart Law plays out in HCM way more than most people realize. Take the company Cypress – the story of which was shared by T.J. Rodgers in the Harvard Business Review article “No Excuses Management” in the 1990s. It was a highly measurement driven company. I quote the article here:

“All of Cypress’s 1,400 employees have goals, which, in theory, makes them no different from employees at most other companies. What does make our people different is that every week they set their own goals, commit to achieving them by a specific date, enter them into a database, and report whether or not they completed prior goals. Cypress’s computerized goal system is an important part of our managerial infrastructure. It is a detailed guide to the future and an objective record of the past. In any given week, some 6,000 goals in the database come due. Our ability to meet those goals ultimately determines our success or failure.”

Have you heard of Cypress? I suspect not.

One of the things that happens when you measure people on the number of goals and track the aggregate completions is that people put in goals that are easy to complete. They did 6000 things that didn’t really contribute much. After all “brush my teeth” counts the same as “build tesla” if all you measure is the number of goals.

This may be an exaggerated example, but I’ve seen most companies succumb to this fallacy. We set goals in April, review them in March, and base our performance appraisals on that. We feel “scientific” when we make SMART, quantifiable, objective goals. But unfortunately, when we start to measure people on objective, reduced metrics and tie a paycheck to it – people tend to figure out how to boost the metric in the letter without necessarily boosting it in spirit.

“Boost revenue by 10%”? Sure! I’ll make sales with razor thin margins and reduce profitability in favour of revenue!

“Complete 2 certifications”? Sure! Let me pick the easiest certifications I can find and use cheatsheets to get through!

You get the point.

So how do I solve this?

Well, you don’t. Not fully. But what you can do is use multiple measures. That’s my favourite way anyway. Using regular reviews and multiple different metrics as a way to measure performance. You can round out performance metrics across different areas that cover contribution to the team, feedback from peers, feedback from juniors (360 feedback is important), innovativeness, ability to bounce-back from difficult situations, rate of learning from mistakes, outcomes generated, and so on. The idea is to look at the overall contribution by a person as a whole rather than reducing people to a single talent rating.

The other thing to do is to use proxy metrics. Analytical folks have an inherent bias to be objective, and therefore prefer objective metrics. But in most human business, the qualitative metrics matter more. The way to measure qualitative impact is to look at proxies. For instance, look at the Customer Satisfaction (CSAT) “score” but also look at number of renewals, public testimonials, positive words shared by customers, referencibility, willingness of the customer to give higher rates to retain the original team etc. as proxy metrics for customer satisfaction. These proxies are much harder to optimize or game.

A lot of this depends on a company’s size, scale, culture and nature. We’ve been helping customers find their unique talent processes that work for them. While these are just two ways to improve performance appraisals as a process, each company would need a unique approach to talent management.

The Orbrick Way: POKR

We at Orbrick implement a version of this idea in our very own POKR framework which is based on John Doer’s OKRs. Its Purpose, Objectives, Key Results/KPIs, and Rituals. These are big, ambitious, purpose-guided objectives that are measurable but the measures aren’t targets. The purpose is always personal for each employee. It is the answer to “why do you come to Orbrick on a Monday”, or “we know why Orbrick hired you, but why did YOU hire Orbrick?”. The purpose then brings out the objectives and the objectives that align with the organization in some way are selected (generally no more than 3 per quarter). There are no consequences to failure. We then use something called a talent dossier which measures over 20 different metrics to gauge how a person has performed. There is a quarterly reviews of people’s POKRs. And there is a regular updation of the talent dossier too. This helps us keep biases (like recency bias or availability heuristic) low and is more resilient to being gamed!

Purpose derives Objectives. Objectives guide Key Results or Goals. Goals are met through Rituals. Rituals reflect Identity. Identity fuels Purpose.

Work. Laugh. Repeat. The Orbrick Way

Work. Laugh. Repeat. The Orbrick Way

They say your first job leaves an indelible mark, becoming the foundation for the rest of your professional life, kind of like the first time you try to make instant noodles and accidentally set off the smoke alarm. Whether you realize it or not, it’s the place where your core values begin to take shape, guiding you through future endeavours and relationships. As a 2024 graduate stepping into the corporate world, Orbrick Consulting has become more than just my first workplace – it’s my first crash course in adulting. 

What is work culture, really? Is it the coffee breaks where we vent about managers and laugh it off? The table tennis matches that only end when someone mutters, “Maybe we should work”? Or the pizza and coke after surviving tough clients? Maybe it’s more than that—it’s about people. It’s about those small efforts that make everyone, from the CEO to the office attendant, want to show up on a Monday morning (yes, I said Monday). It’s about creating an environment where seeing your manager walk over with more tasks feels like a challenge to grow, not a reason to wish you were elsewhere. 

Here, fostering a healthy work culture isn’t just a goal—it’s a commitment. From prioritizing mental health to creating spaces where everyone feels heard, innovative steps are woven into our daily lives. Mental health, being the cornerstone of well-being, is given utmost priority. We have alternate-day meditation sessions, including manifestation practices (or just a good lunch), to help us centre ourselves. There’s also a unique benefit—a dedicated mental health leave employees can take anytime during the year. At our entrance, a well-being wall with four quadrants invites us to share how we’re feeling each day, creating a space for reflection, and helping the company understand and support us better. Orbrick doesn’t just hear us; it listens, making every day a little brighter, even Mondays. 

At the company, we take “team bonding” to a whole new level with our weekly series, “Know Your Brickster” It’s basically show-and-told for grown-ups, where one lucky Brickster gets to spill the beans about their life while everyone else asks everything from “What’s your hidden talent?” to “Pineapple on pizza: yes or no?” For an hour, it’s not about work, it’s about the person behind the desk. It’s a fun, slightly chaotic way to turn colleagues into friends, break the ice, and remind us that behind every email is a real human. 

At Orbrick Consulting, learning doesn’t stop at your desk—it thrives in our Knowledge Transfer Sessions where the company’s leaders generously share their expertise (and occasionally their life hacks). From “How to Enhance Your Business Knowledge” to “Mastering MS Office Tools” these sessions are packed with insights that bridge the gap between theory and practice. We’ve explored topics like functional and technical roles, project management basics, and even the fine art of change management. It’s like TED Talks, but with fewer buzzwords and more practical takeaways. These sessions not only sharpen our skills but also inspire us to think bigger, work smarter, and inch closer to becoming the best versions of ourselves.

At Orbrick, physical health and creativity walk hand in hand—literally. Employees who hit 6,000 steps for at least 85% of the quarter are rewarded with prizes and a heartfelt appreciation letter from our leaders. Think of it as getting fit with a side of fame. For the bookworms (or aspiring ones), there’s a new initiative: read 12 books in a year and earn rewards. And then there’s Spark Tank, our quarterly showdown of brilliance. Teams brainstorm three technical and feasible ideas around a tagline, and the winning idea not only gets bragging rights but also a share of the profits when it hits the market. 

In the end, your first job is never just about the work; it’s about figuring out how to look busy during a surprise meeting. it’s been a rollercoaster of growth, laughter, and plenty of “what just happened?” moments. If this is the foundation for my career, I’d say it’s off to one great of a start. Here’s to first jobs, lessons that last, and a lifetime of figuring it all out – one coffee at a time. 

Processing Large Data in Oracle ERP System

Introduction

Oracle Fusion ERP helps businesses to manage their operations and to make decisions from data available in the system. However, the problem arises when data volumes increase as organizations start to grow. Working with large datasets in the system will lead to performance issues like executing large reports, integrations that rely on the data from the reports, or data extractions. For technical teams, handling huge volumes of data effectively may be quite challenging.

Large datasets can cause several performance issues, like:

  1. Report Failures: Scheduled reports or online reports can often fail or time out due to large amounts of data causing system limits.
  2. Slow integrations or failures: When working with big datasets, scheduled procedures or API-based integrations may suffer from performance deterioration, which might lead to delays in data processing or synchronization.
  3. Issues in data extraction: It may be essential to split or segment data when exporting large datasets for analytics or compliance reasons, as they might exceed system-imposed size restrictions.
  4. User frustration: Decision-making becomes more difficult when processes are disrupted by frequent failures or delays in getting crucial information.

Such challenges arise from inefficient techniques for process design and data extraction or reporting, along with the inherent limits of handling huge volumes of data. In addition, it’s critical to resolve these performance issues while recognizing Oracle Fusion ERP’s limitations, especially the absence of direct database access and a strong dependence on seeded tools like BI Publisher, OTBI (Oracle Transactional Business Intelligence), and REST/SOAP APIs for data management.

Reports and integrations that do not function properly could lead to delays in business-critical operations like supply chain management, regulatory filings, and financial closes. To ensure seamless operation, maintain user productivity, and increase system dependability, performance optimization for huge data reporting and associated procedures becomes vital.

This blog tackles the challenges of handling large data sets in Oracle Fusion ERP, offering practical solutions to enhance performance. From effective filtering to advanced techniques like chunking and bursting, we address the root causes of slow reports, integrations, and data extractions. By adopting these best practices, you can optimize performance and future-proof your processes against the growing demands of a data-intensive business environment.

Performance Tuning

When we talk about the improvement in the performance of the query or code, we can divide it into two major parts:

  • Code Optimization
  • Data Size

In code optimization, we can use various methods like rearranging the query in a structured way by checking the joins and removing or realigning the joins properly. In the data size part, we can break down data in the output itself by adding proper filters to reduce the size of the data generated by the SQL query, or we can use the chunking functionality provided by Oracle to split the data into multiple outputs.

Code Optimization

The first and most important step in deconstructing the problem of the big data collection is code optimization. We must first examine the SQL query’s flows and reorganize it in relation to the results.  The query might encounter issues with performance due to the possibility of missing or improper joins. To fix these kinds of problems, we must first divide the queries into smaller components and then debug the queries to find the problematic portion. Code optimization can majorly be divided into three parts:

  1. Process outside ERP
    1. Process Data in Warehouse System
    2. Third Party Tools
  2. Query Re-Arrange
    1. Use of proper joins
    2. Removal of subqueries
    3. Remove unnecessary data
  3. Query Tuning
    1. Use of views
    2. Hints

The above diagram shows various ways to tackle the issue, which is caused by the code; we can use these different ways to resolve the issue. Let us discuss these methods in detail.

Process Outside ERP System

As we know, Oracle Fusion is a transactional database.  There will be some limitations to it; to overcome these limitations in performance, we can use Data warehouse systems, or we can get the help of various third-party tools available in the market like Power BI.

Process Data in Warehouse System:

Data warehouse systems efficiently handle large ERP data volumes. Oracle Analytics Cloud (OAC) seamlessly integrates with Oracle ERP, allowing custom subject areas in the presentation layer, similar to OBIEE, or direct SQL query building. To generate reports, ERP data must be periodically extracted via scheduled reports, Business Intelligence Cloud Connector (BICC), or integrations. This reduces data load, ensuring smooth processing. Warehousing is crucial for large reports like GL transactions or Aging reports, which are difficult to manage in transactional ERP databases

Use of third-party tools:

Various third-party tools for reporting are available in the market, which can be used to generate the report in various ways. These tools can provide more insights in a better way than the reporting tool available in the ERP system. Some of these tools are Power BI (a Microsoft Product), SmartView for Oracle (can be used in Excel), or APEX Dashboards. These tools provide greater flexibility and efficiency in handling large datasets compared to standard ERP reporting solutions. By offloading data processing to external tools, businesses can significantly enhance report performance, minimize timeouts, and ensure smoother operations without being constrained by ERP limitations.

Power BI allows users to connect directly to Oracle Fusion ERP data sources, process and visualize data more effectively, and apply advanced analytics without overloading the ERP system. By extracting and transforming data externally, reports can be generated faster and with richer insights.

Oracle APEX is another powerful tool that enables the development of lightweight web applications and dashboards. It can be used to create customized reports that fetch and process data outside of the ERP, reducing the burden on the system while improving response times.

Query Re-Arrange

When we talked about processing the data outside of the ERP system, we needed to use third-party tools or data warehouse systems, which can be costly and require high maintenance. To save a cost, we can optimize the query by removing subqueries and merging them into the main queries or we can relook at the joins we have used in the query and rearrange them better way we can remove unnecessary data from the query to optimize the performance. This way we can save money and improve the performance of the query and get the desired results.

Proper Joins

The query will not perform well if proper joins are not being used in SQL. As a standard, we have to always use a proper join to fetch the data. It is essential to use proper joins to retrieve the data. For large reports, if the joins are not maintained properly the query might not provide a desired result or in worse scenarios, it will not run at all. It is recommended to check the Oracle documents in case of the query performance issue to identify any obsolete columns or missed joins as the first approach in the query rearrangement.

Remove Subqueries

Another bottleneck issue in the time-consuming queries is sub-queries. Sub-queries are good if they do not consume more resources, but in most cases, subqueries consume more resources and can generate duplicate or improper data. Below are the pros and cons of using sub queries:

Before jumping to any conclusion about using the subqueries or not, it is always recommended to go through the explain plan generated by the SQL to identify the part that is causing the issue. If it is the subquery part that is causing the problem, then it is advisable to use it as Common Table Expressions (CTE). CTEs are generally faster in executing the way databases process and optimize them. Below is the explanation of when to use the subquery and when not to:

  • When to use subqueries:
    • When dealing with the smaller amount of data
    • When using aggregation logics
    • When inline calculation needed
    • When filtering data in where clause
  • When not to use subqueries:
    • When dealing with larger data sets
    • When it is feasible to use CTE for faster executions
    • When require using the same logic multiple times
    • When query performance is important
Scenario Use a subquery? Better Alternative?
Simple queries with filters or aggregations ✅ Yes N/A
Checking for existence (IN, EXISTS) ✅ Yes N/A
Queries involving large datasets ❌ No CTEs or JOINs
Performance-sensitive queries ❌ No JOINs
Recursive queries (e.g., Org Hierarchy) ❌ No Recursive CTEs
Ranking and row-based operations ❌ No RTF / Excel Functions

Remove Unnecessary Data

After applying the above-mentioned optimization techniques, if there is still a performance issue, then it is recommended to remove unnecessary columns from the query. We have seen many times there are not-so-important columns added in the query, which can cause performance issues and slow down the execution time. It is recommended to exclude these columns to improve the performance of the query.

Query Tuning

The final part in the optimization of the query is tuning. As mentioned earlier, we need to check the explain plan to identify the part that is causing the performance issue. In the tuning part we need to rewrite the code based on the available resources in the Oracle ERP system, as direct database access isn’t available in Fusion. As a developer, we can make proper use of the views provided by the oracle or usage of the hints.

Use of views:

Views that are provided by the oracle are generally faster than the normal tables in execution due to several factors like proper joins maintained in the view logic, performance enhancements via indexing, etc. For e.g., To fetch the data of supplier in oracle fusion Instead of using POZ_SUPPLIERS and joining it with multiple tables, it is advisable to use view POZ_SUPPLIERS_V which is provided by an oracle with some of the useful columns required for the query.

Use of Hints:

Oracle SQL hints are instructions that help the optimizer determine the optimal query execution strategy. Hints can help optimize performance in Oracle Fusion, particularly when querying huge datasets in BI Publisher.

Revolutionizing Asset Management: Key Transformation Features of Oracle Fusion’s Fixed Asset Module

Introduction: 

Fixed assets are long-term tangible properties, such as machinery, buildings, and equipment, that businesses use to generate income. Managing these assets effectively ensures operational stability, cost efficiency, and better financial control. Oracle has introduced significant enhancements in its Fusion Fixed Asset module to improve usability, financial reporting, and integration with other applications. 

Key Transformative Features:

We can discuss some of these remarkable enhancements in detail, as listed below. These updates have significantly improved the Fusion Fixed Asset module, offering businesses greater efficiency and financial reporting capabilities. 

Fixed Asset Approval: 

Business requires certain governance while recording the fixed asset transactions including but not limited to addition, retirement, and transfer, to ensure the accuracy and completeness of it. The approval workflow on the fixed asset transactions also ensures the appropriate level of internal control. 

The approval workflow streamlines the elimination of paperwork by acting as a centralized repository for all asset approval transactions. It ensures compliance, enhances accountability, and meticulously records audit trials.  

Oracle has recently introduced approval on Fixed Asset transactions such as Addition, Adjustment, Transfer and Retirement for single and mass transactions. To enable the approval, select the required transactions such as Additions, Adjustments, Transfers and Retirements in ‘Enable Approval’ field available at the asset book level. 

The system will route the fixed asset transactions for approval using rules configured in asset transactions approval spreadsheet available under manage workflow rules in spreadsheet page. 

The following is the difference between Single Transaction and Mass Transaction Approval. (Source: Oracle Consolidated Document for Assets approval) 

 

Single Transaction  Mass Transaction 
Each transaction is approved separately. Approver is notified for each transaction.  Transaction group as whole is approved. Approver gets only one notification for each Mass Transaction group. 
Enter single transaction in the following pages to submit for approval. 

 

· Add Assets 

· Adjust Assets 

· Transfer Assets  

· Retire Assets  

 

To create approval rules for the single transaction use the following sheets in “Manage Workflow Rules in Spreadsheet”.  

 

· Addition 

· Adjustment 

· Transfer  

· Retirement 

Enter Mass Transactions for group of assets through ADFdi Spreadsheet, or FBDI Spreadsheet and to create approval rules use the “Mass” sheet in “Manage Workflow Rules in Spreadsheet”. 
Most of the asset attributes and transaction attributes are available to define the approval rules.  Only Mass Transaction group attributes are available to define the approval rules. Individual asset level attributes are not available. 
Approval is initiated when you submit the transaction.  Approval is initiated when you set the status to Post for all lines in the group and post them. 
Approval notification shows the details of the assets transactions submitted.  Approval notification shows the summary details of all the asset included. in the mass adjustment transaction group/batch.

The business can consider below factors to decide if Fixed Asset approval should be implemented by the entity which might add the administrative cost but ensures accurate financial reporting. 

 

Decision Point  Explanation  Financial Impact 
Asset Materiality and Value  Approval is necessary if the fixed asset addition, retirement, or adjustment exceeds the materiality threshold.  Ensures proper oversight for high-value transactions, preventing material misstatements in financial statements and safeguarding assets. 
Risk of Misclassification or Errors  Implement approvals if there’s a history or high likelihood of errors in classification, depreciation, or adjustments.  Reduces the risk of misstating expenses or asset values, which could impact reported profits, tax liabilities, and investor confidence. 
Impact on Financial Ratios  Approvals are critical if the decision significantly affects key ratios like ROA, Debt-to-Equity, or Current Ratio.  Prevents unintended consequences on financial ratios, maintaining compliance with loan covenants and supporting informed decision-making by stakeholders. 
Regulatory and Audit Requirements  Required if compliance with standards like IFRS/GAAP or audit recommendations demands additional oversight.  Avoids penalties, audit findings, or reputational damage by ensuring adherence to regulatory and reporting standards. 
Frequency and Volume of Changes  Approvals should be implemented if the entity frequently adds, retires, or adjusts fixed assets.  Controls prevent fraudulent activities and ensure that frequent changes don’t lead to over- or under-capitalization, safeguarding the accuracy of financial records. 

 

The detail of setup is available in Oracle Fusion Cloud Financials Readiness document of release 24C. (Exception-Based Approvals for Fixed Asset Transactions) 

 

Segregation of Asset Transaction Entry and Transaction Posting Duties: 

Segregating asset transaction entry and posting in Oracle Fusion enhances internal controls, reduces errors and fraud, improves data integrity, and strengthens auditability. This structured workflow boosts efficiency, transparency, and compliance with global internal control standards. 

To set up this in the system, navigate to Setup and Maintenance -> Financials -> Change Feature opt in -> Fixed Assets -> Edit Feature -> Segregation of Asset Transaction Entry and Transaction Posting Duties.
 

The separate custom role needs to be created for the preparer by removing the posting-related privileges and for the reviewer by adding privileges related to transaction viewing after copying the ‘Asset Accounting Manager’ seeded role.
 

Below is a table list down the nature of transactions which can be performed by the preparer and reviewer (Source: Oracle Docs: Implementing Assets 24A) 

User Type  Duties 
Transaction Preparer 
  • Create all types of asset transactions in draft mode, including additions, adjustments, transfers, and retirements. 
  • Set the status to Review. 
  • Create impairment and revaluation transactions and set the posting status to Review after the transactions have been previewed. 

Note: The Submit button is disabled for the transaction preparer. 

Transaction Reviewer 
  • Review transactions in Read Only mode. 
  • Post all types of asset transactions, including additions, adjustments, transfers, retirements, impairments, and revaluations. 
  • Review and post suspend or resume depreciation transactions only through an ADFdi spreadsheet. 
  • Send a transaction back to the preparer if it requires corrections by changing the queue status to New. 

Note: Transaction reviewers can’t create or edit transactions. 

The details of setup is available in Oracle Fusion Cloud Financials readiness under Asset and Lease Management > Assets (Oracle Fusion Cloud Financials 24A What’s New) 

The separate of asset transactions and posting duties is also in line with principle of lease privilege and best practice of internal control which should aim to achieve. Business can consider below pointers to decide if entity should segregate asset transaction entry and posting duties when recording fixed assets in the books.
 

Decision Point  Explanation  Financial Impact 
Risk of Fraud or Misappropriation  Segregation is essential if there’s a risk of asset-related fraud or unauthorized postings.  Mitigates potential financial losses and improves internal control, safeguarding assets and reducing the risk of fraudulent financial reporting. 
Complexity and Volume of Transactions  High transaction volumes or complex entries may require segregation for accuracy.  Reduces the likelihood of errors, ensuring accurate asset values, depreciation schedules, and financial statements. 
Regulatory and Audit Requirements  Required if accounting standards (e.g., SOX, IFRS/GAAP) or auditors recommend stronger controls.  Enhances compliance with regulations, avoids penalties, and builds stakeholder confidence in the integrity of financial reporting. 
Expertise and Accountability  Segregation ensures that specialized personnel handle entry and posting responsibilities.  Reduces errors caused by a lack of expertise, preventing misstated asset values and incorrect depreciation charges. 
Cost of Implementation vs. Benefits  Consider whether the financial benefits of segregation (e.g., reduced errors and fraud) outweigh the costs (e.g., hiring additional personnel).  Balanced controls improve reporting accuracy and reduce costly mistakes, but excessive controls could increase operational expenses unnecessarily. 

  

Capitalization of Fixed Assets for Expense Destination Receipts in the Procurement Process 

Capitalizing fixed assets for expense destination receipts improves financial accuracy, transparency, and compliance by ensuring timely recording of asset-related transactions. This approach enhances asset tracking, reduces manual errors, and provides a clear audit trail for regulatory and internal audits. Automating capitalization streamlines financial operations, enabling businesses to allocate resources efficiently and plan future investments effectively. Even when invoices are delayed due to vendor or internal approval issues, this method ensures that assets in use are properly recorded, preventing financial misstatements and improving overall reporting accuracy.

There are ample of cases where the entity has received the asset and started using it but the invoice for the same is not booked in the system due to variety of reasons such as delay in invoice submission by the vendor or internal delay due to approval or similar issues. 

The system will also create a maintenance asset for such receipts automatically to establish a relationship with the corresponding fixed asset without any manual intervention. It will create a single fixed and maintenance asset for non-serialized items and multiple assets will be created for serialized items. 

After accounting for the receipt of the asset, transfer the estimated costs and non-recoverable taxes from the receipt to Assets using the Transfer Receipts to Mass Additions process. This process transfers the assets to the corporate book associated with the purchase order’s inventory organization, using the receipt date of the goods as the in-service date. Once the invoice is created and accounted any price variance between invoice and purchase order will be posted to the Fixed Assets. 

The business can consider below pointers to decide if asset can be capitalized while receiving or at invoice. 

 

Decision Point  At Asset Receipt  Financial Impact (At Receipt)  At Payables Invoice Creation  Financial Impact (At Invoice) 
Ownership and Risk Transfer  Capitalize if ownership and risks are transferred upon receipt of the asset.  Increases fixed assets and liabilities simultaneously; aligns timing of capitalization with control transfer.  Capitalize when ownership is confirmed through the invoice.  Delays asset recognition, potentially underreporting assets in interim periods. 
Cost Certainty  Estimate and capitalize based on expected costs if all relevant costs (e.g., freight, installation) are known.  Risk of estimation inaccuracies; may require future adjustments, creating complexity in reporting.  Capitalize based on the final confirmed invoice value.  Ensures accurate asset valuation and avoids retroactive adjustments. 
Asset Readiness for Use  Capitalize if the asset is in the location and condition necessary for its intended use.  Accurately reflects asset usage timeline and depreciation commencement.  Delay capitalization until the invoice confirms readiness.  May defer asset recognition and delay depreciation start, impacting reported earnings. 
Supplier Invoice Discrepancies  Ignore minor discrepancies and capitalize based on receipt records.  Risk of mismatched liability and asset values if invoice adjustments occur later.  Capitalize after resolving discrepancies in the invoice.  Ensures accurate recording of asset value, minimizing reconciliation challenges. 
Materiality Threshold Compliance  Capitalize immediately if the value exceeds the business’s materiality threshold.  Aligns with policy thresholds but may result in premature recognition if costs are uncertain or incomplete.  Capitalize after invoice verification of materiality.  Avoids capitalizing items incorrectly, ensuring compliance with accounting standards like GAAP or IFRS. 

 

The detail of setup is available in Oracle Fusion Cloud Financials Readiness document of release 23B under Assets. (Oracle Fusion Cloud Financials 23B What’s New) 

Conclusion: 

In conclusion, the features outlined in this blog provide significant enhancements that will undoubtedly benefit businesses in the tracking and reporting of fixed assets. These innovations ensure greater accuracy, compliance, and efficiency, thereby facilitating more effective asset management and informed decision-making. Implementing these features will empower organizations to streamline their financial operations and achieve better transparency and control over their fixed assets.

Onboarding: The Orbrick Way

Challenges in Onboarding  

Onboarding is a crucial step in shaping a new hire’s journey, but it often comes with challenges that can impact their integration and long-term success. Here are some of the most common challenges: 

 

Information Overload on Day 1

Overwhelming new hires with excessive information can cause anxiety and hinder retention. Research indicates that 81% of new hires feel overwhelmed during the onboarding process. withe.co (Glean) 

 

Unclear Job Roles

Ambiguity about responsibilities can lead to disengagement and reduced productivity. According to Talmundo, 64% of employees face challenges due to unclear roles. explodingtopics.com 

 

Not Utilizing a Buddy System

Without a peer mentor or buddy, new hires may struggle with informal support and social integration. The data suggests that 56% of new hires find an onboarding buddy or mentor helpful. devlinpeck.com 

 

Overreliance on Automated Systems

While automation streamlines processes, excessive reliance can make onboarding impersonal and reduce mentorship opportunities. Studies show that 80% of employees prefer onboarding with more face-to-face interaction. withe.co 

 

Disconnected Manager Onboarding

Delayed one-on-ones with managers can create confusion and a sense of being unsupported. Research indicates that poor management contributes to 50% of new hires leaving within 18 months. devlinpeck.com 

 

Lack of Ongoing Feedback Loops

Without regular feedback, new hires may feel uncertain about their progress and performance. Gallup reports that 43% of employees would stay longer with consistent feedback. withe.co 

Pre-Onboarding: 

During the notice period, HR connects with the candidate every 20 days and tracks progress monthly. Upskilling topics are shared in advance to help candidates prepare, reducing training time after joining. One week before joining, HR shares necessary forms including background verification and welcome kit personalization. To minimize plastic waste, we allow new joiners to choose the items they would like in their welcome kit ensuring it’s tailored to their needs. 

Onboarding Day: 

Branding and Professional Identity 

From day one we help new joiners build a strong professional identity. We encourage them to update their LinkedIn profiles, which enhances both their brand and our network. A personalized welcome email introduces them to the team, helping forge meaningful connections right away. 

Orbrick Rituals 

Our unique rituals create a sense of community and engagement. KYB (Know Your Brickster) encourages team members to share personal stories, while Spark Tank sparks innovation. Activities like the Step-Up Challenge and Orbrick Plays (Cricket/Pickleball) add fun and wellness to the workplace, making everyone feel connected. 

First-Day Engagement 

We make sure every new joiner feels welcomed and valued from the start. With warm greetings, an office tour, and team introductions, we ensure they settle in quickly. A personalized welcome kit and a shared lunch help make the first day memorable and build strong early bonds. What sets us apart is our innovative Augmented Reality (AR) experience. On their first day, new joiners explore the office by scanning codes to discover Orbrick’s values and culture. The journey ends with a fun AR quiz, making their first day both engaging and unforgettable. 

Tools and Systems 

A smooth start means having the right tools in place. From IT setup and Launchpad access to adding them to our communication channels like WhatsApp, we ensure new hires are ready to hit the ground running on day 1. 

Cultural Induction 

Our interactive AR onboarding activity gives new joiners insights into our story, and a “Chai Pe Charcha” with the CEO connects them with our leadership team. This helps them align with our values and vision right from the start. 

Post Onboarding  

Continuous Tracking and Feedback 

Regular check-ins during the first 30-60-90 days, along with feedback collection, ensure new joiners have the support they need to thrive and grow.  

How have we tried to design better Onboarding?  

Engagement Before Day One: 

Proactive communication during the notice period ensures new hires feel engaged and supported even before their first day. As per our survey, 99% of employees expressed satisfaction with the onboarding process, this approach boosts morale, improves retention, and aligns new hires with company values from the very beginning. 

Pre-Joining Upskilling: 

Early knowledge-sharing helps employees start with confidence. As per our survey 83% of new hires understand their roles clearly on Day 1, this pre-joining support reduces confusion, sets expectations, and accelerates productivity, allowing new hires to contribute effectively from the start. 

Personalized Welcome Kits: 

Thoughtful, customized kits make employees feel valued and create a positive first impression of the company culture. As per our survey 92% of employees were pleased with the welcome kit, enhancing the overall onboarding experience. 

AR (Augmented Reality): 

AR in onboarding helps new hires explore the company interactively through the Orvoyage activity, uncovering stories and key details. This innovative approach to onboarding creates a fun and engaging way to learn about the company’s culture and values. 

Ongoing Support and Follow-Up: 

Regular check-ins ensure that employees feel supported throughout their journey. As per our survey 73% of employees found the buddy system helpful, demonstrating that peer support plays a crucial role in onboarding, leading to smoother transitions, stronger relationships, and better integration into the company culture. 

Conclusion:  

An effective onboarding process is the foundation for long-term success. By tackling common challenges and focusing on clarity and support, we ensure new hires are ready to thrive from day one. Our tailored approach drives engagement, boosts productivity, and helps new employees feel valued. A seamless onboarding experience not only supports retention but also strengthens our team, creating a culture of success. 

Assessing Human Capital: The 3P Talent Framework

Dimensions of Top Talent

If the Pareto Principle is true (it is!), then 20% of your people generate 80% of your outcomes. Every organization (especially those which depend on people) need to nurture its top talent. But how do you measure top talent in your org?

We propose three dimensions to look at to identify your best talent.

Performance

One way is to measure Performance. Performance is the metric every single organization uses to assess their talent. It is the most objective (or at least objective-seeming). It looks backwards and therefore gives a lot of comfort as you can conjure up a lot of data to justify a rating. This also feels most important because most firing decisions will be based on this. If people do not meet the job’s expectations – what’s the point of paying them? This makes regularly assessing performance paramount to running a people driven business. This itself is tricky, since it’s often hard to understand who is “performing” well especially in knowledge work where the work is unique to individuals and largely incomparable (how do you compare apples with F-16s?). Let’s say we got that down to a T. Top performers whose performance is maxed out are going to face the problem of diminishing returns. This is the idea behind the Peter Principle which states “an employee continues to receive promotions to work in higher ranks up to that point where he reaches a level of incompetence“. You’ll eventually have people in positions they are dramatically unsuited for.

Potential

Many great HCM systems (such as the super-powerful Oracle Fusion HCM) will give tools and processes that help measure an employee’s potential over and above their performance. This looks ahead rather than backwards. This is slightly more subjective and has some biases involved, so a great way to handle this (in Fusion) is using Talent Assessment questionnaires which use proxy questions to assess what potential looks like in your company’s context. Based on answers, the score for potential should be adjusted. Designing these questions takes skills, patience, and testing. Design Thinking helps. The Performance vs Potential matrix is typically a 9-box matrix, where the High Performance, High Potential folks are typically considered your top talent. The challenge here, however, is that you may have excellent performing, highly versatile high potential talent that is going to leave you in the next 3 months as soon as the appraisal cycle is over. All they are waiting for is the pay hike, so that they can get a bigger pay hike down the road. Goodbye, greatness!

Permanence

The final dimension we suggest that should be considered over and above the Performance vs Potential is permanence. How long is someone likely to stay with you, given that the you continue to reward them fairly as per the business’s context. This is the hardest to measure. This is what many people would call “Employee Loyalty”. Oracle Fusion’s Risk of Loss vs Impact of Loss framework is a good start. However, a robust off-system process must be designed, implemented, and regularly followed so that acts both as an Early Warning System to identify high risk of loss, high impact employees as well as measure likely “long runners” in the organization who come from the High Performance, High Potential pool. These people are in for the long haul.

Note that Permanence is a measure of ownership not inertia.

 


The combination of these three will most likely give you your top talent. Remember that this box (High Performance, High Potential, High Permanence) is one with some churn. We need to nurture the people in this group, and continue adding more people to it. Any organizational, market, or work changes can trigger a change in people’s performance, potential and permanence. Personal issues can diminish performance, purposeless can dampen potential, and perceived slights can damage permanence. People need to be treated as people and supported to ensure they unlock their whole self and bring it to work. It’s very important to keep measuring all three regularly and take appropriate actions, give necessary support, and stage interventions wherever necessary.

Absence Minded: Features to look out for in 2025(A)

What’s New in 25A

It’s always exciting to start a new year with something new to know. So, here are a few features which are eye-catchers for the release of 25A in Oracle Fusion Absence Management:

  1. Self Service Qualified Entitlement Display: This will be helpful now, which was most of the time fulfilled with reports. It gives insights to employees who want to validate the accuracy of payments for qualification leave type. This also reduces number of queries Payroll team had to clarify and provide calculation for:

Ex:

Leave Duration Days First 30 Days Next 60 Days Next 30 Days
Salary Pay 100% Pay 75% Pay 0% Pay

 

Configure it here and result will be on Employee/Manager self-service:

 

 NOTE: Use the new balance display options to display qualified entitlements in a new tab on the Redwood Absence Balance page.

 

  1. Pay Rate Date Configuration Options for Accrual Plans: This was a huge challenge that always ended with a workaround or no solution or policy change to the need.

If my carryover leave balance was 10 days from year 2024 and utilizing that balance in 2025, my rate of pay should be calculated based on salary of 2024 and not 2025.

Ex:

Salary Date Salary Rate Leave Dates Calculation
01/01/2024 $25 per hour Start Date: 15/12/2024 12 (workdays) * 25 (rate) * 8 (daily hours)
01/01/2025 $30 per hour End Date: 15/01/2025 11 (workdays) * 30 (rate) * 8 (daily hours)

 

  1. Compensatory Time Pay Rate Configuration: Like above feature, Compensatory Time-off pay rate is also availed with feature of choosing whether pay rate should be considered as of the earned time-off date or current pay rate.

  1. Forfeit accrual balance, EVEN POSITIVE balance value:

Sounds odd, right??

But it has excellent use in Reverse Termination case. If the balance was forfeited upon termination, it will be reinstated upon reverse termination action, AUTOMATICALLY.

We are eager to try out these and explore the workings of it. There are a few more features, listed in the below link and in overall, these are very good updates to start new year with.

Link to updates: Absence Management 25A Features Release

Top 3 Under-rated or Under-used features (already there!)

  1. Donation Plans:

Workers can donate some or all their accrual plan absences to others who need it. This demonstrates organization’s commitment to social responsibility which not only benefits society but also strengthens their reputation among consumers and stakeholders.

Below is the link for creating Donation Plan

Link to Create Donation Plan

  1. Year End Disbursements:

This feature is used for Annual disbursement which is practiced in some organizations while some doesn’t. The POV here is that it eases down liability on organization and for employees it’s additional payout every year.

Navigation:

My Client Groups -> Absence -> Absence Plan -> (Search for Accrual Plan Type) -> (Click on plan name) -> (Accruals tab) -> Check Disburse remaining balance under Post Rollover and Carryover

NOTE: This would be only applicable if your legislation allows for such an option.

  1. Liability Rate Rule:

For financial sheets to balance well, Organizations remain prepared for liabilities that are due and upcoming uncertainty. If otherwise to create custom provision in payroll, it is better to utilize the rate liability rate rule available in the absence plan. Provided that accrual takes place on periodic basis which resembles with payroll period as well, liability accrual will be straight to get processed in payroll and accumulate provision amount.

Redwood Ready SCM: Oracle’s Introduction to Redwood, AI and VBS

In today’s fast-evolving digital landscape, businesses must adopt cutting-edge technologies to enhance user experience, streamline operations, and stay competitive. Oracle Fusion’s Redwood User Interface (UI), Artificial Intelligence (AI) capabilities, and Visual Builder Studio (VBS) together form a transformative trifecta that modernizes enterprise applications. These tools redefine operational efficiency, revolutionize user engagement, and empower businesses to interact seamlessly with data, processes, and people. This blog delves into these advancements, exploring their essence, impact on Oracle’s ecosystem, and implications for businesses and consultants alike.

Redwood Capabilities

Oracle’s Redwood User Interface (UI) represents a significant evolution in enterprise application design, offering a modern, intuitive, and cohesive user experience across all Oracle applications. It shifts the focus from purely functional interfaces to an adaptive, user-centric framework that aligns with the demands of a digitally driven workforce.

Core Features of Redwood UI

  1. Modern and Consistent Design: Delivers a unified look and feel across Oracle’s ecosystem, ensuring a seamless user experience throughout various application.
  2. Visualization-Driven Insights: Focuses on dashboard-centric analytics, enabling users to access actionable data briefly and make informed decisions efficiently.
  3. Improved Accessibility and Simplified Layouts: Enhances navigation and usability, reducing the learning curve and improving inclusivity for a diverse user base.
  4. Faster Navigation and Performance: Optimizes response times and ensures smoother transitions, empowering users to complete tasks swiftly.
  5. Enhanced Mobile Responsiveness: Adapts seamlessly across devices, including smartphones and tablets, ensuring consistent functionality and usability on the go.
  6. Integration with VBS: Offers advanced extensibility by integrating with Oracle’s Visual Builder Studio (VBS), enabling businesses to customize applications to fit their unique needs.
  7. AI and ML Integration: Leverages artificial intelligence and machine learning to provide intelligent recommendations, personalized insights, smart search.

The traditional Oracle UI, while functional, often felt dated and complex, focusing on operational efficiency over user engagement. By contrast, the Redwood UI reimagines the user experience by intuitive designs, visualization-driven insights, and mobile adaptability create an interface that is not just a tool but a strategic enabler of productivity and engagement.

Oracle’s Next Step

Oracle has already released many Redwood & AI features and planning to release many other features in upcoming upgrades. Following is the summary on the same:

  1. Procurement – Oracle Healthcare Marketplace, Buyer Workbench, Gen AI (Summarize Supplier Attachment, Purchase Order note to approver) and many more
  2. Inventory and Cost Management – Mobile Shipping, Work Order Costing, RFID Inventory Tracking, Prebuilt integration and reconciliation with WMS/3PL, etc.
  3. Order Management – Expediting Orders at risk using Oracle digital assistant, Redwood page for order creation and mass action, AI predictive task and travel time.
  4. Manufacturing – Production Supervisor Workbench, Work Instruction Task, Kanban Management, Inspect using external Vision Systems.

Source: https://community.oracle.com/customerconnect/categories/planning

Transition into Oracle Redwood

The transition to Oracle Redwood UI requires careful planning and execution to ensure a smooth adoption. Enabling Redwood pages in Oracle Fusion involves activating specific features and configuring roles and permissions, which are essential for a seamless transition.

Enabling Redwood Pages:

  1. Opt-in Features and Profile Options

To enable Redwood pages, administrators must either enable the relevant Opt-in Features or enable profile options depending on the specific pages being transitioned. This process ensures that Redwood UI elements are available for use across Oracle Fusion applications. Once these features or options are enabled, users will need the appropriate duty roles or privileges to access the new Redwood pages. In such cases, custom roleswill have to be created to assign the necessary access permissions.

  1. Handling Personalization During Transition

A key consideration when moving to Redwood pages is that personalization made through the traditional Sandbox interface do not automatically migrate to Redwood. Therefore, any customizations made in the old UI need to be replicated in the Redwood UI using Visual Builder Studio (VBS). This can be challenging, as it can be difficult to track all the changes made through Sandbox. To assist with this, Oracle provides a tool (Redwood Personalization Helper Tool) that helps identify and list all modifications made on a page. This list can be used to assess whether the personalization can be re-created or improved through VBS, ensuring consistency and minimizing disruptions to workflows.

Key Considerations Before Transitioning to Redwood

  1. Pre-requisites Check: Before initiating the transition, ensure that all necessary user roles and access permissions are configured correctly in the test environment. This includes verifying that administrators have the right privileges to enable and manage Redwood features.
  2. Redwood Opt-in Features: Some Redwood features are irreversible once activated. It’s essential to communicate this clearly with stakeholders and conduct thorough testing in a test environment before enabling these features in the live system.
  3. Personalization Compatibility: Extract and document any existing personalization from the old UI. Assess if these customizations can be replicated or enhanced using VBS and determine if any adjustments or new configurations are necessary.
  4. Feature Availability Audit: Create a comprehensive list of features that are available in the traditional UI but may not yet be supported in the Redwood UI. This will help manage customer expectations and develop workarounds or alternatives for any missing features.
  5. Testing New Redwood Features: As part of the transition, test all new features introduced with Redwood to ensure they meet user requirements and do not disrupt existing workflows. It’s also crucial to gather user feedback during the pilot phase to identify any potential improvements or additional training needs.

Oracle AI capabilities

Oracle’s AI and Machine Learning capabilities are transforming business operations, driving smarter decision-making, enhanced efficiency, and proactive management across key functional areas. In Procurement & PLM, AI automates tasks like spend classification, supplier recommendations, while Generative AI streamlines the creation of negotiation cover pages and item descriptions. Similarly, there are various other AI capabilities across all modules which will help businesses moving from reactive to proactive operations, optimizing processes, and gaining a competitive edge through smarter, data-driven decision-making.

Oracle VBS

With VBS, Oracle empowers enterprises to innovate on their own terms. The platform enables businesses to extend Oracle Cloud applications or build entirely new functionalities, delivering tailor-made solutions with agility.

Core Capabilities:

  • Low-Code Application Development: Simplify app creation with drag-and-drop interfaces.
  • Integration with Oracle Cloud: Seamlessly extends functionality across HCM, SCM, and other Oracle systems.
  • Rule Automation: Custom business rules enhance app responsiveness to organizational needs.

Conclusion:

Oracle’s Redwood UI, integrated AI and ML capabilities, and Visual Builder Studio (VBS) together provide a transformative platform that empowers businesses to not only streamline their operations but also enhance user engagement and decision-making. The transition to Redwood UI, though strategic, requires careful planning and execution. By understanding the key considerations and leveraging tools like VBS, businesses can ensure a smooth migration, maintain the integrity of customizations, and unlock the full potential of these advanced technologies.

The Art of Selecting the Perfect ERP

As we are well-aware, it is a known fact that Enterprise Resource Planning (ERP) tools have helped businesses to streamline operations, improve efficiency, and drive growth. Hence Choosing and implementing a right ERP becomes a critical task.

However, with a wide range of ERP solutions available in the market, it’s essential to understand that one size does not fit all. Selecting the right ERP solution can be a challenging task, especially when considering the unique needs of different industries. From manufacturing to retail, finance to healthcare, each line of business has specific requirements that must be addressed by its ERP system.

Do any of these questions resonate with you?

  • Are you fully leveraging the capabilities of your current software?
  • Do you rely on multiple software applications to manage different business functions?
  • Is your ERP system becoming difficult to maintain?
  • Does your software seamlessly integrate with all operational areas of your business?

These are some of the primary & critical questions that a decision maker must think about before investing further time & Energy in choosing the ERP software. Let’s try to understand what current ERP software looks like and what our key considerations should be.

 

The Modern ERP Landscape: Key Needs and Trends

Cloud based accessibility (Going further Mobile accessibility)

  • As more and more business and business users start operating remotely, demand for Cloud based methodologies has increased drastically. Furthermore, they offer Scalability, Flexibility & can reduce infra cost as compared to traditional on-premises software.
  • Some ERP systems are even accessible via smartphones and tablets, allowing employees – the access to critical information and flexibility to perform tasks from anywhere.

Enhanced UI/UX (User Interface & User Experience)

  • Better UI/UX helps in reducing learning curves and improving tool adoption ratios. With the ERP tool operational amongst, wide range of employees with varying expertise, an “easy to navigate” ERP is needed of the hour.

Real – time reporting and analysis

  • Monitoring KPI, making agile decisions, customizable dashboards, predictive analysis, — these are some of the key needs of business that should be catered.

Modular Systems supporting easier Flexibility

  • A modular system refers to a design approach where a larger system is divided into modules. These modules, either individually or combined, help forming a complete system web.
  • Having a modular system in place helps scale business solutions and incorporating customizations.

Adaption of Emerging Technologies

  • A lot has been discussed about AI/ML and their endless capabilities. One would surely want to have new technologies easily embedded into ERP.
  • These would surely help in gaining predictive insights, automate business processes & improve operational efficiency.

Please do have a look at the insight below on how Generative AI is shaping the cloud ERP systems:

Generative AI in Action: Comparing Use-Cases Across Cloud ERP Systems

The Importance of Implementation Approach and Vendor Capabilities:

Selecting an ERP without considering the implementation process and the vendor’s capabilities can lead to mismatched solutions, cost overruns, and operational disruptions. When evaluating ERPs, include:

  • Implementation timelines & methodologies (for e.g.: Big bang, Phased or Parallel).
  • Vendor stability, industry reputation, and future-proofing capabilities.

By prioritizing these aspects, businesses can ensure the ERP system not only aligns with their current requirements but also supports long-term growth and innovation.

Uncovering the Root Causes of ERP Failure:

Whilst we have covered most of the aspects, let’s sneak-peek at common reasons observed so far for ERP failures. This may help in the strategic planning of the overall project.

Inadequate planning

  • Lack of clear goals/objectives can hinder the entire ERP implementation cycle. One needs to have an active track of what is the current need vs what is being implemented.

Poor Change management:

  • Adoption of newly implemented tools is one of the key reasons for failure. Business users should be clearly communicated about the benefits of the new system. Implementation programs should incorporate user training programs.

Customization vs Standardization

  • Every software has its unique strength, and this is crucial in leveraging standard features and helps in avoiding unnecessary customizations. Avoidable customizations can sometimes cause overhead maintenance activities. Use of standard features is well backed by ERP provider and any updates can help business stay ahead of themselves.

Data Migration – A well-known factor!!

  • Overlooking legacy data cleansing and integration challenges leads to inefficiencies. Hence there should be a strategy that has to be designed in order to have the source cleaned up first so that new data generated for migration is clean.

Inadequate Vendor Support

  • The program should be well designed to get the best vendor support throughout the implementation process. For e.g.: There must be dedicated team assigned in “hyper-care” phase for smooth transition. This helps in ironing out technicalities which have been ignorant so far!

Please refer below snapshot to understand top reasons for failures:

Source: https://www.researchgate.net/publication/337905839_ERP_issues_and_challenges_a_research_synthesis

 

To wrap it up, choosing the right ERP is not just a technical decision—it’s a strategic move that can unlock new levels of agility and innovation. By embracing the latest trends and ensuring seamless integration, businesses can turn their ERP system into a competitive advantage. The key lies in thoughtful implementation and staying ahead of potential challenges, making sure the system evolves with both your needs and the market. If you’re ready to explore how the right ERP system can transform your business, contact us for a personalized consultation.

The right ERP isn’t just a tool; it’s a catalyst for future success.

Which option—Accrue at Period End or Accrue at Receipt—works best for you?

A key policy decision during implementing Oracle Fusion for Receipt Accounting for Expense category PO lines is choosing between “Accrue at Receipt” or “Accrue at Period End”. In our Managed Service journey, we have seen many clients facing issues because of uninformed decisions regarding Accrue at Receipt or Period end resulting in piling up of expense accruals, inaccurate expense booking etc.

Making well-informed decisions is essential and relies on a thorough understanding of the business and expert guidance. A wrong decision here can impact the functioning of the business process and result in inaccurate financial reporting. For instance, a company misreporting just 3% on a $10 million expense budget could be presenting $300,000 in errors in a financial statement.

A wrong decision can impact the organization in following ways –

The key differences of these two Accrual concepts are as below –

  • Accrue at receipt (also known as perpetual accrual) – The Accounting entry for expense and accrual is recorded when you create Receipt in Oracle. When you create accounting for the invoice, the accrual is reversed, and the accounts payable liability is recorded.

For Inventory category PO Lines, “Accrue at Receipt” option is selected by default.

  • Accrue at period end – No accounting entry is made when a Receipt is created in Oracle for items or services and the expense is recorded only when the invoice is booked. There is no major dependency on receipt creation for booking the expense. We need to run the “Create Period End Accruals” process to create accrual journal entries for all uninvoiced receipts. The entries are automatically reversed in the next period.

Accounting entries in different scenarios:

 

Events Accrue at Receipt Accrue at Period End
PO Creation No Entry No Entry
Receipt Creation Receiving (Dr)

Accrual (Cr)

No Entry
Expense booking (Put Away) Expense (Dr)

Receiving (Cr)

No Entry
Invoice booking Accrual (Dr)

Liability (Cr)

Expense (Dr)

Liability (Cr)

Period End Accrual

(For Uninvoiced Receipts)

No Entry Expense (Dr)

Accrual (Cr)

 

Difference between Accrue at Receipt vs Period End:

 

Metrics Accrue at Receipt Accrue at Period End
Expense Accrual On Receipt Creation On Invoice Booking
Separate Accrual at month end Not Required At Month End for Uninvoiced Receipt
Inflow of Expense to Project On Receipt Accounting On Invoice Accounting
Inflow of Expense to Fixed Assets Possible on Receipt Accounting Only on Invoice Accounting
Accrual Write Off Required Not Required
Invoice Price Variance (Difference between Purchase & Invoice) Invoice Price Variance generated during invoice processing Charged directly to expense instead of Invoice Price Variance
Non-Recoverable Tax variance tracking in case of rate change Tax Variance generated during invoice processing Charged directly to tax instead of Tax Variance
Using Multi-Period Accounting (MPA) MPA not possible to be used MPA can be used for these lines
Reconciliation Report for Uninvoiced Receipt Accrual Reconciliation Report Uninvoiced Receipt Accrual Report
Budget release in case of Encumbrance accounting Funds released on Receipt creation Funds released on Invoice creation

 

In the Accrue at Receipt method, timely booking of receipts is crucial for recognizing expenses. If the organization lacks personnel to perform real-time receiving, it can disrupt the expense booking process. We have observed that organizations choosing the Accrue at Receipt option for expense items often face delays in expense recognition due to delays in creating receipts.

For example, one of the entities was following a Cost-Plus model for raising the invoices to customer from Projects Contract. But there was no dedicated user who would record the receipts resulting in inadequate costs being reported.

Key factors to consider before deciding Accrue at Receipt vs Accrue at Period End Option:

The decision needs to be taken based on the nature of the business processes and the different types of expenses. The following are the key parameters to be considered –

 

Metrics Accrue at Receipt Accrue at Period End
Company has requirement to book the expenses once goods/services are received in Oracle.

X

Company has business SOP in place for doing the receiving for all different type of goods/services.

X

Company has decentralized operations and services are received at different places. It is difficult to have users perform the receiving at different places.

X

 

 

Company does not have designated team/reasonable team size to perform the receiving within the system.

X

 

 

Company has requirement to accurately update Project Forecasts on monthly basis based on Project Cost.

X

Company has requirement of Fixed Assets to be capitalised based on accurate date placed in service i.e. receipt date.

X

 

Based on above considerations, the client should determine the business process that they need to follow considering available resources and then take a decision whether they want to go for Accrue at Receipt or Accrue at Period End.

Accrual Flexibility in Oracle – Receipt or Period End:

  1. For Expense category PO Lines, the client will have an option on the Manage Common Options for Payables and Procurement page to be set as Accrue at receipt or period end.
  2. However, the default value of Accrue at Receipt or Period end can be changed at the PO Line Schedule level based on specific requirement for that PO Line.

For example, if client has selected Accrue at receipt at the setup level but for a PO Line of Insurance expense, the user needs to have the multiperiod accounting to be created, then the user can change to Accrue at Period end for this PO Line.

Best Practices when using Period end accrual:

  1. At the end of accounting period, you must run “Create Uninvoiced Receipt Accrual” process after closing the Accounts Payable period and transferring all the Accounts Payable invoices to Cost Management, and before you close the General Ledger period.
  2. Run the Create Un invoiced Receipts Accruals process in the Report accrual run mode to review the entries before it gets posted. The report helps you to understand the details about the Uninvoiced purchase order receipts for which accruals will be created. After analysis of the report and making required updates, the process should be run in final mode.
  3. Auto Reversal of the receipt accrual entries should be set.

Best Practices when using Accrue at Receipt:

  1. In case of Accrue at Receipt, PO line should not have Invoice Match option as “Order” and Match Approval level as “2-way”. As in such case, the receipt creation might be missed and expense would be charged only if the receipt is booked, resulting in under-reporting of expenses.
  2. Accrual Reconciliation Report should be run on periodic basis and open entries should be analysed.
  3. Accrual Aging and Receiving Inspection account should be reconciled and analysed at regular intervals. Timely Accrual write-off should be done for the open Purchase orders where the Invoices are not received for the Receipts created or vice versa.