Applications

Expand all | Collapse all

Bulk Data Load into WAM

  • 1.  Bulk Data Load into WAM

    Posted 10 days ago
    We are looking to determine if there is an Oracle Work and Asset Management (WAM) function or API for use in bulk loading data (primarily past work orders) into a WAM database?

    We have not found any documentation on any functions like this in the WAM documentation but it would not be a generally used function, mainly used during migration to WAM.

    Thanks in advance,
    James Carolan

    ------------------------------
    James Carolan
    CDM Smith Inc.
    Boston MA
    -
    ------------------------------


  • 2.  RE: Bulk Data Load into WAM

    SIG Leader
    Posted 8 days ago
    Hi James,

    Is your bulk import need in this case a one-time project (i.e. migration) or an ongoing business function?

    ------------------------------
    Ted Chappell
    Director of Product Management
    STR Software
    Richmond VA
    (804) 897-1600
    ------------------------------



  • 3.  RE: Bulk Data Load into WAM

    Posted 7 days ago
    Ted, thanks for the fast response. This will be a one time migration of legacy records. We plan to migrate the records to a shell database schema that matches the current WAM schema and make sure the data are tight and clean before we do the migration so its basically a one time database to database transfer but want to determine if anything special is needed to register the new records or update indexes, etc that the WAM app would need.

    This is a WAM v 1.9.1.2.11 application running on an Oracle 12.1.0.2 OL 6.9 database.

    James

    ------------------------------
    James Carolan
    CDM Smith Inc.
    Boston MA
    -
    ------------------------------



  • 4.  RE: Bulk Data Load into WAM

    OATUG Star Partner
    Posted 7 days ago
    Hi James,
    Oracle is not very consistent on how the documentation is available for their different products, for example when you use oracle R12 you can see all the integration points using the responsibility "Integrated SOA Gateway". There you can drop down all the APIs and web services available for integration 
    Taking as a point of reference my knowledge on integrations with Oracle EBS, my first suggestion will be to contact oracle support (to identify possible interface, APIs available), as sometimes develop a tool could take forever. Depending on what is available, if any, the path to take could be from taking an excel macro approach (when no API or interface available), or also to develop an API (but you will need to evaluate if that could void your Oracle Support).

    Good luck,

    Carlos 
    .

    ------------------------------
    Carlos Urtubia
    Presales
    Carlos.Urtubia@More4apps.com
    More4apps
    ------------------------------



  • 5.  RE: Bulk Data Load into WAM

    Posted 7 days ago
    Carlos,

    Thanks, yes we are engaging Oracle support so I am sure we'll get to the bottom of it and I'll let you know how it works out. We are hoping its just a database record transfer between the databases at this point. Thanks for the tip on the libraries. I'll peruse those to see what I can find as well.

    James

    ------------------------------
    James Carolan
    CDM Smith Inc.
    Boston MA
    -
    ------------------------------