Skip navigation

LearnJDE.pngStill thinking of migrating from #JDEdwards World to EnterpriseOne? Migrate NOW to take advantages of the new features and products added to JD Edwards EnterpriseOne. Know more - http://bit.ly/2JSPOYw

YouTube.pngDid you know that you can now create activity rules for #JDEdwards manufacturing work orders? Watch this video to know all about this functionality - http://bit.ly/2YkpFWm

When customers are delinquent in paying their bills, you can send a delinquency notice on overdue invoices as a reminder to pay the delinquent balance. Delinquency notices are created by running the Print Delinquency Notices version (XJDE0002) of the Credit Analysis Refresh program (R03B525). This version has predefined processing options set for printing delinquency notices and calls either the AR Delinquency Notice Print (R03B20), or from release 8.9, the Global Reminders (R03B21) to generate the notices. The system generates notices based on the delinquency policy that is assigned to the customer. See Document 1490134.1 for further information on setting up delinquency policies and the system set up requirements for generating notices.

 

Prior to release 8.9, only the A/R Delinquency Notice Print (R03B20) program can be called from Credit Analysis Refresh to print notices. From release 8.9 onwards, there is a further option to use Global Reminders (R03B21), which is also referred to as Tiered Delinquency Notice Print.

 

More details on how this process works, common issues and troubleshooting tips could be found in:

  • E1: 03B: How To Process, Purge and Troubleshoot Delinquency Notices (R03B525, R03B20, R03B21, P03B202, P03B201, R03B5010) (Doc ID 644234.1)
  • E1: 03B: FAQ - Frequently Asked Questions about Delinquency Notice Processing and Purging (R03B525, R03B20, R03B21) (Doc ID 945005.1)
  • E1: 03B: How To Set Up and Run Credit Analysis Refresh In EnterpriseOne (R03B525) (Doc ID 1495853.1)

During the Package deployment , we need to lock/unlock the JOB Queue using P986130 Application

P986130 is designed to lock/unlock one Job Queue at a times. So if we have many job queues in the system then this process will be a time consuming one during the package deployment window. Now we can use orchestration to lock or unlock all the job queues with very less effort. This blog will help you to create the Orchestration for this requirement.

 

Steps to create the Lock or Unlock Job Queue Orchestration

 

  • Create Form Service Request
  • Create Rule
  • Create Orchestration
  • Test the Orchestration

 

Step 1 : Create Form Service Request

 

We need to pass the Grid Data (Multiple rows) of P986130 to the orchestration to execute the orchestration in a loop. So that we can lock or unlock the multiple job queue using Orchestration!

 

Here we are creating two Form Service Request to change the Job Queue Status

  • Get Grid Data of P986130 Form Service Request will save the Grid data in the Grid Data Set

  • Grid Data which we got from the First Service Request will be passed to "Lock or Unlock Job Queue" Service to update the multiple records.

 

Follow the below steps to create the "Grid Data of P986130" Form Service Request

  • Login into Orchestrator Studio
  • Click on Service request button
  • Click on Create Service Request --> Form Request

           

        Form Service Request Input

 

Host Name             --> Enterprise Server Name

Port Number          --> Enterprise Server Port Number

Job Queue Status  --> Enterprise Server Job Queue Status

 

You can use Process Recorder or Orchestrator Studio to create this service request. Create the Service Request with below Order of the Execution         

     

Form Service Request Output

 

Grid Data Set Name --> Grid Data

 

Host Name            --> Grid Enterprise Server

Job Queue             --> Grid Job Queue

Job Queue Status --> Grid Job Queue Status

Port Number        --> Grid Port Number

Follow the below steps to create the "Lock or Unlock Job Queue" Form Service Request      

  • Grid Data which we got from the First Service Request will be passed to "Lock or Unlock Job Queue" Service to update the multiple records.
  • Click on Service request button
  • Click on Create Service Request --> Form Request

    

        Form Service Request Input

