Skip to content

Latest commit

 

History

History

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 
 
 
 
 

README.md

layout default
title FND Concurrent Program Incompatibilities | Oracle EBS SQL Report
description Concurrent Program Incompatibilities – Oracle E-Business Suite SQL report
keywords Oracle EBS, Oracle E-Business Suite, SQL report, Blitz Report, Enginatics, FND, Concurrent, Program, Incompatibilities, fnd_concurrent_program_serial, fnd_concurrent_programs_vl, fnd_application_vl
permalink /FND%20Concurrent%20Program%20Incompatibilities/

FND Concurrent Program Incompatibilities – Oracle EBS SQL Report

Oracle E-Business Suite SQL report from the Enginatics Library powered by Blitz Report™.

Overview

Concurrent Program Incompatibilities

Report Parameters

Concurrent Program Name, Concurrent Program Short Name, Application Name

Oracle EBS Tables Used

fnd_concurrent_program_serial, fnd_concurrent_programs_vl, fnd_application_vl

Report Categories

Enginatics

Related Reports

FND Concurrent Requests 11i, FND Concurrent Requests, FND Concurrent Request Conflicts, FND Request Groups, FND Concurrent Programs and Executables, Blitz Report RDF Import Validation, XDO Publisher Data Definitions, FND Flex Value Sets, Usages and Values, ECC Admin - Concurrent Programs

Running This SQL Without Blitz Report

Some Oracle EBS SQL reports in this library require functions from the utility package xxen_util. Install it before running the SQL directly against your Oracle EBS database.

Download & Import Options

Resource Link
Excel Example Output FND Concurrent Program Incompatibilities 27-Jan-2019 115110.xlsx
Blitz Report™ XML Import FND_Concurrent_Program_Incompatibilities.xml
Full SQL on Enginatics www.enginatics.com/reports/fnd-concurrent-program-incompatibilities/

Executive Summary

The FND Concurrent Program Incompatibilities report documents the exclusion rules defined between concurrent programs. It ensures that conflicting jobs (e.g., two programs updating the same table) do not run simultaneously.

Business Challenge

  • Data Integrity: Preventing race conditions where two programs try to modify the same data at the same time.
  • Performance Protection: Ensuring that resource-intensive programs do not run in parallel.
  • Setup Validation: Verifying that necessary incompatibilities are correctly defined after a new module implementation.

The Solution

This Blitz Report lists all defined incompatibilities:

  • Conflict Mapping: Shows Program A and Program B, and the scope of the incompatibility (Global or Domain).
  • Scope Clarity: Identifies if the incompatibility applies to the entire system or just within the same argument set.
  • Bi-Directional Check: Helps verify that the rule is effective in both directions if required.

Technical Architecture

The report queries FND_CONCURRENT_PROGRAM_SERIAL, which stores the incompatibility rules. It joins FND_CONCURRENT_PROGRAMS twice (once for the running program, once for the incompatible program) to resolve names.

Parameters & Filtering

  • Program Name: Search for a specific program to see what it is incompatible with.
  • Application: Filter by module.

Performance & Optimization

  • Static Data: This is a configuration report and runs instantly.

FAQ

  • Q: What is a "Global" incompatibility?
    • A: It means the two programs can never run at the same time, regardless of who runs them or with what parameters.
  • Q: Can I set incompatibilities here?
    • A: No, this is a reporting tool. Incompatibilities are defined in the "Concurrent Programs" setup form.

Useful Links

© 2026 Enginatics