# ashishhcm/oracle-hcm-cloud-articles architecture

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

- Interactive diagram: https://gitdiagram.com/ashishhcm/oracle-hcm-cloud-articles
- Repository: https://github.com/ashishhcm/oracle-hcm-cloud-articles

## Overview

This repository is a collection of Oracle HCM Cloud articles and sample SQL/text artifacts, not an executable application. Its documented content spans HCM administration and workforce features, analytics and BI Publisher reporting, and data loading or migration examples. The tree identifies these materials, but no source excerpts or article contents were provided, and the README makes no workflow or component-interaction claims. Accordingly, the graph groups the materials by topic without inventing runtime flows or relationships.

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_hcm["HCM Features"]
  node_provisioning["Role Provisioning"]
  node_release12["Release 12 Global HR"]
  node_userconversion["Read-Only User Conversion"]
  node_valueset["Independent Value Set"]
  node_matching["Person Matching Criteria"]
  node_workingage["Minimum Working Age"]
end

subgraph group_reporting["Reporting"]
  node_workerreport["Worker BIP Report"]
  node_pipeotbi["OTBI Pipe-Delimited Output"]
  node_formatting["OTBI Conditional Formatting"]
  node_loggeduser["Logged User in OTBI"]
  node_etext["E-Text BIP Template"]
  node_csvoutput["E-Text CSV Output"]
  node_payrollflow["Parameterized Payroll Flow"]
end

subgraph group_data["Data Operations"]
  node_absence["Absence Migration"]
  node_absencehdl["Absence HDL Formula"]
  node_personabsence["Absence Entry Sample"]
  node_extractcriteria["Extract Criteria Formula"]
  node_hdlload["HDL Transformation Formula"]
  node_commonqueries["Common Queries"]
  node_employeemaster["Employee Master Query<br/>[EmployeeMaster.sql]"]
  node_employeelov["Employee Master LOV Query"]
  node_generatedata["Load and Report SQL"]
  node_employeeview["Employee Details PVO Query"]
  node_pvodetails["PVO Details Query<br/>[PVODetails.sql]"]
end

