Configuring Soft Delete
In Oracle E-Business Suite Data Intelligence, the soft delete feature is controlled by the SOFT_DELETE_PREPROCESS parameter.
Oracle E-Business Suite Data Intelligence supports soft delete for the following dimensions and facts:
| Group Code | Description | Fact/Dimension |
|---|---|---|
|
PRODCAT_DIM |
Product Category Dimension |
W_PROD_CAT_DH |
|
PURAGG_FG |
Purchase Agreement Fact Group |
W_PURCH_AGREEMENT_HEADER_F/W_PURCH_AGREEMENT_LINE_F |
|
SPEND_FG |
Spend Fact Group |
W_AP_INV_DIST_F |
|
GLSEG_DIM |
GL Segment Dimension |
W_GL_SEGMENT_D |
|
PARTYPER_DIM |
Party person Dimension |
W_PARTY_PER_D |
|
PONRESP_FG |
PO Negotiation Responses Fact Group |
W_NEG_AWARDS_F/W_NEG_RESPONSES_F |
|
PRJBUDGET_FG |
Project Budget Fact Group |
W_PROJ_BUDGET_F |
|
PRJCRSCHRG_FG |
Project Cross Charge Dist Line Fact Group |
W_PROJ_CROSS_CHARGE_DIST_F |
|
PRJREVN_FG |
Project Revenue Fact Group |
W_PROJ_REVENUE_HDR_F/W_PROJ_REVENUE_LINE_F |
|
PRJRSRCMGMT_FG |
Project Resource Management Fact Group |
W_PROJ_RSRC_RQRMNT_F/W_PROJ_RSRC_UTILIZATION_F |
|
PROCPURREQ_FG |
Procurement Purchase Requisition Fact Group |
W_PURCH_RQSTN_LINE_F/W_RQSTN_LINE_COST_F |
|
PRODUCT_DIM |
Product Catalog Dimension |
W_PRODUCT_CATALOG_D |
|
USER_DIM |
User Dimension |
W_USER_D |
|
NAT_ACCT_DIM |
Natural Account Dimension |
W_NATURAL_ACCOUNT_D |
|
PARTY_DIM |
Party Dimension |
W_PARTY_D |
|
PONNEG_FG |
PO Negotiation Fact Group |
W_NEG_INVITATIONS_F/W_NEG_LINES_F |
|
POSHIER_DIM |
Position Hierarchy Dimension |
W_POSITION_D |
|
PRJBILLING_FG |
Project Billing Fact Group |
W_PROJ_INVOICE_LINE_F |
|
PRJCOST_FG |
Project Cost Line Fact Group |
W_PROJ_COST_LINE_F |
|
PRJFRCST_FG |
Project Forecast Fact Group |
W_PROJ_FORECAST_F |
|
PRJFUNDING_FG |
Project Funding Fact Group |
W_PROJ_FUNDING_HDR_F/W_PROJ_FUNDING_LINE_F/W_PROJ_RETENTION_F |
|
PROCPURRCPT_FG |
Procurement Purchase Receipt Fact Group |
W_PURCH_RCPT_F |
|
SUPACCT_DIM |
Supplier Account Dimension |
W_SUPPLIER_ACCOUNT_D |
|
BALSEG_DIM |
Balancing Segment Dimension |
W_BALANCING_SEGMENT_D |
|
CUSTLOC_DIM |
Customer Location Dimension |
W_CUSTOMER_LOC_D |
|
BUSNLOC_DIM |
Business Location Dimension |
W_BUSN_LOCATION_D |
|
COSTCTR_DIM |
Cost Center Dimension |
W_COST_CENTER_HIER_PS |
|
EXPOVERVIEW_FG |
Employee Expense Overview Fact Group |
W_EXPENSE_F |
|
EXPVIOLATION_FG |
Employee Expense Violation Fact Group |
W_EXPENSE_VIOLATION_F |
|
INDUSTRY_DIM |
Industry Dimension |
W_INDUSTRY_DH |
|
INVPROD_DIM |
Inventory Product Dimension |
W_INVENTORY_PRODUCT_D |
|
PRJCIP_FG |
Project Cost InProgress Fact Group |
W_PROJ_CIP_DTL_F/W_PROJ_CIP_HDR_F |
|
APHOLDS_FG |
Accounts Payable Holds Fact Group |
W_AP_HOLDS_F |
|
APTRANS_FG |
Accounts Payable Transaction Fact Group |
W_AP_XACT_F |
|
ARTRANS_FG |
Accounts Receivable Transaction Fact Group |
W_AR_XACT_F |
|
CUSTACCT_DIM |
Customer Account Dimension |
W_CUSTOMER_ACCOUNT_D |
|
EMPLOYEE_DIM |
Employee Dimension |
W_EMPLOYEE_D |
|
FINPROFL_FG |
Customer Financial Profile Fact Group |
W_CUSTOMER_FIN_PROFL_F |
|
ASTXACT_FG |
Asset Transaction Fact Group |
W_FA_XACT_F |
|
CHLTYPE_DIM |
Channel Type Dimension |
W_CHNL_TYPE_D |
|
EXPCRDTCRD_FG |
Expense Credit Card Fact Group |
W_EXPENSE_CC_F |
|
INTORG_DIM |
Internal Organization Dimension |
W_ORA_INT_ORG_DH_PS |
|
PROCPO_FG |
Procurement Purchase Order Fact Group |
W_PURCH_SCHEDULE_LINE_F/W_PURCH_VARIANCE_XACT_F/W_PURCH_COST_F |