Skip navigation

Reader.pngThis new KM document explains general next numbering behavior for API JDB_SelectKeyedForUpdate using the table F00021. Document ID 2351706.1.

Reader.pngJD Edwards EnterpriseOne has been enhanced to provide barrel import functionality in the Blend Management product for release 9.2.


During the time of year when winemakers transfer wine from tanks to barrels, there is a large quantity of data to manage. A tank of wine could be broken down into thousands of barrels, for which the records are commonly stored in a spreadsheet or csv file. With the Barrel Import enhancement, users can now take the thousands of barrels stored in a file, and import or copy and paste them into a Blend Management operation. This saves users valuable time and improves the accuracy of the data imported. Doc ID 2356414.1.

Reader.pngJD Edwards EnterpriseOne release 9.2 has been enhanced to provide inventory commitment functionality in the Grower and Blend Management product.


Grower and Blend operations that use additives, sprays, or consumables now validate the availability of that inventory. Because an inventory commitment is created at the time the operation is created, buyers now have visibility into inventory that is running low and users are assured that the inventory and lot is available at the time they are executing the operation. When the operation is closed, inventory is relieved ensuring that on-hand inventory remains accurate. If the items used are non-stocked items or for Grower Spray operations that are not internally supplied, availability checking, updating commitments, and updating on-hand inventory will be disabled. Doc ID 2356412.1.

As we approach the end of FY 2017 (for those of you who are following a non-calendar date pattern), it’s a great time to start thinking about year-end close issues. Rather than wait until the end of closing month, getting a head start can improve your chances of closing smoothly without any issues by the closing month.


There are several tasks that need to be completed as part of the closing process; including closing the accounting period, changing the financial reporting date and closing the fiscal year.  Before closing the year, there are several other tasks that need to be performed before the annual close can take place:


  • Verify General Ledger Automatic Accounting Instructions (AAIs)
  • Set up Leger Type points to close to retained earnings
  • Enter period-end accruals
  • Review and post all batches
  • Verify data integrity
  • Reconcile General Ledger to bank accounts
  • Run monetary account valuation and financial reports


In addition to these tasks, organization should develop their own detailed closing tasks and include them in their internal documentation.


You can also review these knowledge articles for more information on the Annual Close Process:

  • Overview of Annual Close Report (R098201) (Doc ID 664688.1)
  • Frequently Asked Questions on the Annual Close Report (R098201) (Doc ID 664687.1)

Reader.pngThe Inbound Condition-Based Alerts Inquiry (P1310Z1) is accessed from EnterpriseOne menu G13CBM311. This application can be used update and review information that was added to the F1310Z1 table from the Inbound Flat File Conversion batch program (R47002C), or to simply add a new inbound record manually. The Inbound Condition-Based Alerts Processing (R1310Z1I) batch application copies transactions from the Unedited Condition-Based Alerts table (F1310Z1) and populates the Condition Based Alerts table (F1310). Depending on the settings in the batch application’s Version tab, the system can initiate other downstream Condition-Based processing. This new KM document explains how to add an install base record using the Inbound Condition-Based Alerts Inquiry (P1310Z1) and the minimum fields necessary. Document ID 2346377.1.

Reader.pngThis new KM document provides an example of how to use a groovy script to call an external database table. Document ID 2345190.1.


Are you using the customer credit limits and credit hold codes to effectively manage accounts receivable?


Credits granted to your customers are similar to financial loans.  Effective use of the credit limit ensures that the amount of credit granted a customer aligns with the financial abilities of each customer.


Setting up a credit limit on a customer account does not mean that new sales orders cannot be created for the customer. In EnterpriseOne, credit holds can be setup based on the customer's credit limit or based on the age of open accounts receivable.  A credit hold on a customer's sales order(s) will prevent further processing of the order, to reduce your risk.  You don't always want to ship items to customers who are poor payers, customers with a history of late payments or missed payments.


Did you know that you can record information for credit insurance policies (insured credit limit) in EnterpriseOne?


Don't get caught with large noncollectable accounts receivable balances. Review the functionality available in EnterpriseOne in Credit Checking (Doc ID 2319760.2).



