Search Results concurrent




Overview
Explore in AI Chat

Overview

The concurrent program PCORGSUM is delivered as part of the Oracle E-Business Suite module AMW – Internal Controls Manager, an application historically associated with the governance, risk, and compliance (GRC) functionality that underpinned organizational certification and evaluation workflows. Its user-facing name, Populate Evaluation Summary for Organization Certification, accurately reflects its role: the program processes certification evaluation data and populates the summary structures used to report on the outcome of an organization-wide certification exercise.

In the ETRM documentation set for release 12.2.2, the program is recorded as Enabled: Yes, indicating that it remains available for submission within the environment even though the parent product is annotated as Obsolete. This dual status is common in EBS: a program may still be executable for historical or transitional reasons while the owning module is no longer actively developed or recommended for new implementations. Organizations upgrading from 12.1.1 to 12.2.2 should therefore treat PCORGSUM as a legacy component whose behavior is preserved for backward compatibility rather than as a supported forward-looking feature.

Execution Details

PCORGSUM is implemented as a PL/SQL Stored Procedure, the execution method recorded in the concurrent program definition. The registered Executable is PCORGSUM, and the associated Execution Filename resolves to the packaged procedure:

  • AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_summary
  • Argument Method: Standard
  • Execution Method: PL/SQL Stored Procedure
  • Subroutine Name: (not populated in the documented metadata)

Because the program calls a packaged PL/SQL API rather than an external executable or Java concurrent program, it runs entirely within the database tier and inherits the standard concurrent manager processing model, including request logging and completion status reporting through the Concurrent Requests form.

How to Run

Users submit PCORGSUM through the standard Submit Request (SRS) window, navigating via Requests → Run and selecting Populate Evaluation Summary for Organization Certification by its user-facing name. The documented metadata specifies a Standard argument method, which indicates that the program accepts a conventional parameter list defined at the concurrent program level. Typical parameters for a certification summary program of this class include the organization identifier and the certification or evaluation period; however, the ETRM excerpt does not enumerate specific parameter tokens, so implementers should inspect the live concurrent program definition in the target instance to confirm the exact prompt names, data types, and whether any are mandatory.

General guidance for submission includes verifying that the relevant certification is in an appropriate state before running the program, scheduling it during periods of low concurrent manager load if large volumes of evaluation rows are involved, and reviewing the request log for PL/SQL errors surfaced by the underlying package. Because the parent module is marked obsolete, organizations should validate results carefully and consider whether a replacement GRC process is in use.

Related Objects

As a member of the AMW organization certification family, PCORGSUM is closely associated with the following:

  • Package: AMW_ORG_CERT_EVAL_SUM_PVT, containing the populate_org_cert_summary procedure invoked at runtime.
  • Sibling concurrent programs in the same product that handle certification creation, evaluation, and reporting.
  • Interface and summary tables populated by the procedure, which feed organization certification reports and inquiry forms.
  • Concurrent request output and log files generated through the standard concurrent manager framework.

