You are browsing the archive for Oracle Process Manufacturing Systems.

GMA: Edit Text Migration

 

NAME: GMA: Edit Text Migration
SHORT CODE: GMA_EDIT_TEXT
MODULE: Oracle Process Manufacturing Systems

Description: Edit Text Migration to Attachments
Navigation: Oracle Process Manufacturing Systems Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • migration_var : Entity Name which need to be migrated

 

Audit Trail Report

 

NAME: Audit Trail Report
SHORT CODE: GMAAUREP
MODULE: Oracle Process Manufacturing Systems

Description: Audit Trail Report
Navigation: Oracle Process Manufacturing Systems Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • P_REP_ID : Report ID
  • P_AUDIT_GROUP : Audit Group
  • P_TABLE_NAME : Table Name
  • P_USERNAME : User Name
  • P_TRANS_TYPE : Transaction Type
  • P_FROM_DATE : From Date
  • P_TO_DATE : To Date

 

Oracle Process Manufacturing Systems Tables

Oracle Process Manufacturing Systems – List of Tables:

  • GEM_LOOKUP_TYPES
  • GEM_LOOKUP_VALUES
  • GMA_ACTCOL_WF_B
  • GMA_ACTCOL_WF_TL
  • GMA_ACTDATA_WF
  • GMA_ACTDEF_WF
  • GMA_AUDIT_DISP_COLS
  • GMA_AUDIT_LKUPS
  • GMA_AUDIT_REP_DTL
  • GMA_AUDIT_REP_HDR
  • GMA_AUDIT_TMPLT_DTL
  • GMA_AUDIT_TMPLT_MST
  • GMA_MIGRATION_CONTROL
  • GMA_MIGRATION_LOG
  • GMA_PROCCOL_WF_B
  • GMA_PROCCOL_WF_TL
  • GMA_PROCDATA_WF
  • GMA_PROCDEF_WF
  • GMA_REASON_CODE_SECURITY
  • SY_ADDR_MST
  • SY_CMPY_MST
  • SY_DOCS_MST
  • SY_DOCS_SEQ
  • SY_GEOG_MST
  • SY_ORGN_MST
  • SY_ORGN_MST_B
  • SY_ORGN_MST_TL
  • SY_ORGN_USR
  • SY_PARA_CDS_TL
  • SY_PURG_DEF
  • SY_PURG_DEF_ACT
  • SY_PURG_DEF_CRIT
  • SY_PURG_ERR
  • SY_PURG_LOG
  • SY_PURG_MST
  • SY_PURG_MST_CRIT
  • SY_REAS_CDS
  • SY_REAS_CDS_B
  • SY_REAS_CDS_TL
  • SY_TEXT_HDR
  • SY_TEXT_TBL_TL
  • SY_TEXT_TKN_TL
  • SY_TRIGGER_ACTIVATION_WF
  • SY_UOMS_MST
  • SY_UOMS_STD
  • SY_UOMS_TYP