Results 1 to 7 of 7

Thread: Tips/Traps - X00022

  1. #1
    Senior Member
    Join Date
    Jan 2001
    Location
    Meridian, ID (and wherever there is work)
    Posts
    2,760

    Tips/Traps - X00022

    OK - Call me stupid (cuz, I'm sure the rest of you learned this on Developer Training, Day One)...

    I'm attempting to use X00022 to create a Unique ID for a Business Function in a report. For whatever reason, I'm not getting a value and it is crashing (ok, saying 'Error', then proceeding).

    I turned on logging - oh hail the chief, I see the mistaken direction of my ways:
    JDB9910006 - Read Only Report, Fetch for update not executed
    JDB9910020 - Read Only Report, Insert not executed

    Wow - I had never considered that the UKID Function would not work on a Read Only report! I guess I'd better make this 'simple' little read report an Update report....

    Now you know what I know (and you probably, already, knew it)....

    GoPhigure!

    (db)

    Daniel Bohner
    Independent E1 Developer/Techno-Functional Consultant
    www.JDERESEARCH.COM
    drbohner@JDEResearch.com | 208.495.4JDE
    http://www.linkedin.com/in/drbohner

  2. #2
    New Member
    Join Date
    Feb 2010
    Location
    North Carolina
    Posts
    11

    Re: Tips/Traps - X00022

    That is news to me. Thanks for the tip.

  3. #3
    New Member
    Join Date
    May 2001
    Posts
    27

    Re: Tips/Traps - X00022

    Ah well, not day one since we did not have that "no-update" feature back in B732

  4. #4
    Member
    Join Date
    Aug 2004
    Location
    NYC, Lower East Side
    Posts
    532

    Re: Tips/Traps - X00022

    that's a nice one. surprised me as well at 1st. but come to think of it, it does make sense though: it needs to keep track of the unique id to issue, so it needs to be stored in some table i presume. i just checked: F00022.

    ps: these kind of things make me choose "update report" by default when creating a new report, even if i'm not planning to do any table i/o.
    Technical Consultant Xe-9.1

  5. #5
    Senior Member Zoltan_Gyimesi's Avatar
    Join Date
    Oct 2000
    Location
    Budapest, Hungary
    Posts
    4,167

    Re: Tips/Traps - X00022

    Hi Daniel,

    More years ago it made me hard hours and head ache - that time with Get Next Number. Moreover, there were Transaction Processing over F0911 and some other table. The first symtom was, that the transaction always rolled back. I made this UBE from a copy of a similar of mine. I had never seen before Update report option on the UBE copy form - I think, it was a new feature after SP upgrade. Digging down, I detected, the Get Next Num and later Insert always faild - and because I hadn1t known this feature, it was hard to find the real cause and figure out, how to solve it.

    By the way, it makes sense that Get Next UKID does not work in a Read Only report - because it should update the UKID table.

    Regars,

    Zoltán
    - XE UPDATE 2 SP22, Intel NT4, SQL 2000
    - B9 (8.93B1)
    - was/is working with B7321, B7331, B7332 too

  6. #6
    Member
    Join Date
    Jun 2009
    Location
    New Jersey, USA
    Posts
    280

    Re: Tips/Traps - X00022

    Another place where you need update reports checked is in Financial reports that create journal entries. I understand that creating JEs is an update, however the process creates a batch of unposted JEs that have to be approved and posted like any other batch. There is no update being made to a control table. Also, the developer does not enter any code to do table updates, all the code is in the JDE supplied smartfield.
    Brad
    OneWorld B7321 - EnterpriseOne 9.1
    World F6.2 - A7.3

  7. #7
    Senior Member Adrian_Chimirel's Avatar
    Join Date
    Nov 2000
    Location
    Toronto, Canada
    Posts
    2,167

    Re: Tips/Traps - X00022

    Just another good intention (hell is so well paved with) turning against its creator.
    Adrian,
    E1 9.1 TR 9.2.2.4 03-26-2018_03 Orchestrator 6.1 MSQL 2016 x64, WebLogic 12c, all on WIntel 2016 x64
    3rd Party Software: PowerApps, All Out Security 3.2, TransForm 7.1, SAP Business Objects Enterprise XI 12
    In the Microsoft Azure Cloud!

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.