Skip navigation

When researching an issue with OMW, it is best to start with the OMW logging.  In the debug log, this is done by searching for the F98211 table.  Then you look at the insert statement to locate the data dictionary alias.  The best way to do this is to download Notepad++. Then open the log file and do a Find (CTRL-F) for the F98211. Select the button for Find All in All Opened Documents or if you have multiple documents open use Find All in Current Document if only working with one file.

 

FindAllCurrent.png

 

Then you can scroll through the results looking at the codes.  As an example, in the log we would have an entry similar to the following:

 

Jun 22 13:45:31.990006 - 5892/9072 WRK:Starting jdeCallObject        INSERT INTO SY910.F98211 (LDLOGKEY, LDLOGSEQ, LDOMWLDTAI, LDOMWLDATA, LDOMWDFS1, LDOMWDFS2, LDOMWDFS3, LDOMWDFD1, LDOMWDFD2, LDOMWDFD3, LDOMWDFN1, LDOMWDFN2, LDOMWDFN3, LDPID, LDMKEY, LDUSER, LDUPMJ, LDUPMT, LDTIMEZONES, LDDSAVNAME) VALUES ('B1B8210E-F047-45B8-95DA-3110F5F71E4E',17,'149T','R55000T|UBE|E910|USER |',' ',' ',' ',0,0,0,0.000000,0.000000,0.000000,'P98220', 'TOOLSB','USER',115173,134531.000000,' ',' ')

Reviewing the insert statement, we can locate the data dictionary error message alias '149T'.

 

Note: Many of the codes may be simply action called items which can be ignored.  For example, 130S is one of these.  As you go through the log, you’ll have to weed through these entries to locate the actual issue.

 

To look up any given code:

  1. Log into EnterpriseOne > Fastpath to DD > Launch the Error Messages application > Enter the alias into the Alias QBE field to search.
    DDFastpath.png
  2. Enter the alias from the insert statement from the log into the data item QBE and press find
    ErrorCodeDD.png
  3. Open the data dictionary item and select the Item Glossary tab to see the full details of the message
    Glossary.png

 

If you look at the OMW logging in OMW, you should see a message similar to what we see in the Glossary Text.

 

  1. Highlight the object in OMW
  2. Row exit > Logging
  3. Find
  4. Select the log entry or Row > Log Detail

 

Some of the error codes can be self-explanatory in their resolution. However, others may need further research.  Once you locate the error code, simply search in MOS for the code and you should get a document with details on its resolution.  This process can be seen in the following examples where we locate the code and the document with additional details.

 

Example with Document:

 

Jun 03 07:24:44.061005 - 2608/3944 WRK:Starting jdeCallObject INSERT INTO SY910.F98211 (LDLOGKEY, LDLOGSEQ, LDOMWLDTAI, LDOMWLDATA, LDOMWDFS1, LDOMWDFS2, LDOMWDFS3, LDOMWDFD1, LDOMWDFD2, LDOMWDFD3, LDOMWDFN1, LDOMWDFN2, LDOMWDFN3, LDPID, LDMKEY, LDUSER, LDUPMJ, LDUPMT, LDTIMEZONES, LDDSAVNAME) VALUES ('54497473-6a7f-49b9-8fce-0e8a396c41b5',2,'130H','a required Template|the destination for this version.  Template must exist in the target location before the version, or be in the same project if this action is being done on the project.|',' ',' ',' ',0,0,0,0.000000,0.000000,0.000000,'P98220', 'TOOLSB','USER',115154,72444.000000,' ',' ')

 

Check In Fails for One Specific UBE version. Error: 130H - Template Must Exist In The Target Location Before The Version (Doc ID 2011394.1)

 

Example with Document:

 

Jan 05 19:47:37.609003 - 3748/1612 WRK:Starting jdeCallObject INSERT INTO JDE812.SY812.F98211 VALUES ('07829c75-9eaf-4dbd-951d-903a85a685fa',12,'130J','c:\e812\DV812\include\F0005.h|FUtil::CopyF|',' ',' ',' ',0,0,0,0.000000,0.000000,0.000000,'P98220','TOOLSB','USER',110005,194737.000000,' ',' ')

 

