Insights

Practical notes on JD Edwards, Oracle Database, AI for ERP systems and e-invoicing — the recipes and lessons we use on real projects.

E-invoicing

French e-invoicing: six weeks after go-live, what the field shows

Non-compliant flows, rejections that do not always come from the invoice, standards that keep changing, corrections through credit notes or corrective invoices: what the first weeks of the French reform show, and what to put in place.

Read the article
JD Edwards

JD Edwards AIS server tuning: timeouts, response size and orchestration performance

The AIS and HTML server settings to review when JD Edwards orchestrations, UX One or REST integrations slow down — with the Oracle Support notes behind each recommendation.

Read the article
JD EdwardsOracle

Set up a JD Edwards EnterpriseOne trial instance on Oracle Cloud (OCI)

Step by step: deploy the JD Edwards EnterpriseOne Trial Edition from the Oracle Cloud Marketplace — instance, shape, network, SSH keys and first login.

Read the article
Oracle

Oracle: find blocking sessions and locks

A diagnostic query that shows which Oracle session is blocking which — with database and OS user — and how to release the lock.

Read the article
Oracle

Oracle: gather optimizer statistics for a table or a schema

Two DBMS_STATS recipes to refresh optimizer statistics — on a single table after a large load, and on a whole schema in parallel — with what each parameter does.

Read the article
Oracle

Oracle: database size by tablespace, by schema, and fragmented space per table

Four queries to measure an Oracle database: total size, size per tablespace, size per schema, and the space lost to fragmentation in each table of a schema.

Read the article
Oracle

Oracle: transport a SQL profile from one database to another

Export a SQL profile from one Oracle database and import it into another with DBMS_SQLTUNE staging tables — for example from a test environment where the plan was fixed to production.

Read the article