Question

External File Upload Error: ORA-20105: AccountingCodestr.MISSCODE:

  • 13 August 2021
  • 3 replies
  • 491 views

Userlevel 5
Badge +9

Hi,

In apps-9, I have created my own external file template to upload manual supplier invoice in bulk, but while uploading i am getting the error saying “ORA-20105: AccountingCodestr.MISSCODE: The value  used for the code part Account is missing or has invalid time interval”. I thought i was missing Code_A for this, but in this view this field is not available. so now i am confused how to deal with it. i have checked the csv file in notepad as well but could not find the problem.

Can anyone suggest what can be the probable reason?

 

Regards-

Nahin


This topic has been closed for comments

3 replies

Userlevel 4
Badge +9

Hi,

Did have any news about this problem? I am having almost the same problem.

 

Thanks,

 

Gianni

Userlevel 5
Badge +9

hi @gianni.neves , i sorted it myself. cant remember exactly how, but so far i can remember may be i had problem in my csv file data.

 

Regards-

Nahin

Userlevel 7
Badge +18

Hi, 

I know the issue.   

Per the comment “I created my own template”    - Ideally we would have copied one of the IFS templates as a starting point.    If you started with STDSIN1 you should have the code_A. 

If you copied some other template then you may see an attribute for account. Account is not the same as code_a.    

 

You “really” want to use code_a for the account number. 

 

Best regards, 

Thomas