How aljolandaalhandhali/oracle-ebs works
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 Factorial Calculation · SYSDATE_Procedure.sql System Date Procedure · Factorial_Procedure.sql Factorial Procedure · Procedure_Function.sql Procedure and Function Examples
Components 18
SQL and PL/SQL
- Procedure and Function Examples
Procedure_Function.sql - Factorial Calculation
Factorial_Calculation.sql
Oracle Reports
- Report Registration Guide
Create_Report_Register_EBS.pdf - Parameterized Report Guide
Create_Report_Register_EBS_Parameters.pdf - Master-Detail Report Guide
Create_Report_Based_on_Master_Detail.pdf - Charts and Pivot Guide
BI_Publisher_Charts_Pivot_Conditional_Formatting.pdf
EBS Workflows
- System Date Procedure
SYSDATE_Procedure.sql - Factorial Procedure
Factorial_Procedure.sql - Department LOV Guide
Create_LOV_for_DEPTNO.pdf - Dependent Value Set Guide
Independent_Dependent_VALUE_SET.pdf - Department Lookup Guide
LOOKUP_FOR_DEPARTMENT.pdf - APSTAND Form Guide
Oracle_EBS_APSTAND_Master_Detail_Form.pdf
Other components
- Learner
- SQL Tool
- Oracle Database
- Oracle EBS
- FND_FILE
- DBMS_OUTPUT
Connections 19
- 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