Sourcing Wizard Version

Package Body Version

2.5.31 (10-Apr-2025)

1.2.6 (Minimum 1.2.3)

2.5.31 (10-Apr-2025)

Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the Login process from completing.

2.5.30 (20-Jan-2025)

Fixed the error that cannot upload Shipping DFFs for a Sourcing Rule.

2.5.29 (13-Dec-2024)

Added fix for Error: ORA-06550 PLS-00172: string literal too long.

2.5.28 (12-Nov-2024)

Internal update.

2.5.27 (11-Nov-2024)

Internal update.

2.5.26 (11-Oct-2024)

Added new Digital Signature.

2.5.25 (10-Oct-2024)

Added Default Browser Login option.

2.5.24 (03-Nov-2023)

Fix for bug where the End-to-End Trace might not return the SQL Statement's execution plan.

2.5.23 (26-Jul-2023)

Sourcing Rules mode: Corrected criteria logic for validating Supplier Operating Unit to enforce uniqueness across multiple Operating Units.

2.5.22 (25-Jul-2023)

Sourcing Rules mode: Added extra conditional checking in validation to allow Supplier sites to pass validation for a Delete action when the Site is no longer flagged as a Purchasing Site or not a RFQ Only site.

2.5.21 (25-Jul-2023)

Sourcing Rules mode: Removed inactive check on Supplier Site and Supplier Operating Unit when attempting to Delete a Sourcing Rule or Sourcing Rule Supplier.

2.5.20 (20-Jul-2023)

Sourcing Rules mode: Added Shipping Action into Supplier validation so that disabled Suppliers now validate when a Delete action is performed at the shipping level.

2.5.19 (20-Jul-2023)

Sourcing Rule mode: Changed Supplier validation to allow disabled suppliers when deleting sourcing rules.

2.5.18 (06-Apr-2023)

ASL mode: Corrected table join in which prevented downloading ASL where there was no Release Method.

2.5.17 (18-Jan-2023)

Approved Supplier List mode: Ensured only numeric data is entered in ASL ID.

2.5.16 (18-Jan-2023)

Assign sourcing Rules mode: Corrected issue where assignments would not download when the assignment is for a Category instead of an Item.

2.5.15 (09-Dec-2022)

Fixed issue that caused large uploads to unexpectedly fail with error "438(Object doesn't support)".
Removed unsecure document links.
Fixed issue where enabling end to end trace did not generate the trace.

2.5.14 (06-Dec-2022)

Internal update.

2.5.13 (02-Dec-2022)

Internal update.

2.5.12 (07-Sep-2022)

Updated Licencing modules.

2.5.11 (22-Jul-2022)

Corrected download issue which may have caused orphaned data in some scenarios.

2.5.10 (06-Jul-2022)

Internal update.

2.5.09 (06-May-2022)

Assign Sourcing Rules mode: Updated upload to ensure Oracle does not retain data between API calls.

2.5.08 (03-May-2022)

Assign Sourcing Rule mode: Corrected some issue with Download by form and made more consistent with Download by Sheet.

2.5.07 (27-Apr-2022)

ASL mode: Corrected issue with download form generating 'ORA-00918: column ambiguously defined in some circumstances.

2.5.06 (21-Apr-2022)

ASL mode: Restructured download SQL to avoid missing table issue in some circumstances.

2.5.05 (08-Apr-2022)

ASL mode: Corrected ORA-01722:invalid number during download.

2.5.04 (08-Apr-2022)

ASL mode: Fixed ORA-0094: "PAAV"."RELEASE_GENERATION_METHOD_DSP":invalid identifier during download.

2.5.03 (29-Mar-2022)

Fix for One Drive saving issue by removing code from the on_save event.

2.5.02 (24-Mar-2022)

Added 'Sheet Filter Batch Size' functionality via the Download Settings form.

2.5.01 (17-Mar-2022)

Corrected the Extension Package reporting on the About form.

2.5.00 (20-Jan-2022)

Updated Custom Query including:
- Added Not Equals Operator on the Download Form.
- Values with single quotes will now download correctly on the sheet.
- Removed ability to free type into the query box within the Download Form.
- Removed functionality to save and default the Last used query parameters on the Download Form.

2.4.01 (28-Sep-2021)

