Search Results sourcing

Deep Dive: PON_NOTIF_SUBSCRIPTION_GROUPS in Oracle EBS 12.1.1/12.2.2

Table Purpose

Stores notification subscription groups for Oracle iProcurement/Purchasing workflows in Oracle E-Business Suite.

Module Association

Primarily used by Oracle Purchasing (PO) and iProcurement modules for approval workflow notifications.

Key Relationships

Links to PON_NOTIF_SUBSCRIPTIONS (child table)
References WF_NOTIFICATION_GROUPS (Workflow engine)
Tied to FND_USER for subscriber information

Critical Columns

Column	Description
GROUP_ID	Primary key, sequence-generated identifier
GROUP_NAME	User-defined name for the subscription group
CREATED_BY	FND_USER reference for creator
CREATION_DATE	Timestamp of record creation
LAST_UPDATED_BY	FND_USER reference for last modifier
LAST_UPDATE_DATE	Timestamp of last modification

Functional Usage

Groups multiple notification subscriptions for workflow approvals
Enables batch processing of related notifications
Supports delegation scenarios in approval hierarchies
Facilitates notification routing based on business rules

Technical Implementation

Integrated with Oracle Workflow engine (WF_NOTIFICATIONS)
Utilizes Oracle Advanced Queuing for message delivery
Accessed via PL/SQL APIs in PO_NOTIFICATION_SERVICES_PKG
Audit columns follow Oracle EBS standards

Customization Considerations

Adding custom attributes requires extension tables
Modifications may impact workflow performance
Changes require thorough testing of approval routing
Must maintain referential integrity with WF tables

Upgrade Impact (12.1.1 to 12.2.2)

Minimal structural changes between versions
New workflow features may leverage existing groups
Online patching considerations in 12.2.2

