Search Results advice_code

Overview

PAY_SG_CPFLINE is an Oracle E-Business Suite payroll package owned by the APPS schema and classified as OTHER in the ETRM metadata set for release 12.2.2. It supports the Singapore statutory payroll reporting framework associated with the Central Provident Fund (CPF), producing the transactional detail lines that accompany the monthly CPF contribution file generated from Oracle Payroll. The package is one component in a family of Singapore-localized payroll objects that assemble, format and archive statutory tape and file output for submission to the CPF Board.

The package header identifies the standard payroll archive interface contract. The comment block preceding the declarations states explicitly that the public procedures are required by the Archive process and that their names are stored in PAY_REPORT_FORMAT_MAPPINGS_F, so the archive process knows what code to execute for each step. This design is characteristic of Oracle Payroll's "magtape" architecture, in which a payroll action is decomposed into a range of person records, a set of assignment actions, and a final archive write step coordinated through mapping rows.

Key Procedures and Functions

• RANGE_CODE — Defines the set of assignment actions to be processed for the payroll action. It returns the SQL text that the archive process uses to select the population of person records belonging to the run.
• ASSIGNMENT_ACTION_CODE — Performs the per-assignment processing step across a person-ID chunk, invoked for each block of assignment actions selected by the range code.
• INITIALIZATION_CODE — Executed once at the start of the archive to establish session-level state, including package variables such as LEVEL_CNT, and to seed any run-wide parameters.
• ARCHIVE_CODE — Writes the formatted CPF detail line output for a single assignment action as of the supplied effective date; this is the procedure that materializes the record content.
• DEINIT_CODE — Performs cleanup at the close of the archive run, releasing transient state held by the package.
• CHECK_CPF_NUMBER — Validates the CPF membership number held against the employee, returning the outcome used to determine whether a valid line can be emitted.

The package also declares the COMPANY_IDENTIFICATION cursor, which assembles header parameters such as BUSINESS_GROUP_ID, TAX_UNIT_ID, DOCUMENT_DATE, LEGAL_ENTITY, MONTH, and ADVICE_CODE using PAY_MAGTApe_GENERIC.GET_PARAMETER_VALUE and the HR_ORGANIZATIONS name. Bug#3501950 added CPF_Interest and FWL_Interest parameters to this structure.

Tables Accessed

Payroll action context is drawn from PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS, with their shadow tables PAY_ACTION_INFORMATION and PAY_ACTION_INFORMATION_S supplying action parameters. Person and assignment data come from PER_ALL_PEOPLE_F, PER_ALL_ASSIGNMENTS_F, PER_PERIODS_OF_SERVICE, and PER_ASSIGNMENT_EXTRA_INFO. CPF balances are resolved through PAY_DEFINED_BALANCES, PAY_BALANCE_TYPES, and PAY_BALANCE_DIMENSIONS, while HR_ORGANIZATION_INFORMATION supplies the legal entity name. DUAL and PLITBLM are used for utility and PL/SQL-table operations.

Usage Notes

PAY_SG_CPFLINE is not exposed through a form UI. It is invoked indirectly by the Oracle Payroll archive process, which resolves the procedure names from PAY_REPORT_FORMAT_MAPPINGS_F and calls RANGE_CODE, INITIALIZATION_CODE, ASSIGNMENT_ACTION_CODE, ARCHIVE_CODE, and DEINIT_CODE in sequence for the CPF report format. The package header notes that it is referenced by one other package. In the context of the searched term "happay greenlam," no relationship exists: Happay is a third-party expense management product and Greenlam is an unrelated corporate entity; neither is referenced in this ETRM metadata. Any integration between such external systems and Oracle EBS payroll would be implemented as custom concurrent programs or interfaces and would not alter the standard behavior of PAY_SG_CPFLINE. Customization should be avoided; the package is a localized statutory object whose output participates directly in CPF submission and is subject to Oracle patch application.