Incorrect Inventory Commitments and the Manual Rollback Functionality
Incorrect Inventory Commitments and the Manual Rollback Functionality Nichole Grawer August 22, 2018 #JDEINFOCUS
Welcome • Win a $100 Amazon Gift Card • • Awarded at end of session Take brief electronic survey Visit: https: //emeraldcube. com/4/ Must be present to win #JDEINFOCUS
Emerald. Prism Fraud. ID Best in class CNC monitoring and alerting tool built, proactively identifying issues and changes that can affect stability and uptime Proactively detects and alerts for suspicious accounts payable, payroll, accounts receivable and general ledger activity within JDE E 1 Managed Services En. Crypto On-demand managed services models with 24 x 7 coverage and 100% certified on-shore team. OBIEE, JDE E 1 CNC, Functional & Development JDE sensitive data protection with military grade encryption (AES) Project Services Emerald. Cloud JDE Upgrades and Net New Implementations, as well as Oracle Business Intelligence & Hyperion Secure managed hosting solution built exclusively for JDE E 1 environments and powered by AWS Emerald. Vision Saa. S based Business Intelligence solution built specifically for JD Edwards #JDEINFOCUS
Attend Our Education Sessions Visit us at Booth #626 #JDEINFOCUS
Upcoming Events • Upgrade Success Stories and Tools • Thursday, September 20 @ 1: 00 pm EST • Sign up: emeraldcube. com/educational-webinars • Part II: JDE on AWS – Maximum Availability Architecture • Thursday, October 11 @ 1: 00 pm EST • Sign up: emeraldcube. com/educational-webinars • Cubeology • Free Online Education Courses • Sign up: emeraldcube. com/cubeology #JDEINFOCUS
Follow Us @Emerald. Cube #JDEINFOCUS
Incorrect Inventory Commitments in Item Availability • Why is this a problem • Order items that are over stocked • Produce an item that isn’t really needed • May run out of an item that appears to be on order • How do we fix them • Run reposts • SO Repost (R 42995), WO Repost (R 3190), PO Repost (R 43990) • SQL #JDEINFOCUS
Rollback Process • If a Transaction Error occurs in an E 1 Distribution application, all files except the Item Location (F 41021) file will be rolled back. • Due to the high utilization of the Item Location (F 41021) table, it is excluded to avoid record-locking issues. • Certain applications will automatically rollback the F 41021 via special application and Tools Code #JDEINFOCUS
Note: In the event a problem occurs with auto-rollback process the manual process may need to be used. For example if a database connection is lost the manual process will need to be used. #JDEINFOCUS
Example: • Example - when a database connection is lost • Inventory will be off #JDEINFOCUS
Example: • Example - when a database connection is lost • Inventory will be off Can run SO Repost (R 42995) – May have to create a dummy SO. *** unless on 9. 2 – more on this later *** #JDEINFOCUS
Work with F 42210 Commitments Recovery (P 42210) • First Level • Second level • Third level • Fourth level • Fifth level Look for a record that can be Rolled Back #JDEINFOCUS
Manual “Roll Back” #JDEINFOCUS
Review Detailed Availability #JDEINFOCUS
When to look for Manual Rollback Records in P 42210 • Anytime you encounter commitment integrities. • When Item Availability does not match the Cardex • Before you run SO Repost (R 42995), WO Repost (R 3190), PO Repost (R 43990) • Scheduler? • F 41021 Commitments Recovery (R 42210) • First review F 41021 WF #JDEINFOCUS
Technical Requirements • UDC 00/AT must have special handling code “ 1” • F 41021 Transaction Workfile (F 41021 WF) must exist in the Business Data data source • The calling application must have Transaction Processing implemented #JDEINFOCUS
Refresh Inventory Commitments (R 42990) *** 9. 2 Enhancement *** • Run at the same time you run SO Repost (R 42995) • Run over different data sets, mutually exclusive and designed to run in tandem • R 42990 runs over F 41021, F 4101, and F 4102, refreshing commitments for those items that do not have an active sales order • R 42995 runs over F 4211 and updates commitments for those items on active sales orders #JDEINFOCUS
Please complete a session evaluation Session ID: 101120 Contact Info: ngrawer@emeraldcube. com Tel: 314. 323. 5879
Who is the Quest Community? A 55, 000+ member user community for Oracle Cloud, JD Edwards and People. Soft customers. What the Quest JD Edwards Community offers: Customized digital content Official JD Edwards newsletter Customer success stories Virtual and face-to-face events JD Edwards networking groups Visit www. Quest. Direct. org for more information! #JDEINFOCUS
- Slides: 19