Concurrent Program: PON_GENERATE_PDF 12.1.1
execution_filename: GeneratePdfCp , product: PON - Sourcing , user_name: Insert sourcing with contracts PDF in Contracts Repository , description: Used for insertion of Sourcing Contracts pdf in Contracts Repository , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PON_GENERATE_PDF 12.2.2
execution_filename: GeneratePdfCp , product: PON - Sourcing , user_name: Insert sourcing with contracts PDF in Contracts Repository , description: Used for insertion of Sourcing Contracts pdf in Contracts Repository , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: PON_AUCTION_EMD_ACTIONS 12.2.2
product: PON - Sourcing , meaning: EMD Actions ,
Lookup Type: PON_LINE_ATTRIBUTE_GROUPS 12.1.1
product: PON - Sourcing , meaning: Sourcing Line Attribute Groups , description: Sourcing Line Attribute Groups ,
Lookup Type: PON_HEADER_ATTRIBUTE_GROUPS 12.2.2
product: PON - Sourcing , meaning: Sourcing Requirement Sections , description: Pre-defined Sections for Sourcing Requirements ,
Concurrent Program: PON_CREATE_PO 12.1.1
execution_filename: PON_AUCTION_CREATE_PO_PKG.START_PO_CREATION , product: PON - Sourcing , user_name: Create Purchasing Document from Sourcing for Super Large Negotiation , description: Depending upon the outcome of the negotiation, create a standard PO or blanket/contract purchase agreement , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PON_CREATE_PO 12.2.2
execution_filename: PON_AUCTION_CREATE_PO_PKG.START_PO_CREATION , product: PON - Sourcing , user_name: Create Purchasing Document from Sourcing for Super Large Negotiation , description: Depending upon the outcome of the negotiation, create a standard PO or blanket/contract purchase agreement , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Lookup Type: PON_ACCESS 12.1.1
product: PON - Sourcing , meaning: PON: Sourcing Access Level , description: PON: Sourcing Access Level ,
Lookup Type: PON_ACCESS 12.2.2
product: PON - Sourcing , meaning: PON: Sourcing Access Level , description: PON: Sourcing Access Level ,
Lookup Type: PON_SPREADSHEET_TYPES 12.2.2
product: PON - Sourcing , meaning: PON: Sourcing Spreadsheet Types , description: PON: Sourcing Spreadsheet Types ,
Lookup Type: PON_HEADER_ATTRIBUTE_GROUPS 12.1.1
product: PON - Sourcing , meaning: Sourcing Requirement Sections , description: Pre-defined Sections for Sourcing Requirements ,
Lookup Type: PON_LINE_ATTRIBUTE_GROUPS 12.2.2
product: PON - Sourcing , meaning: Sourcing Line Attribute Groups , description: Sourcing Line Attribute Groups ,
Lookup Type: PON_ATTRIBUTE_LEVELS 12.1.1
product: PON - Sourcing , meaning: PON: Sourcing Attribute Levels , description: PON: Sourcing Attribute Levels ,
Lookup Type: PON_SPREADSHEET_TYPES 12.1.1
product: PON - Sourcing , meaning: PON: Sourcing Spreadsheet Types , description: PON: Sourcing Spreadsheet Types ,
Lookup Type: PON_MESSAGE_TYPE_CODE 12.1.1
product: PON - Sourcing , meaning: PON: Sourcing Online Discussion Message Type , description: PON: Sourcing Online Discussion Message Type ,
Lookup Type: PON_MESSAGE_TYPE_CODE 12.2.2
product: PON - Sourcing , meaning: PON: Sourcing Online Discussion Message Type , description: PON: Sourcing Online Discussion Message Type ,
Lookup Type: PON_ATTRIBUTE_LEVELS 12.2.2
product: PON - Sourcing , meaning: PON: Sourcing Attribute Levels , description: PON: Sourcing Attribute Levels ,
Concurrent Program: PON_EXPORT_AWARD 12.1.1
execution_filename: ExportAwardCp , product: PON - Sourcing , user_name: Generate and Store Sourcing Analysis/Award Spreadsheet , description: Generate Zip file containing Analysis & Award spreadsheet , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PON_EXPORT_AWARD 12.2.2
execution_filename: ExportAwardCp , product: PON - Sourcing , user_name: Generate and Store Sourcing Analysis/Award Spreadsheet , description: Generate Zip file containing Analysis & Award spreadsheet , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Lookup Type: PON_SECURITY_LEVEL_CODE 12.1.1
product: PON - Sourcing , meaning: PON: Sourcing Security Level , description: PON: Sourcing Security Level ,
Lookup Type: PON_AUCTION_DOC_TYPES 12.1.1
product: PON - Sourcing , meaning: PON: Sourcing Document Types , description: PON: Sourcing Document Types ,
Lookup Type: PON_SECURITY_LEVEL_CODE 12.2.2
product: PON - Sourcing , meaning: PON: Sourcing Security Level , description: PON: Sourcing Security Level ,
Lookup Type: PON_AUCTION_DOC_TYPES 12.2.2
product: PON - Sourcing , meaning: PON: Sourcing Document Types , description: PON: Sourcing Document Types ,
Concurrent Program: PON_EXPORT_RESPONSE 12.1.1
execution_filename: ExportResponseCp , product: PON - Sourcing , user_name: Export response for Super Large Negotiation , description: Generating zip file containing response spreadsheet , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PON_EXPORT_RESPONSE 12.2.2
execution_filename: ExportResponseCp , product: PON - Sourcing , user_name: Export response for Super Large Negotiation , description: Generating zip file containing response spreadsheet , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
Concurrent Program: PON_IMPORT_NEGOTIATIONS 12.2.2
execution_filename: PON_OPEN_INTERFACE_PUB.CREATE_NEGOTIATIONS , product: PON - Sourcing , user_name: Import Negotiations , description: This program is to import draft sourcing negotiations from interface tables. , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: PON_NOTIF_SUBSCRIPTION_GROUPS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_NOTIF_SUBSCRIPTION_GROUPS, object_name:PON_NOTIF_SUBSCRIPTION_GROUPS, status:VALID, product: PON - Sourcing , description: This table stores the notification subscription preferences for the sourcing instance. , implementation_dba_data: PON.PON_NOTIF_SUBSCRIPTION_GROUPS ,
Table: PON_NOTIF_SUBSCRIPTION_GROUPS 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_NOTIF_SUBSCRIPTION_GROUPS, object_name:PON_NOTIF_SUBSCRIPTION_GROUPS, status:VALID, product: PON - Sourcing , description: This table stores the notification subscription preferences for the sourcing instance. , implementation_dba_data: PON.PON_NOTIF_SUBSCRIPTION_GROUPS ,
Table: PON_CUSTOM_LANGUAGES 12.2.2
product: PON - Sourcing , description: Contains Enabled Languages available to Sourcing Product , implementation_dba_data: Not implemented in this database ,
Table: PON_CUSTOM_IMAGES 12.2.2
product: PON - Sourcing , description: Stores the image names and sizes for sourcing , implementation_dba_data: Not implemented in this database ,
Table: PON_CUSTOM_LANGUAGES 12.1.1
product: PON - Sourcing , description: Contains Enabled Languages available to Sourcing Product , implementation_dba_data: Not implemented in this database ,
Table: PON_CUSTOM_IMAGES 12.1.1
product: PON - Sourcing , description: Stores the image names and sizes for sourcing , implementation_dba_data: Not implemented in this database ,
Concurrent Program: PON_COPY_NEGOTIATIONS 12.1.1
execution_filename: PON_NEGOTIATION_COPY_GRP.PON_CONC_COPY_SUPER_LARGE_NEG , product: PON - Sourcing , user_name: Copy Super Large Negotiation , description: Copy Super Large Negotiation Lines , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PON_COPY_NEGOTIATIONS 12.2.2
execution_filename: PON_NEGOTIATION_COPY_GRP.PON_CONC_COPY_SUPER_LARGE_NEG , product: PON - Sourcing , user_name: Copy Super Large Negotiation , description: Copy Super Large Negotiation Lines , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PON_PURGE_ERRORS 12.2.2
execution_filename: PON_LARGE_AUCTION_UTIL_PKG.PURGE_INTERFACE_ERRORS_CP , product: PON - Sourcing , user_name: Purge expired errors from PON_INTERFACE_ERRORS table , description: Purge expired errors from pon_interface_errors table , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Concurrent Program: PON_PURGE_ERRORS 12.1.1
execution_filename: PON_LARGE_AUCTION_UTIL_PKG.PURGE_INTERFACE_ERRORS_CP , product: PON - Sourcing , user_name: Purge expired errors from PON_INTERFACE_ERRORS table , description: Purge expired errors from pon_interface_errors table , argument_method: Standard , enabled: Yes , execution_method: PL/SQL Stored Procedure ,
Table: PON_EMD_CORPORATE 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_EMD_CORPORATE, object_name:PON_EMD_CORPORATE, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_EMD_CORPORATE ,
Table: PON_SAAS_PO_ATTACHMENTS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SAAS_PO_ATTACHMENTS, object_name:PON_SAAS_PO_ATTACHMENTS, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_SAAS_PO_ATTACHMENTS ,
Table: PON_SAAS_NEGOTIATION_PO 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_SAAS_NEGOTIATION_PO, object_name:PON_SAAS_NEGOTIATION_PO, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_SAAS_NEGOTIATION_PO ,
Table: PON_FORM_SECTION_COMPILED 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_FORM_SECTION_COMPILED, object_name:PON_FORM_SECTION_COMPILED, status:VALID, product: PON - Sourcing , description: Stored the "compiled form". , implementation_dba_data: PON.PON_FORM_SECTION_COMPILED ,
Table: PON_FORM_FIELD_VALUES 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_FORM_FIELD_VALUES, object_name:PON_FORM_FIELD_VALUES, status:VALID, product: PON - Sourcing , description: Stores the form data. , implementation_dba_data: PON.PON_FORM_FIELD_VALUES ,
Table: PON_ISETUP_ANSWERS 12.2.2
product: PON - Sourcing , implementation_dba_data: Not implemented in this database ,
Table: PON_BID_ITEM_PRICES_INTERFACE 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_ITEM_PRICES_INTERFACE, object_name:PON_BID_ITEM_PRICES_INTERFACE, status:VALID, product: PON - Sourcing , description: PON_BID_ITEMS_PROCES_INTERFACE temporarily stores response information. , implementation_dba_data: PON.PON_BID_ITEM_PRICES_INTERFACE ,
Table: PON_UMBRELLA_PROGRAMS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_UMBRELLA_PROGRAMS, object_name:PON_UMBRELLA_PROGRAMS, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_UMBRELLA_PROGRAMS ,
Table: PON_EMD_PAYMENT_TYPES_TL 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_EMD_PAYMENT_TYPES_TL, object_name:PON_EMD_PAYMENT_TYPES_TL, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_EMD_PAYMENT_TYPES_TL ,
Table: PON_ORCA_CERT_DETAILS 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_ORCA_CERT_DETAILS, object_name:PON_ORCA_CERT_DETAILS, status:VALID, product: PON - Sourcing , implementation_dba_data: PON.PON_ORCA_CERT_DETAILS ,
Table: PON_BID_ITEM_PRICES_INTERFACE 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_BID_ITEM_PRICES_INTERFACE, object_name:PON_BID_ITEM_PRICES_INTERFACE, status:VALID, product: PON - Sourcing , description: PON_BID_ITEMS_PROCES_INTERFACE temporarily stores response information. , implementation_dba_data: PON.PON_BID_ITEM_PRICES_INTERFACE ,
Table: PON_WF_DEBUG 12.2.2
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_WF_DEBUG, object_name:PON_WF_DEBUG, status:VALID, product: PON - Sourcing , description: Holds the debug statements for workflow processes , implementation_dba_data: PON.PON_WF_DEBUG ,
Table: PON_FIELDS_TL 12.1.1
owner:PON, object_type:TABLE, fnd_design_data:PON.PON_FIELDS_TL, object_name:PON_FIELDS_TL, status:VALID, product: PON - Sourcing , description: Stores translatable information about a field. , implementation_dba_data: PON.PON_FIELDS_TL ,
File: auctiondoctypes.pdf 12.1.1
product: PON - Sourcing , size: 17.448 KBytes , file_type: PDF Diagram ,