Host Name             --> Enterprise Server Name                   

Port Number          --> Enterprise Server Port Number      

Job Queue Status  --> Enterprise Server Job Queue Status

 

You can use Process Recorder or Orchestrator Studio to create this service request. Create the Service Request with below Order of the Execution

Form Service Request Output

 

You can return the data which you want to see in the Orchestration Output

 

Here we are returning the below data

Host Name            --> Enterprise Server

Port Number        --> Enterprise Server Port Number


Step 2 : Create a Rule

 

Job Queue Status is saved in the table as numeric ( 01 or 02 ). It would be good to pass the String Lock or Unlock as input when compare to 01 or 02.

 

To achieve this we are creating the below rule

   When the input is equal to Lock then this rule will return true or it will return false

                           

         Step 3 : Create Orchestration

 

         Here we are creating two orchestration to lock and unlock the Job Queue. Follow the below steps to Lock or Unlock Job Queue Orchestration

 

  • Call the Rule and Form Request which we created on the above steps in the below order

  • Add the below Orchestration Inputs and Variables

 

Orchestration Inputs

 

Enterprise Server

Port Number

Lock or Unlock

 

Variables

 

Lock Job Queue     = 01

Unlock Job Queue = 02

  • Map the Data input for Rule

  • Map the Data Input for Get Grid Data of P986130  - True Condition     

    

  • Map the Data Input for Lock or Unlock Job Queue - True Condition

  • Map the Data Input for Lock or Unlock Job Queue - False Condition

  • Click on Define Output

 

  • Make sure to select the below Output then only Data Set from Grid Data of P986130 Form Request will be passed to Orchestration in a loop

       Step 4 : Test the Orchestration

 

       We can test the Orchestration using Orchestrator Client

 

Case 1 : Lock Job Queue

 

Login into Orchestrator Client then run the Lock or Unlock Job Queue Orchestration by passing the Enterprise Server Name and Port Number and Lock or Unlock condition

 

  •   Before running the Orchestration

  •     Run the Orchestration

  •     Job Queue Locked successfully !

   Case 2 : Unlock Job Queue

 

   Login into Orchestrator Client then run the Lock or Unlock Job Queue Orchestration by passing the Enterprise Server Name and Port Number and Lock or Unlock condition

 

  •    Before running the Orchestration

  •    Run the Orchestration

  •    Job Queue Unlocked successfully!

       

QuestIcon2.pngJoin this Quest Oracle Community webinar on August 1 for a tour of #JDEdwards Notifications enhancements - http://bit.ly/2JMVnbk

3-steps.jpgJoin Redfaire on August 1 to get insights of #JDEdwards top implementation strategies. http://bit.ly/2YfLDK1

Reader.pngThis KM document lists known issues and workarounds for Tools Release 9.2.3.3 including a link to an Alert document for a package build issue with Tools Release 9.2.3.3. Doc ID 2550812.1. http://ora.cl/DD6E6

Reader.pngThis new KM document explains where records with blob data are stored in EnterpriseOne for Orchestrations and Related Components (SREQ, NTF, etc). Doc ID 2552441.1. http://ora.cl/Cx5AZ

Reader.pngThis new KM document has frequently asked questions and answers about the Account Balance to Transaction Integrity Report (R09705). Doc ID 2557616.1. http://ora.cl/Xj4xl

Reader.pngThis new KM document explains what the JDENET_KERNEL_DEF24 (XML Service Kernel) is used for in the JDE.INI. Doc ID 2546962.1. http://ora.cl/aU4Ir

QuestIcon2.pngRead this Quest Oracle Community blog providing an overview of the Accounts Receivable Manager #UXOne roles available for #JDEdwards financials - http://bit.ly/2YlU6eG

INFOCUS19_JDE.pngHow does #JDEdwards digital solutions empowers your organization? Attend the keynote session at #INFOCUS19 on August 20 where #JDE customers will share their experiences and successes with Lyle Ekdahl. http://bit.ly/2LM12jE

