Current position:  Home > Default > What is the use of an outbound Select in DB adapter

What is the use of an outbound Select in DB adapter

Time:November 30
Advertisement
Hi,
In an ESB project, I use a DB adapter to 'select' certain rows from a table. But it is being shown as an outbound adapter and I am unable to transform the xml output of the selected rows. How can I achieve this in ESB. If I use the same adapter in BPEL, it gives me a response xml which I can transform, but in ESB, I am unable to create a routing service that takes the xml output of the selected rows and does a transformation.
Thanks
Arvind
Advertisement
Hi Dominik,
        Thanks for the repy !!!!
Now, as you said we can access a (deep) node of the whole model using an access object.
Let us consider the component set ONEORDER. As seen we can use the following path to reach BTDocFlowAll using search object :-
BTQuery1O -> BTOrder  -> BTOrderHeader  -> BTHeaderDocFlowSet -> BTDocFlowSet -> BTDocFlowAll ....
Also, to reach BTDocFlowAll we can even use the access object as follows :-
BTAdminI -> BTItemDocFlowSet  -> BTDocFlowAll....
Now my question is :-
Normally we use the class cl_crm_bol_query_service to fire a search based on a search object. Can we use the same class to fire a search based on access object ?
(actually I currently dont have a CRM system so I could not try it out myself).
If not, then how do we fire a query using an access object ?
Regards,
Ashish

Re: Need Satellite 5200 Select Bay Hdd adapter

-0001-11-30

I want to buy a select bay hdd adapter for satellite 5200 new or used part nr PA3223U-1ETCWell, it sounds like you will need to search on Ebay because Satellite 5200 is an oldie Im not quite sure how old it is but its definitely an stone age notebook

Outbound AS2 with Seeburger Adapter

2015-10-11

I am attempting to send a flat file using Seeburger's AS2 adapter.  1.  I created a new scenario.  2.  In the identifier section of the partner, I added a line for Seeburger | AS2ID | theID.  3.  I created a communication channel of type AS2.  It's s

Testing Outbound Scenario with File Adapter

2015-10-11

Testing an Outbound Scenario, This uses File Adapter. I checked Payloads in the Transaction SXMB_MONI in R/3 as well as XI. There was no message for error. So I suppose to get the data downloaded to a directory. The output file is a text file. The fi

Parameter in Select of DB Adapter

2015-10-11

Hi We implement some services with the osb 10gR3. For my specific service the target is an ms sql database (2005). Over jdeveloper I am defining the connection to the server and with the wizard a select statement. Now to my problem - how can I define

Slim Select Bay HDD adapter

-0001-11-30

I put in another HDD, and wanted to use the original one (MK4021GAS) in the slim select bay (SSB) using a SSB HDD adapter. However although the manual says "insert the HDD and push forward to ensure a firm connection", and shows a picture of thi

Using Conditional To Determine Select Statement

-0001-11-30

I am not sure if anyone knows if I can do this, but I am trying to use some determining factor based upon a value as to which query to run-. Something like: DECODE('INBOUND',      'INBOUND', SELECT 'I' FROM DUAL,      'OUTBOUND', SELECT 'O' FROM DUAL

Process Code in outbound IDOC

-0001-11-30

Hi, We have created a process code for outbound IDOC and assigned an FM to it.In that FM, code is written to generate an IDOC(FM 'master_idoc_distribute').Please let us know how to trigger the outbound IDOC using the process code.Are there any FM or

Exception handling in outbound ABAP proxy

2015-10-11

Hi All, i need to catch exception in outbound abap proxy in two cases: 1. if RFC dest in R3 which is pinging to XI goes down. 2. IF xi server is down. in both the cases i need to catch the exceptions. now i written the code in this way: DATA: v_excep

How to change namespace in outbound file

2015-10-11

Hi, When I creates a outbound file using file adapter, BPEL or jDeveloper creates a file with its own namwspace like ns1: or ns15: or so on... But if I want to change it to my own tag say like tns: or its:, is it possible? example: the usual creation

Where do we configure Seeburger adapter in case of outbound?

2015-10-11

<b>Hello Freinds,                              Can you please help me out where do we configure the Seeburger adapter if the sender is EDI ANSIX12...I mean at what point of time we use this Seeburger adapter to convert to XI Specific XML format?<

EDI X12 810 outbound Invoice subscription using BPEL Apps adapter

-0001-11-30

I am confused with subscribing to EDI X12 810 outbound Invoice. When I try to subcribe to EDI 810 outbound Invoice using App adapter , it shows XMLGateway(4), EDI (1), PL/SQL(1) , CON_PROGRAMS(1), Interface views (1). I dont understand to which I sho

What about: oracle.tip.adapter.custom.outbound.CustomInteractionSpec ?

-0001-11-30

Hi all, I am trying to configure a custom outbound JCA adapter through BPEL, using the following link as guide-line: [http://docs.oracle.com/cd/E17904_01/integration.1111/e10231/life_cycle.htm#BABBCCGC] My current installation consists of Oracle SOA

DB / Integation adapter returning duplicate rows on select [not all rows]

-0001-11-30

I am seeing some unusal behavior, we have Application adapter invoking BEPL and which invokes DB adapter to make a select call to ERP database. Select should return 2 different records, where as in the response xml it has same record [only first reco

Need help in Xi faqs

2015-10-11

Hi guys , This is SuryaNarayana . I have collected some faqs from www.**************** but they have no answers please answers these questions Questions are releated in to XI-BPM 1. Business Process Management is concerned with ? a. Processes within

JMS Adapter Config issues with Plan.xml

2015-10-11

Hi All, I'm learning how to configure JMS Resources in WLS to use within a JMS adapter in my application. My approach so far has been : 1. Configure Outbound Connection in JMS Adapter : eis/wls/Queue. I used the weblogic.jms.XAConnectionFactory as th

Bussines Service for AQ enqueuing

2015-10-11

I have created a business service based on a JCA Adaptor for enqueuing messages to a queue. When try the bussines service from the test console a new message appears in the queue table but the payload fields are empty, so the adapter is working but t

Regarding partner profile

-0001-11-30

HI all i am configuring an outbound partner profile for an outbound IDOC ,when i try to give the <i>post processing:permitted agent</i>,here i am getting this message <i>NO ACTIVE PLAN VERSION EXISTS</i>. CAN ANYBODY HELP ME ON THI

JMS Adapter: Disabling debug log

-0001-11-30

Hi All, we are having trouble with the JMS Adapter. Adapter is showing message in the opmn/default oc4j intance log growing until 15gb or more.. Is there a way to disable the JMS transaction log ? Log is showing the following lines: <2010-02-25 13:12

Can we debug a idoc?

-0001-11-30

can we debug a idoc?Hi, You can debug "idoc processing" in the transaction WE19. Provide the appropriate inbound function module and execute in debugging mode.. 1>Provide idoc number 2>Execute 3>For inbound Select the option inbound fun