Results for “okl_fun_validate_rsts”
26 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.OKL_CREDIT_CHECKLISTS_UV is a user-facing (UV) view within the Oracle E-Business Suite Lease and Finance Management (OKL) module. Its purpose is to present the credit checklist configuration used by the lease credit approval workflow, resolving the underlying flexfield segments stored in OKC_RULES_B into human-readable meaning columns. Each row represents a single checklist item (todo item) associated with a credit rule group, exposing the item code, whether the item is mandatory, whether it is checked off, its validation status, and any associated function-driven validation logic.
Because credit approval decisions depend on a defined sequence of checklist items and their pass/fail outcomes, this view serves as the reporting and integration layer over that configuration. Rather than exposing raw rule information segments, it decodes them into meaningful values via FND_LOOKUPS, which makes it suitable for both internal EBS inquiry screens and external reporting extracts.
The view is particularly relevant to the lookup code okl_fun_validate_rsts: the validation status of each checklist item is derived from the OKL_FUN_VALIDATE_RSTS lookup type, and columns such as FUNCTION_VALIDATE_RSTS, FUNC_VAL_RSTS_MEANING, and CHECKIST_RESULTS are driven by this lookup.
Underlying Base Objects
The view is built from the following documented base objects:
- OKC_RULES_B (synonym) — the primary rule/checklist repository. Rows are filtered where RULE_INFORMATION_CATEGORY = 'LACCLD'. The rule information segments (RULE_INFORMATION1 through RULE_INFORMATION10) supply todo item code, mandatory flag, check-off indicator, note, status, admin note, function validation result, validation message, function ID, and checklist type.
- FND_LOOKUPS (view) — joined six times (LK1–LK6) to translate codes into meanings for OKL_TODO_ITEMS, YES_NO, OKL_FUN_VALIDATE_RSTS, OKL_CHECKLIST_TYPE, and status results.
- OKC_STATUSES_V (view) — supplies status code and meaning for the rule record.
- OKL_DATA_SRC_FNCTNS_B (synonym) — outer-joined via FUNCTION_ID (RULE_INFORMATION9) to return the function name and source of the validation function.
- FND_PROFILE (package) — used to retrieve the OKL_CREDIT_LINE_APPROVER profile value, exposed as APPROVERYN.
- FND_GLOBAL (package) — standard EBS context package referenced in the view definition.
Key Columns
- TODO_ITEM_CODE / TODO_ITEM_MEANING — the checklist item identifier and its decoded description.
- MANDATORY_FLAG / MANDATORY_FLAG_MEANING — whether the item must be completed.
- CHECK_OFF / CHECK_OFF_MEANING — whether the item has been checked off.
- CHECK_OFF_RESULTS / CHECKIST_RESULTS — the outcome (PASSED, FAILED, UNDETERMINED). Where a validation function exists, the function's result meaning is used instead.
- STATUS / STATUS_MEANING — status of the checklist rule, defaulting to 'NEW'.
- FUNCTION_VALIDATE_RSTS / FUNC_VAL_RSTS_MEANING — the function validation result and its lookup meaning (OKL_FUN_VALIDATE_RSTS), defaulting to 'UNDETERMINED'.
- FUNCTION_VALIDATE_MSG, FUNCTION_ID, FUNCTION_NAME, FUNCTION_SOURCE — details of the validation function and any message returned.
- CHECKLIST_TYPE / CHECKLIST_TYPE_MEANING — defaults to 'ACTIVATION'.
- APPROVERYN — derived from the OKL_CREDIT_LINE_APPROVER profile option.
- KHR_ID, RGP_ID, ID — identifiers linking the checklist to the rule group and source credit request.
Common Use Cases and Queries
A typical use case is auditing outstanding credit checklist items that remain mandatory but unchecked, or reviewing function validation results. Because the user specifically searched for okl_fun_validate_rsts, a natural query filters on the validation result meaning:
- SELECT id, khr_id, todo_item_code, mandatory_flag_meaning, check_off_results, function_validate_rsts, func_val_rsts_meaning FROM apps.okl_credit_checklists_uv WHERE function_validate_rsts = 'UNDETERMINED';
- SELECT khr_id, todo_item_code, status_meaning, checklist_type_meaning FROM apps.okl_credit_checklists_uv WHERE mandatory_flag = 'Y' AND check_off = 'N';
- Querying FUNCTION_NAME and FUNCTION_SOURCE to identify which validation functions are attached to checklist items for troubleshooting credit approval failures.
The view is also useful for integration extracts that feed credit decisioning engines, since it delivers fully decoded checklist state without requiring callers to understand the OKC_RULES_B flexfield layout.
-
Function validation results
-
Function validation results
-
User inteface view for lease creditline checklist
APPS.OKL_CREDIT_CHECKLISTS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_PROFILE·Explore OKL module →
-
Funding Checklist Instance Details
APPS.OKL_INSTANCE_CHECKLIST_DTL_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_CHECKLIST_DETAILS·Explore OKL module →
-
User interfacer view for funding checklist details page
APPS.OKL_CHECKLIST_DETAILS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_CHECKLISTS·Explore OKL module →
-
User interfacer view for funding checklist details page
APPS.OKL_CHECKLIST_DETAILS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_CHECKLISTS·Explore OKL module →
-
Funding Checklist Instance Details
APPS.OKL_INSTANCE_CHECKLIST_DTL_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ OKL_CHECKLIST_DETAILS·Explore OKL module →
-
User inteface view for lease creditline checklist
APPS.OKL_CREDIT_CHECKLISTS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_PROFILE·Explore OKL module →
-
User Interface view for lease funding checklist
APPS.OKL_FUNDING_CHECKLISTS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_PROFILE·Explore OKL module →
-
User Interface view for lease funding checklist
APPS.OKL_FUNDING_CHECKLISTS_UV·↳ FND_GLOBAL·↳ FND_LOOKUPS·↳ FND_PROFILE·Explore OKL module →
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 FND Design Data 12.2.2