Develop a RESTful Web Service in Oracle Integration Cloud (OIC)

We are seeking an experienced Oracle Integration Cloud (OIC) developer to create a RESTful web service that interfaces with our Oracle database. The primary function of this web service is to accept specific input parameters (`order_nbr` and `facility_code`), execute a predefined SQL query with these parameters, and return a structured JSON response with the query results.