Reader.pngFailure Analysis is tool that can help the end user identify failures, analyze their symptoms and arrive at a resolution in an effective manner. Data recorded in the Failure Analysis system can be used to track failure trends related to equipment records. Once set up, the Failure Analysis can be used from Cases, Capital Asset Management Work Orders or Service Warranty Management Work Orders. When an organization requires data related to equipment failures as reported in cases and work orders, Failure Analysis can be useful for end users as a guide to product analyses and resolutions. Over time, as users input more failure analysis information, an enhanced Pareto Analysis can be helpful for faster resolutions. This new document provides an overview, setup and execution. Document ID 2345769.1.

Is your organization hampered by not being able to use Basket level price adjustments in Procurement? We heard you, and we’ve changed that in the 9.2 release. Now, all the features you know and love from Sales Order Basket Pricing are available for Purchase orders including interactive/batch/automatic repricing, Enhanced Baskets, and complex customer (supplier) groups, to name a few. Plus, you have the option to apply the adjustment during order entry or at receipt.


There is an ESU to install, but once that’s done, the functionality has the same look and feel as the Sales Order Basket processes, so you can hit the ground running. We even added a new UBE to tie it all together: Basket Level Pricing for Procurement program (R45750).


For full details see Basket Pricing for Procurement Enhancement Available (Doc ID 2290155.1). We’d love to show you how it all works in our Advisor Webcast, too. Mark your calendar for March 27th 2018 and register at Document ID 2357496.1.


New EnterpriseOne Basket Pricing for Purchase Orders – it’s a slam-dunk !!!


This new KM document provides information about how to use watchlist outputs as inputs for Orchestration steps, i.e. use watchlist values in an orchestration. Document ID 2345166.1.


JD Edwards on Cloud- The Offering !


  • You can run JD Edwards on Oracle Cloud by using the IaaS offerings as a substitute for your owned or hosted hardware systems.
  • Regardless of whether you run on Oracle Cloud, you can also run JD Edwards EnterpriseOne with Oracle Cloud by adopting any of the many PaaS and SaaS offerings to complement JD Edwards EnterpriseOne.


Key Benefits of JD Edwards on Cloud:


  • Support for business growth :

Deployment on Oracle Cloud gives you the capability of elastic expansion without disruption.


  • Greater business agility:

You can scale up or down to achieve the agility to respond quickly to changes such as acquisitions, globalization, divestitures, and regulatory or process changes, with the ability to adopt new technologies or applications functionality. With JD Edwards One-Click Provisioning,you can provision

new development, test, and production environments on Oracle Cloud quickly in response to such changes without IT bottlenecks that could lead to disruption of day to - day operations.


  • Lower cost:

With Oracle Cloud deployment, you can both lower costs and make them more predictable as your cost is commensurate to usage. You reduce the need for upfront capital expenditure hardware by paying for usage as you go and eliminate wait time for hardware and other resources.


  • Risk reduction:

You lower your overall risk with Oracle Cloud because you get a complete integrated technology stack from a single vendor


Provisioning a New JD Edwards EnterpriseOne Installation on Oracle Cloud:


You can provision a new JD Edwards EnterpriseOne installation on Oracle Compute Cloud Service using one of the following:


Trial Edition on Oracle Cloud

  • The JD Edwards EnterpriseOne Release 9.2 Trial Edition provides a fully functional suite of interconnected virtual machines.
  • These virtual machines are deployed on a single Oracle Cloud instance.
  • The virtual machines contain a snapshot of an EnterpriseOne server at a certain point in time and cannot be updated.
  • The Trial Edition is for demonstration purposes only and can be used it to verify functionality and investigate proof of concepts.
  • The Trial Edition only contains the Pristine environment, which is one of the four standard JD Edwards EnterpriseOne environments. It does not contain a Deployment Server or allow for the creation or use of a Development Client.

Review the "Deploying JD Edwards EnterpriseOne Trial Edition" Oracle-By-Example tutorial for instructions.


Multi-Tier Installation on Oracle Cloud

  • This allows you perform a fresh install of JD Edwards EnterpriseOne in Oracle Cloud Infrastructure as a Service.
  • Optionally you can also install JD Edwards Database on Oracle Database Cloud Service (DBCS).
  • You can also use this environment for Lift and Shift of on-premise JD Edwards environment

