Search Results maintain_groups

Overview

Concurrent Program IGSAZJ01, presented to users as Maintain Advising Group, is a component of the Oracle IGS – Student System product family. Within the ETRM documentation for Oracle E-Business Suite 12.1.1 and 12.2.2, this product is classified as Obsolete, indicating that the functionality it supports has been superseded or deprecated in the current release architecture. Despite this classification, the concurrent program itself remains recorded with an Enabled status of Yes, meaning it can still be registered and submitted within an environment where the IGS schema objects remain deployed.

The program serves as the batch driver for maintaining advising group data. Advising groups in the Student System model associate advisors with cohorts of students for the purpose of academic guidance and progress tracking. The concurrent process performs the set-based maintenance logic that would otherwise be executed through online forms, allowing bulk creation, update, or synchronization of advising group assignments across large populations of learners.

Execution Details

The documented execution metadata for IGSAZJ01 is as follows:

• Execution Method: PL/SQL Stored Procedure
• Argument Method: Standard
• Executable: IGSAZJ01
• Execution Filename: IGS_AZ_GEN_001.MAINTAIN_GROUPS
• Subroutine Name: (not specified in the ETRM record)
• Product: IGS – Student System (Obsolete)
• Enabled: Yes

The execution filename reveals that the underlying PL/SQL package is IGS_AZ_GEN_001, with the entry point being the MAINTAIN_GROUPS procedure. Because the argument method is Standard, parameters are defined on the concurrent program record and passed positionally to the stored procedure at runtime, rather than being captured through a token-based or descriptive flexfield mechanism.

How to Run

Users submit IGSAZJ01 through the standard Submit Request (SRS) window, available from the navigation path appropriate to the Student System responsibility. Because the record specifies a Standard argument method, the parameters dialog presented at submission time reflects the token list defined on the concurrent program definition.

General guidance for submission includes:

• Confirm that the IGS product schema is still present in the instance before relying on this program, given its Obsolete classification.
• Review the parameter list carefully; typical student-system maintenance programs accept an institution or academic period identifier plus a processing mode or commit flag.
• Run the request during a low-activity window, since bulk advising group maintenance may lock or heavily update the underlying IGS tables.
• Verify the concurrent manager for the IGS application is active, and check the request log for the standard completion message and any error diagnostics emitted by IGS_AZ_GEN_001.MAINTAIN_GROUPS.

Related Objects

As with most IGS concurrent programs, the logical companions to IGSAZJ01 are the base advising group tables, the associated validation and maintenance APIs packaged under the IGS_AZ_GEN_001 family, and any online forms that maintain the same data. Because the product is flagged Obsolete in ETRM, interface tables and public APIs for this area are not actively documented in the current release, and reliance on them should be validated against the specific instance rather than assumed from the 12.2.2 metadata.