Given that the AMW product is documented as obsolete, the most reliable reference for related objects remains the live application dictionary and the AOL (Application Object Library) definitions in the specific EBS instance.

  • Concurrent Program: PCORGSUM 12.1.1

    execution_filename: AMW_ORG_CERT_EVAL_SUM_PVT.populate_org_cert_summary ,  product: AMW - Internal Controls Manager ,  user_name: Populate Evaluation Summary for Organization Certification ,  description: Populate Evaluation Summary for Organization Certification ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIPCINI 12.1.1

    execution_filename: RCI_PROC_CERT_SUMM_PKG.proc_cert_initial_load ,  product: AMW - Internal Controls Manager ,  user_name: RCI Proc Cert Summary Initial Load ,  description: RCI Process Certification Summary Initial Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWSYNCPROCORGSNOCOUNT 12.1.1

    execution_filename: AMW_ORG_HIERARCHY_PKG.sync_proc_org_srs ,  product: AMW - Internal Controls Manager ,  user_name: AMWSYNCPROCORG ,  description: Synchronize Process to Organizations. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIEINLD 12.1.1

    execution_filename: RCI_COMPL_ENV_CHG_SUMM_PKG.initial_load ,  product: AMW - Internal Controls Manager ,  user_name: RCI_COMPL_ENV_INI_LOAD ,  description: RCI Compliance Env Change Summ Report Initial Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMW_GENERATE_AUDIT_REPORT 12.1.1

    execution_filename: ConcurrentReport ,  product: AMW - Internal Controls Manager ,  user_name: AMWAUDITRPRT ,  description: Generate the Audit Report for a Project. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FSDASHSUM 12.1.1

    execution_filename: AMW_FINSTMT_CERT_PVT.Populate_All_Cert_General_Sum ,  product: AMW - Internal Controls Manager ,  user_name: Financial Statement Certification Dashboard Summary ,  description: Populate Dashboard Summary for Financial Statement Certification ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWCTRLIMP 12.1.1

    execution_filename: amw_load_ctrl_data.create_controls ,  product: AMW - Internal Controls Manager ,  user_name: AMWCTRLIMP ,  description: Import Controls ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FSIEVLSUM 12.1.1

    execution_filename: AMW_FINSTMT_CERT_PVT.build_amw_fin_cert_eval_sum ,  product: AMW - Internal Controls Manager ,  user_name: Financial Statement Certification Financial Item Evaluation ,  description: Populate Financial Item Evaluation Summary for Financial Certification ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWPROCIMP 12.1.1

    execution_filename: amw_load_proc_data.create_processes ,  product: AMW - Internal Controls Manager ,  user_name: AMWPROCIMP ,  description: Import Processes ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWAPRIMP 12.1.1

    execution_filename: AMW_LOAD_AUDIT_PROCEDURE_DATA.update_apr ,  product: AMW - Internal Controls Manager ,  user_name: Audit Procedure Results Import ,  description: Audit Procedure Results Import ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWKACCIMP 12.1.1

    execution_filename: amw_load_key_acc_data.create_key_acc_assoc ,  product: AMW - Internal Controls Manager ,  user_name: AMWKACCIMP ,  description: Import Process to Key Account Associations ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FSTCTSUM 12.1.1

    execution_filename: AMW_FINSTMT_CERT_PVT.Populate_Fin_Stmt_Cert_Sum ,  product: AMW - Internal Controls Manager ,  user_name: Financial Statement Certification Summary ,  description: Populate Financial Statement Certification Summary ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCISGINC 12.1.1

    execution_filename: RCI_SIG_ACCT_EVAL_SUMM_PKG.sig_acct_incremental_load ,  product: AMW - Internal Controls Manager ,  user_name: RCI Sig Acct Eval Summary Incremental Load ,  description: RCI Sig Acct Eval Summary Incremental Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWVIOLATCHK 12.1.1

    execution_filename: AMW_CONSTRAINT_PVT.Check_Violation ,  product: AMW - Internal Controls Manager ,  user_name: AMWVIOLATCHK ,  description: Check Constraint Violation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWASSOCTOPROCSRS 12.1.1

    execution_filename: AMW_ORG_HIERARCHY_PKG.push_proc_org_srs ,  product: AMW - Internal Controls Manager ,  user_name: Associate Process to Organizations ,  description: Associate Process to Organization ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWPCFIND 12.1.1

    execution_filename: AMW_PROCESS_CERT_SUMMARY.Populate_Proccert_Findings ,  product: AMW - Internal Controls Manager ,  user_name: AMWPCFIND ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FCORGSUM 12.1.1

    execution_filename: AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Org_Eval_Sum ,  product: AMW - Internal Controls Manager ,  user_name: Finstmt Certification Organization Summary ,  description: Populate Organization Summary for Finstmt Certification ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWSODCSTWAIVERUPLOAD 12.1.1

    execution_filename: AMW_LOAD_SOD_DATA.create_constraint_waivers ,  product: AMW - Internal Controls Manager ,  user_name: Upload Segregation Of Duties Constraint Waivers ,  description: Executable to upload seggreagtion of duties constraint waiver ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWBUSPROCDET 12.1.1

    execution_filename: CPBusProcReport ,  product: AMW - Internal Controls Manager ,  user_name: AMWBUSPROCRPT ,  description: Business Process Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: AMWVIOLATREVAL 12.1.1

    execution_filename: AMW_CONSTRAINT_PVT.Revalidate_Violation ,  product: AMW - Internal Controls Manager ,  user_name: AMWVIOLATREVAL ,  description: Revalidate Constraint Violation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWPCOUNT 12.1.1

    execution_filename: AMW_RL_HIERARCHY_PKG.reset_count ,  product: AMW - Internal Controls Manager ,  user_name: AMWPCOUNT ,  description: To Reset the risk and control count of processes in RiskLibrary ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWVIOLATCHKBYNAME 12.1.1

    execution_filename: AMW_CONSTRAINT_PVT.Check_Violation_By_Name ,  product: AMW - Internal Controls Manager ,  user_name: AMWVIOLATCHKBYNAME ,  description: Check Violation For Constraint By Name ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FCPROSUM 12.1.1

    execution_filename: AMW_FINSTMT_CERT_PVT.Populate_All_Fin_Proc_Eval_Sum ,  product: AMW - Internal Controls Manager ,  user_name: Finstmt Certification Processes Summary ,  description: Populate Processes Summary for Finstmt Certification ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCICDTICLOAD 12.1.1

    execution_filename: RCI_CTRL_DETAIL_ETL_PKG.incr_load ,  product: AMW - Internal Controls Manager ,  user_name: RCICDTICLOAD ,  description: Control Detail Report Incremental Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIODFCYICLOAD 12.1.1

    execution_filename: RCI_ORG_DFCY_ETL_PKG.incr_load ,  product: AMW - Internal Controls Manager ,  user_name: RCIODFCYICLOAD ,  description: RCI Process Deficiency Report Incremental Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIORINC 12.1.1

    execution_filename: RCI_OPEN_REMED_SUMM_PKG.open_remed_act_increment_load ,  product: AMW - Internal Controls Manager ,  user_name: RCI Open Remedial Action Summary Incremental Load ,  description: RCI Open Remedial Action Summary Incremental Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIOUNMRINLOAD 12.1.1

    execution_filename: RCI_UNMTG_RISKS_ETL_PKG.initial_load ,  product: AMW - Internal Controls Manager ,  user_name: RCIOUNMRINLOAD ,  description: RCI Unmitigated Risks Initial Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIECRLD 12.1.1

    execution_filename: RCI_COMPL_ENV_CHG_SUMM_PKG.incremental_load ,  product: AMW - Internal Controls Manager ,  user_name: RCI_COMPL_ENV_INCR_LOAD ,  description: RCI Cimpliance Env Chg Summ Report Incremental load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWFSTFIND 12.1.1

    execution_filename: AMW_FINSTMT_FINDING_PVT.POPULATE_FINSTMT_FINDINGS ,  product: AMW - Internal Controls Manager ,  user_name: AMWFINFIND ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWFSCTRLDEF 12.1.1

    execution_filename: CPFinStmtCtrlDefReport ,  product: AMW - Internal Controls Manager ,  user_name: AMWFSCTRLDEFRPT ,  description: Financial Statement Control Deficiencies ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: AMWASSOCTOORG 12.1.1

    execution_filename: AMW_ORG_HIERARCHY_PKG.push_proc_org_conc_request ,  product: AMW - Internal Controls Manager ,  user_name: AMWASSOCTOORG ,  description: Associate process to selected oraganization ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWRCIMP 12.1.1

    execution_filename: amw_load_rc_data.create_risks_and_controls ,  product: AMW - Internal Controls Manager ,  user_name: AMWRCIMP ,  description: Import Risks and Controls ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: SODTABUPDREPORT 12.1.1

    execution_filename: AMW_LOAD_SOD_DATA.cst_table_update_report ,  product: AMW - Internal Controls Manager ,  user_name: Segregation Of Duties Tables Update Report ,  description: Segregation Of Duties Table Update Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWAPIMP 12.1.1

    execution_filename: amw_load_ap_data.create_audit_procedures ,  product: AMW - Internal Controls Manager ,  user_name: AMWAPIMP ,  description: Import Audit Procedures ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIOUNMRICLOAD 12.1.1

    execution_filename: RCI_UNMTG_RISKS_ETL_PKG.incr_load ,  product: AMW - Internal Controls Manager ,  user_name: RCIOUNMRICLOAD ,  description: RCI Unmitigated Risks Incremental Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWSODCONC 12.1.1

    execution_filename: AMW_LOAD_SOD_DATA.insert_data ,  product: AMW - Internal Controls Manager ,  user_name: Public SOD upload concurrent program ,  description: Public SOD upload concurrent program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIOISSI 12.1.1

    execution_filename: RCI_OPEN_ISSUE_SUMM_PKG.initial_load ,  product: AMW - Internal Controls Manager ,  user_name: RCI Open Issues Summary Initial Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: CERTREMINDER 12.1.1

    execution_filename: AMW_PROCCERT_REMINDER_PKG.send_reminder_to_all_owners ,  product: AMW - Internal Controls Manager ,  user_name: Process Certification Reminder ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWDELOBJ 12.1.1

    execution_filename: AMW_DELETE_OBJECT_PVT.Delete_Objects ,  product: AMW - Internal Controls Manager ,  user_name: AMWDELOBJ ,  description: Delete Objects ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: PCDASHSUM 12.1.1

    execution_filename: AMW_PROCESS_CERT_SUMMARY.Populate_All_Cert_General_Sum ,  product: AMW - Internal Controls Manager ,  user_name: Process Certification Dashboard Summary ,  description: Populate Dashboard Summary for Process Certification ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWTWFLOAD 12.1.1

    execution_filename: TutorToWorkflow ,  product: AMW - Internal Controls Manager ,  user_name: Oracle Audit Manager Tutor to Workflow Loader ,  description: This program converts uploaded Oracle Audit Tutor files to Workflow ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: AMWSYNCPH 12.1.1

    execution_filename: AMW_WF_HIERARCHY_PKG.sync_hier_amw_process_wrap ,  product: AMW - Internal Controls Manager ,  user_name: AMWSYNCPH ,  description: To sync process hierarchy and Amw_Process ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWPOCOUNT 12.1.1

    execution_filename: AMW_ORG_HIERARCHY_PKG.reset_count ,  product: AMW - Internal Controls Manager ,  user_name: AMWPOCOUNT ,  description: To Reset the process risk and control count in Oraganization context ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCIOCRTINLOAD 12.1.1

    execution_filename: RCI_ORG_CERT_ETL_PKG.initial_load ,  product: AMW - Internal Controls Manager ,  user_name: RCIOCRTINLOAD ,  description: RCI Organization Certification Initial Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWASSOCPROCNOCOUNT 12.1.1

    execution_filename: AMW_ORG_HIERARCHY_PKG.push_proc_org_no_count ,  product: AMW - Internal Controls Manager ,  user_name: AMWASSOCPROCNOCOUNT ,  description: Associate Process to Organizations Concurrent Program with no Count Update ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: RCICDTINLOAD 12.1.1

    execution_filename: RCI_CTRL_DETAIL_ETL_PKG.initial_load ,  product: AMW - Internal Controls Manager ,  user_name: RCICDTINLOAD ,  description: RCI Control Detail Report Initial Load ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWRCMORGIMP 12.1.1

    execution_filename: amw_load_rcm_org_data.create_risks_and_controls ,  product: AMW - Internal Controls Manager ,  user_name: AMWRCMORGIMP ,  description: Import Risks and Controls in Organization Context ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWORGDOCDET 12.1.1

    execution_filename: CPOrgProcDocReport ,  product: AMW - Internal Controls Manager ,  user_name: AMWORGDOCRPT ,  description: Organization Process Documentation ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: AMW_UPDATE_ORG_PARAMS 12.1.1

    execution_filename: AMW_PARAMETERS_PVT_PKG.update_all_org_params_cp ,  product: AMW - Internal Controls Manager ,  user_name: AMWUPDATEORGPARAMS ,  description: Update Organization Parameters ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: AMWFULLHIER 12.1.1

    execution_filename: AMW_ORG_CERT_AGGR_PKG.populate_full_hierarchies ,  product: AMW - Internal Controls Manager ,  user_name: AMWFULLHIER ,  description: Populate the full entity hierarchy ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure ,