Search Results generate_fiscal_month_start

Overview

The APPS.PAY_ZA_CALENDARS_PKG package is a South African localization component within Oracle E-Business Suite Payroll (Oracle Payroll). Its business purpose is the generation and maintenance of payroll calendar structures required for South African statutory and payroll processing. South African payroll operates on a combination of fiscal year, tax year, and payroll period constructs that do not align to a single Gregorian calendar boundary; the package encapsulates the date arithmetic and calendar record creation needed to translate legislative rules into concrete payroll periods.

The package is classified as an OTHER API within the E-Business Suite Technical Reference Manual (ETRM), indicating that it is an internal localization utility rather than a formally published public API. It is owned by the APPS schema and holds a VALID status in both Oracle EBS 12.1.1 and 12.2.2. The package is referenced by no other packages, confirming that it functions as a leaf-level utility invoked primarily through configuration and concurrent processing rather than as a shared library consumed by downstream application logic.

Key Procedures and Functions

The package exposes fourteen documented procedures and functions. These fall into three logical groupings:

• Calendar and period creation: CREATE_CALENDAR establishes the base calendar definition; CREATE_ZA_PAYROLL_MONTH_ENDS populates month-end payroll period records; CREATE_ZA_PERIOD_NUMBERS assigns sequential period numbering for the generated calendar; CREATE_ZA_TAX_QUARTERS generates the quarterly tax structures used for provisional tax and statutory reporting.
• Year derivation: RETRIEVE_TAX_YEAR_START and RETRIEVE_FISCAL_YEAR_START derive the opening dates of the South African tax year and fiscal year respectively, based on legislative rules. GENERATE_FISCAL_MONTH_START computes the start date of individual fiscal months. CREATE_ZA_EMPLOYEE_TAX_YEARS and CREATE_ZA_EMPLOYEE_CAL_YEARS create the per-employee tax year and calendar year records that anchor payroll processing for each assignment.
• Date arithmetic utilities: DO serves as the main driver procedure; NEXT_LOWER_DAY, ADD_MULTIPLE_OF_BASE, NEXT_SEMI_MONTH, and PREV_SEMI_MONTH perform the semi-month and base-unit date calculations required to position period boundaries correctly, including adjustments for non-working days.

Tables Accessed

The package operates against four tables through APPS synonyms:

• PER_TIME_PERIODS — the primary target for created payroll periods and period start/end dates.
• PER_TIME_PERIOD_TYPES — defines the period type (for example, semi-month, monthly, or quarterly) used to classify generated periods.
• PAY_LEGISLATION_RULES — supplies the South African legislative parameters that govern tax year and fiscal year boundaries and period derivation logic.
• HR_ORGANIZATION_INFORMATION — provides organization-level context used to scope calendars to the appropriate business group or payroll organization.

Usage Notes

PAY_ZA_CALENDARS_PKG is typically invoked during South African payroll implementation and year-end rollover, when a new tax or fiscal year requires calendar generation. Because it is classified as OTHER and is not referenced by any other package, it is not intended for direct invocation from Oracle Forms; instead it is most commonly called from concurrent programs, seeded setup processes, or carefully controlled custom PL/SQL scripts executed during localization configuration. Any custom invocation should be performed in a controlled environment, as the package writes directly to PER_TIME_PERIODS and can affect payroll period integrity. As with all APPS-schema localization utilities, direct modification of the underlying source is not supported; changes must follow Oracle's patching and localization maintenance procedures.