Review the OBE (Oracle-by-Example) documentation:
"Deploying the JD Edwards EnterpriseOne Release 9.2 Oracle Linux Servers for Multi Tier Edition"
Deploying the JD Edwards EnterpriseOne Release 9.2 Deployment Server for Multi Tier Edition"


One-Click Provisioning on Oracle Cloud

Oracle Cloud Infrastructure Classic:

  • JD Edwards continues to invest in automating the deployment of JD Edwards EnterpriseOne in Oracle Cloud. JD Edwards One-Click provisioning provides an easy-to-use, automated framework for deploying JD Edwards EnterpriseOne environments to Oracle Cloud.
  • One-Click Provisioning introduces a console that provides an automated process for deploying and scaling out a JD Edwards EnterpriseOne environment with a single click.
  • The One-Click Provisioning console provides an intuitive user interface that enables you to easily provision a fully functional suite of interconnected Linux-based servers and a Microsoft Windows-based Deployment Server.
  • Configure your Oracle Cloud account details and orchestrate your deployment plan by choosing the JD Edwards EnterpriseOne components, server names, and virtual machine sizes to deploy.
  • The One-Click Provisioning deployment also includes the JD Edwards Server Manager Console (SMC) and Application Management Suite for JD Edwards EnterpriseOne (AMS4JDE) for Oracle Enterprise Manager Cloud Control (EM 13c). This version of AMS4JDE plug-in allows you to automatically deploy the Enterprise Manager Hybrid Cloud Agent onto your Oracle Cloud environment and manage JD Edwards EnterpriseOne deployments to Oracle Cloud and on-premise from a single console.


Detailed Instructions for Oracle Cloud Infrastructure Classic:

"Preparing for a JD Edwards EnterpriseOne Release 9.2 Deployment Using One-Click Provisioning on Oracle Cloud Infrastructure Compute Classic"
"Deploying JD Edwards EnterpriseOne Release 9.2 Using One-Click Provisioning on Oracle Cloud Infrastructure Compute Classic"
"Deploying JD Edwards EnterpriseOne Release 9.2 Using One-Click Provisioning on Oracle Cloud Infrastructure Compute Classic and Oracle Database Cloud Service"
"Deploying JD Edwards EnterpriseOne Release 9.2 Using One-Click Provisioning on Oracle Cloud Infrastructure Compute Classic, Oracle Database Cloud Service, and Oracle Java Cloud Service"


Oracle Cloud Infrastructure:

  • Oracle Cloud Infrastructure combines the elasticity and utility of public cloud with the granular control, security, and predictability of on-premises infrastructure to deliver high-performance, high availability and cost-effective infrastructure services.
  • Oracle Cloud Infrastructure redefines how you modernize, innovate, and compete in a digital world with industry-leading compute, high-performance storage, enhanced networking and DNS, and a stack of complete and seamlessly integrated Cloud Platform services such as database and load balancing services.
  • JD Edwards EnterpriseOne deployed on Oracle Cloud Infrastructure enables you to take advantage of these benefits and accelerate your path to digital transformation.


Detailed Instructions for Oracle Cloud Infrastructure:

"Preparing for a Deployment of JD Edwards EnterpriseOne Release 9.2 on Oracle Cloud Infrastructure"
"Deploying JD Edwards EnterpriseOne Release 9.2 Using One-Click Provisioning on the Oracle Cloud Infrastructure"


Hybrid Cloud for JD Edwards EnterpriseOne:


The term “hybrid cloud” means that making smart use of cloud technologies is not a “yes-or-no” or “all-or-nothing” decision. As customers and partners evaluate their choice of platform and deployment options against their business requirements, most configurations will result in a hybrid deployment ,model in which some of the functionality and computing resources remain on-premise and some are more optimally provisioned via cloud services. Depending on your business needs, here are some potential scenarios:


  • Development and test environments can be deployed on the cloud platform while the production instance can continue running on-premise.
  • EnterpriseOne test/development and production instances can be deployed on the cloud platform while some of the integrations can run on-premise or vice versa.
  • EnterpriseOne test/development and production instances run on-premise or on the cloud platform while you extend and complement EnterpriseOne functionality by selectively adopting cloud-based services,such as Oracle Mobile Cloud =Service, Internet of Things Cloud Service, Business Intelligence Cloud Service, or many others.


