Skip to main content
Question

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


Forum|alt.badge.img+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

Forum|alt.badge.img+11

Hi,

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

 

Thanks,

 

Gianni


Forum|alt.badge.img+9
  • Sidekick (Partner)
  • October 25, 2021

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


Forum|alt.badge.img+19

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings