Search Results zpstr_ras sap table details




The SSP_MEDICALS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a custom table, as it does not exist in the standard Oracle EBS data dictionary. Based on the naming convention, it likely belongs to a custom module or extension, possibly related to medical or healthcare functionalities within the Self-Service Procurement (SSP) or a similar domain. Below is a detailed analysis of its potential structure, purpose, and integration within Oracle EBS.

1. Overview of SSP_MEDICALS Table

The SSP_MEDICALS table is presumed to store medical-related data, such as employee health records, medical reimbursements, or procurement of medical supplies. In Oracle EBS, custom tables like this are typically created to extend standard functionalities, often interfacing with modules like Oracle iProcurement, Payables, or Human Resources. The table might be part of a larger custom solution for tracking medical expenses, approvals, or inventory management.

2. Potential Table Structure

While the exact schema of SSP_MEDICALS is unknown, it likely includes the following columns:

  • MEDICAL_ID – Primary key, uniquely identifying each medical record.
  • EMPLOYEE_ID – Foreign key linking to PER_ALL_PEOPLE_F (HR employees table).
  • ITEM_CODE – References medical supplies or services (possibly linked to MTL_SYSTEM_ITEMS_B).
  • QUANTITY – Number of units procured or consumed.
  • COST – Monetary value of the medical item or service.
  • STATUS – Tracks approval workflow (e.g., "Pending," "Approved," "Rejected").
  • CREATION_DATE – Audit column for record creation.
  • LAST_UPDATE_DATE – Audit column for modifications.

3. Integration with Oracle EBS Modules

The SSP_MEDICALS table likely integrates with the following Oracle EBS modules:

  • Self-Service Procurement (iProcurement) – If used for medical supply requisitions, it may interface with PO_REQUISITIONS_INTERFACE or PO_HEADERS_ALL.
  • Payables (AP) – For reimbursements, it might feed data into AP_INVOICES_ALL.
  • Human Resources (HR) – If tracking employee health records, it could link to PER_ALL_ASSIGNMENTS_F.
  • Inventory (INV) – If managing medical stock, it may reference MTL_ONHAND_QUANTITIES.

4. Custom Workflow and Extensions

Since SSP_MEDICALS is not a standard Oracle table, it likely relies on custom PL/SQL triggers, APIs, or Oracle Workflow to automate processes like approvals or notifications. For example:

  • A trigger might validate medical requests against budget limits in GL_JE_LINES.
  • An API could sync approved records to AP_EXPENSE_REPORT_HEADERS_ALL for reimbursement.

5. Reporting and Analytics

Reports on medical expenditures or inventory levels may use SSP_MEDICALS alongside standard Oracle BI Publisher or OTBI templates. SQL queries might join this table with FND_USER for requester details or GL_CODE_COMBINATIONS for accounting data.

6. Conclusion