Error 130J "Failed to write file" during Check-In or Check-Out of a Business Function or Table (Doc ID 631737.1)

 

Additional details on this troubleshooting process can be found in document Understanding OMW Logging in Object Management Workbench (P98220) (Doc ID 1569747.1) and OMW Troubleshooting Tips and Techniques (Doc ID 660791.1).

ChristyH-Oracle

Optimizing Performance

Posted by ChristyH-Oracle Aug 21, 2015

JD Edwards published two new white papers on driving the performance of JD Edwards EnterpriseOne using Oracle In-Memory Advisor:

Take Action: Read and share these white papers with customers and partners:

You can also navigate to the white papers from www.learnjde.com > White Paper Index > Performance.


We value your feedback! After reading the white papers, please rate them and provide reviews at the links above.

If your company reorganizes or acquires another business, you might need to move an existing business unit to a different company. You complete this move by changing the company number on the business unit and then updating the relevant tables with the new company number.

 

Following graphic illustrates the process of moving Business Unit 3 from Company 1 to Company 200:

 

Moving_Business_Unit.png

 

You achieve this by running following integrity reports in update mode in sequential order:

 

  1. Accounts without Business Units (R097041)
  2. Account Balance without Account Master (R097031)
  3. Transactions without Account Master (R097021)


Additionally, if your company has recently expanded or merged with another company, or a management decision has been made to change financial reporting, you might need to change the company account structures in the chart of accounts. This task might involve:

 

  • Creating new business units and moving existing account detail and balances to the new business units. You can change the business unit portion of the account number on many accounts at once by globally changing the business units. For example, you can change business unit 501 to business unit 301 for all object and object.subsidiary accounts. You can run the Global Business Unit Change application (P09812) to change business unit for multiple accounts.
  • Creating new object or object.subsidiary accounts under an existing or new business unit, and moving existing account detail and balances to the new object.subsidiary or business unit.object.subsidiary. For example, you can change object account 1131 to 1132 for all business units in company 1 or you might change the subsidiary portion of account 1110.BEAR i.e. BEAR to 2220 for data entry efficiency. For these scenarios, you can run the Global Account Number Change application (P09803) to change object accounts for one company or for all companies and Global Subsidiary Update application (P09805) to change Subsidiary for multiple accounts.

 

In addition to changing the structure of your accounts, you can also run programs that:


  • Change Account information. For instance, you can run the Change Account Information program (R09813) to change information such as account description or posting edit code for several accounts at one time.
  • Change Model/Consolidation field. For instance, you can run the Update Model/Consolidated Field program (R0006QD) if you change the value of the Model/Consolidation field on a business unit. This program updates the Model/Consolidation field on all accounts in the business unit to match the value for the field for the business unit.
  • Update Category Codes. For instance you can run the Update Cat Codes F0101>F0006 program (R098021) to ensure that the category code information for a business unit in the F0101 table matches the category code information for the business unit in the Business Unit Master table (F0006).

 

More detailed information on Global Updates applications can be found in the following KM documents:

  • How To Run Global Updates for Organizational and Account Structure Revisions In EnterpriseOne (Doc ID 1390947.1)
  • How To Change the Company Number for a Business Unit In EnterpriseOne (Doc ID 664718.1)
  • How To Run Global Update To Change Account Information (Doc ID 664713.1)
  • Global Update: Update the Model/ Consolidated Field (Doc ID 1393249.1)
  • How To Run Update Category Codes F0101>F0006 program For Business Units In EnterpriseOne (Doc ID 1393213.1)

Starting in Tools Release 9.1.5.5, Internet of Things (IoT) components are available for download from the Update Center.  This allows customers to run IoT orchestration samples and create their own orchestrations which utilize our standard JD Edwards EnterpriseOne system.  IoT Orchestrator works with applications built on EnterpriseOne applications release 9.0 and 9.1 with Tools Release 9.1.5.5. 

This document is the place to get started.


