Search Results invalid_instance_id

Overview

MSC_WS_COLLECTIONS is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, classified under the API type OTHER. Its documented purpose is to provide web-service entry points that launch Advanced Supply Chain Planning (ASCP) collection request sets and related data-loading and conversion programs. The package encapsulates the logic required to validate a caller's identity and environment, submit the underlying concurrent programs, and return a status code together with the concurrent program request identifier. In the Oracle EBS 12.1.1 and 12.2.2 releases, the source header identifies the file as MSCWCOLLS.pls and states that the procedure is invoked from a web service to launch the ASCP Collection request set.

Key Procedures and Functions

The package exposes sixteen documented procedures. Each has a public-facing variant and a corresponding _PUB wrapper, a common pattern used to separate the externally callable interface from the internal implementation.

• RunASCPCollections / RunASCPCollections_PUB — Launches the ASCP Collection request set. The input parameters mirror the parameters of the concurrent programs contained within that request set, and the procedure returns a status plus a concurrent program request id.
• RunODSLoad / RunODSLoad_PUB — Submits the operational data store load program used to move source data into the planning schema.
• RunDemantraShipmentBooking / RunDemantraShipmentBooking_PUB — Loads shipment booking data into the Demantra (Demand Management) collection stream.
• RunDemantraSCIData / RunDemantraSCIData_PUB — Loads supply chain intelligence data for Demantra.
• RunDemantraCurrConversion / RunDemantraCurrConversion_PUB — Executes currency conversion for Demantra data.
• RunDemantraUOMConversion / RunDemantraUOMConversion_PUB — Executes unit-of-measure conversion for Demantra data.
• RunDemantraPricingData / RunDemantraPricingData_PUB — Loads pricing data into Demantra. This is the procedure named in the user's search term.
• RunDemantraReturnHistory / RunDemantraReturnHistory_PUB — Loads returns history data into Demantra.

For the ASCP collection procedure, the documented return statuses include SUCCESS, ERROR_SUBMITTING, INVALID_FND_USER, INVALID_FND_RESP, INVALID_INSTANCE_ID, INVALID_COLLECTION_GROUP, INVALID_TIMEOUT, INVALID_WORKER_NUMBER, and INVALID_ODS_WORKER_NUMBER.

Tables Accessed

The package references three documented objects through APPS synonyms:

• MSC_APPS_INSTANCES — Used to validate the InstanceID supplied by the caller, which corresponds to the INVALID_INSTANCE_ID status.
• MSD_DEM_RMA_TYPE — A Demantra return material authorization type table, referenced in support of the Demantra return history and shipment booking loads.
• DUAL — Used for standard singleton operations and validation.
• PLITBLM — The PL/SQL integer table type used for bulk collection handling within the package.

Usage Notes

This package is invoked primarily through web services rather than from an Oracle Forms interface. External systems, integrations, or custom code call the _PUB procedures, supplying user and responsibility identifiers, an instance id, a collection group, worker and timeout settings, and a set of enablement flags for collection entities such as forecasts, MPS, on-hand, sourcing, and ATP rules. The package validates these inputs, raises the appropriate invalid-input status when validation fails, and otherwise submits the request set and returns the request id. Typical use cases include scheduled or event-driven planning collections, Demantra data loads, and third-party integration points that need to trigger supply chain data collection programmatically. Because the _PUB routines are the documented public entry points, custom code should target them and always inspect the returned status before assuming successful submission.