Search Results concurrent




Overview
Explore in AI Chat

Overview

The concurrent program FAMADEL — presented to users as Mass Additions Delete — is owned by the Oracle Assets module, identified in the ETRM as product OFA - Assets. It operates within the Oracle E-Business Suite releases 12.1.1 and 12.2.2 and is delivered in an Enabled state. Its functional purpose is to purge records from the Oracle Assets Mass Additions interface, removing rows that were staged through the Mass Additions process but are no longer required for capitalisation. This allows fixed asset administrators to clean the interface of duplicate, erroneous, or obsolete lines before the Create Accounting and post-to-asset routines are executed, keeping the FA_MASS_ADDITIONS staging table accurate and manageable.

Execution Details

The ETRM documentation defines the following execution metadata for FAMADEL:

  • User-facing name: Mass Additions Delete
  • Execution Method: Spawned
  • Argument Method: Database fetch
  • Executable: FAMADEL
  • Execution File: FAMADEL

The Spawned execution method indicates that the program invokes a spawned (child) process or C-based executable rather than running purely as PL/SQL inside the concurrent manager. The Database fetch argument method means parameters are not presented in the standard SRS parameter window for direct entry, but are resolved from database values — in this case keyed through the descriptive flexfield attribute ATTRIBUTE1 defaulting to $SRS$.FAMADEL. The documented request-set argument metadata confirms that ATTRIBUTE1 is set to display, insert, and update with this shared default value, which governs how the concurrent request identifies and selects the mass addition records to delete.

How to Run

Because the argument method is Database fetch with a shared descriptive flexfield default, FAMADEL is not typically submitted through the standard Submit Request parameter form. It is instead invoked through the Oracle Assets Mass Additions user interface, where delete actions on selected interface lines trigger the spawned executable, or it is submitted as part of a request set that supplies the $SRS$.FAMADEL value. Administrators who need to submit it directly use the standard Submit a New Request or Submit Request Set navigation (Requests > Run), selecting Mass Additions Delete from the OFA - Assets list of values. General guidance applies: verify that the target mass addition lines are genuinely deletable, confirm no downstream Create Assets request is still pending on the same rows, and review the concurrent request log and output after completion, since the spawned process can terminate with warnings if rows are locked or already transferred.

Related Objects

FAMADEL is closely associated with the Oracle Assets Mass Additions workflow objects:

  • FA_MASS_ADDITIONS — the interface table that stores staged mass addition lines; FAMADEL removes records from this table.
  • FA_MASS_ADDITIONS_DEL / related staging views used by the delete process.
  • FAMAPT — the Post Mass Additions concurrent program that transfers interface rows into FA_ASSETS.
  • FACOINP / FA_MASS_ADDITIONS import programs — feeders such as the Mass Additions Interface for Payables and the Create Assets interface that populate the staging table.
  • FA_ADDITIONS_A / FA_BOOKS — downstream asset and book tables affected once mass additions are posted.

