Can we add sharepoint documents to Document Revision?

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-point

what 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 got some idea.

​

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 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.

​
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_PROPERTY_TAB.Property_Value%TYPE;
   stmt_                     VARCHAR2(5000);
BEGIN
   file_path_ := OBJECT_PROPERTY_API.Get_Value(object_lu_     => 'ObjName',
                                               object_key_    => 'OBJ_NAME',
                                               property_name_ => 'A_PREFERRED_NAME');

    IF(file_path_ IS NOT NULL) THEN
      stmt_ := 'CREATE OR REPLACE DIRECTORY '|| directory_object_ || ' AS ' || ''''||file_path_||'''';
      EXECUTE IMMEDIATE stmt_;
   END IF;
END;

But in my .lnk/.url instance, we created a BLOB from the server side(.plsql) and created a .lnk/.url file from there.

PROCEDURE C_Generate_File_Data (
   file_data_  OUT BLOB,
   string_     IN VARCHAR2)
IS
BEGIN
   dbms_lob.createtemporary(file_data_, FALSE);
   dbms_lob.append(file_data_, utl_raw.cast_to_raw('[InternetShortcut]' || chr(10)));
   dbms_lob.append(file_data_, utl_raw.cast_to_raw('URL=' || string_));
END C_Generate_File_Data;

File content as shown below.

Eg:

[InternetShortcut]
URL=https://google.com

Hope this will be helpful to you.

​