Rental Management enables a company to manage the rental and sale of items, including capital equipment, inventory items, and associated services. You can manage all aspects of a rental service, including:

  • Managing rental contracts and agreements
  • Handling equipment and item commitments to inventory
  • Billing (periodic)
  • Managing rental cost allocations
  • Managing asset depreciation expense
  • Managing the movement of assets in and out of inventory as they are rented out and returned, and serviced at the end of the rental contract
  • Reporting for rental contracts, including profitability

 

For more information, refer to Rental Management and One View Rental Management (Doc ID 1937114.1).

Inventory Transfer is the common process in all types of industries. A transaction will be recorded for the inventory movements within the internal locations. There will be always two set of entries generated in GL for Inventory Transfers (IT) P4113, one is from From location and another is from To location.

 

Sometimes, the entries will not get properly created. There will be one sided transactions or the entries will get updated two or three times. Let's discuss on those issues in this post.

 

First Scenario (One Sided Transactions)

 

When there are multiple lines in the Inventory transfers, if the Invalid location error comes ,  the erroneous line will deleted and a new line will be added by the user. For this line From Location entries will not be updated. Issue was reported as a bug and it was fixed. The fix is available. Please refer to the document Not Updated From Location And Quantity But Updated To Location, When Using Delete Operation (Doc ID 1988441.1) and (Doc ID 2117264.1) to know more about this issue and the bug details.

 

Second Scenario (Additional One Sided Transactions)

 

This issue is similar to the above scenario, but here the TO LOCATION field is edited two times with incorrect location even after getting the Invalid Location error(3138) in the first edit and that erroneous line is deleted after second edit. Please refer to the document Inventory Transfer(P4113) Creates additional One Sided entries in General Ledger (F0911) and Cardex (F4111) (Doc ID 2497204.1)

 

Third Scenario (Additional One Sided Transactions Only in GL)

 

When entering Inventory Transfer (P4113) for a license plate item and when entering the incorrect quantity, Error 140LPN – Insufficient Quantity in LP is issued which is correct. However when correcting the quantity and saving the transaction there are duplicate F0911 journal entries created, one entry for the the incorrect quantity and 2 for the correct quantity. The cardex only has 2 entries although Journal entry line number is 2.0 and 3.0. Please refer to the document Inventory Transfer for License Plate Item generating Out of Balance GL Batch (Doc ID 2452890.1)

 

Fourth Scenario (Double Or Triple Transactions in GL)

 

When entering a transfer using P4113, Inventory Transfers, extra F0911 records are being created.  They are either being doubled or tripled depending on whether the warning "Item Location is not Found" is shown. Please refer to the document F0911 Entries are Being Doubled or Tripled when Creating a Transfer using P4113 (Doc ID 2404708.1).

Business_Innovation.pngRead this Forbes article to learn three safe ways to test bots in your call centers. bit.ly/2LVPolj

QuestIcon2.png“Getting More Value from Your Maintainable Assets: Part 2” is coming mid-August. Register for this Quest webinar presented by Oracle’s very own Louise Farner.  bit.ly/2XPALqU

Quest Experience Week is packed with digital education to provide both strategic insight and how-to-education for Oracle users of all levels – for free! #JDEdwards day is November 15 during QXW.  Sign up for updates. bit.ly/31voN42QXW.png

QuestIcon2.pngLearn how you can develop an Automated ERP with #JDEdwards. Read the Quest User Community article. http://bit.ly/2NVIm2C

Reader.pngThis new KM document explains how Payment Instrument D functions when using in Check Processing (P04571). Doc ID 2547353.1. http://ora.cl/Aj1lU