E1: IoT: Installation of Internet of Things Orchestrator components (TR 9.1.5.5) (Doc ID 2026713.1)


Sample Orchestrations can be downloaded from the Update Center by selecting EnterpriseOne IoT Orchestrator

On the Oracle Learning Library  (OLL) you will find more information related to IoT, video demonstrations and an Oracle by Example document which steps you thru a simple orchestration using Address Book

The AIS server now contains a built in client used to run the samples.  Here is a screen shot of what the client looks like when running the Sample Orchestration

Using cross-references, rules, and service requests, business analysts can design orchestrations that tie IoT devices directly to JD Edwards EnterpriseOne applications. The samples provided from the update center demonstrate all these features.

Are you looking to improve the performance of your Blend and Grower modules? Oracle has proactively addressed these issues in some ongoing improvements to meet our customer needs in the Blend and Grower modules.

 

Bug 19956791: Roll Forward/Recalculation - Performance Improvement

  • Reduce the amount of data that rolls-forward, by classification of Lot Attributes.  Any change to the Lot attributes now results in just that attribute being recalculated during roll-forward.
  • When new operations are inserted, operations are closed, or any legitimate changes are made to lot attributes, recalculations now function more efficiently.

 

Bug 20108356: Blend Dependency and Barrel Inquiry

  • Create Dynamic Dependency chain - The Blend Dependency Chain has been re-written to take advantage of new technology; enabling the system to reliably and efficiently maintain dependencies with large volumes of data. 
    • Uses data from Operation header Table (F31B65) and the Vessel Assignments Table (F31B70) to dynamically fetch and display the required data.
    • It is no longer required to maintain the static dependency chain (F31B33) table.
    • Eliminates errors due to data corruption.
    • Fetches and maintains the data on-demand basis.
    • It is no longer required to run R31B33FIX. 
  • Set-based APIs in B31B6530 (GenerateBarrelInquiry BSFN) has been enhanced.
    • Leverages the latest Tools features (9.1.5.x) to improve the performance.

 

Note: There are two Special Instructions when applying the ESU containing Bug 20108356:

  1. Table Generation - Barrel Inquiry Work File (F31B03E) has been modified for the bulk insert. The table will have to be regenerated for Barrel Inquiry.
  2. Requires Mandatory Tools Release of 9.1.5.x or higher.

Are you or have you experienced issues with the grid (import / export) or media object (icons missing) with your Internet Explorer browser?  Many grid and media object issues are actually ActiveX control issues, and not a problem with the E1 html client.  However, troubleshooting and identifying ActiveX as the cause and resolution can be confusing when someone does not have any experience with Microsoft ActiveX controls.  Over the years, we have provided two main documents in order to help identify and resolve these issues:

 

  • E1: MOBJ: Working with E1 Web Client ActiveX Controls for Media Object and Grid Export / Import (Doc ID 1056203.1)
  • E1: GRID: Troubleshooting Internet Explorer ActiveX Control Installation and Configuration Issues (Doc ID 1621386.1)

  

Both of these documents provide installation instructions and troubleshooting information.  Recently, we have added a new Troubleshooting Flow Chart, which is linked from the previous documents.  This new flowchart provides a visual step by step set of troubleshooting steps complete with videos to show what needs to be done.  Be sure to try it out the next time your struggling with Internet Explorer and ActiveX controls.  (An example screen shot is shown below)

Note: If you have not seen it, be sure to review the previous blog post, Running JD Edwards EnterpriseOne with Internet Explorer (IE) Compatibility View.

FlowChart.png

 

video.jpgCheck out our these great sales and procurement documents that include videos                                                                      

 

Sales

  • Line Types in Sales [Video] (Doc ID 985506.1)
  • Sales Order Templates [Video] (Doc ID 1479659.1)
  • Backorders in Sales FAQ [Video] (Doc ID 763476.1)

  

Procurement

The Financial Accounting Standards Board (FASB) and the International Accounting Standards Board (IASB) created a joint standard regarding the recognition of revenue.

 

