stevend17's Profile
Agile Talent
259
Points

Questions
8

Answers
34

  • Agile Talent Asked on April 1, 2021 in Agile PLM (v9).

    Hi Alex,

    We’re still on 9.3.2 and our notification table currently hosts 4 different object types.

    ID            PARENTID     DESCRIPTION
    6000     5002                  Change Orders
    7000     5002                  Change Requests
    18022  5002                  Activities
    18451  5002                  discussions

    Steve

    • 188 views
    • 2 answers
    • 0 votes
  • Agile Talent Asked on April 1, 2021 in Product Collaboration.

    Madhu,

    My first thought is that I’m not sure you can make such a restriction based solely on permissions. It seems to me that you would need a process extension, possibly one triggered when the affected items table is updated, that would look for the criteria in question and provide validation to the user or simply remove the invalid item.  I realize that’s not a big help, but not sure how you can do this without customization. At our company, we created a configurable validation PX, which is used to validate many situations. In a case like this, it would initially allow the user to add the affected items, but would validate upon workflow change, and then return the workflow to a status of Error.   I’m hoping someone can provide a simpler solution for you.

    Steve

    • 173 views
    • 2 answers
    • 0 votes
  • Agile Talent Asked on April 1, 2021 in Product Collaboration.

    Manoj,

    Try this…

    SELECT MP.PART_NUMBER, M.NAME
    FROM AGILE.MANUFACTURERS M
    INNER JOIN AGILE.MANU_PARTS MP ON M.ID = MP.MANU_ID
    INNER JOIN AGILE.MANU_BY MB ON MP.ID = MB.MANU_PART
    INNER JOIN AGILE.ITEM I ON MB.AGILE_PART = I.ID
    WHERE MB.PREFER_STATUS = 1
    AND MB.CHANGE_OUT = 0
    AND I.ITEM_NUMBER = :ITEMNUMBER

    This answer accepted by agileplmuser. 5 days ago Earned 15 points.

    • 74 views
    • 1 answers
    • 0 votes
  • Agile Talent Asked on March 1, 2021 in Agile PLM (v9).

    The best way I have found to order an exploded BOM is to  include a SYS_CONNECT_BY_PATH statement, which is also what mrmathison did.  the difference that I construct that path based on the find number rather than the part number. This should keep the exploded order just as expected.  In my case, I’m assuming the find numbers to be numeric, but keep in mind the field is a string. To build something that sorts properly, you must pad the find the numbers with zeros to a length greater or equal to the greatest number of digits you allow for a find number. We typically only allow only up to 4-digit find numbers, so that’s what the following example includes. The BOLD test below is what I added.

    SELECT childItem, ITEM_PATH
    ,findNumber, bomLevel, i.item_number as PARENT_ITEM, c.change_number,r.rev_number,c.id,r.change,n.id
    ,NVL(n.DESCRIPTION, ‘Preliminary’)
    FROM (
    SELECT DISTINCT A.item_number As childItem, A.find_number as findNumber
    , SYS_CONNECT_BY_PATH(LPAD(A.FIND_NUMBER,4,’0′), ‘|’) ITEM_PATH
    , a.item as item, LEVEL as bomLevel
    FROM 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 = ‘EC2630QI’)
    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 nocycle 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)) BOM
    INNER JOIN Item i ON BOM.item=i.id
    INNER JOIN Rev r on r.item = (select id from item where item_number =childItem) and r.latest_flag=1 AND R.SITE = 0
    INNER JOIN Nodetable n on r.release_type=n.id
    INNER JOIN Change c on c.id=r.change
    ORDER BY ITEM_PATH;

    • 237 views
    • 2 answers
    • 0 votes
  • Agile Talent Asked on February 2, 2021 in Agile PLM (v9).

    Htsh, Have you tried simply using the Import feature under the Tools menu.  You can create an XLS file with some minimum required fields and create both new items and their BOMs. Exactly how much information you provide in the Excel sheet may depend on what your organization  requires and if the attributes are change controlled or not.  Are you creating new items in addition to adding components to their BOMs or just adding BOMs to existing items?  If both, it may go smoother if done in 2 steps… do one import just to create the items, and then another to add components to their BOMs.  I was able to do both at the same time. I did get one error, but in the end it still did what I needed.  Here’s a sample of what your spreadsheet might need to contain.  Your requires will obviously vary some, such as subclass names and Master Item Type (MIT). It doesn’t really matter what you name the columns as long as you map the values properly in the import.

    ITEM_NUMBER SUBCLASS DESCRIPTION MIT COMPONENT FIND_NUM QTY
    TESTASSY1 Design Part Test Assembly One Phantom Assembly-PHASSY COMPPART1 1 2
    COMPPART1 Design Part Test Component One Make Part-MP

     

    Hope this helps,

    Steve

    • 159 views
    • 1 answers
    • 0 votes
  • Agile Talent Asked on October 26, 2020 in Product Collaboration.

    Laura, it is possible that something in the database has gotten corrupt. Have all saved searches stopped working, or just this one?  If just this one, you might simply try recreating it and saving it with a slightly different name. I also recommend that you use Number Equals rather than Number Contains, unless that just won’t work for your users.  It runs quite a bit faster if you do that.

    Steve

    • 255 views
    • 1 answers
    • 0 votes
  • Agile Talent Asked on October 26, 2020 in Agile PLM (v9).

    Ravi, your question is not real specific.  Obviously redline changes take place on a Change Order. Are you looking for BOM changes or changes to other change-controlled attributes?

    Are you looking to do this via database query or did you have something else in mind? If query, I may be able to help. Let me know.

    • 288 views
    • 2 answers
    • 0 votes
  • Agile Talent Asked on October 26, 2020 in Agile PLM (v9).

    Priya,

    You might also try this… It seems to run fairly quickly.

    SELECT * FROM
    (SELECT I.ITEM_NUMBER, COUNT(B.COMPONENT) CNT FROM AGILE.ITEM I
    LEFT JOIN AGILE.BOM B ON I.ID = B.COMPONENT
    WHERE I.CLASS = 10000
    GROUP BY I.ITEM_NUMBER)
    WHERE CNT = 0;

    It is a bit over simplified though. This would return only items that have NEVER been on a BOM. As you are probably already aware, it is possibly for an item to be a component in the BOM table, but not be on the latest BOM because the item had been redline removed on a change order.  This query does account for that use case, but with a little more work, it could.

    Steve

    • 245 views
    • 2 answers
    • 0 votes
  • Agile Talent Asked on August 3, 2020 in Agile PLM (v9).

    Wow, that is a really good question. Clearly there is not any one way to answer this or even a right or wrong answer.  I think I read once that any documentation is better than no documentation. For us, I don’t think we’ve yet found a consistent and formal way of doing this, but I can tell you the direction we are moving on this.

    First, let’s clarify the type of environment changes that you may be talking about. I’m guessing that you’re referring to configuration changes. This could be as simple as adding a new Page Three attribute to a subclass to creating a brand new subclass.  The company I work for has many process extensions (PX) within Agile.  In many cases, the way those PXs behave are based on Agile Document items that we use as configuration objects.  Without them, the PX does not function, so it is indeed important that we document how to recreate these objects and what purpose they serve.  Personally, one of my favorite tools to document most anything was a free app called ClarifyIt. I still have it and use it, but unfortunately it is longer available. It is just a convenient tool to do screen captures and add headings and text to those screen captures. But honestly, you can do the same thing with Microsoft Word.

    We now use Azure DevOps for source control and to keep up with Features and tasks assigned to Analysts and developers. We have started to create UI configuration objects within DevOps to also document these Agile Configuration objects and changes to them. Within those, it’s descriptive text and images.  That’s really all it boils down to… any documentation tool where you can describe what you’ve done and add screen shots to provide clarification. How formal the documentation is a decision only you and your company decide on.

    It is possible that I’ve misunderstood what you’re asking for. It may be that you’re wanting some tool that extracts data from the system both before and after config changes.  I can’t make any recommendations on that, because I’m not aware of any such tool. That said, this has given me an idea. I have a database view that I created that shows subclass properties.  I could see running this each I make changes and then saving the output of this as part part of my documentation.  I may consider sharing this view at some time in the future.

    Steve LaLonde

    • 356 views
    • 1 answers
    • 0 votes
  • Agile Talent Asked on August 3, 2020 in Product Collaboration.

    Is the user logging in manually or through a Single Sign On  service?  Also, check to see if the user has made their own shortcut to launch the app.  Depending on how they went about doing that, it can save previous session data in the URL.  This can cause all kinds of weird behavior.

    Steve

    • 488 views
    • 2 answers
    • 0 votes