Visual Builder

Get Involved. Join the Conversation.

Topic

    Uvaraja Sadhana
    Upload and modify using B.O. in ABCS
    Topic posted March 13, 2017 by Uvaraja SadhanaRed Ribbon: 250+ Points, last edited March 24, 2017 
    39 Views, 6 Comments
    Title:
    Upload and modify using B.O. in ABCS
    Summary:
    Upload and modify using B.O. in ABCS
    Content:

    Hi All,

    Could you please let me know whether below scenario is possible through ABCS,

    • Want to Upload data from a CSV file.
    • Modify/change data after uploading.
    • Move the data to Oracle Finance Cloud.

    Thanks.

    Uva

    Comment

     

    • Shay Shmeltzer

      Yes this is possible.

      Create business objects in ABCS.

      Use the import option to load data from CSV

      Update data in an ABCS app

      Export data to CSV from ABCS.

      More on data import export see:

      Managing Application Data

    • Uvaraja Sadhana

      Hi Shay,

      Thanks for your reply. I will try to implement using ABCS.

      Regards,

      Uva

    • Uvaraja Sadhana

      Hi Shay,

      I am trying to implement as you said.

      I have successfully loaded data from CSV into Business Object.

      But I am not sure how to modify data in it.

      For example, my scenario is,

      I get my financial transaction from Legacy system, I have uploaded to Business Object. Post loading, I have to do COA mapping(change from 3 segments to 6 segments) then i have send this data to Oracle Financial Cloud.

      Is this possible to achieve this changing data ?

      Thanks.

      Uva

    • Shay Shmeltzer

      Once the data is inside your business object you can create an edit page on that business object and have a UI where you can modify the data.

      Here are the basics of building an app with ABCS - the difference for you would be that when you drop the table on the landing page - you pick up your existing object instead of creating a new one:

             Oracle Application Builder Cloud Service Tutorial - Creating an Application    

      Are you still missing something?

    • Uvaraja Sadhana

      Shay,

      Thanks for your reply.


      I don't want to update the record manually. I want it to be automated.

      As soon as the file is placed, Business Object(BO1) should be updated(Data coming from Legacy system).
      I will have separate BO(BO2) to store COA mapping.

      Now, either
           1) I should Extract data from BO1 based on BO2, or
           2) Update in the same table(BO1) based on COA mapping table(BO2) and then extract finally.

      example,
      In BO1 data will be like below,

      Column1,column2,column3,column4
      1,A,B,2

      in BO2 data will be like below,

      Column1,column2,column3,column4,column5
      A,B,X,Y,Z

      If I get A,B in the data file, my extract should be
      1,X,Y,Z,2

      I will send this extract to upload in Financial Cloud.

      Thanks.

      Uva

    • Shay Shmeltzer

      You might be able to do this with a script in the business logic in ABCS.

      But just so I'll better understand your use case - are you saying that all you are using ABCS for is manipulating data in files, without actually building any UI? If this is the case, I'm not sure ABCS is the right choice, you can probably just have a Java program run over your files merge the data and produce the new file.

      ABCS is more about building Web and mobile applications that have UI.