Thanks a ton. I was missing a simple configuration.
Thanks for this. Is there any option to SORT the data ?
Hi, I decided to give this a go, to test my theory. Seems this approach works well. I hope this might help others who need to do similar things in relation to importing documents. The building blocks are: - A custom event that fires on inserts/new records in the EdmFile LU (table = edm_file_tab) and where we make four of the keys available for event actions. - An event action connected to the custom event, of type Execute Online SQL. - The File Import screen. Each file that is imported must have the part number in parentheses, like this: My document (12345).docx. Here, 12345 would be the part number used when connecting the document. The site (see CONTRACT= in the code below) is hard coded, and probably can be in most cases. The LU, InventoryPart is also hard coded. Here is the code for the event action: DECLARE doc_class_ doc_issue_tab.doc_class%TYPE := '&NEW:DOC_CLASS'; doc_no_ doc_issue_tab.doc_no%TYPE := '&NEW:DOC_NO'; doc_sheet_ doc_issue_tab.doc_sheet%TYPE
Dear Mathias,Thanks a lot for the guidance. It worked though after some modifications.But all thanks to you! I took reference from your idea of using File Import feature.I used it to attached multiple documents to multiple Employees under Employee Files screen.The steps which I followed :-Create an Event for Lu_Name = EdmFile and Table = EDM_FILE_TAB ::: Same as suggested by you Create an Event Action for new insert of record in this Table with Action Type - Execute Online SQL:: Same as suggested by you. I changed the SQL code as per my requirement:===========DECLAREPRAGMA AUTONOMOUS_TRANSACTION; doc_class_ doc_issue_tab.doc_class%TYPE := '&NEW:DOC_CLASS'; doc_no_ doc_issue_tab.doc_no%TYPE := '&NEW:DOC_NO'; doc_sheet_ doc_issue_tab.doc_sheet%TYPE := '&NEW:DOC_SHEET'; doc_rev_ doc_issue_tab.doc_rev%TYPE := '&NEW:DOC_REV';CURSOR get_data IS SELECT S.DOC_CLASS, S.DOC_NO, S.DOC_SHEET, S.DOC_REV, REGEXP_SUBSTR (S.TITLE, '\
Hi Akila,Please note the following. It shows 1 instead of 100.
Hi Akila - It is in Project Navigator and all other windows also where the ratio is displayed.
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.
