CSV File Upload Error

[kabaliganesan]

Hi All, we are working on service provider capacity management. We are able to get committed and usage values updated, whereas Finalize is not getting updated, even after the shipment is accepted and invoice is raised.

We were trying to update some data through CSV file to the table, 'COMMIT_USAGE' that updates the finalized commitment value.

We are unable to upload the data in CSV file.

Following error is displayed:
ORA-01861: literal does not match format string
or
ORA-01843: not a valid month

Note: We were having issues in date earlier

CSV file is attached for reference.

[james_foran]

Re: CSV File Upload Error

If you are updating a date field, make sure the 3rd line of the CSV file contains the date format as follows:

EXEC SQL ALTER SESSION SET NLS_DATE_FORMAT = 'DD/MM/YYYY'

Line 1 must contain the table name
Line 2 must contain the column names, separated by a comma. Make sure there are no additinoal commas after the last column.

Always edit CSV files in a Text editor. Excel plays havoc with CSV files. Particullary with AGENT_ACTION_DETAILS and SAVED QUERY records where certain fields may contain a large amount of data.

I use the following SQL Script to extract AGENT_ACTION_DETAILS from the DB:

SELECT AD.AGENT_GID, AGENT_ACTION_GID, ACTION_FLOW, ACTION_SEQUENCE,'"'||replace(replace(replace(ACTIO N_PARAMETERS, chr(9), ' '), chr(10), ' '), chr(13), ' ')||'"' ACTION_PARAMETERS,DOMAIN_NAME, DATA_TYPE_ASSOCIATION_GID FROM AGENT_ACTION_DETAILS AD WHERE agent_gid in(
:agent_gid)

It removes all tabs and line returns.

I cannot see the file, so I hope this helps with your issue. If not, attache the file (or at least the first 4-5 lines), and I will have a look into this for you.

Cheers,

[kabaliganesan]

Re: CSV File Upload Error

Hi James,
Thanks for the response. We tried that... seems there is some other problem as well. Attaching the CSV file for reference.

Thanks in advance.

[james_foran]

Re: CSV File Upload Error

Hi,

This file contains a Date time value, but not translation.

Also, you cannot include null as a value. This should just be blank.

EG
Correct Line
test,,
incorrect line
test,null,

Dont forget to add line 3 data format