Search Results xdp_fa_resubmission_log




Overview
Explore in AI Chat

Overview

The XDP_FA_RESUBMISSION_LOG table is a core data object within the Oracle E-Business Suite Provisioning (XDP) module, specifically for Oracle Service Fulfillment Manager. Its primary role is to log and track resubmission jobs, which are administrative operations used to reprocess orders through the provisioning workflow. This functionality is critical for handling order fulfillment errors or reprocessing requirements without manual intervention. The table acts as a central audit and control point for these automated resubmission processes, ensuring traceability and management of order reprocessing within the EBS ecosystem.

Key Information Stored

While the provided metadata does not list all columns, the documented primary and foreign keys reveal the essential data relationships. The central column is RESUBMISSION_JOB_ID, which serves as the unique identifier for each resubmission job and is the table's primary key. Another critical column is FE_ID (Fulfillment Element ID), which links the resubmission job to a specific Fulfillment Element defined in the XDP_FES table. This connection identifies which provisioning component is being restarted in "Order Resubmission" mode. The table likely contains additional audit columns such as creation date, job status, parameters for the resubmission, and user identifiers to provide a complete log of the resubmission activity.

Common Use Cases and Queries

The primary use case is monitoring and auditing the resubmission of orders that have failed or require reprocessing in the provisioning workflow. Administrators can query this table to review the history of resubmission attempts, diagnose fulfillment issues, and verify the status of ongoing jobs. A common reporting query would join this table with XDP_FES to get details about the fulfillment element involved. For example:

  • Tracking all resubmission jobs for a specific time period: SELECT * FROM xdp_fa_resubmission_log WHERE creation_date > SYSDATE - 1;
  • Identifying resubmissions for a particular fulfillment element: SELECT rsl.* FROM xdp_fa_resubmission_log rsl, xdp_fes f WHERE rsl.fe_id = f.fe_id AND f.name = '<FE_NAME>';
  • Investigating the runtime details of a specific resubmission job by joining with XDP_FA_RUNTIME_LIST.

Related Objects

The table maintains defined relationships with other key provisioning tables, as documented in the foreign key metadata.

  • References (Parent Table): XDP_FES via the FE_ID column. This links each resubmission log entry to the specific Fulfillment Element being restarted.
  • Referenced By (Child Table): XDP_FA_RUNTIME_LIST via its RESUBMISSION_JOB_ID column. This indicates that the XDP_FA_RESUBMISSION_LOG table provides the master job identifier for detailed runtime list entries associated with the resubmission process.

These relationships are integral for constructing complete audit trails and understanding the full context of a resubmission job from the master log entry down to its individual runtime components.

  • Table: XDP_FA_RESUBMISSION_LOG 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RESUBMISSION_LOG,  object_name:XDP_FA_RESUBMISSION_LOG,  status:VALID,  product: XDP - Provisioning ,  description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow. ,  implementation_dba_data: XDP.XDP_FA_RESUBMISSION_LOG , 

  • Table: XDP_FA_RESUBMISSION_LOG 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RESUBMISSION_LOG,  object_name:XDP_FA_RESUBMISSION_LOG,  status:VALID,  product: XDP - Provisioning ,  description: This table records the resubmission jobs for Oracle Service Fulfillment Manager. The fulfillment elements may be restarted in Order Resubmission mode to resubmit orders to the provisioning workflow. ,  implementation_dba_data: XDP.XDP_FA_RESUBMISSION_LOG , 

  • Table: XDP_FA_RUNTIME_LIST 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RUNTIME_LIST,  object_name:XDP_FA_RUNTIME_LIST,  status:VALID,  product: XDP - Provisioning ,  description: This table contains the list of the FAs which need to be executed for a workitem instance. ,  implementation_dba_data: XDP.XDP_FA_RUNTIME_LIST , 

  • Table: XDP_FES 12.2.2

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES,  object_name:XDP_FES,  status:VALID,  product: XDP - Provisioning ,  description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. ,  implementation_dba_data: XDP.XDP_FES , 

  • Table: XDP_FA_RUNTIME_LIST 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FA_RUNTIME_LIST,  object_name:XDP_FA_RUNTIME_LIST,  status:VALID,  product: XDP - Provisioning ,  description: This table contains the list of the FAs which need to be executed for a workitem instance. ,  implementation_dba_data: XDP.XDP_FA_RUNTIME_LIST , 

  • Table: XDP_FES 12.1.1

    owner:XDP,  object_type:TABLE,  fnd_design_data:XDP.XDP_FES,  object_name:XDP_FES,  status:VALID,  product: XDP - Provisioning ,  description: This table holds all the names of the Fulfillment Elements (Network Elements). This data contains the definition of a fulfillment element. ,  implementation_dba_data: XDP.XDP_FES ,