# aljolandaalhandhali/oracle-ebs architecture

> Architecture diagram of the GitHub repository aljolandaalhandhali/oracle-ebs, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-25). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/aljolandaalhandhali/oracle-ebs
- Repository: https://github.com/aljolandaalhandhali/oracle-ebs

## Overview

This repository is a collection of Oracle EBS, Oracle Reports, SQL, and PL/SQL training examples—not a single application. Its main hands-on workflow is to run a SQL script in a database tool, then view output through DBMS_OUTPUT or, for EBS concurrent-program procedures, FND_FILE in an EBS context. The PDFs provide separate report, form, and configuration walkthroughs. Relationships below follow the README and filenames; source excerpts were unavailable, so internal implementation links are omitted.

Main entry points: [`Factorial_Calculation.sql`](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Factorial_Calculation.sql) (Factorial Calculation), [`SYSDATE_Procedure.sql`](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/SYSDATE_Procedure.sql) (System Date Procedure), [`Factorial_Procedure.sql`](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Factorial_Procedure.sql) (Factorial Procedure), [`Procedure_Function.sql`](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Procedure_Function.sql) (Procedure and Function Examples)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_plsql["SQL and PL/SQL"]
  node_procedure_function["Procedure and Function Examples"]
  node_factorial_calc["Factorial Calculation"]
end

subgraph group_reports["Oracle Reports"]
  node_report_register["Report Registration Guide"]
  node_report_parameters["Parameterized Report Guide"]
  node_master_detail["Master-Detail Report Guide"]
  node_charts_pivot["Charts and Pivot Guide"]
end

subgraph group_ebs["EBS Workflows"]
  node_sysdate_proc["System Date Procedure"]
  node_factorial_proc["Factorial Procedure"]
  node_lov_dept["Department LOV Guide"]
  node_value_set["Dependent Value Set Guide"]
  node_department_lookup["Department Lookup Guide"]
  node_apstand_form["APSTAND Form Guide"]
end

node_learner(("Learner"))
node_sql_tool["SQL Tool"]
node_oracle_db[("Oracle Database")]
node_ebs_env["Oracle EBS"]
node_fnd_file["FND_FILE"]
node_dbms_output["DBMS_OUTPUT"]

node_learner -->|"runs scripts in"| node_sql_tool
node_sql_tool -->|"executes against"| node_oracle_db
node_learner -->|"studies"| node_procedure_function
node_learner -->|"runs"| node_factorial_calc
node_learner -->|"runs"| node_sysdate_proc
node_learner -->|"runs"| node_factorial_proc
node_factorial_calc -->|"prints through"| node_dbms_output
node_factorial_calc -->|"prompts via"| node_sql_tool
node_sysdate_proc -->|"writes through"| node_fnd_file
node_factorial_proc -->|"writes through"| node_fnd_file
node_learner -->|"registers and runs in"| node_ebs_env
node_learner -->|"follows"| node_report_register
node_learner -->|"follows"| node_report_parameters
node_learner -->|"studies"| node_master_detail
node_learner -->|"studies"| node_charts_pivot
node_learner -->|"studies"| node_lov_dept
node_learner -->|"studies"| node_value_set
node_learner -->|"studies"| node_department_lookup
node_learner -->|"studies"| node_apstand_form

click node_procedure_function "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Procedure_Function.sql"
click node_factorial_calc "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Factorial_Calculation.sql"
click node_sysdate_proc "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/SYSDATE_Procedure.sql"
click node_factorial_proc "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Factorial_Procedure.sql"
click node_report_register "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_Report_Register_EBS.pdf"
click node_report_parameters "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_Report_Register_EBS_Parameters.pdf"
click node_master_detail "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_Report_Based_on_Master_Detail.pdf"
click node_charts_pivot "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/BI_Publisher_Charts_Pivot_Conditional_Formatting.pdf"
click node_lov_dept "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_LOV_for_DEPTNO.pdf"
click node_value_set "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Independent_Dependent_VALUE_SET.pdf"
click node_department_lookup "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/LOOKUP_FOR_DEPARTMENT.pdf"
click node_apstand_form "https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Oracle_EBS_APSTAND_Master_Detail_Form.pdf"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_procedure_function,node_factorial_calc toneBlue
class node_report_register,node_report_parameters,node_master_detail,node_charts_pivot,node_oracle_db toneAmber
class node_sysdate_proc,node_factorial_proc,node_lov_dept,node_value_set,node_department_lookup,node_apstand_form toneMint
class node_learner,node_sql_tool,node_ebs_env,node_fnd_file,node_dbms_output toneIndigo
```

## Components

### SQL and PL/SQL

- [Procedure and Function Examples](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Procedure_Function.sql): `Procedure_Function.sql`
- [Factorial Calculation](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Factorial_Calculation.sql): `Factorial_Calculation.sql`

### Oracle Reports

- [Report Registration Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_Report_Register_EBS.pdf): `Create_Report_Register_EBS.pdf`
- [Parameterized Report Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_Report_Register_EBS_Parameters.pdf): `Create_Report_Register_EBS_Parameters.pdf`
- [Master-Detail Report Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_Report_Based_on_Master_Detail.pdf): `Create_Report_Based_on_Master_Detail.pdf`
- [Charts and Pivot Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/BI_Publisher_Charts_Pivot_Conditional_Formatting.pdf): `BI_Publisher_Charts_Pivot_Conditional_Formatting.pdf`

### EBS Workflows

- [System Date Procedure](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/SYSDATE_Procedure.sql): `SYSDATE_Procedure.sql`
- [Factorial Procedure](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Factorial_Procedure.sql): `Factorial_Procedure.sql`
- [Department LOV Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Create_LOV_for_DEPTNO.pdf): `Create_LOV_for_DEPTNO.pdf`
- [Dependent Value Set Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Independent_Dependent_VALUE_SET.pdf): `Independent_Dependent_VALUE_SET.pdf`
- [Department Lookup Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/LOOKUP_FOR_DEPARTMENT.pdf): `LOOKUP_FOR_DEPARTMENT.pdf`
- [APSTAND Form Guide](https://github.com/aljolandaalhandhali/oracle-ebs/blob/main/Oracle_EBS_APSTAND_Master_Detail_Form.pdf): `Oracle_EBS_APSTAND_Master_Detail_Form.pdf`

### Other components

- **Learner**
- **SQL Tool**
- **Oracle Database**
- **Oracle EBS**
- **FND_FILE**
- **DBMS_OUTPUT**

## Connections

- Learner → SQL Tool: runs scripts in
- SQL Tool → Oracle Database: executes against
- Learner → Procedure and Function Examples: studies
- Learner → Factorial Calculation: runs
- Learner → System Date Procedure: runs
- Learner → Factorial Procedure: runs
- Factorial Calculation → DBMS_OUTPUT: prints through
- Factorial Calculation → SQL Tool: prompts via
- System Date Procedure → FND_FILE: writes through
- Factorial Procedure → FND_FILE: writes through
- Learner → Oracle EBS: registers and runs in
- Learner → Report Registration Guide: follows
- Learner → Parameterized Report Guide: follows
- Learner → Master-Detail Report Guide: studies
- Learner → Charts and Pivot Guide: studies
- Learner → Department LOV Guide: studies
- Learner → Dependent Value Set Guide: studies
- Learner → Department Lookup Guide: studies
- Learner → APSTAND Form Guide: studies