Skip to main content
Question

Permissions Error on External File Assistant - File Type is not available


Forum|alt.badge.img+8
  • Do Gooder (Customer)
  • 31 replies

 Some users are receiving an error message “The File Type is not available” when trying to use a certain file type in External File Assistant. 

I have confirmed that changing to a different permission set resolves this issue, but I have not been able to pinpoint what needs to be granted in the orignial permission set.

How can I determine what projection or other grant needs to be added to the permission set to resolve the issue? 

I have tried using the debugger but the projection listed (ExternalFileAssistantHandling) is not the issue.

 



 

11:36:49 INFO - REQUEST method "GET"
11:36:49 INFO - REQUEST uri "https://abc.def.com:12345/main/ifsapplications/projection/v1/ExternalFileAssistantHandling.svc/GetDefaultFileTypeInfo(Company='DHP',FileType='ExtPosPayCheck',ProcessOption=IfsApp.ExternalFileAssistantHandling.ProcessOptionsEnum'Online')?odata-debug=json"
11:36:49 INFO - REQUEST protocol "HTTP/1.1"
11:36:49 INFO - REQUEST headers {"Host":"abc.def.com:12345","sec-ch-ua":"\"Not_A Brand\";v=\"8\", \"Chromium\";v=\"120\", \"Microsoft Edge\";v=\"120\"","Accept":"application/json;odata.metadata=full;IEEE754Compatible=true","X-Requested-With":"XMLHttpRequest","Accept-Language":"en-US,en;q=0.5","sec-ch-ua-mobile":"?0","User-Agent":"Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/120.0.0.0 Safari/537.36 Edg/120.0.0.0","sec-ch-ua-platform":"\"Windows\"","Sec-Fetch-Site":"same-origin","Sec-Fetch-Mode":"cors","Sec-Fetch-Dest":"empty","Referer":"https://abc.def.com:12345/main/ifsapplications/web/assistant/ExternalFileAssistant/Assistant;path=0.2026593824.1876323749.2098603466","Accept-Encoding":"gzip, deflate, br","Cookie":"XSRF-TOKEN=M5UP-MXQX-WJCB-C6E5-8KDZ-IM51-Y8Q5-XCGF; JSESSIONID=vJTeSE5Ie1G9QQNcJY-tLJKus8-_W6QOjzHpqyHQfNl7VmnMuqzE!-1182627715; _WL_AUTHCOOKIE_JSESSIONID=CXcu1hwkJSnkvg9Cd9nq","ECID-Context":"1.00jQFBTH04LFw0zzjr0Afz4cndy3zNIz90003F80008Ug;kXjE","Connection":"Keep-Alive","X-Forwarded-For":"10.10.48.155","X-WebLogic-KeepAliveSecs":"30","X-WebLogic-Request-ClusterInfo":"true","x-weblogic-cluster-hash":"wzCbc8umKb0cV2bauve9kqrjGm4"}
11:36:49 INFO - RESPONSE status {"code":"500","info":"Internal Server Error"}
11:36:49 INFO - RESPONSE headers {"OData-Version":"4.0","Content-Type":"application/json"}
11:36:49 INFO - RESPONSE body "{\"error\":{\"code\":\"DATABASE_ERROR\",\"message\":\"Database error occurred. Contact administrator.\",\"details\":[{\"code\":20105,\"message\":\"ORA-20105: ExternalFileAssistantHandling.INVFILETYPE: The File Type is not available\"}]}}"
11:36:49 ERROR - INVFILETYPE - (Server Application Error): The File Type is not available Database error occurred. Contact administrator. undefined
11:36:49 ERROR - Command error: (INVFILETYPE) - The File Type is not available, details: "[{\"code\":20105,\"message\":\"ORA-20105: ExternalFileAssistantHandling.INVFILETYPE: The File Type is not available\"}]" undefined
11:36:49 DEBUG - CMD(1): Error: The File Type is not available

 

20 replies

Charith Epitawatta
Ultimate Hero (Employee)
Forum|alt.badge.img+31

Hi @hreavis,

Please try granting ExternalFileAssistantHandling projection as per the error message. If the projection is already granted, then check if there is a difference in the access levels between the permission sets(Custom/Full etc.). 

Hope this helps!


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 31 replies
  • November 21, 2023

@Charith Epitawatta ExternalFileAssistantHandling is already fully granted - every entity action is granted and there are no Projection Action Grants for that projection.

Do you have any other suggestions?

Thanks!

 


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 14 replies
  • February 28, 2024

Is there an update on this error? 

