Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
epmautomate importpremappedtransactions — Cloud Customer Connect
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

epmautomate importpremappedtransactions

Received Response
26
Views
11
Comments
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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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