Posts

Posts

  • Karthik Ramachandran
    Run a select clause in ATP database with 'in'...
    Topic posted July 26, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Database, Integration, REST in Integration > Integration public
    Title:
    Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
    Summary:
    Run a select clause in ATP database with 'in' Operator using OIC ATP Adapter
    Content:

    Hi,

    RestAPI structure : 

    {

    'accountNum' : '123456'

    'product' : ['abc','def','ghi']

    }

    I can receive multiple product name in rest api, i need to concatenate the array like this ('abc','def';'ghi') and which i was able to do using XSL concat & create-delimited-string function. i can see the same when i log the same function in logger. But when i pass that variable the ATP adapter to run a query like this.

    Select accountid, accountName, productid, price from producttable where productname in #productname

    it should work similar to below query which i run in ATP db directly

    Select accountid, accountName, productid, price from producttable where productname in ('abc','def';'ghi')

    But it is not retrieving any record. same query work fine in ATP database but it doesn't work from OIC. Do OIC doesn't support 'in' operator in select statement?

     

     

     

     

  • Karthick S
    How to Insert multiple values in Business Object in VBCS3
    Topic posted July 25, 2019 by Karthick SRed Ribbon: 250+ Points, tagged Action Flows, Business Objects, Database in Application Development > Visual Builder public
    Title:
    How to Insert multiple values in Business Object in VBCS
    Summary:
    How to Insert multiple values in Business Object in VBCS
    Content:

    Hi Team,

    My goal is to insert all table data into a business object.

    How to achieve this.

    Could you please help me to solve this.

    Thanks,

    Karthick

  • David Tran
    how to update database with the database adapter?2
    Topic posted July 24, 2019 by David TranRed Ribbon: 250+ Points, tagged Adapters, Database, Integration, Mapping, Orchestration, PaaS, Process in Integration > Integration public
    Title:
    how to update database with the database adapter?
    Summary:
    need to update rows based on a value found in one of the fields
    Content:

    Hello Gurus,

    I'm processing data from a database using the DB adapter. I'm able to get data from the database.

    after processing that data, i want to use the primary key from that row of data to update a field value.

     

    the workflow is:

    Get data from DB
         for each row
              process data
              update a field in db to know its been processed.
         end loop
    end orchestration

     I tried the the update option in the connection configuration, but I can only map data, I'm guessing this will perform an update on the entire field vs updating the field where the primary key is found.

    I want something closer to:

    update tablename
    set field1="value"
    where field2 = key;

    such that key is a value I'm getting from iterating over the data in the orchestration.

    How can I do this using the DB adapter?

     

    Thank you in advance.

  • Karthick S
    How to join two tables in vbcs?3
    Topic posted July 23, 2019 by Karthick SRed Ribbon: 250+ Points, tagged Business Objects, Database in Application Development > Visual Builder public
    Title:
    How to join two tables in vbcs?
    Content:

    How to create realationship in BO between two Tables.

    For example: 

    I have two tables.
     Employee Table.  Primary Key: Request_Num
     Course Reference Table. Foreign Key: Request_Num
     
     Common column in both tables: Request_Num
     
    I want to create relationship between two tables based on Request_Num.

    Version:
    19.1.3
  • Karthik Ramachandran
    Oracle Integration Cloud running SQL statement in Oracle ATP11
    Topic posted July 23, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Connection, Database, Integration in Integration > Integration public
    Title:
    Oracle Integration Cloud running SQL statement in Oracle ATP
    Summary:
    Getting error when I ran sql statement in ATP using oracle integration cloud
    Content:

    Hi,

    I am executing sql statement using oracle integration cloud in ATP database. While adding connection and validating the SQL itself i am getting the error.

    SQL> 

      SELECT CITY, POSTAL_CODE, STATE_CODE, COUNTY
      FROM zeb_vertex_lookup
    WHERE NVL(POSTAL_CODE,0)   = NVL(#postalcode, NVL(POSTAL_CODE,0))
       AND NVL( STATE_CODE,0)      = NVL(#statecode , NVL( STATE_CODE,0)  )
       AND NVL( CITY ,0) = NVL(#city , NVL( CITY ,0))
    AND NVL( COUNTY,0) = NVL(#county , NVL( COUNTY,0))

    I have to use variable name with '#' so that it get displayed in the mapping. if I use ':' sql it is getting validated but i don't see it in the mapping.

    kindly please help.. 

    More Info on requirement -

    My SQL statement where clause should have search condition only if parameter has a value , if it null it should skip it.

    for example refer this pseudo code : 

    var a = select * from address 

    var b = where 1 = 1;

    if (postalcode is not null)

    b = b + 'postal_code =  ' + Postalcode + '

    if (city is not null)

    b = b + 'city = ' + City + '

     

     

     

     

    Image:
  • Cesar Tepetla Corte
    Problem to send the payload of reading a file in Visual...7
    Topic posted July 17, 2019 by Cesar Tepetla CorteBronze Medal: 1,250+ Points, tagged Action Flows, Custom Code, Database, JET, Process, REST, Services, Web in Application Development > Visual Builder public
    Title:
    Problem to send the payload of reading a file in Visual Builder to the RESTful web service of Apex
    Summary:
    Problem to send the payload of reading a file in Visual Builder to the RESTful web service of Apex
    Content:

    The requirement consists of a screen in Visual Builder that uses a file picker to upload a CSV file to a database.

    I have developed the screen and can read the files correctly.

    I have developed a package and a RESTful Web Service for the invocation and use of that package.

    I have tried the Rest service from Postman and it works without problem, then I have consumed it in Visual Builder and the test works well.

    Then I configure the service within an action in a button.

    The strange thing starts when I run the Visual Builder screen and everything indicates that all the execution was correct but when checking the database I insert an empty data, checking the browser console the request if it contains information and still insert it blank.

    I repeated that test but this time I created an OIC integration that receives the same payload and with ICO if it worked correctly

    What can be happening?

  • Karthik Ramachandran
    Connecting Oracle Integration to Oracle ATP - Issue with...Answered9
    Topic posted July 16, 2019 by Karthik RamachandranRed Ribbon: 250+ Points, tagged Database, Integration, PaaS, REST in Integration > Integration public
    Title:
    Connecting Oracle Integration to Oracle ATP - Issue with Sequencing
    Summary:
    I am not able to understand from where the sequence is picked up.
    Content:

    In Oracle ATP DB : Created new sequence

    CREATE SEQUENCE ZEB_TEMP START WITH 1000000 INCREMENT BY 1

    so as per sequence when I call sequence number next val it give me next digit. 

    When we mentioned the same sequence in Oracle ATP connection step in integration, it is generating some different sequence number. Only one good thing is, it is not random. But not sure from where sequence is getting generated. It works fine from ATP database, only issue is when i call it from Oracle Integration Cloud. 

    Sequence number what it is generating is 1200214, 1200215, 1200216 etc

    Screenshot attached for the step in OIC where sequence is selected.

    Please let me know if you need more details.

    Image:
  • Amitabha Dutta
    Oracle DbaaS Test Connect Failure in ICS5
    Topic posted July 15, 2019 by Amitabha DuttaRed Ribbon: 250+ Points, tagged Connection, Database, Integration, PaaS in Integration > Integration public
    Title:
    Oracle DbaaS Test Connect Failure in ICS
    Summary:
    ICS Test DbaaS Connection failing after updating the schema password
    Content:

    A number of integrations in ICS using a Oracle DbaaS Connection. The connection was created few months back, today the database schema password was changed and we had to update the ICS connection with new password. Now the Test Connection is failing with error "The connection test failed. Check your connection and use agent from agent group.". However, existing integrations using the connection are working fine.

    We had not created any agent for our connection and it was working fine. Can anyone highlight any possible reason for this issue?

     

    Version:
    19.3.1.0.0
  • Moon Ray Lo
    Best Practice for OIC to Cloud DB: DB Adapter or RESTful...
    Topic posted July 12, 2019 by Moon Ray LoSilver Medal: 2,000+ Points, tagged Adapters, Cloud, Connection, Database, Integration, Orchestration, PaaS, REST, Web Services in Integration > Integration public
    Title:
    Best Practice for OIC to Cloud DB: DB Adapter or RESTful Services?
    Summary:
    Better way to connect in Oracle DBCS from Integration Cloud (OIC/AIC)
    Content:

    Hi,

     

    I'd like to hear your inputs as to which approach is better in terms of efficiency, performance and maintenance when connecting to Oracle DB Cloud items (ex: table) from Integration Cloud - DB Adapter Operations or RESTful Services (ORDS)?

     

     

    Thanks ahead,

    Moon

    Version:
    19.2.1.0.0 (190323.0400.26650)
  • logu Prasanth
    How to move IAR file from one OIC to Another OIC instance115.0
    Topic posted July 9, 2019 by logu PrasanthSilver Medal: 2,000+ Points, tagged Adapters, Connection, Database, Integration, Mapping, Orchestration, Web Services, xml in Integration > Integration public
    Title:
    How to move IAR file from one OIC to Another OIC instance
    Summary:
    Move IAR file from one OIC to Another OIC instanc
    Content:

    I have Export the IAR file from One OIC Instance.

    1. Is it IAR having All the dependencies like lookups and libraries or we need to export dependency lookups and libraries

    2. If IAR having All the dependencies while importing to another OIC it will automatically import All the dependencies or we need to import separately ??

     Thanks in advance.