The SSP_MEDICALS table exemplifies how Oracle EBS can be extended to support niche requirements like medical tracking. While its exact implementation depends on organizational needs, it typically interfaces with procurement, HR, and financial modules, leveraging Oracle's robust workflow and integration capabilities. Proper documentation and alignment with Oracle's data governance standards are critical for maintaining such custom solutions.

  • Concurrent Program: SAPRPELR 12.2.2

    execution_filename: SSPSAPEL ,  product: SSP - SSP ,  user_name: SAPRPELR ,  description: SAP Element Results Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: SAPRPELR 12.1.1

    execution_filename: SSPSAPEL ,  product: SSP - SSP ,  user_name: SAPRPELR ,  description: SAP Element Results Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Table: SSP_MEDICALS 12.2.2

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_MEDICALS,  object_name:SSP_MEDICALS,  status:VALID,  product: SSP - SSP ,  description: Medical reports of sickness or evidence of maternity for a person. ,  implementation_dba_data: SSP.SSP_MEDICALS , 

  • Table: SSP_TEMP_AFFECTED_ROWS 12.2.2

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_TEMP_AFFECTED_ROWS,  object_name:SSP_TEMP_AFFECTED_ROWS,  status:VALID,  product: SSP - SSP ,  description: For internal Oracle use only. ,  implementation_dba_data: SSP.SSP_TEMP_AFFECTED_ROWS , 

  • Table: SSP_STOPPAGES 12.2.2

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_STOPPAGES,  object_name:SSP_STOPPAGES,  status:VALID,  product: SSP - SSP ,  description: Periods of non-entitlement to a given element. ,  implementation_dba_data: SSP.SSP_STOPPAGES , 

  • Table: SSP_MATERNITIES 12.2.2

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_MATERNITIES,  object_name:SSP_MATERNITIES,  status:VALID,  product: SSP - SSP ,  description: Record of a woman's maternities/pregnancies. ,  implementation_dba_data: SSP.SSP_MATERNITIES , 

  • Table: SSP_EARNINGS_CALCULATIONS 12.1.1

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_EARNINGS_CALCULATIONS,  object_name:SSP_EARNINGS_CALCULATIONS,  status:VALID,  product: SSP - SSP ,  description: Calculations of average weekly earnings for the purposes of determining entitlement to SSP/SMP. ,  implementation_dba_data: SSP.SSP_EARNINGS_CALCULATIONS , 

  • Table: SSP_TEMP_AFFECTED_ROWS 12.1.1

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_TEMP_AFFECTED_ROWS,  object_name:SSP_TEMP_AFFECTED_ROWS,  status:VALID,  product: SSP - SSP ,  description: For internal Oracle use only. ,  implementation_dba_data: SSP.SSP_TEMP_AFFECTED_ROWS , 

  • Table: SSP_MEDICALS 12.1.1

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_MEDICALS,  object_name:SSP_MEDICALS,  status:VALID,  product: SSP - SSP ,  description: Medical reports of sickness or evidence of maternity for a person. ,  implementation_dba_data: SSP.SSP_MEDICALS , 

  • Table: SSP_STOPPAGES 12.1.1

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_STOPPAGES,  object_name:SSP_STOPPAGES,  status:VALID,  product: SSP - SSP ,  description: Periods of non-entitlement to a given element. ,  implementation_dba_data: SSP.SSP_STOPPAGES , 

  • Table: SSP_MATERNITIES 12.1.1

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_MATERNITIES,  object_name:SSP_MATERNITIES,  status:VALID,  product: SSP - SSP ,  description: Record of a woman's maternities/pregnancies. ,  implementation_dba_data: SSP.SSP_MATERNITIES , 

  • Table: SSP_EARNINGS_CALCULATIONS 12.2.2

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_EARNINGS_CALCULATIONS,  object_name:SSP_EARNINGS_CALCULATIONS,  status:VALID,  product: SSP - SSP ,  description: Calculations of average weekly earnings for the purposes of determining entitlement to SSP/SMP. ,  implementation_dba_data: SSP.SSP_EARNINGS_CALCULATIONS , 

  • Table: SSP_WITHHOLDING_REASONS 12.2.2

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_WITHHOLDING_REASONS,  object_name:SSP_WITHHOLDING_REASONS,  status:VALID,  product: SSP - SSP ,  description: Reasons for withholding payment of a specified element. ,  implementation_dba_data: SSP.SSP_WITHHOLDING_REASONS , 

  • Table: SSP_WITHHOLDING_REASONS 12.1.1

    owner:SSP,  object_type:TABLE,  fnd_design_data:SSP.SSP_WITHHOLDING_REASONS,  object_name:SSP_WITHHOLDING_REASONS,  status:VALID,  product: SSP - SSP ,  description: Reasons for withholding payment of a specified element. ,  implementation_dba_data: SSP.SSP_WITHHOLDING_REASONS , 

  • File: SSP_Tables.html 12.1.1

    product: SSP - SSP ,  size: 100.044 KBytes ,  file_type: HTML Report ,  description: SSP_Tables.html is an html report that documents the table and view definitions for the SSP product. , 

  • File: SSP_Tables.html 12.2.2

    product: SSP - SSP ,  size: 101.374 KBytes ,  file_type: HTML Report ,  description: SSP_Tables.html is an html report that documents the table and view definitions for the SSP product. , 

  • View: SSP_SSPRPSMP_V 12.1.1

    owner:APPS,  object_type:VIEW,  fnd_design_data:SSP.SSP_SSPRPSMP_V,  object_name:SSP_SSPRPSMP_V,  status:VALID,  product: SSP - SSP ,  description: Details of a Maternity Pay Period, including derived dates, used in SMP reports. ,  implementation_dba_data: APPS.SSP_SSPRPSMP_V , 

  • View: SSP_SSPRPSMP_V 12.2.2

    owner:APPS,  object_type:VIEW,  fnd_design_data:SSP.SSP_SSPRPSMP_V,  object_name:SSP_SSPRPSMP_V,  status:VALID,  product: SSP - SSP ,  description: Details of a Maternity Pay Period, including derived dates, used in SMP reports. ,  implementation_dba_data: APPS.SSP_SSPRPSMP_V ,