Reader.pngThis new KM document explains the Period Number Processing Option (#2) in the Certified Payroll Register UBE (R07371). Doc ID 2547938.1. http://ora.cl/BL2Av

Reader.pngThis new KM document explains the setting ONTHEFLYMIGRATION in the [SECURITY] stanza of the JDE.INI. Doc ID 2548821.1. http://ora.cl/tw3d3

Direct Ship Order (SD/OD) process used to have a quantity integrity issue when Direct Purchase Order OD was over received. When Direct Purchase Order OD was over received than the original Sales Blanket order quantity, Direct Ship Order SD quantity was not updated and blanket quantity remained open. This was driving to several order quantity integrity issues.

 

The cause of this issue was that while receiving the OD quantity the original sales blanket order quantity was not considered. When OD is over-received with quantity exceeding sales blanket quantity system should generate a hard error (similar to sales order update mode).                                               

 

Now the system has been changed so when OD is over received with quantity exceeding sales blanket quantity, an error is generated during P.O. Receipt (P4312).

 

For more information regarding the fix please see SD Direct Ship Order Quantity Is Not Updated And/Or Second New Line Added And Blanket Quantity Remains Open When Direct Purchase Order OD Is Over Received (Doc ID 2407480.1).

Kathies -Oracle

LearnJDE: Use Cases

Posted by Kathies -Oracle Jul 23, 2019

LearnJDE.pngExplore what’s possible with #JDEdwards UX One and Orchestrator by viewing the new Use Case page on LearnJDE.com. Submit your solutions. bit.ly/32zsI03

OLL.jfifExplore this new #JDEdwards learning path on deploying EnterpriseOne Release 9.2 using One-Click Provisioning on-premises with Linux and an Oracle database.  http://bit.ly/2M2urp7

digital-transformation-concept--virtual-hand-creating-network-.jpgCost reduction, growth, and digital transformation! Read how digital leaders can make a difference. #InformationWeek ubm.io/2Y7isgo

QuestIcon2.pngTake a quick tour of the recent #JDEdwards Notifications enhancements this past year. Attend this Quest User Community webinar presented on August 1st by Oracle’s own AJ Schifano.  bit.ly/2KJS2u0

Reader.pngThis new KM document explains what JRE is needed for Change Assistant - 64-bit vs. 32-bit. Doc ID 2548815.1. http://ora.cl/H4eo5

Reader.pngThis new KM document lists the required User Defined Codes (UDCs) for Lease Accounting. Doc ID 2548836.1. http://ora.cl/yk7cL

Reader.pngThis KM document explains the functionality of the Complete Regeneration Processing Option for the As Of Generation (R41542). Doc ID 2548854.1. http://ora.cl/Op4yU

LearnJDE.pngAnnouncing #JDEdwards EnterpriseOne Tools Release 9.2.3.4 with customer-driven enhancements and #DigitalTransformation features. Visit #LearnJDE for the full announcement. bit.ly/2XXq019

JDE Infocus_white.pngJDEdwards #INFOCUS19 is a great place to connect with #JDEdwards experts from your industry or with others using the same products. Benchmark your strategy, learn new tips & tricks, hear about lessons learned, and ask all your questions! Quest Oracle Community bit.ly/2xVcYq0

LearnJDE.pngRead our latest #JDEdwards announcement for customer-driven EnterpriseOne product features and new Tools release 9.2.3.4. We are focused on enabling our customers journey to becoming digital enterprises. http://bit.ly/2XXq019

Kathies -Oracle

LearnJDE: Use Cases

Posted by Kathies -Oracle Jul 18, 2019

LearnJDE.pngExplore what’s possible with #JDEdwards UX One by reviewing the new Use Case repository on LearnJDE.com. Submit your solutions. http://bit.ly/2VKF4Pj

reports.pngRead this #JDEdwards whitepaper on how to setup data security for #EnterpriseOne HCM applications.  Visit #LearnJDE for the latest details. http://bit.ly/2XY7727

JDE Infocus_white.pngAcquire the #JDEdwards skills you need at #INFOCUS19. Enjoy hands-on learning from our hands-on labs that complements your education schedule and keep your JD Edwards knowledge fresh. Quest Oracle Community.  http://bit.ly/2NQKoRt

YouTube.pngView this new tutorial to learn how to create an Orchestration for system administration. Visit the #JDEdwards channel on YouTube for the latest details. http://bit.ly/2GczcJ0

Reader.pngThe JD Edwards Get Proactive Portfolio page has been updated with a new Now Trending article "NEW with Tools Release 9.2.3.4! Simplified Diagnostics Collector Tool Built Into Server Manager". Doc ID 1389028.1. http://ora.cl/L908T

Reader.pngThis new KM document explains why some deduction write-offs are created as document type RS rather than document type RC. Doc ID 2549345.1. http://ora.cl/pm0Yr

Reader.pngThis new KM document explains the different types of components for Server Manager available on the Update Center. Doc ID 2549751.1. http://ora.cl/737ls

Reader.pngThis new KM document talks about the location that service request output is saved to and how the Temporary Directory in the rest.ini. http://ora.cl/Vf0J5

Reader.pngWhen installing the Platform Pack with the Load Production data option you might note that some tables (e.g. F0012) are installed with pre-loaded data. Doc ID 2551646.1. http://ora.cl/Nx4y2

training.pngLearn how to create no-code solutions for integrations, file transfers utilizing real-time processing and exchange external and/or internal data, create notifications and send messages service using #JDEdwards Orchestrator. http://bit.ly/30z9ciI

YouTube.pngWatch this new tutorial to understand how to associate Orchestrations and Notifications with events from interactive applications. Visit the Oracle JD Edwards channel on YouTube for the latest details. http://bit.ly/2xPqQSJ

IoT2.pngAutomation enables companies to re-allocate their resources towards innovative projects and digital transformation. Autonomy allows workers to focus less on what is already working and more on what can be done better. http://bit.ly/2Z4PbzS

YouTube.pngView this new #JDEdwards video on how to simplify your business processes by calling Orchestrations form forms without customizations. http://bit.ly/2LlrnVm

Reader.pngBy design, in order to use existing Available to Promise (ATP) or Cumulative Available to Promise (CATP) calculations to determine a Delivery Date during sales order entry, users must exit to the Supply/Demand Inquiry form where the date is displayed, then return the date. A new enhancement is now available in the 9.2 release that streamlines the sales order entry process by allowing for automatic population of sales order dates without having to access the Supply/Demand Inquiry form. See KM document "Enhancement Available in Sales Order Entry to Automatically Return Pick Date from Available or Cumulative Available to Promise" (Doc ID 2555461.1). http://ora.cl/lo8oe

Reader.pngThis new KM document talks about the ability to do a bulk update on the business unit location table (F1204) for multiple equipment records. Doc ID 2552410.1. http://ora.cl/sl4Y1

Reader.pngThis new KM document explains the significance of the JAS whitelist in the e1adf.ini for ADF requests that go through AIS to JAS. Doc ID 2552785.1. http://ora.cl/kL1mn

Reader.pngThis new KM document provides setup help to guarantee price and availability of inventory for a set of customers (e.g. large customers) but keeping remaining inventory available for other customers at a higher price level and non-guaranteed availability. Doc ID 2554633.1. http://ora.cl/uG0aH

Reader.pngThis KM document answers the question - When the 'Generate Purchase Order' flag is set on the line type constants (P40205) and a cost change is made to the generated purchase order or related requisition, will the cost be updated on the related sales order? Doc ID 2555557.1. http://ora.cl/WZ4Pr

clock-163202__340.jpgWhen combined with IoT, a blockchain network can assure temperature-sensitive commodities such as food, pharmaceuticals and chemicals are monitored and well maintained throughout the supply chain itinerary. Article in Forbes http://bit.ly/2JxbGbq

YouTube.pngWatch this new #JDEdwards video on how to distribute expenses, revenue and overhead to joint venture partners.  http://bit.ly/2XK49tO

QuestIcon2.pngJoin this Quest Oracle Community webinar on August 1, that will provide a quick tour of #JDEdwards Notifications enhancements - http://bit.ly/2JMVnbk

OLL.jfifLearn how to deploy #JDEdwards 9.2 on Oracle #Cloud Infrastructure with Windows SQL Server Database using One-Click Provisioning. Check this new learning path - http://bit.ly/2J1FGw3

YouTube.pngAnd #JDEdwards is now 5000+ strong on YouTube! Thanks to all who have subscribed. And to those who have not, now is the time. Subscribe today!  - http://bit.ly/JDEonYouTube

Kathies -Oracle

LearnJDE: UX One

Posted by Kathies -Oracle Jul 11, 2019

LearnJDE.pngBe productive with your enterprise applications by leveraging #JDEdwards UX One Alert, Analyze, Act design principles. Learn more - http://bit.ly/2PAQDGD

Reader.pngThis new KM document talks about licensing needed for CRM Sales Force Management, CRM Foundation, and CRM Case Management. It also includes a link to the JD Edwards EnterpriseOne Licensing Information User Manuel. Doc ID 2555613.1. http://ora.cl/6sb3x

Reader.pngThis new KM document explains the DSA1 and DSA3 AAIs used for the French Derogatory method for assets depreciation. Doc ID 2555867.1. http://ora.cl/0iT8H

Reader.pngThis new KM document explains the "Refresh" interval associated with the watchlists on composite pages. Doc ID 2555938.1. http://ora.cl/fw3Nx

Reader.pngThis new KM document explains how to store half Katakana Japanese names for suppliers in the Address Book application (P01012). Doc ID 2556008.1. http://ora.cl/cR3M5

You asked. We delivered.

 

Historically in sales order entry, in order to use existing Available to Promise (ATP) or Cumulative Available to Promise (CATP) calculations to determine a Delivery Date during current sales order entry, the user must exit to the Supply/Demand Inquiry form where the date is displayed and then return the date.

 

An Enhancement is now available in the 9.2 release that streamlines the sales order entry process by allowing for automatic population of sales order dates without having to access the Supply/Demand Inquiry form.

 

The new functionality automatically populates the pick date without having to access the Supply/Demand Inquiry form when the user enters a sales order line for a quantity of an item and tabs to the next line without entering any dates.

 

For more information see Enhancement Available in Sales Order Entry (P4210/P42101) to Automatically Return Pick Date from Available to Promise (ATP) or Cumulative Available to Promise (CATP) (Doc ID 2555461.1)

ESU JN17107  (Bug 29500686) contains a major enhancement that manufacturing customers have been requesting. 

 

The completion of this enhancement provides Work Order Activity Rules functionality for manufacturing.

 

This is similar to what is provided for equipment maintenance and sales and purchase order processing, which defines the allowable steps that an order can take from beginning to end.

 

These Work Order Activity Rules for Manufacturing include:  

  • A Manufacturing Constants control to turn on Work Order Activity Rules for a specific branch.    If you don’t want or need this new functionality, it can be off, and this also provides a smooth transition as rules would not be turned on until the set up is complete.
  • Set-up application for creating Order Type/Doc Type combination Work Order Activity Rules that defines Next Status and Other Allowed Statuses.
  • Status Validation per Activity Rules. With the Activity Rules Flag in Manufacturing Constants set to ‘Y’:
    • Status changes are validated against activity rules, when an update status is specified that is not in the status flow, a hard error is generated
    • Beginning status is retrieved from activity rules if none is specified in a processing option
    • Status is updated according to activity rules if ‘*’ is specified in a processing option
    • For reports, when specified new status is not in the status flow, the record is printed on an exception report and not processed

OLL.jfifLearn how to upgrade to #JDEdwards 9.2 code current on a One-click provisioned Microsoft Windows target environment with a SQL Server Database. Check this new learning path - http://bit.ly/30qae0p

INFOCUS19_JDE.pngExplore #JDEdwards recent digital investments – modern mobile apps, Notifications and Orchestration updates, and automation process technologies at #INFOCUS19. Register now - http://bit.ly/2WfMSsa

QuestIcon2.pngJoin this webinar on July 18 to meet #JDEdwards Fixed Assets expert John Murphy who will be presenting a brief overview of Fixed Asset capabilities and discussing common #FAQs. Know more - http://bit.ly/2XuJCcF

QuestIcon2.pngDid you know that the first step to automate #JDEdwards is to upgrade to 9.2? Read this Quest Oracle Community blog to know how you can develop an automated #ERP - http://bit.ly/2S1OVPq

Reader.pngThis new KM document explains the timeout threshold parameter to update to avoid "COSE#1000 Request timeout" errors. Doc ID 2556081.1. http://ora.cl/tm3vB

Reader.pngIn a clustered database system, if the host is down or E1 services are stopped when attempting UBE retrieval the user will receive an error. See this KM document for more details. Doc ID 2556154.1. http://ora.cl/y9Mq0

Reader.pngThis new KM document addresses the question about both selling and providing a free item in Free Goods. Doc ID 2556514.1. http://ora.cl/Xq5ud

Reader.pngThis KM document explains how you can correct an incorrect account number in a purchase order line while entering in the voucher in Purchase Order Entry (P4314). Doc ID 2556638.1. http://ora.cl/0CN2v

QuestIcon2.pngJoin this Quest Oracle Community webinar on July 18 to hear #JDEdwards Capital Asset Management expert Louise Farner review our many robust offerings and how customers are using CAM.  http://bit.ly/30kRsr4

PLUG.pngJoin Paul Houtkooper at the PackerLand User Group on July 18 in Green Lake, WI. Paul will share how #JDEdwards is delivering on the #JDE digital platform and how customers have created a competitive advantage. Know more - http://bit.ly/2YmhdXy

YouTube.pngWatch this video to learn how you can simplify your business processes by calling #Orchestration and #Notification from #JDEdwards EnterpriseOne events in real-time without any customizations. http://bit.ly/2XsmrEy

LearnJDE.pngStill thinking on upgrading to #JDEdwards 9.2? It is easy now! Take a look at our simplified upgrade process on #LearnJDE- http://bit.ly/2YYcj3q

Learn-More-Button-JPG-Graphic-Cave-1080x565.jpgSubscribe to this new learning path providing simplified and easy-to-follow #JDEdwards #Orchestrator Studio videos - http://bit.ly/2ZUCvvA

LearnJDE.pngThinking of moving to 64-bit processing? Visit #LearnJDE to know more and review our customer success stories on this page - http://bit.ly/2LPLEnf

Following steps demonstrate how to read data from the a .CSV file which can be further passed to a Services Request (Form Service, Data Service or a custom database connector).

 

Purpose –

We will be creating the connector for FTP server and read a CSV file which has AddressBook Numbers.

The output of this will be sent to a Form Service request which will return AddressBook Number, Alpha Name and Search Type for that AB number from P01012. Also, we will be using iterate over to read each row from the CSV file

 

Step 1 -

Login into OrchestratorStudio and Click on the Tools link

 

Step 2 -

Select Connections where we will be defining the FTP server details

 

 

Step 3 -

Enter your FTP server details. Please make sure to validate the FTP server details using tools like - WinSCP

 

 

Step 4 -

Click on Service Request and select Connector option. This will be used for defining CSV file details and selecting the field’s data to be imported.

a) Select the FTP connection name from the drop-down which we had created in the previous step.

