Two developers designing the workflow of a custom application

Oracle APEX · Cloud Native Applications Expertise

That critical Excel file can become an application inside Oracle

Oracle's development platform. We use it to build extensions and applications connected to your ERP's real data.

At CETERiS we develop with Oracle APEX, backed by Oracle's Cloud Native Applications Expertise, and we run our own internal system on this platform.

Illustration of interconnected systems

What we use it for

Four things we build with APEX

Migrating the spreadsheet that holds a process together

Every company has one: the macro-filled file only one person understands and nobody dares touch.

Show more

APEX turns it into an application with users, permissions, history, and backup, connected to your ERP data.

Mexico-specific tax requirements

When regulation demands controls specific to your operation, such as validating suppliers under Article 69-B of the Federal Tax Code (blacklisted suppliers) before invoicing, we build them at CETERiS, connected to the Oracle standard without modifying it.

Extending the ERP without compromising it

When you need a screen, an approval flow, or a report the standard product doesn't provide, APEX connects as a satellite instead of a customization that later complicates updates.

Training your team

If you'd rather build in-house, we train your people.

Show more

We think it's the healthiest outcome: you stop depending on a vendor, and we focus on higher-level problems.

Two real cases

What this looks like in practice

Checking the SAT blacklists before invoicing

If you invoice a company that has been blocked for a tax issue, you end up caught in the same problem. It's a Mexican tax requirement (the SAT is Mexico's tax authority) that we build into the workflow as our own add-on.

  • When a customer or supplier is entered, the system queries the SAT
  • It returns a yes or a no before the record moves forward
  • The control lives inside the workflow, not in a separate manual review
Printed reports and charts on a desk, under review

Classifying travel expenses by cost center

One client booked 80% of its travel through an agency, which sent a single consolidated invoice with the breakdown. What they needed was to know which cost center each expense belonged to: the plant manager's travel is not the same as sales'.

  • The development reads the document and classifies it
  • It allocates each line item inside the ERP
  • Accounts payable sees the destination of each expense without entering it by hand
Laptop showing financial reports next to printed documents

An honest note

We are not an APEX application factory, and that is not what we aim to sell. We use APEX when it is the right tool for a problem in your Oracle ERP. If what you need is a business application unrelated to Oracle, we are not your vendor, and we will tell you so on the first call.

APEX versus a standalone development

The useful question isn't whether something can be coded, but what it will cost you to maintain it three years from now.

  • APEX runs inside the Oracle ecosystem: on EBS it uses the database you already have, and on Fusion Cloud ERP it relies on an Autonomous Database on OCI, which we size during the assessment.
  • It connects to the ERP's real data, not to a copy you have to keep in sync
  • It inherits the security and user model you already have
  • It doesn't force you to customize the standard product, so updates keep coming in
  • A change doesn't require a full development cycle
  • Your team can learn to maintain it, and we train them

Frequently asked questions

Does APEX carry an additional license cost?

APEX has no license cost of its own, since it is part of the Oracle database. On EBS it is normally already available; on Fusion Cloud ERP it requires an Autonomous Database on OCI, which is purchased separately and which we size with you before building.

Do we need programmers to maintain it?

Fewer than you might think: APEX is low-code, and much of the maintenance can be handled by someone on the functional side. That's why we offer training, not just development.

Are you going to customize our ERP?

That's exactly the opposite of the idea. APEX connects as a satellite rather than modifying the standard product, so Oracle's quarterly updates keep coming in without conflict.

Do you teach APEX courses?

We train a company's team as part of a project, so they can maintain what we build. We don't sell open enrollment training or certifications.

Where do we start?

Tell us which process is being held together by a spreadsheet, or what your ERP is missing. From that we can tell you whether APEX is the answer, and if it isn't, we'll tell you that too.

Which of your processes depends on an Excel file today?

If the answer makes you uncomfortable, it's a good first conversation.

Let's talk about your case

The first conversation is about understanding where you are, not about quoting.

Phone
+52 (55) 5256 4220
Offices
State of Mexico and Querétaro
Coverage
Mexico, the United States, and the rest of the Americas

Contact us

By submitting your information you accept our privacy notice.