Oracle Fusion Technical – BIP and PL/SQL
Technical Oracle Fusion training across SQL, P2P/O2C database tables, BI Publisher reporting and PL/SQL.
What This Course Covers
Technical Oracle Fusion training across SQL, P2P/O2C database tables, BI Publisher reporting and PL/SQL.
Who Should Attend
Contact Tech Arryaan for audience guidance based on your current experience and the role or technology path you want to pursue.
Prerequisites
Contact our team for prerequisite guidance based on your current experience. Our team can help you choose a suitable starting point.
Approved Source Material
This course page is structured from the supplied Oracle Fusion Technical – BIP and PL_SQL Course Content.pdf.
Approved Course Syllabus
Expand each section below to review the approved modules, weeks, projects and learning areas supplied by Tech Arryaan.
- Database concepts
- SELECT, WHERE, ORDER BY, DISTINCT
- LIKE, IN, BETWEEN, NULL handling
- 25+ practice queries
- Joins
- GROUP BY and HAVING
- Aggregate functions
- Set operators
- Subqueries and correlated subqueries
- 30 advanced queries
- P2P lifecycle
- Requisition tables: POR_REQUISITION_HEADERS_ALL,
- POR_REQUISITION_LINES_ALL
- PO tables: PO_HEADERS_ALL, PO_LINES_ALL
- Supplier tables: POZ_SUPPLIERS
- Receiving tables: RCV_*
- AP Invoice and Payment tables
- PR to PO, Spend and Aging reports
- O2C lifecycle
- Customer tables: HZ_PARTIES, HZ_CUST_ACCOUNTS
- Order tables: DOO_HEADERS_ALL, DOO_LINES_ALL
- Shipping tables: WSH_*
- Receivables tables: RA_* and AR_*
- Order, Shipment and Invoice reports
- Data Models
- Parameters and LOVs
- RTF Templates
- PDF, Excel, CSV outputs
- eText Output files
- Supplier and Customer reports
- End-to-end P2P report
- End-to-end O2C report
- Blocks, variables and records
- IF and loops
- Cursors
- Exception handling
- Hands-on programming exercises
- Procedures
- Functions
- Packages
- Note: Course contents may be adjusted as per the contents.
SQL, Oracle Fusion P2P/O2C Database Tables, BI Publisher Reports, and PL/SQL.
Training Information
Training Mode
Confirmed based on the current offering.
Duration
8-week syllabus
Batch Timing / Next Batch / Trainer
Contact our team for current details.
Practical Learning
Projects, assignments, practical scenarios and capstone items are shown inside the approved syllabus wherever the source document includes them.
Course Enquiry
Tell us the technology, your current experience, preferred training mode and schedule.