JD Edwards supports these scenarios and hybrid deployment models, thus empowering customers and partners with choice and control. In general Oracle does not recommend splitting the tiers of a single JD Edwards EnterpriseOne environment between on-premise and cloud, for example, running the web tier on-premise and the database in the cloud.


Does Oracle provide managed services for JD Edwards EnterpriseOne on Oracle Cloud?

Oracle’s Managed Cloud Services (OMCS) team provides managed services for customers running Oracle JD Edwards EnterpriseOne instances on Oracle Cloud or on-premises. Oracle partners can also provide managed services with JD Edwards on Oracle Public Cloud.


Important Documents:


E1: OCI: Frequently Asked Questions for JD Edwards EnterpriseOne on the Oracle Cloud (Doc ID 2093838.1)

E1: OCI: Getting Started with JD Edwards EnterpriseOne on the Oracle Cloud (Doc ID 2149203.1)


Three new how-to documents have been created for US 1099 year-end processing:

* Setup 1099 Version Processing for Electronic Filing. Document ID 2345261.1

* Create Two Separate 1099 MISC Electronic Filing Submissions for Different Due Dates. Document ID 2345545.1

* Verify 1099 Batch Versions Will Launch BIP Report Definitions. Document ID 2351721.1


Reader.pngThis new KM document explains how to open a Service Request (SR) to request a 'Oracle Cloud Infrastructure Planning Session' with Oracle Global Customer Support. This will give you an opportunity to proactively discuss your Oracle Cloud implementation plans with Oracle Support where we can help clarify roadmaps, best practices and provide general guidance. Document ID 2348382.1.

Reader.pngThe latest IRS publication 1220 clarifies the 1099 Protecting Americans from Tax Hikes (PATH) Act of 2015, specifically for Non-Employee Compensation filing due date changes and the associated penalty notifications for Non-Employee Compensation on 1099s when filed after the early electronic filing cutoff. This new KM document how to comply for the JD Edwards EnterpriseOne. Document ID 2347361.1.

Record Reservation:

Make sure that following applications are added under  UDC "00/RR," (Record Reservation) and having Special Handling Code '1'

Applications:(P48013,,P3111,P3112,P31113,P311221,P31114,P31123,P3002,P3003,P3006,P31116,P31P001,P31225), (P3157-Special Handling code should be blank)

Batch Applications:(R31410,R31422 & R31802A)


Product Costing:

Run the Integrity Analysis program (R30601) immediately after a data conversion, or often when BOMs are entered, changed or deleted.

It is strongly suggested to run the Integrity Analysis program before running the Simulate Rollup (R30812).


Frozen Update (R30835) and WIP Revaluation (R30837) should not be run when the shop floor is in operation.

Stop shop floor operations/transactions. These include material issues, hours and quantities entry and update, completions and Order Processing (R31410).

Resume shop floor transactions once R30835/R30837 is completed.


Never run Frozen Cost Update (R30835) with Open Unaccounted units.

Run Mfg Acctg R31802A in final mode to clear unaccounted units and write journal entries for shop floor transactions.


Cost Simulation may be run while the shop floor is operating, with the exception of BOM Integrity (R30601), BOM (P3002) or Routing (P3003) updates.



Never run Manufacturing Accounting (R31802A) and  Frozen cost update R30835 / WIP revaluation R30837 at the same time.


R30812,R30835 & R31804 must be run in single-threaded job queue.

When two distinct submissions of this UBE are waiting for one another to complete its processing of a table, a deadlock may occur.




How the Labor Accrual amount (3401) is treated?

Amount accrued under labor accrual account (3401) is a liability amount that comes under balance sheet accounts and that should be knocked off during payroll processing.


What to do with amount booked under variance accounts?

Variance accounts comes under income statement accounts Amount booked under these accounts along with COGS (Cost of Goods Sold) is considered to calculate profit & loss statement during year end processing.

Reader.pngThis new KM document shows, with screen prints, how to configure communication between AIS, using HTTP protocol, and HTML, using HTTPS protocol, with a handshake error. Doc 2341042.1

Reader.pngThis new KM document shows how, with screen prints, to send an email with a shortcut using "Message Services" in SoapUI using JSON. Doc 2339426.1.

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 for instructions.