Search Results concurrent




Overview
Explore in AI Chat

Overview

The concurrent program ASFLDLVS belongs to the ASF - Sales Online product module within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Its user-facing name is Initial Load for Leads reports, and it is also described in the ETRM documentation as the program responsible for executing an Initial Load for Leads process. ASF - Sales Online is the Oracle Sales foundation layer that underpins lead and opportunity management, and this program supports the bulk or initial population of lead data used by downstream reporting. According to the documented metadata, the program is not enabled (Enabled: No), which indicates that Oracle has either deprecated it, superseded it with a newer mechanism, or expects it to be enabled only in specific implementations or upgrade scenarios. Because the ETRM record is a formal, Oracle Proprietary, Confidential Information artifact, it should be treated as the authoritative reference for the object's identity and configuration.

Execution Details

The documented execution method is SQL*Plus, which means the program is not a PL/SQL stored procedure or Java concurrent program; instead it runs a SQL*Plus script against the database. The Argument Method is Standard, indicating that any parameters are supplied through the standard Oracle Applications concurrent program parameter window rather than through a token-substitution or custom method. The executable is named ASFLDLVS with the same user-facing name, and the execution file name is asfldlvs. The subroutine name field is empty in the metadata, consistent with the SQL*Plus execution style where the script body itself contains the logic. All of these attributes should be verified against the actual Concurrent Programs form (Application Developer > Concurrent > Program) in a target instance, since the ETRM describes the object but not the contents of the underlying script.

How to Run

In a standard EBS configuration the program would be submitted via the Submit Request (SRS) window, typically from Requests > Run, or through a responsibility that includes ASF - Sales Online functionality. Because the program is marked Enabled: No, it will not appear in the list of values for most responsibilities unless it is explicitly enabled by an administrator. General guidance for initial load concurrent programs of this type is to run them in a controlled maintenance window, with no active user transaction load against leads tables, and to confirm that any prerequisite setups (such as lead source, sales channel, and territory definitions) are complete before submission. Parameter prompting, if any, should be reviewed in the Parameters region of the Concurrent Programs form; the metadata does not specify individual parameters, so the live definition or the executable script should be inspected to determine expected inputs.

Related Objects