We get one step further in the process but have the same error. Permissions for ExternalFileAssistant are fully granted.

 

 


Forum|alt.badge.img+8
  • Author
  • Do Gooder (Customer)
  • 31 replies
  • February 28, 2024

@SAXBBSOT We are still experiencing this issue.


Forum|alt.badge.img+4
  • Do Gooder (Customer)
  • 14 replies
  • March 27, 2024

We found the cause for our error “File Type XXX is not available for the user”.

In our case it was not a permission error. In IFS cloud it’s not possible to crerate new external file Types. See for details: https://community.ifs.com/finance-financials-42/create-a-new-external-file-type-30279?tid=30279&fid=42

The error is only triggered when we use file types we created in APPS 10. System defined file types are working. This means we have to adjust our workflow by using the default file types but separate with file Template per company instead of a file type per company.

The topic is also already on the idea wall: 

https://community.ifs.com/ideas/possibility-to-create-your-own-external-file-types-43875?tid=43875&postid=159347#post159347

 


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 44 replies
  • April 15, 2025

Hello

We are experiencing the same issue: we migrated from IFSv8 vers Cloud Remote R24R2.

We have the External file templates for IFS v8

 

And when we login with IFSAPP, or any other user we get

 

What is the process to solve this issue ?  System defined file types are working. 

Help Greatly appreciated.

Best Regards


Forum|alt.badge.img+12
  • Hero (Customer)
  • 321 replies
  • April 17, 2025

I personally had to do a full customization to re-enable the creation and use of user-defined (i.e. not system defined) file types.

 

Several things needed to be done to both enable the creation of a new file type, file type template (especially an input template, haven’t checked output), and then using said file in the Assistant.

 

If there’s interest I can share how I accomplished it but unless you have access to studio developer and you’re willing to create a customization and associated delivery, you’re probably out of luck.


Forum|alt.badge.img+11
  • Hero (Partner)
  • 171 replies
  • July 24, 2025

@SimonTestard We are facing the same problem, Could you please share me with how you over came this issue as we are willing to do a customization to get this sorted. 
Thanks in Advance & Regards,

Malik


kavinduxo
Hero (Partner)
Forum|alt.badge.img+9
  • Hero (Partner)
  • 43 replies
  • July 24, 2025
malik.sally wrote:

@SimonTestard We are facing the same problem, Could you please share me with how you over came this issue as we are willing to do a customization to get this sorted. 
Thanks in Advance & Regards,

Malik

Hi ​@malik.sally ,
Can you please check the thread below? Hope it will resolve the issue. 
External File Upload Error - 21R1 | IFS Community

BR,

Kavindu Gunathilake


Forum|alt.badge.img+11
  • Hero (Partner)
  • 171 replies
  • July 24, 2025

@kavinduxo Thanks for the link, yes, we identified that a Projection Action is required in the EXT_FILE_TYPE table. Now the question is what is the Projection Action that need to be used? 

 

Custom API’s are used, so not too sure which projection actions to be used. May be new projection actions are to be developed? 

 


Forum|alt.badge.img+12
  • Hero (Customer)
  • 321 replies
  • July 24, 2025

I’m not using any projection action whatsoever, just customized PL/SQL Package Methods.

 

I have however customized the  ExternalFileType client to re-allow creation of non system defined file types, as well as the ExternalFileTemplate client file to make those fields editable as long as they template is not system defined.

 

Projection:

 

ExternalFileTypeHandling:

 

 

ExternalFileTemplateHandling:

 

 

 

Client:

 

 

ExternalFileType

 

 

ExternalFileTemplate

 

 

 

 

Result:

 

When Not System Defined

 

When System Defined

 


Forum|alt.badge.img+12
  • Hero (Customer)
  • 321 replies
  • July 24, 2025

Oh, I also had to overtake the ExtFileAssistant Fragment to ensure the Non System Defined (i.e. Custom) File Types could actually be used in the assistant:

 Overtaken as:

 

 


Forum|alt.badge.img+11
  • Hero (Partner)
  • 171 replies
  • July 24, 2025

Thanks for the quick response Simon. I will give it a shot tomorrow morning and see how it goes. It looks promising. :)


Forum|alt.badge.img+6
  • Sidekick (Customer)
  • 44 replies
  • July 25, 2025

Subject: Clarification on Custom Import Files in IFS Cloud 24R2

Hello,

As I understand it, only system-defined import formats are now permitted, as the use of “Custom Import files” has been restricted in the latest IFS Cloud version.