Revenue recognition is the accounting rule that defines revenue as an inflow of assets, not necessarily cash, in exchange for goods or services. It requires the revenue to be recognized at the time, but not before, it is earned. You use revenue recognition to create G/L entries for income without generating invoices.

 

Generally, you use revenue recognition when:

  • You have finished the work and you have earned the income, but you do not need to bill a customer yet.
  • You want income statements and balance sheets to reflect the amounts earned for a realistic picture of the company's financial status.
  • You need to reallocate internal costs.
    • To calculate revenue (actual or accrued) for the current period, you must create G/L journal entries. The amounts related to these entries appear on the income statements and balance sheets when you complete the revenue recognition process. You can use the recognized revenue amounts for projections and to review the profitability or liability of specific departments in the organization.

     

More information on this new enhancement can be found in New Enhancement For FASB – Revenue Recognition in Contract Service Billing For Release 9.1 (Doc ID 2030133.1).

This winter, the UK Oracle User Group brings you the UKOUG JD Edwards Conference & Exhibition 2015! Held at the ICC Birmingham on the 8th & 9th of December, this conference is the go-to event for the JD Edwards community.


As well as being in a location central to the UK, this event is co-located with UKOUG’s other flagship conferences Tech15 & Apps15, meaning you can attend sessions and exhibitions stands from our other two conferences, giving you a higher ROI than attending a standalone conference.


With the popularity of this event growing year on year, this year’s conference is packed with loads of new features to help you embrace, explore, and evolve your Oracle knowledge & professional network.


So what could you get out of attending JDE15?
Following on from the success of last year, UKOUG will be bringing back their
Knowledge Bite sessions that give delegates short and engaging sessions in a round table environment. These sessions are really interactive and each Knowledge Bite is on the agenda 3 times consecutively. As a delegate, you can attend up to 3 30 minute sessions across the time period, interchanging rooms at the end of each 30 minute slot. This helps break up the longer presentation sessions and keep you engaged and focused. Allowing you to ask questions, and delve deeper into the topics that affect you in your working life.

 

With sessions on the agenda ranging from the topics of; supply chain, cloud, talent retention, reporting, security, integrating external systems and electronic software updates - the UK Oracle User group have selected the very highest quality papers from the like of; RF-Smart, Differentia Consulting, Altro, Steltix, DWS, Q Software, Pwc and more. The agenda features customer stories, to give you a better understanding of how the UK’s 350 JD Edwards vendors can help benefit the JDE community, plus live demo stands where vendors can show delegates the features of the products  mentioned in their sessions, or are presented on their exhibition stands. This allows you as a delegate to see their products in action, giving a greater level of meaning and understanding to the sessions, and giving you a visual and physical take away to bring back with you to the office.

To top it all off this two day event starts each day with a keynote session from some our top JD Edwards experts; Lyle Ekdahl, and Bob Monahan & Gary Schreiber - discussing topics such as innovative solutions for the modern enterprise, and the JD Edwards applications and tools roadmap. These Oracle celebrities will also be featured on the ‘Oracle Panel Session’ that will close the conference and allow you to ask the burning questions you have developed over the two day conference, providing you with that last key piece of takeaway knowledge.

 

With all those great learning opportunities available to you at the conference, they have also prepared some great networking opportunities too! With beach themed JDE exhibition drinks, as well as a combined conference social, you can chat and engage with other JDE users, and grow your professional network as well as build your professional profile among others in the industry who face the same trials and tribulations as you do.

 

Combine this with the Test Fest Scheme, Oracle UX Lab, and the option to visit Apps15 & Tech15, they way that this year’s JD Edwards Conference & Exhibition has adapted to the needs of the JDE community promises a worthwhile, engaging, and knowledge filled event, providing the JDE group here in the UK, with its key annual conference for its community.

 

If that wasn’t enough to twist your arm, take a look at the agenda, the conference website, or the JDE15 LinkedIn Group to find out what else the UK Oracle User Group has in store for you at JDE15.

Filter Blog

By date: By tag:

Welcome to the My Oracle Support Community! We highly encourage you to personalize your community display name to make your activity more memorable. Please see https://community.oracle.com/docs/DOC-1022508 for instructions.