Oracle EBS Profile Option Change Log Worksheet
Profile options quietly control how EBS behaves, and they are rarely tracked well. After a clone or an upgrade, someone always asks why a setting differs between TEST and PROD. This log gives you a simple, exportable record of who changed what, at which level and why.
| Change date | Profile option (user name) | Level | Level value | Old value | New value | Instance | Change ticket | Changed by | Approved by | Reason | |
|---|---|---|---|---|---|---|---|---|---|---|---|
Profile values are stored in FND_PROFILE_OPTION_VALUES against FND_PROFILE_OPTIONS. Use this log together with the Profile Options report or a SQL extract from your own instance, and verify the profile option names against your release.
Compare EBS settings across instances
Optional walkthrough of querying configuration across DEV, TEST and PROD from one read-only interface.
Optional. The tool and every export work without this. No spam.
How to use the log
Add one row per change. Record the user-visible profile option name, the level where the value was set and the level value, such as a responsibility name or user name. Always capture the old value so a rollback is possible. Export to Excel or CSV for audits, or paste the rows into your change ticket. Keep the log per environment or use the instance column to filter.
Why profile levels matter
A profile option can be set at several levels and the most specific wins at runtime. In the usual order, user overrides responsibility, which overrides application, which overrides site. Some options also support server or organization levels. A value that looks correct at site level may be overridden somewhere you did not check, so the level and level value columns are the most important fields in this log.
- Always log the level and the exact level value
- Treat site level changes as high impact
- Re-check profile values after every clone
- Note seeded defaults you changed, so upgrades can be reviewed
Using the log after a clone or upgrade
Cloning copies profile values from the source, and Oracle's clone tooling resets some, such as URLs and node related values. Compare your log with the target instance to see which environment specific values must be reapplied. Before an upgrade, the log also tells you which seeded options were customised, which is a short list worth reviewing in the release notes.
Frequently Asked Questions
Where are Oracle EBS profile option values stored?
Definitions sit in FND_PROFILE_OPTIONS and the values at each level sit in FND_PROFILE_OPTION_VALUES. The System Profile Values form shows them in the application. Table details can vary a little by version, so verify in your instance.
Which profile level wins in Oracle EBS?
The most specific level that has a value is used. In the usual hierarchy user is more specific than responsibility, then application, then site. Some profile options may also be set at server or organization level.
Does EBS audit profile option changes automatically?
The tables hold who last updated a value and when, but not a full history of old values. Many sites add database auditing or keep a manual log like this one to preserve the old value and the reason.
Should profile options be changed directly in production?
Prefer a controlled change: test in a lower instance, log the change, get approval, then apply it in production. Some profile values can be migrated with FNDLOAD, others are set by hand and need documentation.
If you want an easier way to answer configuration questions across several EBS instances, we can show a read-only, query-visible approach. No obligation.
Related Tools
Oracle EBS Instance Clone Request Template
A clone request form for EBS refreshes: source and target, backup point, data scrambling, post-clone configuration and sign-off.
OracleOracle EBS Custom Code Inventory Worksheet
Catalog reports, interfaces, conversions, extensions and forms with a disposition and effort estimate so you can size an EBS upgrade or retirement.
OracleOracle EBS User Access Review Template
A periodic access review record for EBS users and responsibilities, with scope, evidence, exceptions and reviewer sign-off.
OracleOracle EBS Concurrent Program Registration Request Template
A request form that captures everything an EBS developer needs to register a custom concurrent program: executable, execution method, parameters, request group and incompatibilities.
More Oracle tools
See all- Oracle EBS Inventory Tables Reference
- Oracle EBS WIP Tables Reference
- Oracle EBS Cycle Count Workload Calculator
- Oracle EBS Discrete Manufacturing Go-Live Checklist
- Oracle EBS Inventory Accuracy Readiness Assessment
- Oracle EBS Concurrent Request Phase and Status Reference
- Oracle EBS Responsibility Design Worksheet
- Oracle EBS GL Period Close Checklist
- Oracle EBS AP Invoice Interface Template
New to Oracle E-Business Suite? Start with the Oracle E-Business Suite guide and toolkit, or plan with Oracle EBS Roadmap Planner, Training Path Builder, ERP Certification Study Planner.
Keep exploring
Free tools
- Oracle EBS Profile Options ReferenceA searchable lookup of the profile options EBS administrators change most: sign-on security, concurrent processing, multi-org, logging and session settings.
- Oracle EBS Engineering Change Order Request TemplateFill-in change request that captures what changes, which BOMs and routings are affected, effectivity, and approval signatures before you create the ECO in Oracle Engineering.
- Oracle EBS Item Cost Update Request FormFill-in form to request and approve a standard cost change with reason, impact and sign-off lines for the audit file.
ERP fixes and how-tos
- SQL query to find profile option values by level in Oracle EBSSQL to list Oracle EBS profile option values at site, application, responsibility and user level using FND_PROFILE_OPTIONS and FND_PROFILE_OPTION_VALUES, with level IDs.
- Organization Structure in Oracle EBS: Ledger, Legal Entity, Operating Unit, Inventory OrgHow Oracle EBS organizes ledgers, legal entities, operating units and inventory organizations, how security fits, and how to mask data in non-production.
- Cost profile in Oracle Fusion: cost organization, cost book and manufacturing costingHow cost organizations, cost books and cost profiles fit together in Oracle Fusion Cost Management, and how to set up manufacturing costing step by step.
Runs with your ERP
- Esker Order Management and Oracle E-Business SuiteHow Esker captures customer POs from email, fax and PDF and creates sales orders in Oracle EBS: integration, data flows, setup, pitfalls and a private AI layer.
- Cloud Inventory (DSI) with Oracle E-Business Suite: Mobile Barcode InventoryCloud Inventory, formerly DSI, adds offline mobile barcode inventory to Oracle E-Business Suite and JD Edwards. Data flows, setup steps, pitfalls and AI notes.
- BarTender and Oracle E-Business Suite: Label Printing from OracleHow BarTender prints labels from Oracle EBS using Oracle XML print requests and Integration Builder: methods, data flows, setup steps, pitfalls and AI help.
AI on your ERP
- AI for Oracle E-Business Suite, Without Leaving On-PremHosting Oracle EBS 12.2 on-prem or in a private cloud? Add a private LLM over concurrent programs, interface tables and AP/PO data without moving to Fusion.
- AI for Oracle EBS in Industrial Manufacturing: WIP, MRP, and BOM Questions Answered DirectlyAI for Oracle E-Business Suite in industrial manufacturing: WIP jobs, BOMs, MRP, inventory and purchasing answered in plain English, private and read-only.
Integrations
- How to use ChatGPT with Oracle E-Business SuiteUsing ChatGPT with Oracle E-Business Suite: export vs live access, custom GPT actions over ISG REST, enterprise data controls and when to keep data on-prem.
- How to connect Claude to Oracle E-Business SuiteConnect Claude to Oracle E-Business Suite via MCP, the Anthropic API, AWS Bedrock or Vertex, and know when an on-prem open-weight model is the better fit.