Posts By Artem Nesterko

Artem Nesterko

AP Supplier Upload

By Artem Nesterko|October 29th, 2024|

Overview of the AP Supplier Upload1 Purpose2 Required Fields for Bank Account Creation or Update3 Country-Specific Validations4 Common Validation Errors and Solutions5 Bypassing Bank Validations Overview of the AP Supplier Upload 1. Purpose The AP Supplier Upload enables automatic creation of a bank [...]

AR Customer Upload

By Artem Nesterko|October 7th, 2024|

Overview of the AR Customer Upload1 Purpose2 Process Parameters3 Upload Excel Columns4 Support for File Attachments Overview of the AR Customer Upload 1. Purpose The AR Customer Upload allows users to create Customer Accounts and Sites on a single Excel line while being able [...]

PA Project Budget Upload

By Artem Nesterko|June 6th, 2024|

Overview of the PA Project Budget Upload process1 Process Parameters2 Pre-defined Templates3 Excel Upload Template4 Specific points to note regarding the PA Project Budget Upload Excel Template5 Upload Process6 Upload Process Concurrent Requests Overview of the PA Project Budget Upload process The PA Project [...]

INV Inventory Item Upload

By Artem Nesterko|April 2nd, 2024|

INV Inventory Item Upload allows creation of Inventory Items: from an item template (Copy From Template) from an existing item in the same Organization (Copy From Item) from the same item in the Master Organization (Assign From Master) manually enter the Item details. It [...]

INV Safety Stock Upload

By Artem Nesterko|March 5th, 2024|

INV Safety Stock Upload allows the user to: Upload New Safety Stock Entries. Update Existing Safety Stock Entries. Delete Existing Safety Stock Entries (Delete by setting the 'Delete This Entry' = Yes). Upload Modes1 Download Parameters2 Excel Upload TemplateUpload Modes: Create Opens an [...]

PA Project Event Upload

By Artem Nesterko|March 2nd, 2024|

Overview of the PA Project Event Upload process1 Purpose2 Process Parameters3 Pre-defined Templates4 Excel Upload Template5 Upload Process6 Upload Process Concurrent Requests Overview of the PA Project Event Upload process 1. Purpose The PA Project Event Upload allows users to create new Project [...]

Hyperlinks in Blitz Report™

By Artem Nesterko|August 17th, 2019|

Hyperlinks can be embedded in Blitz Report excel output files using the syntax: HYPERLINK("URL to the location", "alternate text") Here is an example: select hp.party_number, 'HYPERLINK("'||case when hp.url like 'http%' then null else 'https://' end||hp.url||'","'||replace(hp.party_name,'"','""')||'")' party_name, hp.party_type from hz_parties hp where hp.url is not [...]

Securing sensitive data with Oracle VPD

By Artem Nesterko|May 14th, 2019|

What is VPD? 1 Why VPD? 1.1 Scalability 1.2 Simplicity 1.3 Security 2 How does VPD work? 3 Securing HR data 3.1 Example 1: Row Level VPD 3.2 Example 2: Column Level VPD 3.3 Securing data while using Blitz Report 4 Which data to [...]

Vegas, Baby! – Enginatics is showcasing Blitz Report at Collaborate 18

By Artem Nesterko|May 6th, 2018|

Over the course of four action-packed days in the entire year, more than 200 exhibitors and 5000 users attend OAUG’s COLLABORATE. They are all attending North America’s largest Oracle user conference to both network and learn from the plethora of discussed topics. Such topics [...]

Case study – The MYTOYS GROUP chooses Blitz Report™

By Artem Nesterko|September 10th, 2017|

The MYTOYS GROUP is one of the most successful e-commerce companies in Germany for family shopping and has been working with Oracle E-Business Suite from their first day of operation. After upgrading from version 11.5.10 to version 12.2.5 in spring 2016, myToys selected Enginatics [...]