Results 1 to 8 of 8

Thread: Cross Reference Facility

  1. #1

    Cross Reference Facility

    What is current Oracle best practice, or just general consensus among the JDE community, on rebuilding the Cross Reference Facility (P980011) for existing environments? In the system I'm working on it is completely inaccurate. For example, if I go to Tables Used by an Interactive Application and put in a standard application such as P4021 it doesn't list a single table. I'm sure that can't be correct. In a previous installation I scheduled all environments to rebuild the tool once every 6 months, but the current CNC team I'm working with doesn't rebuild at all 'because it takes too long.' Opinions/thoughts?

  2. #2
    Senior Member
    Join Date
    Mar 2004
    Location
    Fort Worth, Texas
    Posts
    1,456
    We usually rebuild in DV after every full build. We do a full build in DV on demand when needed or about once a month. I am a developer and I usually kick of the xref build, usually on my local full client and usually over a weekend.
    Brian Oster
    Application Development Manager
    E1: 9.0 (TR9.1.5.1) / 9.2 (TR9.2.2.2)
    JAS/BSSV: Weblogic 12.1.2 / Weblogic 12.2
    ES: Win2008 / Win2016
    DB: MSSQL 2014 / 2016
    WebDev Client: Win7Pro / Win10Pro

  3. #3
    Quote Originally Posted by BOster View Post
    We usually rebuild in DV after every full build. We do a full build in DV on demand when needed or about once a month. I am a developer and I usually kick of the xref build, usually on my local full client and usually over a weekend.
    You know there is update capability, right?

    R980011 change data selection to BC Date - Updated (UPMJ) > = [last run date]

  4. #4
    Member David Robertson's Avatar
    Join Date
    Nov 2000
    Location
    UK
    Posts
    275
    Run it once in DV, then the update as needed, maybe every 6 months, depending how much development work you do.
    You don't really need it in other environments, and if you do, map the OCM to the DV tables.

    Developer / CNC
    E9.1 TR 9.1.4.6 AS/400
    WebSphere 8.5.0.2 AS/400
    DB2 AS/400

  5. #5
    Member Soumen's Avatar
    Join Date
    Sep 2005
    Location
    Houston, Texas
    Posts
    233
    And ... use UBECommander to schedule it in Windows to run as per our needs... then forget about it! ;-)

  6. #6

    Limit to only 1 environment

    Quote Originally Posted by David Robertson View Post
    Run it once in DV, then the update as needed, maybe every 6 months, depending how much development work you do.
    You don't really need it in other environments, and if you do, map the OCM to the DV tables.

    How do I limit cross-reference to only the DV environment? Seems to me that a contractor enabled it in all environments and it was not that way before.

  7. #7
    Member David Robertson's Avatar
    Join Date
    Nov 2000
    Location
    UK
    Posts
    275
    You run the UBE in the environment you choose. DV is usually where you want to run it, as that would then include any development work.

    The tables where the xref info is written to, can be mapped so that they are common across environments, which can be convenient if you want to access them from PY or such.

    I have never seen the need to run it in every environment, and certainly not to schedule it being rerun from scratch on a regular basis.

    Developer / CNC
    E9.1 TR 9.1.4.6 AS/400
    WebSphere 8.5.0.2 AS/400
    DB2 AS/400

  8. #8
    Quote Originally Posted by JThompson1 View Post
    How do I limit cross-reference to only the DV environment? Seems to me that a contractor enabled it in all environments and it was not that way before.
    What are your OCM mappings for F980011 and F980021?

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.