b) Enter the Source file name which is located in your FTP Server locations share path example. /E920

c) Check Import CSV as Array and CSV have Headers options.

The Import CSV as Array option helps to read all the rows from the CSV file and using the header it becomes easy to recognize the fields.

 

d) Define Data Set variable name. This is similar to the concept of the array which will hold the value for a row from the CSV file and will be used for iteration purpose in further steps.

e) Upload your CSV file as a sample/reference to create a variable name for each of the row headers/columns

 

Save this Connector Service Request.

 

Shown below is the Structure of ABN1.csv file:

Step 5 -

Creating Form Service Request

Create a Service Request which will take input (AddressBook number) from the CSV file and will return associated AddressBook Number and Alpha Name from P01012 Application

 

Return Fields –

 

 

Step 6 -

Now we need to map the Connector and Form Service to an Orchestration. Click on the navigation panel and select Orchestration.

 

Enter the name of the Orchestration and under Orchestration steps, select Service Request and click on the + icon.

Click on the drop-down and select the previously created FTP connector.

Now, we will add Form Service to Orchestration as Step After the connector using the same steps.

Orchestration after adding Connector and Form Service Request.

If you highlight the Form Request, orchestration will show the required inputs to the form request.

Now, we will map the output from the connector to the Form Service Request.