Previously, in IFS Applications v8, it was possible to create and use custom import file methods. However, with the transition to Cloud 24R2, this functionality appears to have been removed. As a result, the File Assistant tool no longer supports true custom imports, making it somewhat misleading in this context—since the underlying standard code now prohibits such flexibility.

Could you please confirm if this interpretation is correct, and whether there are any recommended alternatives for handling custom import needs in the current version?

Best regards,
Peter STEVENINCK


Forum|alt.badge.img+12
  • Hero (Customer)
  • 321 replies
  • July 25, 2025
MCIPSTEV wrote:

Subject: Clarification on Custom Import Files in IFS Cloud 24R2

Hello,

As I understand it, only system-defined import formats are now permitted, as the use of “Custom Import files” has been restricted in the latest IFS Cloud version.

Previously, in IFS Applications v8, it was possible to create and use custom import file methods. However, with the transition to Cloud 24R2, this functionality appears to have been removed. As a result, the File Assistant tool no longer supports true custom imports, making it somewhat misleading in this context—since the underlying standard code now prohibits such flexibility.

Could you please confirm if this interpretation is correct, and whether there are any recommended alternatives for handling custom import needs in the current version?

Best regards,
Peter STEVENINCK

 

This is correct, and you need a customization (as I’ve described above) if you want to be able to use custom imports again.

 

Also obviously, IFS would probably tell you you should use the Data Migration module in order to do such things, hence why they now restricted the Ext File Load, but a lot of customers (including myself) do find a lot of added flexibility in the External File feature that isn’t necessarily found in Migration Jobs :)


Forum|alt.badge.img+11
  • Hero (Partner)
  • 171 replies
  • July 28, 2025

@SimonTestard Thanks a lot! That works. 
Just picking your brain a little further, have you had a requirement / managed to run a scheduled batch job for External File Uploads with changing file names?
Ex: Currency Rates / Credit Card Statements are dropped in to an FTP folder regularly with a date/time stamp. The Batch Job should be able to fetch the file which has a different name to the static file name in the External File Template.

 


Forum|alt.badge.img+12
  • Hero (Customer)
  • 321 replies
  • July 28, 2025

You have several ways of doing that.

 

You can read the file in an FTP using Oracle UTL File’s handling, but that typically requires knowing the file name (unless you use Java Class Implementation to create a PL/SQL Method to iterate on files in a folder (but I won’t get into that here,  just read here for more info - https://docs.oracle.com/en/database/oracle/oracle-database/21/jjdev/calling-Java-from-PL-SQL.html, https://oracle-base.com/articles/misc/list-files-in-a-directory-from-plsql-and-sql-java)

 

Otherwise typically there are ways using an IFS Connect FTP Reader which will create an application message, and that application message is then used to fulfill the actual file to the Ext File Type Handler, read more here: https://docs.ifs.com/techdocs/25r1/030_administration/030_integration/330_ifs_applications_business_components/190_ext_files_i/#inbound_routing_rule_used_in_batch_process_import


Forum|alt.badge.img+11
  • Hero (Partner)
  • 171 replies
  • July 28, 2025

Thanks for the quick response. Yes, I did set up a FTP Reader which looks at a specific folder and brings it in to IFS, and with Routing Rules and Address I set it up to forward it to the External File Handler, which in turn creates a record in EXTERNAL_BATCH_LOAD_FILE_TAB and waits in LOADED state until the scheduled external file assistant picks up. The challenge is the background job looks for a specific file name that is set up in the External File Template.

 

 

It looks for the exact file name in the below table to pick up and execute.

 

The only other reference is the yellow highlighted value (CURR_LOAD)  which is the name of the FTP Reader that I have configured. But that doesn’t help either.

Seems like I may have to do a customization to handle the dynamic filename.


Forum|alt.badge.img+12
  • Hero (Customer)
  • 321 replies
  • July 28, 2025

Oh yeah I understand, I don’t know if there’s a way to use wildcards at all in the file name ? You might want to try with leaving “*” at the end if only the end changes, because the extension field below (*^*) does accept wild cards, so maybe the file name does too ?


Forum|alt.badge.img+11
  • Hero (Partner)
  • 171 replies
  • July 28, 2025

Unfortunately, it doesn’t. Tried that as the first option. So what happens is, when a database task is scheduled with external file assistant, a parameter is saved for the background job and the parameter has a fixed value for the filename, every time the schedule kicks in, the background job looks at the parameter and gets the file name (which was set at the time of scheduling).
At least, I got to understand how the system is designed to work, now can change the code to look for a filename with a REG EXP or a LIKE. Thanks foe your valid inputs!


Reply


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