Oracle Apps DBA stuff: web

<!DOCTYPE html>

<head>

<title>How to Investigate BNE Upload Issues in Oracle EBS 12.2 \u2014 Step-by-Step Guide</title>

<style>

:root {

--bg: #0d0f14;

--surface: #141720;

--border: #1e2230;

--accent: #f97316;

--accent2: #38bdf8;

--accent3: #a3e635;

--text: #e2e8f0;

--muted: #64748b;

--code-bg: #0a0c10;

}

* { margin: 0; padding: 0; box-sizing: border-box; }

body {

background: var(--bg);

color: var(--text);

font-family: 'DM Sans', sans-serif;

font-size: 16px;

line-height: 1.75;

}

/* \u2500\u2500 HERO \u2500\u2500 */

.hero {

background: linear-gradient(135deg, #0d0f14 0%, #111827 60%, #0f1a2e 100%);

border-bottom: 1px solid var(--border);

padding: 64px 24px 48px;

text-align: center;

position: relative;

overflow: hidden;

}

.hero::before {

content: '';

position: absolute;

inset: 0;

background: radial-gradient(ellipse 60% 50% at 50% 0%, rgba(249,115,22,0.12) 0%, transparent 70%);

pointer-events: none;

}

.hero-badge {

display: inline-block;

font-family: 'JetBrains Mono', monospace;

font-size: 11px;

letter-spacing: 2px;

text-transform: uppercase;

color: var(--accent);

border: 1px solid rgba(249,115,22,0.35);

border-radius: 4px;

padding: 4px 12px;

margin-bottom: 20px;

background: rgba(249,115,22,0.08);

}

.hero h1 {

font-family: 'Syne', sans-serif;

font-size: clamp(26px, 5vw, 46px);

font-weight: 800;

line-height: 1.15;

color: #fff;

max-width: 760px;

margin: 0 auto 18px;

}

.hero h1 span { color: var(--accent); }

.hero-meta {

font-family: 'JetBrains Mono', monospace;

font-size: 12px;

color: var(--muted);

display: flex;

justify-content: center;

gap: 24px;

flex-wrap: wrap;

margin-top: 16px;

}

.hero-meta span::before { content: '// '; color: var(--accent); }

/* \u2500\u2500 LAYOUT \u2500\u2500 */

.container {

max-width: 820px;

margin: 0 auto;

padding: 0 24px 80px;

}

/* \u2500\u2500 INTRO \u2500\u2500 */

.intro-box {

margin: 40px 0 32px;

background: var(--surface);

border: 1px solid var(--border);

border-left: 4px solid var(--accent);

border-radius: 8px;

padding: 24px 28px;

font-size: 15px;

color: #94a3b8;

line-height: 1.8;

}

.intro-box strong { color: var(--accent); }

/* \u2500\u2500 SECTION HEADERS \u2500\u2500 */

.step-header {

display: flex;

align-items: center;

gap: 14px;

margin: 48px 0 20px;

}

.step-num {

font-family: 'JetBrains Mono', monospace;

font-size: 11px;

font-weight: 600;

color: var(--bg);

background: var(--accent);

border-radius: 4px;

padding: 4px 10px;

letter-spacing: 1px;

white-space: nowrap;

flex-shrink: 0;

}

.step-title {

font-family: 'Syne', sans-serif;

font-size: 20px;

font-weight: 700;

color: #fff;

}

/* \u2500\u2500 PROSE \u2500\u2500 */

p { color: #94a3b8; margin-bottom: 14px; }

p strong { color: var(--text); }

/* \u2500\u2500 CODE BLOCKS \u2500\u2500 */

.code-wrap {

background: var(--code-bg);

border: 1px solid var(--border);

border-top: 2px solid var(--accent);

border-radius: 8px;

overflow: hidden;

margin: 18px 0 24px;

}

.code-label {

background: #0f1117;

border-bottom: 1px solid var(--border);

padding: 8px 16px;

font-family: 'JetBrains Mono', monospace;

font-size: 11px;

color: var(--accent);

letter-spacing: 1px;

text-transform: uppercase;

display: flex;

justify-content: space-between;

align-items: center;

}

.code-label .dots { display: flex; gap: 6px; }

.code-label .dots span {

width: 8px; height: 8px; border-radius: 50%;

}

.dot-r { background: #ef4444; }

.dot-y { background: #eab308; }

.dot-g { background: #22c55e; }

pre {

padding: 20px 20px;

font-family: 'JetBrains Mono', monospace;

font-size: 13px;

line-height: 1.7;

color: #c9d1d9;

overflow-x: auto;

white-space: pre;

}

/* SQL syntax coloring */

.kw { color: #38bdf8; } /* keywords */

.fn { color: #a3e635; } /* functions / objects */

.str { color: #fb923c; } /* strings */

.cm { color: #4b5563; font-style: italic; } /* comments */

.bd { color: #e879f9; } /* bind vars */

.hn { color: #fbbf24; } /* hints */

/* \u2500\u2500 DIVIDER \u2500\u2500 */

.divider {

border: none;

border-top: 1px solid var(--border);

margin: 10px 0;

}

/* \u2500\u2500 TABLE \u2500\u2500 */

.tbl-wrap {

overflow-x: auto;

border-radius: 8px;

border: 1px solid var(--border);

margin: 18px 0 28px;

}

table {

width: 100%;

border-collapse: collapse;

font-size: 14px;

}

thead tr {

background: #0f1117;

border-bottom: 1px solid var(--accent);

}

th {

font-family: 'JetBrains Mono', monospace;

font-size: 11px;

letter-spacing: 1px;

text-transform: uppercase;

color: var(--accent);

padding: 12px 16px;

text-align: left;

}

td {

padding: 11px 16px;

color: #94a3b8;

border-bottom: 1px solid var(--border);

vertical-align: top;

}

td:first-child { color: var(--text); font-weight: 500; }

td strong { color: var(--accent2); }

tr:last-child td { border-bottom: none; }

tr:nth-child(even) { background: rgba(255,255,255,0.02); }

/* \u2500\u2500 CALLOUT \u2500\u2500 */

.callout {

background: rgba(56,189,248,0.07);

border: 1px solid rgba(56,189,248,0.25);

border-radius: 8px;

padding: 16px 20px;

margin: 20px 0;

font-size: 14px;

color: #7dd3fc;

display: flex;

gap: 12px;

align-items: flex-start;

}

.callout .icon { font-size: 18px; flex-shrink: 0; margin-top: 1px; }

.callout.warn {

background: rgba(249,115,22,0.07);

border-color: rgba(249,115,22,0.25);

color: #fdba74;

}

/* \u2500\u2500 PILL LIST \u2500\u2500 */

.pill-list { display: flex; flex-wrap: wrap; gap: 8px; margin: 14px 0 24px; }

.pill {

font-family: 'JetBrains Mono', monospace;

font-size: 12px;

color: var(--accent3);

background: rgba(163,230,53,0.08);

border: 1px solid rgba(163,230,53,0.2);

border-radius: 4px;

padding: 4px 12px;

}

/* \u2500\u2500 FOOTER \u2500\u2500 */

.footer {

margin-top: 60px;

padding: 32px 24px;

border-top: 1px solid var(--border);

text-align: center;

font-family: 'JetBrains Mono', monospace;

font-size: 12px;

color: var(--muted);

}

.footer a { color: var(--accent); text-decoration: none; }

.tags { display: flex; justify-content: center; flex-wrap: wrap; gap: 8px; margin-top: 16px; }

.tag {

font-size: 11px;

color: var(--muted);

border: 1px solid var(--border);

border-radius: 3px;

padding: 3px 8px;

}

</style>

</head>

<body>

<div class="hero-badge">Oracle EBS 12.2 \u00b7 DBA Playbook</div>

<h1>Investigating <span>BNE Upload Issues</span><br/>in Oracle EBS 12.2 \u2014 Step by Step</h1>

<span>Oracle Apps DBA</span>

<span>EBS 12.2.x \u00b7 Solaris</span>

<span>WebADI / BNE</span>

<span>April 2026</span>

</div>

<strong>Scenario:</strong> A user reports that their BNE (Browser-Native Extension / Web ADI) upload is failing or hanging in Oracle EBS 12.2. You have a DMS trace file open on the app server showing heavy SQL activity across <strong>FND_PROFILE_OPTIONS</strong>, <strong>WF_NOTIFICATIONS</strong>, and <strong>FND_GRANTS</strong>. This guide walks you through a structured investigation to identify the root cause \u2014 and the specific user and file involved.

</div>

<span class="pill">WebADI</span>

<span class="pill">FND_PROFILE</span>

<span class="pill">WF_NOTIFICATIONS</span>

<span class="pill">FND_GRANTS</span>

<span class="pill">v$session</span>

</div>

<div class="step-num">CONTEXT</div>

<div class="step-title">What the Trace File Tells Us</div>

</div>

<p>Before jumping into fixes, read the trace. The <code>dms_metrics88_i59.txt</code> trace filename encodes the <strong>OS process ID (88)</strong> and <strong>DB instance number (59)</strong>. The SQL inside reveals three areas of activity during the BNE upload lifecycle:</p>

<table>

<thead>

<tr><th>SQL Activity Seen</th><th>What It Means</th><th>Risk</th></tr>

</thead>

<tbody>

<tr><td>FND_PROFILE_OPTIONS with bind :1\u2013:8</td><td>Profile value lookups at multiple hierarchy levels (Site \u2192 Resp \u2192 User)</td><td>Cache miss = slow upload init</td></tr>

<tr><td>WF_NOTIFICATIONS with N1 and N6 index hints</td><td>Workflow notification checks \u2014 approval routing or audit</td><td>Stalled WF engine = upload hang</td></tr>

<tr><td>FND_GRANTS with instance_type = 'GLOBAL'</td><td>Security privilege check for the uploading user</td><td>Missing grant = silent failure</td></tr>

</tbody>

</table>

</div>

<div class="step-title">Identify the Uploading User from the Trace Session</div>

</div>

<p>The trace process ID gives us the starting point. Run this on the <strong>CORP DB</strong> to match the OS process to a database session and extract the Oracle username:</p>

<span>SQL \u2014 v$session lookup</span>

</div>

<pre><span class="cm">-- dms_metrics88_i59 \u2192 process 88, instance 59</span>

<span class="kw">SELECT</span> s.sid,

s.serial#,

s.username,

s.osuser,

s.module,

s.action,

s.client_info,

s.logon_time,

s.status

<span class="kw">FROM</span> <span class="fn">v$session</span> s

<span class="kw">WHERE</span> s.process = <span class="str">'88'</span> <span class="cm">-- OS process from trace filename</span>

<span class="kw">ORDER BY</span> s.logon_time <span class="kw">DESC</span>;</pre>

</div>

<div>The <strong>username</strong> column gives the Oracle DB user. Cross-check with <strong>fnd_user</strong> using <code>WHERE oracle_username = s.username</code> to get the EBS application username and employee name.</div>

</div>

<div class="step-title">Identify the File Being Uploaded</div>

</div>

<p>BNE stores upload metadata in <strong>BNE_INTERFACES_B</strong>. Query this joined with FND_USER to get the filename and which user triggered it:</p>

<span>SQL \u2014 BNE upload file lookup</span>

</div>

<pre><span class="kw">SELECT</span> bi.interface_code,

bi.upload_filename,

bi.upload_date,

bi.created_by,

fu.user_name,

bi.upload_data

<span class="kw">FROM</span> <span class="fn">bne_interfaces_b</span> bi

<span class="kw">JOIN</span> <span class="fn">fnd_user</span> fu <span class="kw">ON</span> fu.user_id = bi.created_by

<span class="kw">WHERE</span> bi.upload_date > <span class="fn">SYSDATE</span> - <span class="bd">1</span>/<span class="bd">24</span> <span class="cm">-- last 1 hour</span>

<span class="kw">ORDER BY</span> bi.upload_date <span class="kw">DESC</span>;</pre>

</div>

<div class="step-title">Check FND_LOG for BNE Error Messages</div>

</div>

<p>EBS 12.2 logs BNE framework errors into <strong>FND_LOG_MESSAGES</strong>. This is the fastest way to see the exact failure reason \u2014 Java exceptions, profile errors, or security violations:</p>

<span>SQL \u2014 FND_LOG_MESSAGES for BNE</span>

</div>

<pre><span class="kw">SELECT</span> fl.log_sequence,

fl.timestamp,

fl.encoded_message

<span class="kw">FROM</span> <span class="fn">fnd_log_messages</span> fl

<span class="kw">WHERE</span> fl.module <span class="kw">LIKE</span> <span class="str">'%bne%'</span>

<span class="kw">AND</span> fl.timestamp > <span class="fn">SYSDATE</span> - <span class="bd">1</span>/<span class="bd">24</span>

<span class="kw">ORDER BY</span> fl.log_sequence <span class="kw">DESC</span>

<span class="fn">FETCH FIRST</span> <span class="bd">50</span> <span class="fn">ROWS ONLY</span>;</pre>

</div>

<div class="step-title">Check if Workflow Engine is the Culprit</div>

</div>

<p>The trace showed two WF_NOTIFICATIONS queries with different index hints (<code>N1</code> vs <code>N6</code>). If the Workflow background engine is stalled, BNE uploads that trigger notifications will hang. Check for open notifications and FNDWFBG status:</p>

<span>SQL \u2014 Open WF Notifications check</span>

</div>

<pre><span class="kw">SELECT</span> wn.notification_id,

wn.status,

wn.recipient_role,

wn.message_name,

wn.begin_date,

wn.end_date

<span class="kw">FROM</span> <span class="fn">wf_notifications</span> wn

<span class="kw">WHERE</span> wn.begin_date > <span class="fn">SYSDATE</span> - <span class="bd">1</span>

<span class="kw">AND</span> wn.status = <span class="str">'OPEN'</span>

<span class="kw">ORDER BY</span> wn.begin_date <span class="kw">DESC</span>;</pre>

</div>

<span>SQL \u2014 Check FNDWFBG concurrent process</span>

</div>

<pre><span class="kw">SELECT</span> fcr.request_id,

fcr.phase_code,

fcr.status_code,

fcr.actual_start_date,

fcr.actual_completion_date

<span class="kw">FROM</span> <span class="fn">fnd_concurrent_requests</span> fcr

<span class="kw">JOIN</span> <span class="fn">fnd_concurrent_programs_vl</span> fcp

<span class="kw">ON</span> fcp.concurrent_program_id = fcr.concurrent_program_id

<span class="kw">WHERE</span> fcp.concurrent_program_name = <span class="str">'FNDWFBG'</span>

<span class="kw">AND</span> fcr.actual_start_date > <span class="fn">SYSDATE</span> - <span class="bd">1</span>

<span class="kw">ORDER BY</span> fcr.actual_start_date <span class="kw">DESC</span>;</pre>

</div>

<div class="step-title">Verify User's BNE Security Grants</div>

</div>

<p>The trace shows a <strong>FND_GRANTS</strong> query with <code>instance_type = 'GLOBAL'</code> and <code>object_id = -1</code>. This is the security check for BNE access. If the user lacks the correct grant, the upload fails silently. Verify:</p>

<span>SQL \u2014 FND_GRANTS BNE security check</span>

</div>

<pre><span class="kw">SELECT</span> fg.grantee_key,

fg.menu_id,

fg.start_date,

fg.end_date,

fg.instance_type,

fm.menu_name

<span class="kw">FROM</span> <span class="fn">fnd_grants</span> fg

<span class="kw">JOIN</span> <span class="fn">fnd_menus</span> fm <span class="kw">ON</span> fm.menu_id = fg.menu_id

<span class="kw">WHERE</span> fg.instance_type = <span class="str">'GLOBAL'</span>

<span class="kw">AND</span> fg.object_id = <span class="bd">-1</span>

<span class="kw">AND</span> fg.grantee_key = <span class="str">'<USERNAME>'</span> <span class="cm">-- replace with EBS username</span>

<span class="kw">AND</span> (fg.end_date <span class="kw">IS NULL</span> <span class="kw">OR</span> fg.end_date > <span class="fn">SYSDATE</span>);</pre>

</div>

<div>If no rows returned for the user \u2014 or the menu_name does not include a BNE-related menu \u2014 the responsibility needs to be reapplied or FNDLOAD re-run to restore the grant.</div>

</div>

<div class="step-title">Check BNE Profile Options</div>

</div>

<p>BNE behaviour is controlled by specific profile options. Verify these are set correctly at the Site or Responsibility level:</p>

<span>SQL \u2014 BNE critical profile options</span>

</div>

<pre><span class="kw">SELECT</span> fpov.profile_option_name,

fpov.profile_option_value,

<span class="kw">DECODE</span>(fpov.level_id,

<span class="bd">10001</span>, <span class="str">'SITE'</span>,

<span class="bd">10002</span>, <span class="str">'APPLICATION'</span>,

<span class="bd">10003</span>, <span class="str">'RESPONSIBILITY'</span>,

<span class="bd">10004</span>, <span class="str">'USER'</span>) level_name

<span class="kw">FROM</span> <span class="fn">fnd_profile_options</span> fpo

<span class="kw">JOIN</span> <span class="fn">fnd_profile_option_values</span> fpov

<span class="kw">ON</span> fpov.profile_option_id = fpo.profile_option_id

<span class="kw">WHERE</span> fpo.profile_option_name <span class="kw">IN</span> (

<span class="str">'BNE_ALLOW_NO_SECURITY_RULE'</span>,

<span class="str">'BNE_MAPPING_SCHEMA'</span>,

<span class="str">'FND_CORPORATE_BRANDING_IMAGE'</span>

)

<span class="kw">AND</span> fpov.level_value_application_id <span class="kw">IS NOT NULL</span>

<span class="kw">ORDER BY</span> <span class="bd">1</span>, fpov.level_id;</pre>

</div>

<div class="step-title">Check for Invalid BNE Objects</div>

</div>

<p>Any invalid BNE package or view in the DB will cause upload failures without a clear user-visible error. Always run this early:</p>

<span>SQL \u2014 Invalid BNE DB objects</span>

</div>

<pre><span class="kw">SELECT</span> object_name,

object_type,

status,

last_ddl_time

<span class="kw">FROM</span> <span class="fn">dba_objects</span>

<span class="kw">WHERE</span> object_name <span class="kw">LIKE</span> <span class="str">'BNE%'</span>

<span class="kw">AND</span> status = <span class="str">'INVALID'</span>

<span class="kw">ORDER BY</span> object_type, object_name;</pre>

</div>

<p>If invalids are found, recompile:</p>

<span>SQL \u2014 Recompile invalid BNE objects</span>

</div>

<pre><span class="kw">BEGIN</span>

<span class="fn">dbms_utility.compile_schema</span>(

schema => <span class="str">'APPS'</span>,

compile_all => <span class="kw">FALSE</span>

);

<span class="kw">END</span>;

/</pre>

</div>

<div class="step-title">Check

Oracle Apps DBA stuff

Wednesday, April 8, 2026

web

No comments:

Post a Comment

Search This Blog

Blog Archive