Here AB is data set variable define under the Connector service and Address Number is a variable name which holds AB number for the CSV row.

In order to read all the rows (one by one) from the CSV, we will select the Data set variable (AB) from iterate over option.

 

Orchestration Output –

Highlight the Form Service Request and Click on Define Output button.

Select the Output fields -

 

Save this Orchestration.

 

Testing Orchestration using Orchestrator Client-

There is no manual input for this Orchestration as it will read the AddressBook number from the CSV and return the Alpha Name, Search Type and AddressBook Number.

 

Results -

OLL.jfifLearn how to deploy #JDEdwards 9.2 on Oracle Cloud Infrastructure with Windows SQL Server Database using #One-Click Provisioning. Check this new learning path - http://bit.ly/2J1FGw3

workshop.jpgTake this #JDE EnterpriseOne Orchestrator 2-day hands-on training workshop to learn how to automate your business processes. Save your seat now - http://bit.ly/2xlB5hx

QuestIcon2.pngRead this Quest Oracle Community blog to learn how to create a form request using the @OracleJDEdwards #Orchestration Studio - http://bit.ly/2NoNwnK

QuestIcon2.pngAttend this webinar on July 18 to learn about #JDEdwards Capital Asset Management and how to get more value from your maintainable assets - http://bit.ly/2XhdEp6

