Posts

Posts

  • Rashmi Rao
    Need help in uploading a csv or a excel file in a custom adf...
    Topic posted Yesterday by Rashmi RaoBronze Trophy: 5,000+ Points, tagged ADF, Database, JDeveloper, PaaS in Application Development > Java public
    Title:
    Need help in uploading a csv or a excel file in a custom adf page with click of button 'upload'
    Summary:
    Need help in uploading a csv or a excel file in a custom adf page with click of button 'upload'
    Content:

    Hi,

    We have a requirement wherein we need to upload 4-5 excel/csv files (one by one separately) using a ADF custom page in PaaS. For the 4 different file uploads, we will have 4 different upload buttons. Upon clicking on the upload button, file should be parsed and the data should go and sit in the respective columns in the dbcs staging tables.

    Next, there would be a button in the adf PaaS page which says 'download', Upon clicking this button, the data present in the dbcs staging tables should be transformed(calculations performed on it) and it should be downloaded in excel or csv format onto the user's local downloads folder.



    Can we achieve this requirement in PaaS/JCS/DBCS. If yes, can you please guide is to accomplish the same.

    Regards,

    Rashmi

  • Sridhar Yerram
    Error Creating Connection for Oracle DBCS4
    Topic posted October 12, 2019 by Sridhar YerramGreen Ribbon: 100+ Points, tagged Connection, Database, Integration in Integration > Integration public
    Title:
    Error Creating Connection for Oracle DBCS
    Content:

    Hi All,

    Can you please guide me how to create a connection for Oracle Database Connection with DBCS.

    PFA Screenshot of the details entered while creating connecting, but it is giving the error as below : 

    The connection test failed. Check your connection and use agent from agent group.

    -Sridhar

    Image:
  • Muralidharan Kanagaraj
    NoFields5
    Topic posted October 11, 2019 by Muralidharan KanagarajRed Ribbon: 250+ Points, tagged Business Objects, Custom Code, Database, JET, Validation in Application Development > Visual Builder public
    Title:
    Search Criteria for particular user?
    Content:

    Hi,
    We have developed an application in vbcs 
    When logged into the application using username and password in which we get details related to that employee
    We use business object to get table data, service data provider for filterCriteria.(Please find image for ref)
    We have a search page in our application. 
    When we give values for search criteria it works fine, but when we click button without
    giving any criteria all the data are fetched.
    We need only data related to that particular user.
     
    How to achieve this.

    Image:
  • Jaeyshree Kumaran
    Remove trailing zerosAnswered1
    Topic posted October 8, 2019 by Jaeyshree KumaranRed Ribbon: 250+ Points, tagged Adapters, API, Connection, Database, Integration, Orchestration, PaaS, REST, Web Services, xml in Integration > Integration public
    Title:
    Remove trailing zeros
    Summary:
    Remove trailing zeros of number
    Content:

    Hi,

    I have my input text as 0000001780936400. I should remove leading and trailing zeros in the number and the result should be as 17809364. I removed the leading zeros using number() fn. Please suggest a way to remove trailing zeros

  • Digvijay Chauhan
    Accessing Integration User Name in OrchestartionAnswered95.0
    Topic posted October 3, 2019 by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    Accessing Integration User Name in Orchestartion
    Summary:
    Logged in user infromation
    Content:

    Hi,

    Use Case: In ad-hoc run of scheduled integration I am populating a Database table and I also want to populate the username who have submitted the integration. Is there a way we can fetch the user details with integration orchestration to be passed to DB procedure?

    Thanks

    Dvi

  • Amitabha Dutta
    OIC Agent Installation - UnknownHostException from DbaaS...4
    Topic posted September 28, 2019 by Amitabha DuttaRed Ribbon: 250+ Points, tagged Agent, Connection, Database in Integration > Integration public
    Title:
    OIC Agent Installation - UnknownHostException from DbaaS server
    Summary:
    OIC Agent Installation - UnknownHostException from DbaaS server
    Content:

    We had followed https://docs.oracle.com/en/cloud/paas/integration-cloud/integrations-user/index.html and installed agent on the dbaas server by connecting opc user.
    It was working well, suddenly we noticed the agent went down and when we tried to restart the agent, it failed with error -
    Client.ClientHandlerException: java.net.UnknownHostException: <xxxx>.integration.ocp.oraclecloud.com

    It seems it is not able to connect to oic_URL. If I follow the same steps on my local machine, the agent starts successfully.

    As we need to keep the agent running in background from a server for all-time availability, can anyone provide some suggestion to overcome the issue? I hope a separate proxy server is not required as all the components belong to same cloud account.

  • Abhinav Kumar
    Integration3
    Topic posted September 28, 2019 by Abhinav KumarRed Ribbon: 250+ Points, tagged Database, Integration in Integration > Integration public
    Title:
    Integration
    Content:

    I have to update the a staging table with the values from the input file. I  have to run the following query in AIC.

    UPDATE staging_table
        SET active_flag = :active_flag
           ,last_update_date = SYSDATE
           ,last_updated_by = :user_name
      WHERE target_value1 = :target_value1
        AND NVL(active_flag,'Y') <> :active_flag
        AND NVL(target_segment1, 'DEFAULT') = NVL(:x_segment1, 'DEFAULT')
        AND NVL(target_segment2, 'DEFAULT') = NVL(:x_segment2, 'DEFAULT')
        AND NVL(target_segment3, 'DEFAULT') = NVL(:x_segment3, 'DEFAULT')
        AND NVL(target_segment4, 'DEFAULT') = NVL(:x_segment4, 'DEFAULT')
        AND NVL(target_segment5, 'DEFAULT') = NVL(:x_segment5, 'DEFAULT')
        AND NVL(target_segment6, 'DEFAULT') = NVL(:x_segment6, 'DEFAULT')
        AND NVL(target_segment7, 'DEFAULT') = NVL(:x_segment7, 'DEFAULT')
        AND NVL(target_segment8, 'DEFAULT') = NVL(:x_segment8, 'DEFAULT')
        AND NVL(target_segment9, 'DEFAULT') = NVL(:x_segment9, 'DEFAULT')
        AND NVL(target_segment10, 'DEFAULT') = NVL(:x_segment10, 'DEFAULT')
        AND NVL(target_segment11, 'DEFAULT') = NVL(:x_segment11, 'DEFAULT')
        AND NVL(target_segment12, 'DEFAULT') = NVL(:x_segment12, 'DEFAULT')

    I am using a DB adapter in the AIC, to run this query and giving this query in AIC.

    UPDATE staging_table
        SET active_flag = #active_flag
           ,last_update_date = SYSDATE
           ,last_updated_by = #user_name
      WHERE target_value1 = #target_value1
        AND NVL(active_flag,'Y') <> #active_flag
        AND NVL(target_segment1, 'DEFAULT') = NVL(:x_segment1, 'DEFAULT')
        AND NVL(target_segment2, 'DEFAULT') = NVL(:x_segment2, 'DEFAULT')
        AND NVL(target_segment3, 'DEFAULT') = NVL(:x_segment3, 'DEFAULT')
        AND NVL(target_segment4, 'DEFAULT') = NVL(:x_segment4, 'DEFAULT')
        AND NVL(target_segment5, 'DEFAULT') = NVL(:x_segment5, 'DEFAULT')
        AND NVL(target_segment6, 'DEFAULT') = NVL(:x_segment6, 'DEFAULT')
        AND NVL(target_segment7, 'DEFAULT') = NVL(:x_segment7, 'DEFAULT')
        AND NVL(target_segment8, 'DEFAULT') = NVL(:x_segment8, 'DEFAULT')
        AND NVL(target_segment9, 'DEFAULT') = NVL(:x_segment9, 'DEFAULT')
        AND NVL(target_segment10, 'DEFAULT') = NVL(:x_segment10, 'DEFAULT')
        AND NVL(target_segment11, 'DEFAULT') = NVL(:x_segment11, 'DEFAULT')
        AND NVL(target_segment12, 'DEFAULT') = NVL(:x_segment12, 'DEFAULT')

     

    But I am getting error while running.

  • Venkat Ramakrishnan
    JCS-SaaS Extension / APEX DB Connectivity from Java using...
    Topic posted September 27, 2019 by Venkat RamakrishnanRed Ribbon: 250+ Points, tagged ADF, Database, JDeveloper in Application Development > Java public
    Title:
    JCS-SaaS Extension / APEX DB Connectivity from Java using JNDI
    Summary:
    JCS-SaaS Extension / APEX DB Connectivity from Java using JNDI
    Content:

    Hello,

    I am trying to connect to JCS-SaaS extension/APEX DB from a Java program using JNDI. I referred to the blog with link https://blogs.oracle.com/saaspaas/using-database-objects-in-a-java-cloud-application. This blog is mentioned in Oracle Support note 2418002.1. I am getting an error "Need to specify class name in environment or system property, or as an applet parameter, or in an application resource file:  java.naming.factory.initial". Can anyone please tell me how to connect to JCS-SaaS Extension/APEX DB from a Java code using JNDI alias?

    Thanks,

    Venkat Ramakrishnan

  • Digvijay Chauhan
    OIC connection to Database VM on Cloud45.0
    Topic posted September 27, 2019 by Digvijay ChauhanBronze Trophy: 5,000+ Points, tagged Adapters, Cloud, Database, Integration in Integration > Integration public
    Title:
    OIC connection to Database VM on Cloud
    Summary:
    Multi tenancy connection
    Content:

    Hi All,

    I have OIC in one Cloud tenant and Oracle databse VM on different Cloud tenant. Both of them are in OCI bit on different tenants, What would I need to establish a connection from OIC to Database and vice-versa.

    Thanks

    Dvi

  • Ronald Konijnenberg
    Internal server error 500 when creating a complex business...1
    Topic posted September 26, 2019 by Ronald KonijnenbergGreen Ribbon: 100+ Points, tagged Action Flows, Business Objects, Database, REST, Security, Web in Application Development > Visual Builder public
    Title:
    Internal server error 500 when creating a complex business object using REST call
    Summary:
    Internal server error 500 when creating a complex business object using REST call.
    Content:

    Goal
    We would like to store a page variable, whose type is based on the POST request of the REST endpoint of one of our business objects, in our businessobjects. The business object is a complex type referencing another business object, that in its turn references two other business objects. See attached Image.

    Approach
    We've recreated our approach in an example application which produces similar behaviour:

    1. We defined a request and response type based on a 'complex' business object. In the example app this is the "Driver" object.
    2. We've set appropriate values in pages variable and assigned those to the newDriver variable which is based on the request type. The request variable contains a new driver, new combination of a new trailer and a new truck (we do not want to use existing trailer and truck objects in this scenario).
    3. In an action chain we added a REST call action which performs a POST on the businessobject's REST endpoint. We assign the page variable newDriver to the body of the POST call.

    Problem

    1. We get an internal server error (500) when we attempt to post the driver_request variable. Error details show numerous exceptions, all showing:

    arguments: [Exception: TypeError: 'caller', 'callee', and 'arguments' properties may not be accessed on strict mode functions or the arguments objects for calls to them at Function.invokeGetter (<anonymous>:2:14)]

    This looks similar to the error discussed in post: https://cloudcustomerconnect.oracle.com/posts/a1e366f640 this post however does not present a solution.

    1. When we try to store only the 'combination' object within the driver_request variable, by calling the Combination endpoint instead of the Driver endpoint, we do NOT get this error. However, 'trailer'  and 'truck' object are saved successfully and ID's are generated, but these generated ID's are not used as foreign keys in the new 'combination' object and results in an empty Combination object.

    Question

    1. How can the internal server error be resolved?

    2. How can we make sure that the foreign keys of the Trailer and Truck are also stored when the Combination is being created?

    Example

    See attached file for an example project that contains two buttons to reproduce these two problems.

    Version:
    19.1.3
    Image: