Search Results lns_events




Overview
Explore in AI Chat

Overview

LNS_EVENTS is a reference and configuration table within the Oracle E-Business Suite Loans (LNS) module. It stores the actionable events that can be defined against a given loan class. In the LNS functional model, a loan class groups loans that share processing behavior, and the events recorded here represent the discrete business actions that the system can raise, enable, or route for loans of that class. Because workflow integration is part of its design, each row also carries the association to a workflow business event, allowing Oracle Workflow to react when a loan event is triggered.

The table is owned by the LNS schema and holds 13 documented columns in the 12.2.2 physical schema. Its primary key is LNS_EVENTS_PK, defined on EVENT_ID. A unique index, LNS_EVENTS_U1, is defined on the combination of EVENT_ID and ZD_EDITION_NAME, which reflects the editioning support introduced in the 12.2.x code line; in 12.1.1 the edition column is not present. From a Data Vault modeling perspective, the mined foreign key structure classifies this object as hub-leaning: EVENT_ID behaves as a durable business key that anchors dependent detail elsewhere, rather than as a transactional fact.

Key Information Stored

The documented columns support identification, classification, enablement, and audit of each loan event.

  • EVENT_ID — Surrogate primary key of the table, defined by LNS_EVENTS_PK. It is the column referenced by dependent tables and should be treated as the stable identifier for an event definition.
  • LOAN_CLASS_CODE — Identifies the loan class to which the event belongs, tying the event definition to a specific group of loans.
  • EVENT_NAME — The functional name of the actionable event as presented to users and referenced in setup.
  • DESCRIPTION — Free-text explanation of the event's purpose and expected behavior.
  • ENABLED_FLAG — Controls whether the event is active for the loan class; disabled events are not raised during processing.
  • WF_BUSINESS_EVENT — The Oracle Workflow business event name associated with the loan event, used to trigger workflow subscriptions when the event occurs.
  • OBJECT_VERSION_NUMBER — Optimistic locking column used by the OA Framework and concurrent programs to detect conflicting updates.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard who-column audit attributes recording insert and update context.
  • ZD_EDITION_NAME — Editioning column present in the 12.2.x schema, participating in the LNS_EVENTS_U1 unique index alongside EVENT_ID.

Note that EVENT_ID is a surrogate key generated by the application, whereas the unique index LNS_EVENTS_U1 (EVENT_ID, ZD_EDITION_NAME) is the closest documented business-key candidate combination.

Common Use Cases and Queries

Typical usage centers on setup verification, troubleshooting event-driven processing, and reporting on which events are active per loan class.

  • Listing all enabled events for a loan class: 
    SELECT event_id, event_name, wf_business_event
FROM   lns_events
WHERE  loan_class_code = :loan_class
AND    enabled_flag = 'Y';
  • Resolving the workflow trigger behind a raised event: join LNS_EVENTS to LNS_EVENT_ACTIONS and inspect the business event name to confirm which Workflow subscription should fire.
  • Auditing configuration drift between environments by comparing EVENT_NAME and ENABLED_FLAG across instances for the same LOAN_CLASS_CODE.
  • Detecting stale definitions using LAST_UPDATE_DATE, for example to report events not maintained since a given date.

Related Objects

The documented foreign key relationship identifies the principal dependent object, with additional LNS setup and transaction tables commonly joined for context.

  • LNS_EVENT_ACTIONS — Child table joined on LNS_EVENT_ACTIONS.EVENT_ID = LNS_EVENTS.EVENT_ID; holds the actions performed when an event is raised.
  • LNS loan class setup tables — Reference LOAN_CLASS_CODE to describe the loan class owning each event.
  • Oracle Workflow tables (WF_*) — Consumed via WF_BUSINESS_EVENT to resolve subscriptions and event delivery.
  • LNS_EVENTS_PK / LNS_EVENTS_U1 — Constraint and unique index objects that enforce row identity and edition-aware uniqueness.