Search Results msc_questions_s

Overview

APPS.MSC_ASK_ORACLE is a PL/SQL package body in the Oracle E-Business Suite Advanced Supply Chain Planning (ASCP) schema. It implements the "Ask Oracle" mechanism, a guided inquiry and answer framework used within the planning application to pose planning questions and retrieve structured responses and pegged supply/demand detail. The package is classified as OTHER in the ETRM metadata, indicating it is not a published open interface but an internal component supporting planning diagnostics and inquiry flows. Its status is VALID, and it is owned by the APPS schema.

The package operates on the MSC_QUESTIONS and MSC_ANSWERS table families, using question and answer identifiers stored in _S sequence-backed columns and translatable content in _B and _TL tables. In the context of Oracle EBS 12.1.1 and 12.2.2, it serves as the persistence and lookup layer beneath the Ask Oracle feature, letting the application register a question, record a user's selection, and resolve the answer to associated planning entities such as supplies, demands, tasks, and resource requirements.

Key Procedures and Functions

The documented package exposes nine procedures and functions:

• REGISTER_QUESTION — Registers a question definition for use in the Ask Oracle framework, establishing the question metadata and its translatable entries.
• ASK — Drives the asking of a question, presenting or processing the question in a given planning context.
• GET_QUESTION — Retrieves a previously registered question by its identifier for display or processing.
• GET_KEY — Resolves or generates the key identifying a question or answer record.
• GET_ANSWER_ID — Returns the answer identifier associated with a question or context, linking the user response to stored entries.
• INSERT_ANSWER — Inserts a new answer record into the answers tables.
• LATE_PRJ — Supports late-project analysis, evaluating project tasks relevant to a question or answer.
• LATE_SUPPLY — Supports late-supply analysis, identifying supplies that are late relative to the question context.
• LATE_DEMAND — Supports late-demand analysis, identifying demands that are late relative to the question context.

Tables Accessed

The package references the following tables via APPS synonyms: MSC_ANSWERS and MSC_ANSWERS_S (answer records and their sequence), MSC_QUESTIONS_B, MSC_QUESTIONS_S, and MSC_QUESTIONS_TL (question base, sequence, and translatable content), MSC_DEMANDS, MSC_SUPPLIES, MSC_FULL_PEGGING, and MSC_RESOURCE_REQUIREMENTS (planning detail used in late-supply, late-demand, and pegging analysis), and DUAL. Additional dependencies include PA_TASKS_V and PJM_TASKS_V views for project task information, FND_GLOBAL for session context such as user and responsibility, and MSC_UTIL for shared utility logic.

Usage Notes

MSC_ASK_ORACLE is an internal ASCP component, not a public API. It is typically invoked from planning inquiry forms and concurrent processing logic that present Ask Oracle questions and persist answers. Because it is not referenced by any other database object, it is called directly from application code rather than through inter-package dependencies. Customizations should treat it as unsupported and confine extensions to read-only queries of MSC_QUESTIONS and MSC_ANSWERS; any modification to the package or its tables risks invalidating the ASCP Ask Oracle feature. The user search term "msc_questions_s" corresponds to the MSC_QUESTIONS_S sequence table referenced by this package.