Together these objects form the Mass Additions lifecycle; FAMADEL is the specialised cleanup step that removes unwanted staged rows before the posting programs run.

  • Concurrent Program: FAMADEL 12.1.1

    execution_filename: FAMADEL ,  product: OFA - Assets ,  user_name: FAMADEL ,  description: Mass Additions Delete ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FARXACA 12.1.1

    execution_filename: FARXPBSH ,  product: OFA - Assets ,  user_name: FARXPBSH ,  description: RXi Publishing Engine ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FAS460_XML 12.1.1

    product: OFA - Assets ,  user_name: Property Tax Report (XML) - Not Supported: Reserved For Future Use ,  description: Property Tax Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS530 12.1.1

    execution_filename: FAS530 ,  product: OFA - Assets ,  user_name: FAS530 ,  description: Transaction History Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: RXFACCA 12.1.1

    execution_filename: FA_RX_ALT_BAL.CIP_COST_BAL ,  product: OFA - Assets ,  user_name: RXFACCA ,  description: CIP Cost Balances (Alternate) Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAS421_XML 12.1.1

    product: OFA - Assets ,  user_name: Asset Additions By Cost Center Report (XML) - Not Supported: Reserved For Future Use ,  description: Asset Additions By Cost Center Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS520 12.1.1

    execution_filename: FAS520 ,  product: OFA - Assets ,  user_name: FAS520 ,  description: Tax Retirements Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS540_XML 12.1.1

    product: OFA - Assets ,  user_name: Tax Additions Report (XML) - Not Supported: Reserved For Future Use ,  description: Tax Additions Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FASMAIMR_XML 12.1.1

    product: OFA - Assets ,  user_name: Mass Additions Invoice Merge Report (XML) - Not Supported: Reserved For Future Use ,  description: Mass Additions Invoice Merge Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAMRCOSPR 12.1.1

    execution_filename: FA_MRC_OSPT_PKG.run_gain_loss ,  product: OFA - Assets ,  user_name: FAMRCOSPR ,  description: MRC: Run Calculate Gain Loss in all Set of BOoks ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FASRCPVW_XML 12.1.1

    product: OFA - Assets ,  user_name: Mass Reclassification Preview Report (XML) - Not Supported: Reserved For Future Use ,  description: Mass Reclassification Preview Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS823 12.1.1

    execution_filename: FAS823 ,  product: OFA - Assets ,  user_name: FAS823 ,  description: Mass Additions Status Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS441 12.1.1

    execution_filename: FAS441 ,  product: OFA - Assets ,  user_name: FAS441 ,  description: Asset Retirements By Cost Center Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FASMRETX 12.1.1

    execution_filename: FASMRETX ,  product: OFA - Assets ,  user_name: FASMRETX ,  description: Mass Retirements Exception Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAMRCOSPB 12.1.1

    execution_filename: FA_MRC_OSPT_PKG.run_rollback ,  product: OFA - Assets ,  user_name: FAMRCOSPB ,  description: MRC : Rollback Depreciation in all Ledgers ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAS930 12.1.1

    execution_filename: FAS930 ,  product: OFA - Assets ,  user_name: FAS930 ,  description: Leased Assets Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FASMRET_XML 12.1.1

    product: OFA - Assets ,  user_name: Mass Retirements Report (XML) ,  description: Mass Retirements Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS442 12.1.1

    execution_filename: FAS442 ,  product: OFA - Assets ,  user_name: FAS442 ,  description: Reinstated Assets Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FARXADD 12.1.1

    execution_filename: FARXPBSH ,  product: OFA - Assets ,  user_name: FARXPBSH ,  description: RXi Publishing Engine ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FASINSDR 12.1.1

    execution_filename: FASINSDR ,  product: OFA - Assets ,  user_name: FASINSDR ,  description: Insurance Data Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAMACH 12.1.1

    execution_filename: FAMACH ,  product: OFA - Assets ,  user_name: FAMACH ,  description: Mass Change Program ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FAS423 12.1.1

    execution_filename: FAS423 ,  product: OFA - Assets ,  user_name: FAS423 ,  description: Conversion Assets Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAS520_XML 12.1.1

    product: OFA - Assets ,  user_name: Tax Retirements Report (XML) - Not Supported: Reserved For Future Use ,  description: Tax Retirements Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS860_XML 12.1.1

    product: OFA - Assets ,  user_name: Mass Change Preview Report (XML) ,  description: Mass Change Preview Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS446 12.1.1

    execution_filename: FAS446 ,  product: OFA - Assets ,  user_name: FAS446 ,  description: Form 4797 - Sales or Exchange of Property Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAXLAUPGCP2 12.1.1

    execution_filename: FA_UPGHARNESS_PKG.upgrade_by_request2 ,  product: OFA - Assets ,  user_name: FAXLAUPGCP2 ,  description: Upgrade Historical Assets Depreciation for Subledger Accounting ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAWIPSTAT 12.1.1

    product: OFA - Assets ,  user_name: FA CIP Statistics for the Central Statistical Office (KSH) (Hungary) ,  description: Shows Fixed Asset CIP Statistics information in a period range. ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAMTFR 12.1.1

    execution_filename: FAMTFR ,  product: OFA - Assets ,  user_name: FAMTFR ,  description: Mass Transfer ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FASNBV_XML 12.1.1

    product: OFA - Assets ,  user_name: Diminishing Value Report (XML) - Not Supported: Reserved For Future Use ,  description: Diminishing Value Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: RXFAAL 12.1.1

    execution_filename: FARX_C_AL.ASSET_LISTING_RUN ,  product: OFA - Assets ,  user_name: FA Asset Listing By Period Report ,  description: FA Asset Listing By Period Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAS740_XML 12.1.1

    product: OFA - Assets ,  user_name: Asset Reclassification Report (XML) - Not Supported: Reserved For Future Use ,  description: Asset Reclassification Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAS447_XML 12.1.1

    product: OFA - Assets ,  user_name: Form 4797 - Ordinary Gains and Losses Report (XML) - Not Supported: Reserved For Future Use ,  description: Form 4797 - Ordinary Gains and Losses Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAPSGC 12.1.1

    execution_filename: FA_SUPER_GROUP_CHANGE_PKG.do_super_group_change ,  product: OFA - Assets ,  user_name: FAPSGC ,  description: Process Super Group Change ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FASMAINT_XML 12.1.1

    product: OFA - Assets ,  user_name: Asset Maintenance Report (XML) - Not Supported: Reserved For Future Use ,  description: Asset Maintenance Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FASRVRVW_XML 12.1.1

    product: OFA - Assets ,  user_name: Mass Revaluation Review Report (XML) - Not Supported: Reserved For Future Use ,  description: Mass Revaluation Review Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAMRCUPG2 12.1.1

    execution_filename: fa_mc_upg_convert_pkg.main_convert ,  product: OFA - Assets ,  user_name: FAMRCUPG2 ,  description: Convert Reporting Book Program ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAACCPB 12.1.1

    product: OFA - Assets ,  user_name: Create Accounting - Assets ,  description: Create Accounting Program for Assets ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FARXCAP 12.1.1

    execution_filename: FARXPBSH ,  product: OFA - Assets ,  user_name: FARXPBSH ,  description: RXi Publishing Engine ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FARXGA 12.1.1

    execution_filename: FARXPBSH ,  product: OFA - Assets ,  user_name: FARXPBSH ,  description: RXi Publishing Engine ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FAS448 12.1.1

    execution_filename: FAS448 ,  product: OFA - Assets ,  user_name: FAS448 ,  description: Retired Assets Without Retirement Types Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FASWIPSR 12.1.1

    execution_filename: FASCOSTS ,  product: OFA - Assets ,  user_name: FASCOSTS ,  description: Cost Summary Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Oracle Reports , 

  • Concurrent Program: FAVRVL 12.1.1

    execution_filename: FAVRVL ,  product: OFA - Assets ,  user_name: FAVRVL ,  description: Mass Revaluation Program ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FAS449_XML 12.1.1

    product: OFA - Assets ,  user_name: Form 4684 - Casualties and Thefts Report (XML) - Not Supported: Reserved For Future Use ,  description: Form 4684 - Casualties and Thefts Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FAMRCL 12.1.1

    execution_filename: FAMRCL ,  product: OFA - Assets ,  user_name: FAMRCL ,  description: Mass Reclassification Program ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: RXFARET 12.1.1

    execution_filename: FARX_C_RT.RET ,  product: OFA - Assets ,  user_name: RXFARET ,  description: RX: Retirements Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: FAS430_XML 12.1.1

    product: OFA - Assets ,  user_name: Asset Transfers Report (XML) - Not Supported: Reserved For Future Use ,  description: Asset Transfers Report ,  argument_method: Standard ,  enabled: No ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FASRVPVW_XML 12.1.1

    product: OFA - Assets ,  user_name: Mass Revaluation Preview Report (XML) ,  description: Revaluation Preview Report ,  argument_method: Standard ,  enabled: Yes ,  execution_method: Java Concurrent Program , 

  • Concurrent Program: FARXMT 12.1.1

    execution_filename: FARXPBSH ,  product: OFA - Assets ,  user_name: FARXPBSH ,  description: RXi Publishing Engine ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FAPPT 12.1.1

    execution_filename: FAMAPT ,  product: OFA - Assets ,  user_name: FAMAPT ,  description: Mass Additions Post ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned , 

  • Concurrent Program: FARXCCA 12.1.1

    execution_filename: FARXPBSH ,  product: OFA - Assets ,  user_name: FARXPBSH ,  description: RXi Publishing Engine ,  argument_method: Database fetch ,  enabled: Yes ,  execution_method: Spawned ,