Reader.pngThis new KM document explains how to handle the special characters of the Trademark symbol in your JSON request. Doc ID 2557755.1. http://ora.cl/93tO2

Reader.pngTo delete an eReq that is at approved status, the status must first be changed. This document provides the steps to do accomplish this. Doc ID 2558001.1. http://ora.cl/vO6ik

Reader.pngYou can process lease commencement activities to create amortization schedules and journal entries for a lease that is already in progress before you begin using the balance sheet lessee accounting standard. This new KM document provides the steps. Doc ID 2558036.1. http://ora.cl/N7AD0

Reader.pngThis new KM document explains where the UOM default value for Purchase Order Entry (P4310) is determined. Doc ID 2558044.1. http://ora.cl/he8vy

INFOCUS19_JDE.pngExplore how you can solve your business problems by using our pre-built UDOs or building your own using the #JDEdwards UXOne frameworks. Register now for the #INFOCUS 19 educational sessions. http://bit.ly/2WfMSsa

OLL.jfifWatch this tutorial to learn how to create an #JDEdwards EnterpriseOne #Orchestration for system administration. http://bit.ly/2IZ8C7U

QuestIcon2.pngAttend this @QuestUserGroup session on August 15 offering an in-depth discussion of #JDEdwards #JVM. http://bit.ly/31TuIQK

INFOCUS19_JDE.pngDid you attend Collaborate this year? You may be eligible for a discount on #INFOCUS19 registration if you attended Collaborate 2019. Register here. http://bit.ly/2JWwZVo

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.