You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • epmautomate importpremappedtransactions

    edited Nov 29, 2019 11:00AM in Account Reconciliation 11 comments

    Summary

    epmautomate command fails

    Content

    Hi,

    We have a Data Source, NPA_BEC_2114653, setup as

    ID Name Type
    BOGFDATO BOGFDATO Date
    BELOB BELOB Number
    UDSKRTXT UDSKRTXT Text
    OPRETTET_STRING OPRETTET_STRING Text

     

    We have a sample load file setup as:

    BOGFDATO,BELOB,UDSKRTXT,OPRETTET_STRING,Reconciliation Account ID
    01-NOV-2019,-590.00,Wakeup WAF999999,2019-11-01 13:48:57.709815,NPA-71300_PIT

    When running the epmautomate command:

    C:\Oracle\EPM Automate\bin>epmautomate importpremappedtransactions "November 2019" "SRC" "NPA_BEC_2114653.csv" "dd-MMM-yy"
    Processing...
    Retrieving status...
    EPMAT-1:Processed - 1, Succeeded - 0, Failed - 1
    Error at row: 1 at Column: BOGFDATO due to: Invalid column
    Error at row: 1 at Column: BELOB due to: Invalid column

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!