Hi @Vernon Anderson , When you create a EDM Basic File Type you no need to set any file location. Please refer the sample code shown below.DECLARE file_type_ edm_application_tab.file_type%type; file_extension_ edm_application_tab.file_extention%type; description_ edm_application_tab.description%type; check_exist_ VARCHAR2(6);BEGIN file_type_ := 'URLFILE'; file_extension_ := 'URL'; description_ := 'Unified Resource Locator'; check_exist_ := EDM_APPLICATION_API.Check_Valid_File_Extension_(file_extension_); IF (check_exist_ = 'FALSE') THEN EDM_APPLICATION_API.New(file_type_, file_extension_, description_); END IF;END; *Additional:If you mean about fetching files from a file path location, yes for that instance you have to create an oracle directory path via the Object Properties window. That also can be achievable via an INS. DECLARE directory_object_ VARCHAR2(100) := 'FILE_STORAGE_DIR'; file_path_ IFSAPP.OBJECT_PROPE
Thank you Mathias,Solution worked. In APPS9 we don’t need to write any macro to view a .lnk or .url file since when we view the document, the link/url file will be executed automatically. But we have to set the EDM Basic / File Types via an INS. Hope this will be helpful to someone else.
Thanks for the idea @Mathias Dahl .But do you know how we can achieve this? In this post there is a suggestion to add a dummy file to a document revision and set up a macro for the “View” process. Is it the correct way? or are there any other ways? If it is the correct way, how would you suggest to execute it (process or any example work)? Thank you.
Thank you for the response Mathias.If we say about the requirement, the requirement of the customer is to add an attachment to part rev lines. The approach I followed was, create a document revision and add that document as an attachment to the order line. Once we create the document revision, we need to pick the file from a location where customer is mentioned in the incoming XML (in here normally what we do is create an object property and access to the file path). But now customer stated that instead of taking those documents from a file path, he needs the application to fetch the document from share-point.What happens if they can “attach the SharePoint document”? - It will be added to document revision.What then? Should it still be in SharePoint? - Yes, needs to be in share-pointwhat if it is updated in SharePoint? Or Docman? - Pending for that information from the customer, but first they need to make sure whether this kind of activity is possible with IFS application. Hope you g
Already have an account? Login
No account yet? Create an account
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
