Search Results validate_rs_dates_customer
Overview
MSC_SCE_LOADS_PKG is an Oracle EBS Applications (APPS) schema PL/SQL package that belongs to the Advanced Supply Chain Planning (ASCP) module, specifically the Supply Chain Engine (SCE) load-processing layer. Its object name, containing the "SCE_LOADS" token, indicates its role in the loading, validation, and processing of data into the supply chain planning engine — most notably supply/demand entries used during plan runs. In 12.1.1 and 12.2.2, ASCP uses the MSC (Materials/Supply Chain) schema objects to stage and publish planning data, and this package acts as a utility and validation library invoked across that pipeline. It carries an API classification of OTHER, meaning it is an internal engine utility package rather than a formally published public API, though it is referenced by twelve other packages in the MSC namespace.
Key Procedures and Functions
The documented package exposes nineteen procedures and functions covering four broad concerns:
- User and notification handling: GET_USER_ID resolves the current FND user; SEND_NTF dispatches a workflow or notification message; GET_MESSAGE and BUILD_ERROR_STRING retrieve and assemble user-facing error text; LOG_MESSAGE writes diagnostic output.
- Validation logic: VALIDATE and CHECKDATES perform general record and date checks; SERIAL_VALIDATION validates serial-number data; VALIDATE_RS_DATES_SUPPLIER and VALIDATE_RS_DATES_CUSTOMER validate reporting-set date ranges for supplier and customer perspectives respectively.
- Supply/demand processing: REPLACE_SUPDEM_ENTRIES and UPDATE_QTY_FROM_UI manage changes to supply/demand rows; GET_QUANTITY retrieves quantity values; GET_OPTIONAL_INFO returns supplementary attributes; POST_PROCESS finalizes and applies processing results; UPDATE_ERRORS records error details.
- Utility and performance operations: CHANGE_DATE_FORMAT normalizes date string formatting; DROP_INDEX and CREATE_INDEX manage indexes to improve bulk-load throughput during planning data staging.
Tables Accessed
The package reads and writes both ASCP planning tables and shared FND infrastructure, all via APPS synonyms:
- Supply/demand staging: MSC_SUPDEM_LINES_INTERFACE and MSC_SUP_DEM_ENTRIES store the incoming and consolidated supply/demand rows this package validates, replaces, and post-processes.
- Master data: MSC_SYSTEM_ITEMS, MSC_COMPANIES, and MSC_COMPANY_SITES supply item, organization, and site context; MSC_SERIAL_NUMBERS and MSC_ST_SERIAL_NUMBERS support serial-number validation.
- Foundation tables: FND_USER (user identity), FND_LOOKUP_VALUES (lookup codes), FND_APPLICATION, FND_LANGUAGES, FND_NEW_MESSAGES, and FND_RESPONSIBILITY provide messaging, language, and responsibility context.
- Logging and refresh: ECX_DOCLOGS records e-commerce transaction logs, and MSC_CL_REFRESH_S relates to collection/refresh state tracking.
Usage Notes
As an internal ASCP engine utility, MSC_SCE_LOADS_PKG is invoked programmatically rather than through a standalone form. Its documented callers — including MSC_SCE_PUBLISH_PKG, MSC_SCE_PUB_SUPPLY_COMMIT_PKG, MSC_CL_PUBLISH, MSC_EXCHANGE_BUCKETING, MSC_X_HZ_UPDATE, and the MSC_X_NETTING family (MSC_X_NETTING1_PKG through 4, MSC_X_NETTING_PKG, MSC_X_RECEIVE_CAPACITY_PKG, and MSC_X_WFNOTIFY_PKG) — confirm it is called during plan publication, netting, capacity, and workflow-notification processing. Customers are advised to treat it as a private dependency: it may be invoked indirectly during plan runs, data collection, or publishing, but direct calls from custom code risk breakage because the package is not a supported public API. Any modifications should be avoided, and diagnostics should leverage its error-string and logging routines only through supported planning processes.