click node_provisioning "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Introduction%20to%20Role%20Provisioning%20and%20De-provisioning%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf"
click node_release12 "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Overview%20of%20Oracle%20ERP%20HCM%20Cloud%20Application%20Release%2012%20Global%20HR%20New%20Features.pdf"
click node_userconversion "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Converting%20a%20Normal%20User%20to%20a%20Read%20Only%20User%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf"
click node_valueset "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Creating%20a%20Custom%20Independent%20Value%20Set%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf"
click node_absence "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Overview%20Of%20Absence%20Migration%20Report%20in%20Oracle%20HCM%20Cloud%20Application.pdf"
click node_absencehdl "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/GENERATE_ABSENCE_ENTRY_HDL_FROM_CSV_FF.sql"
click node_personabsence "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/PersonAbsenceEntry.txt"
click node_workerreport "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Introduction%20to%20Worker%20Report%20-%20BIP%20Report%20Delivered%20By%20Oracle%20in%20Fusion%20Cloud%20Application.pdf"
click node_pipeotbi "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Creating%20a%20Pipe%20Delimited%20Report%20from%20an%20OTBI%20Analysis%20In%20Oracle%20HCM%20Cloud%20Application.pdf"
click node_formatting "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Conditional%20Formatting%20Feature%20in%20OTBI%20Analysis%20in%20ERP%20Cloud%20Application%20-%20Use%20Case%20Example.pdf"
click node_loggeduser "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Displaying%20Current%20Logged%20User%20in%20a%20OTBI%20Report%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf"
click node_etext "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Creating%20an%20E-Text%20Template%20based%20BIP%20Report%20in%20Oracle%20ERP%20Cloud%20Application.pdf"
click node_csvoutput "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Generating%20An%20Output%20File%20with%20.CSV%20Extension%20from%20an%20E-Text%20Template%20Based%20BIP%20Report%20In%20Oracle%20HCM%20Cloud%20Application.pdf"
click node_payrollflow "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Using%20a%20Custom%20Payroll%20Flow%20Pattern%20to%20Submit%20a%20Parameterized%20Report%20in%20Oracle%20Cloud%20Application.pdf"
click node_extractcriteria "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Using%20Extract%20Criteria%20Fast%20Formula%20in%20Oracle%20HCM%20Cloud%20Application%20%20A%20Sample%20Example.pdf"
click node_hdlload "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Load%20Data%20into%20Oracle%20HCM%20Cloud%20Using%20HCM%20Data%20Loader%20Transformation%20Fast%20Formula.pdf"
click node_matching "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Matching%20Person%20Record%20Criteria%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf"
click node_workingage "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Minimum%20Working%20Age%20Criteria%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf"
click node_commonqueries "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/ComonlyUsedQueries.sql"
click node_employeemaster "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/EmployeeMaster.sql"
click node_employeelov "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/EmployeeMaster_LOVSQL.sql"
click node_generatedata "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/GenerateLoadAndReportDataSQL.sql"
click node_employeeview "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/GetEmployeeDetailsPVO.sql"
click node_pvodetails "https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/PVODetails.sql"

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_provisioning,node_release12,node_userconversion,node_valueset,node_matching,node_workingage toneBlue
class node_workerreport,node_pipeotbi,node_formatting,node_loggeduser,node_etext,node_csvoutput,node_payrollflow toneAmber
class node_absence,node_absencehdl,node_personabsence,node_extractcriteria,node_hdlload,node_commonqueries,node_employeemaster,node_employeelov,node_generatedata,node_employeeview,node_pvodetails toneMint
```

## Components

### HCM Features

- [Role Provisioning](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Introduction%20to%20Role%20Provisioning%20and%20De-provisioning%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf): `An Introduction to Role Provisioning and De-provisioning in Oracle Fusion HCM Cloud Application.pdf`
- [Release 12 Global HR](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Overview%20of%20Oracle%20ERP%20HCM%20Cloud%20Application%20Release%2012%20Global%20HR%20New%20Features.pdf): `An Overview of Oracle ERP HCM Cloud Application Release 12 Global HR New Features.pdf`
- [Read-Only User Conversion](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Converting%20a%20Normal%20User%20to%20a%20Read%20Only%20User%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf): `Converting a Normal User to a Read Only User in Oracle Fusion HCM Cloud Application.pdf`
- [Independent Value Set](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Creating%20a%20Custom%20Independent%20Value%20Set%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf): `Creating a Custom Independent Value Set in Oracle Fusion HCM Cloud Application.pdf`
- [Person Matching Criteria](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Matching%20Person%20Record%20Criteria%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf): `Matching Person Record Criteria in Oracle Fusion HCM Cloud Application.pdf`
- [Minimum Working Age](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Minimum%20Working%20Age%20Criteria%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf): `Minimum Working Age Criteria in Oracle Fusion HCM Cloud Application.pdf`

### Reporting

- [Worker BIP Report](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Introduction%20to%20Worker%20Report%20-%20BIP%20Report%20Delivered%20By%20Oracle%20in%20Fusion%20Cloud%20Application.pdf): `An Introduction to Worker Report - BIP Report Delivered By Oracle in Fusion Cloud Application.pdf`
- [OTBI Pipe-Delimited Output](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Creating%20a%20Pipe%20Delimited%20Report%20from%20an%20OTBI%20Analysis%20In%20Oracle%20HCM%20Cloud%20Application.pdf): `Creating a Pipe Delimited Report from an OTBI Analysis In Oracle HCM Cloud Application.pdf`
- [OTBI Conditional Formatting](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Conditional%20Formatting%20Feature%20in%20OTBI%20Analysis%20in%20ERP%20Cloud%20Application%20-%20Use%20Case%20Example.pdf): `Conditional Formatting Feature in OTBI Analysis in ERP Cloud Application - Use Case Example.pdf`
- [Logged User in OTBI](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Displaying%20Current%20Logged%20User%20in%20a%20OTBI%20Report%20in%20Oracle%20Fusion%20HCM%20Cloud%20Application.pdf): `Displaying Current Logged User in a OTBI Report in Oracle Fusion HCM Cloud Application.pdf`
- [E-Text BIP Template](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Creating%20an%20E-Text%20Template%20based%20BIP%20Report%20in%20Oracle%20ERP%20Cloud%20Application.pdf): `Creating an E-Text Template based BIP Report in Oracle ERP Cloud Application.pdf`
- [E-Text CSV Output](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Generating%20An%20Output%20File%20with%20.CSV%20Extension%20from%20an%20E-Text%20Template%20Based%20BIP%20Report%20In%20Oracle%20HCM%20Cloud%20Application.pdf): `Generating An Output File with .CSV Extension from an E-Text Template Based BIP Report In Oracle HCM Cloud Application.pdf`
- [Parameterized Payroll Flow](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Using%20a%20Custom%20Payroll%20Flow%20Pattern%20to%20Submit%20a%20Parameterized%20Report%20in%20Oracle%20Cloud%20Application.pdf): `Using a Custom Payroll Flow Pattern to Submit a Parameterized Report in Oracle Cloud Application.pdf`

### Data Operations

- [Absence Migration](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/An%20Overview%20Of%20Absence%20Migration%20Report%20in%20Oracle%20HCM%20Cloud%20Application.pdf): `An Overview Of Absence Migration Report in Oracle HCM Cloud Application.pdf`
- [Absence HDL Formula](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/GENERATE_ABSENCE_ENTRY_HDL_FROM_CSV_FF.sql): `GENERATE_ABSENCE_ENTRY_HDL_FROM_CSV_FF.sql`
- [Absence Entry Sample](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/PersonAbsenceEntry.txt): `PersonAbsenceEntry.txt`
- [Extract Criteria Formula](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Using%20Extract%20Criteria%20Fast%20Formula%20in%20Oracle%20HCM%20Cloud%20Application%20%20A%20Sample%20Example.pdf): `Using Extract Criteria Fast Formula in Oracle HCM Cloud Application A Sample Example.pdf`
- [HDL Transformation Formula](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/Load%20Data%20into%20Oracle%20HCM%20Cloud%20Using%20HCM%20Data%20Loader%20Transformation%20Fast%20Formula.pdf): `Load Data into Oracle HCM Cloud Using HCM Data Loader Transformation Fast Formula.pdf`
- [Common Queries](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/ComonlyUsedQueries.sql): `ComonlyUsedQueries.sql`
- [Employee Master Query](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/EmployeeMaster.sql): `EmployeeMaster.sql`
- [Employee Master LOV Query](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/EmployeeMaster_LOVSQL.sql): `EmployeeMaster_LOVSQL.sql`
- [Load and Report SQL](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/GenerateLoadAndReportDataSQL.sql): `GenerateLoadAndReportDataSQL.sql`
- [Employee Details PVO Query](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/GetEmployeeDetailsPVO.sql): `GetEmployeeDetailsPVO.sql`
- [PVO Details Query](https://github.com/ashishhcm/oracle-hcm-cloud-articles/blob/master/PVODetails.sql): `PVODetails.sql`