Search Results late_demand

Overview

APPS.MSC_ASK_ORACLE is a supplementary PL/SQL package within the Oracle Advanced Supply Chain Planning (ASCP) schema, delivered as part of the MSC (Master Scheduling/MSC) application family. The package supports the "Ask Oracle" mechanism in Oracle E-Business Suite, a planning decision-support framework that presents interactive questions to planners and captures their answers so that the planning engine can adjust supply, demand, or resource outcomes accordingly. The package is declared with AUTHID CURRENT_USER, indicating that its SQL statements execute under the privileges of the invoking user rather than the package owner, which is consistent with a controlled planning utility that operates on synonym-based access paths.

The package was introduced around the 11i/12.0 era (the header indicates revision 120.2, dated 2005) and remains documented in ETRM for 12.1.1 and 12.2.2. Its primary responsibilities are the registration of question definitions, the retrieval of question context and keys, and the recording of planner responses against a given plan.

Key Procedures and Functions

• REGISTER_QUESTION — Registers a question definition, including its question code, type, language code, question text, and the package that implements or owns the question logic. It supports copying an existing question.
• ASK (function, returns BOOLEAN) — Presents a question in the context of a plan, passing question type, question text, plan identifier, and up to four numeric key values. It returns the resulting answer identifier, an error message, and a message count.
• GET_QUESTION — Retrieves the current question context, returning the question identifier, question type, and question code.
• GET_KEY — Returns the question type together with the plan identifier and the first two key values (key1 and key2), allowing downstream logic to reconstruct the context of the question being answered.
• GET_ANSWER_ID — Returns the identifier of the current or most recently created answer record.
• INSERT_ANSWER — Inserts an answer row keyed by answer identifier, question identifier, sequence, and answer text.
• LATE_PRJ — Handles the "late project" answer path, receiving an answer identifier and error/message outputs.
• LATE_SUPPLY — Handles the "late supply" answer path, using the same answer identifier and error/message outputs.
• LATE_DEMAND — Handles the "late demand" answer path.

Tables Accessed

The package reads and writes planning tables through APPS synonyms. MSC_QUESTIONS_B, MSC_QUESTIONS_S, and MSC_QUESTIONS_TL store the question base definition, sequence/settings, and translated question text. MSC_ANSWERS and MSC_ANSWERS_S hold the answers and their sequences produced by planners. MSC_DEMANDS, MSC_SUPPLIES, MSC_FULL_PEGGING, and MSC_RESOURCE_REQUIREMENTS are consulted or adjusted when the late-demand, late-supply, and late-project routines evaluate planning data. DUAL is used for single-row PL/SQL evaluations.

Usage Notes

MSC_ASK_ORACLE is not typically invoked directly by end users. It is called from the Ask Oracle forms and from concurrent or planning-engine code paths that drive planner interaction during a plan run. The get_key procedure is commonly referenced by custom extensions that need to recover the plan and key context of the active question before performing additional validation or writing supplemental answers. Because the package is referenced by no other documented packages, custom code that depends on it should treat the API as a private planning utility and guard against signature changes across EBS releases.