Posts

Query to find Sub menu, Menu, userS attached to a responsibility in Oracle EBS R12.2

  SELECT    fu.user_name, frtl.responsibility_name,  FFL.USER_FUNCTION_NAME,FF.FUNCTION_NAME,    CASE         WHEN frtl.responsibility_name LIKE '%KBNA%' THEN 'KBNA'          WHEN frtl.responsibility_name LIKE '%JATM%' THEN 'JATM'           WHEN frtl.responsibility_name LIKE '%JNA%' THEN 'JNA'           WHEN frtl.responsibility_name LIKE '%KCI%' THEN 'KCI'            WHEN frtl.responsibility_name LIKE '%JATX%' THEN 'JATX'              WHEN frtl.responsibility_name LIKE '%JASC%' THEN 'JASC'                 WHEN frtl.responsibility_name LIKE '%KBCA%' THEN 'KBCA'              WHEN frtl.responsibility_name LIKE '%JAMX%' THEN 'JAMX'                       WHEN frtl.responsibility_name LIKE '%KMX%' THEN 'KMX'           WHEN frtl.responsibility_name LIKE '%JANA%' THEN 'JANA'               WHEN frtl.responsibility_name LIKE '%JATV%&#

Components of OSB

Image
  Proxy Services: Proxy services are the entry point for client requests into the OSB. They receive messages, route them to the appropriate back-end service, and send responses back to the client. Business Services: Business services are the back-end services that are called by the proxy services. They may be web services, JMS queues or topics, FTP servers, email servers, or any other type of service that can be accessed through a transport protocol. Message Flow: The message flow is the path that messages follow through the OSB. It consists of stages, actions, and branches that define how messages are processed and routed. Service Bus Console: The Service Bus Console is the graphical user interface (GUI) that is used to configure, manage, and monitor OSB components. It provides a visual representation of the OSB and allows developers to create and modify proxy and business services, message flows, and other components. Operational Settings: The operational settings of OSB allow you to

DBC File location in Oracle Apps R12.2.X

  DBC File location in Oracle EBS R12.2.X $INST_TOP/appl/fnd/12.0.0/secure  

Learn How to Utilize XQuery Mapping in OSB 12c

Image
In integration scenarios, it is common to encounter situations where the source and target systems have different payload structures. The source system may send a payload with a more extensive set of columns, while the target system may only require a specific subset of these columns, or vice versa. In such cases, it becomes necessary to align the payload structures of the source and target systems to enable effective communication between them. Various integration platforms offer their own mechanisms for mapping elements, but in the case of OSB (Oracle Service Bus), we can utilize XQuery mapping to map the payload elements Let's use the existing application where  Business Service is using Database Adapter to fetch records based on the input parameter CustomerId.  Input Response having one element that is :  Cust Id Output Response having multiple Elements like :  CustId   CustomerName City Designation LastUpdateDate LastUpdateLogin CreationDate CreatedBy LastUpdatedBy Refer to t

Maximizing Connectivity: Creating Integrations with Business Services through Proxy Services in OSB 12c

Image
  This article will focus on building SOAP integration in OSB to access data from a database. In this integration, we will utilize the database adapter as a business service, which needs to be configured with select operations. The business service will be called through a proxy service to retrieve data from the database. For this tutorial we will use the existing business service , if you are unaware kindly visit this link Database as Business Service Assuming that we have followed the above link and created Business Service  Create Proxy Service  Select the WSDL of Business Service in Proxy Services  Create PipeLine Drop Routing Node on the Pipe Line Pair  and select Business Service  Run the Proxy Services  Provide the parameter in the payload