Arif's Profile
Agile Angel
2187
points

Questions
19

Answers
147

PLM Enthusiast since 2011. Like Developing extensions,utilities,scripts and provide Configuration and Support on PC,PPM, PG&C, PQM,PCM on 9.3.5,9.3.3 and 9.3.2. Experienced in dev,config and design on PLM4P(6.0.0.3 till 6.1.1.x)
Title Agile PLM Technical Consultant
Company Company Not Entered
Agile Version 9.3.5, 9.3.3 , 6.X.X.X.
  • Agile Angel Asked 7 days ago in Product Collaboration.

    It is not possible to have History attributes however if you want to track activities of user on a particular class or object, you can write a simple sdk program or scripts.

    • 70 views
    • 5 answers
    • 0 votes
  • Hi Naren,

    Do you have security certificates installed on url you trying to access. Normally firefox does that. One way to bypass is :

    1. Go to about:config
    2. Type “security.tls.version.max” and set it to 1 and re-try.

    You can also try to run it in private mode to see if the issue persists.

    • 39 views
    • 1 answers
    • 0 votes
  • Well i don’t have real data to play around with but based on what i have worked earlier on, all the Projects related information is stored in Activity table.

    Activity table id has few important column called Name,Activity_Number and Parent_ID. Generally when Parent_ID is null that’s project and you can find out the phase/tasks by querying that table and giving Project id as Parent_Id.

    Regards,

    • 74 views
    • 2 answers
    • 0 votes
  • As Steve mentioned yes it is possible. Prepare a spread-sheet with the data you need, read it and perform your action.

    • 66 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on June 8, 2018 in Product Collaboration.

    As you want to ensure that Item’s are not visible and not to permanently delete it means you should go ahead with soft-delete.

    Now coming to soft-delete, generally as a best practice you should ensure that part is an Orphan part i.e. Not having any dependencies like pending changes or attached MPNs or BOMs or Where Used. You can delete it using Agile SDK thereafter or SQL statement where SDK is preferred one.  You can use Object.delete() and soft delete it. It will be there in your recycle bin.

    If you must go ahead with Soft-Delete via DB then

    1. Take a prior back up of your DB.
    2. Execute the statement –>   UPDATE  ITEM SET DELETE_FLAG=1  WHERE ITEM_NUMBER IN (‘ITEM1′,’ITEM2’);
    3.  Execute A-verify and ensure all the data errors are taken care of.
    4. Generally this approach worked for me.

    Have tried both SDK and SQL script approach and both have worked fine. Preferred is SDK 

    Regards,
    Arif

    • 134 views
    • 4 answers
    • 0 votes
  • Agile Angel Asked on May 31, 2018 in Other APIs.

    That’s a good one Matt.

    However i tried a similar process to find out the Nth Level Item. I have created a procedure which takes your Item Number as input and then gives you BOM Explosion report as the output.  If your requirement is similar let me know will share the complete procedure. The procedure is applicable for one as well as multiple input.

    Below is my cursor or to say the select statement for generating BOM Explosion. You can give your item number in place of ‘your input item number’ in below SQL and use it.

    SELECT   ‘your input item Number’ AS PARENT_ITEM,
     a.item_number,
     LEVEL
          FROM   AGILE.BOM A
    START WITH   (A.ITEM = (SELECT   DISTINCT i.id
                              FROM   agile.item i, agile.bom b
                             WHERE   i.id = b.item AND i.item_number = ‘your input item Number’)
                  AND NVL (A.change_out, 0) = 0
                  AND (SUBSTR (A.flags, 5, 1) = 1)
                  AND A.id NOT IN (SELECT   C.prior_bom
                                     FROM   AGILE.bom C
                                    WHERE   C.item = A.item))
    CONNECT BY       PRIOR A.COMPONENT = A.ITEM
                 AND NVL (A.change_out, 0) = 0
                 AND (SUBSTR (A.flags, 5, 1) = 1)
                 AND A.id NOT IN (SELECT   B.prior_bom
                                    FROM   AGILE.bom B
                                   WHERE   B.item = A.item);

    Regards,
    Arif

    • 104 views
    • 4 answers
    • 0 votes
  • Agile Angel Asked on May 31, 2018 in Other APIs.

    Hi Raju,

    You can connect Item and BOM table for Level-1 bom output and then use hierarchical query concept to extend it to all levels of BOM. I was able to achieve an output similar to BOM explosion report using the same concept. 

    Regards,
    Arif

    • 104 views
    • 4 answers
    • 0 votes
  • Hi Surya,

    This is limitation for versions prior to 9.3.3. From thereafter you have an option to modify the number of columns in preferences Maximum Search / Custom Reports Columns.

    Regards,
    Arif

    • 56 views
    • 2 answers
    • 0 votes
  • Hi Kshama,

    Not sure what exactly the issue here. Can you share more details like detail error message.

    Also advise you to check the server.conf settings and compare between the two environment. Pattern should be similar.

    Regards,
    Arif

    • 75 views
    • 2 answers
    • 0 votes
  • Agile Angel Asked on May 24, 2018 in Product Collaboration.

    Hi Kenshin,

    There are chances mixed content is blocked in Chrome/FF.  Also check if your save option is set as “Automatically download” instead of “Always Ask”.

    Follow the below steps to Enable the mixed content and give it a try.

    In Chrome
    ————-

    1. Click the Shield icon in the far right of the address bar.
    2. In the pop-up window, click Load anyway or Load unsafe script

    Regards,
    Arif

    • 96 views
    • 2 answers
    • 0 votes