Removed Sourcing Rule validation enforcing From Date to be in the future as this was causing issues updating existing records. Effective Date rules are enforced by the API, but the error messaging is not too intuative. Corrected Sourcing Rule uploads not happening.

2.4.00 (12-Aug-2021)

ASL Mode: Simplified the Extension Package procedures calls by removing inputs that would always be blank.

2.3.06 (30-Jul-2021)

Updated security.

2.3.05 (20-Jul-2021)

Added additional checks in upload PL-SQL to accommodate scenarios where the ASL API errors, but returns a successful status.

2.3.04 (23-Jun-2021)

Sourcing Rule Mode: Allocation Percentage changed to allow 0.

2.3.03 (15-Jun-2021)

ASL Mode: Updated SQL to determine correct Category Set.

2.3.02 (27-May-2021)

ASL Mode - Updated Commodity KFF to account for changes to the default Category Set.

2.3.01 (04-May-2021)

Updated security.

2.3.00 (16-Apr-2021)

ASL mode: Added Extension Package functionality.

2.2.15 (12-Apr-2021)

Updated security.

2.2.14 (23-Feb-2021)

Updated security.

2.2.13 (04-Dec-2020)

Modified ASR item SQL to prevent duplicate error when item is assigned to multiple valid organizations.

2.2.12 (16-Nov-2020)

Updated Assignments section download SQL in Assign Sourcing Rules mode.

2.2.11 (06-Nov-2020)

Updated security.

2.2.10 (02-Oct-2020)

Corrected SQL error ORA-01427: single-row subquery returns more than one row.

2.2.09 (01-Oct-2020)

Corrected Assign Sourcing Rules download where some item names and descriptions were not being downloaded.

2.2.08 (24-Sep-2020)

Assign Sourcing Rules mode - Corrected SQL invalid identifier error when using Sourcing Rule name as download criteria.

2.2.07 (06-Jul-2020)

Assign Sourcing Rules mode - Performance improvements made in download.

2.2.06 (25-Jun-2020)

Corrected server error on upload of ASL - PLS-00306: wrong number or types of arguments in call to /INITIALISE_ASL_TOLERANCE/.

2.2.05 (09-Jun-2020)

Updated example sheets.

2.2.04 (08-Jun-2020)

Corrected SQL error when validating Category in Assign Sourcing Rules mode.

2.2.03 (17-May-2020)

Performance improvements in Assign Sourcing Rules mode and added background upload feature to Sourcing Rule and Assign Sourcing Rule modes.

2.2.02 (30-Apr-2020)

Added background upload feature to both Sourcing Rule modes.

2.2.01 (16-Mar-2020)

Encountered the symbol "," when expecting one of the following:' error.

2.2.00 (12-Mar-2020)

Improved performance of ASL uploads - requires updated packages.
Optimized Assigned to LOV.

2.1.00 (27-Feb-2020)

Corrected issue in Sourcing Rules and Assign Sourcing Rules uploads that altered the created by data.

2.0.16 (20-Feb-2020)

Added background upload feature to ASL mode.

2.0.15 (11-Feb-2020)

Rebranding of logo and new color scheme.

2.0.14 (23-Dec-2019)

Security update.

2.0.13 (02-Dec-2019)

Added optional MFG Org column for when the profile MFG_ORGANIZATION_ID is used in DFF's.

2.0.12 (28-Nov-2019)

Assign Sourcing Rules mode - Assignment ID changed to searchable LOV for situations where there are more than 1000 assignments in a single set.

2.0.11 (27-Nov-2019)

DFF profile reference to fnd_profile.value('MFG_ORGANIZATION_ID') will now reference the owning org.

2.0.10 (25-Nov-2019)

Added :ASL_SUPPLIERS.OWNING_ORGANIZATION_ID form reference which also encompasses fnd_profile.value ('MFG_ORGANIZATION_ID')

2.0.09 (21-Nov-2019)

Firewall compliant encoding added.

2.0.08 (11-Nov-2019)

Security update.

2.0.07 (14-Oct-2019)

Security update.

2.0.06 (01-Oct-2019)

Security update.

2.0.05 (24-Sep-2019)

Major Upgrade
- Improved with new colours
- Improved product architecture
- Templating improvements
- New Action columns
- Enhanced Download

1.0.00 (28-Nov-2017)

Initial Version