Programs of this nature are commonly associated with lead and opportunity interface tables used by the Sales Online (ASF) and TCA (Trading Community Architecture) schemas, as well as with the ASF lead base tables and the reporting views consumed by lead-related reports. The program name Initial Load for Leads reports suggests a relationship to lead reporting structures, and it would ordinarily be scheduled alongside or after initial data conversion loads. Administrators should cross-reference the program with the ASF lead interface and reporting components documented elsewhere in the ETRM, and confirm whether a replacement program now performs the initial load in later point releases of 12.2.x.

  • Concurrent Program: ASFLDLVS 12.1.1

    execution_filename: asfldlvs ,  product: ASF - Sales Online ,  user_name: ASFLDLVS ,  description: Initial Load for Leads reports ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFRVSC 12.1.1

    execution_filename: asfrvsc ,  product: ASF - Sales Online ,  user_name: ASFRVSC ,  description: Refresh of Opportunity Bins Data ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFOPLVS 12.1.1

    execution_filename: asfoplvs ,  product: ASF - Sales Online ,  user_name: ASFOPLVS ,  description: Initial Load for opportunities reports ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFLDLVS 12.2.2

    execution_filename: asfldlvs ,  product: ASF - Sales Online ,  user_name: ASFLDLVS ,  description: Initial Load for Leads reports ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFROSID 12.2.2

    execution_filename: AS_OSI_DENORM_REF.Refresh_OSI_Denorm ,  product: ASF - Sales Online ,  user_name: ASFROSID ,  description: Refresh ASF_OSI_DENORM ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ASFFRVH 12.1.1

    execution_filename: asffrvh ,  product: ASF - Sales Online ,  user_name: ASFFRVH ,  description: Periodically Purge ASF_RECORD_VIEW_HISTORY ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFDTBL 12.1.1

    execution_filename: asfdrptbl ,  product: ASF - Sales Online ,  user_name: ASFDTBL ,  description: Drop temp tables for Home page MVs ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFROSID 12.1.1

    execution_filename: AS_OSI_DENORM_REF.Refresh_OSI_Denorm ,  product: ASF - Sales Online ,  user_name: ASFROSID ,  description: Refresh ASF_OSI_DENORM ,  argument_method: Standard ,  enabled: No ,  execution_method: PL/SQL Stored Procedure , 

  • Concurrent Program: ASFFCMVR 12.2.2

    execution_filename: asffcmvr ,  product: ASF - Sales Online ,  user_name: ASFFCMVR ,  description: Refresh MViews for Forecast reports on Home page ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFSIMSP 12.2.2

    execution_filename: asflsrec ,  product: ASF - Sales Online ,  user_name: ASFSIMSP ,  description: Opportunity Exchange - Get Opportunity ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFLVOL 12.1.1

    execution_filename: asflvol ,  product: ASF - Sales Online ,  user_name: ASFLVOL ,  description: Initial Build of Opportunity and Leads Bins ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFINDXC 12.2.2

    execution_filename: asfindx ,  product: ASF - Sales Online ,  user_name: ASFINDXC ,  description: Index creation for missing indexes for MVs ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFSIMPL 12.2.2

    execution_filename: asflssen ,  product: ASF - Sales Online ,  user_name: ASFSIMPL ,  description: Opportunity Exchange - Push Opportunity ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASXSFIMP 12.2.2

    product: ASF - Sales Online ,  user_name: Load Sales LeadInterface from flat file - >> change the application name ,  description: Import sales lead data from a flat file into interface tables ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Loader , 

  • Concurrent Program: ASFOPLVS 12.2.2

    execution_filename: asfoplvs ,  product: ASF - Sales Online ,  user_name: ASFOPLVS ,  description: Initial Load for opportunities reports ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFFCMVR 12.1.1

    execution_filename: asffcmvr ,  product: ASF - Sales Online ,  user_name: ASFFCMVR ,  description: Refresh MViews for Forecast reports on Home page ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFSIMPL 12.1.1

    execution_filename: asflssen ,  product: ASF - Sales Online ,  user_name: ASFSIMPL ,  description: Opportunity Exchange - Push Opportunity ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFDLST 12.1.1

    execution_filename: asfdlst ,  product: ASF - Sales Online ,  user_name: ASFDLST ,  description: Purge Deleted Lists ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFRVSL 12.1.1

    execution_filename: asfrvsl ,  product: ASF - Sales Online ,  user_name: ASFRVSL ,  description: Refresh of Leads Bin Data ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFDTBL 12.2.2

    execution_filename: asfdrptbl ,  product: ASF - Sales Online ,  user_name: ASFDTBL ,  description: Drop temp tables for Home page MVs ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFRVSL 12.2.2

    execution_filename: asfrvsl ,  product: ASF - Sales Online ,  user_name: ASFRVSL ,  description: Refresh of Leads Bin Data ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFDLST 12.2.2

    execution_filename: asfdlst ,  product: ASF - Sales Online ,  user_name: ASFDLST ,  description: Purge Deleted Lists ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFINDXC 12.1.1

    execution_filename: asfindx ,  product: ASF - Sales Online ,  user_name: ASFINDXC ,  description: Index creation for missing indexes for MVs ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASXSFIMP 12.1.1

    product: ASF - Sales Online ,  user_name: Load Sales LeadInterface from flat file - >> change the application name ,  description: Import sales lead data from a flat file into interface tables ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Loader , 

  • Concurrent Program: ASFSIMSP 12.1.1

    execution_filename: asflsrec ,  product: ASF - Sales Online ,  user_name: ASFSIMSP ,  description: Opportunity Exchange - Get Opportunity ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFFRVH 12.2.2

    execution_filename: asffrvh ,  product: ASF - Sales Online ,  user_name: ASFFRVH ,  description: Periodically Purge ASF_RECORD_VIEW_HISTORY ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFLVOL 12.2.2

    execution_filename: asflvol ,  product: ASF - Sales Online ,  user_name: ASFLVOL ,  description: Initial Build of Opportunity and Leads Bins ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus , 

  • Concurrent Program: ASFRVSC 12.2.2

    execution_filename: asfrvsc ,  product: ASF - Sales Online ,  user_name: ASFRVSC ,  description: Refresh of Opportunity Bins Data ,  argument_method: Standard ,  enabled: No ,  execution_method: SQL*Plus ,