PO Wizard VersionPackage Body Version | 4.8.28 (19-Feb-2025)2.0.01 (Minimum 2.0.01) |
4.8.28 (19-Feb-2025)
Enhanced the Wizard - It will now function using the right-click-menu, without the More4apps Ribbon Tabs.
4.8.27 (19-Feb-2025)
Default Browser Login - Fixed bug where the browser would not navigate away from the homepage. This stopped the login process from completing.
4.8.26 (27-Dec-2024)
Corrected some form tooltips.
4.8.25 (16-Dec-2024)
Blanket Purchase Agreement: Added a new column 'Closed Status' on the sheet.
Made 'Closed Status' a download filter to enable 'Download using sheet data'.
4.8.24 (13-Dec-2024)
Add functionality that displays the available download filters when hovering over the 'Download via Sheet' option.
4.8.23 (10-Dec-2024)
Corrected issue in AutoCreate mode where Quantity and Price were not being uploaded.
4.8.22 (09-Oct-2024)
Internal update.
4.8.21 (08-Oct-2024)
Added Default Browser Login option.
4.8.20 (18-Sep-2024)
Corrected possible interface errors incorrectly being returned when IDs match other processes.
4.8.19 (21-Aug-2024)
Internal update.
4.8.18 (21-Aug-2024)
Corrected download issue introduced in v4.8.15 which prevent Distributions with no Award Number from being downloaded.
4.8.17 (20-Aug-2024)
Added Warning status when Extension Package returns only a message.
4.8.16 (13-Aug-2024)
Added PROJECT_ACCOUNTING_CONTEXT='Y' to upload when Award Number provided.
4.8.15 (09-Aug-2024)
Corrected download of Award Number.
4.8.14 (06-Aug-2024)
Internal update.
4.8.13 (03-Apr-2024)
Fixed possible duplication of messages being returned to child sections after upload.
4.8.12 (07-Mar-2024)
Added Enable Extension Package profile option.
4.8.11 (06-Mar-2024)
Internal update.
4.8.10 (06-Mar-2024)
Added package version checking to login process.
4.8.09 (29-Feb-2024)
Removed some unsupported parameters being passed to the changeapi extension package function for shipments.
4.8.08 (27-Feb-2024)
Removed some unsupported parameters being passed to the changeapi extension package function for lines.
4.8.07 (01-Feb-2024)
Prevented Message Only output from Extension package writing an incorrected Status to the sheet.
4.8.06 (23-Jan-2024)
Corrected Unhandled Return from Extension package.
4.8.05 (17-Jan-2024)
Standard PO mode: Corrected upload issue.
4.8.04 (12-Jan-2024)
Change API mode: Added Extension Package.
4.8.03 (12-Jan-2024)
Prevented StdPO from skipping interface_header_id values during upload.
4.8.02 (10-Nov-2023)
Internal update.
4.8.01 (10-Nov-2023)
Corrected StdPO upload type in Distributions.
4.8.00 (09-Nov-2023)
Standard Purchase Order mode: Added Extension Package.
4.7.16 (30-Jul-2024)
Internal update.
4.7.15 (15-Jul-2024)
Fixed Change API affecting other modes in Download form.
4.7.14 (15-Jul-2024)
Change API mode: Improved the performance of Download.
4.7.13 (02-Jul-2024)
Internal update.
4.7.12 (01-Jul-2024)
Distribution Information Download - Added sorting by 'Dist Number' column.
Fixed issue where 'Shipment ID' was being downloaded into the 'Dist ID' column.
4.7.11 (28-Mar-2024)
Blanket Purchase Agreement mode: Added new field 'Supply Agreement'.
4.7.10 (20-Nov-2023)
Fixed the upload performance issues for PO Number validation and Chart Account validation.
4.7.09 (14-Nov-2023)
Fixed issue where :$PROFILES$.PO_HEADER_TYPE DFF context reference field was not working correctly.
4.7.08 (03-Nov-2023)
Internal update.
4.7.07 (31-Oct-2023)
Fix for bug where the End-to-End Trace might not return the SQL Statement's execution plan.
4.7.06 (03-Oct-2023)
Added new digital signature.
4.7.05 (22-Sep-2023)
Standard and Change API modes: Added new field 'Transaction Reason'. Note - this is only used as a reference field in Change API mode and it cannot be uploaded.
4.7.04 (20-Sep-2023)
Contract and Quotation mode: Fixed ambiguous column name when validating Supplier.
4.7.03 (19-Sep-2023)
Fixed Currency default to Site before Supplier.
4.7.02 (18-Sep-2023)
Currency Code will now default from the Supplier, Site, or Base Currency (previously only Base Currency).
4.7.01 (01-Sep-2023)
Blanket Purchase Agreement mode: Added new field 'Line Quantity Agreed'.
4.7.00 (01-Sep-2023)
Change API mode: Prevent automatic approval process for certain customers.
4.6.99 (31-Aug-0023)
Fixed issue where :$PROFILES$.PO_HEADER_TYPE DFF context reference field was not working correctly.
4.6.98 (24-Aug-2023)
Fixed error 91 when refreshing when certain attachment columns were missing from the sheet.
4.6.97 (26-Jul-2023)
Internal update.
4.6.96 (07-Jun-2023)
Fixed timeout error when uploading mass distributions for one line.
4.6.95 (15-Mar-2023)
Fixed issue where POs without suppliers would not download.
4.6.94 (13-Feb-2023)
Fixed issue with sheet filter batch size.
4.6.93 (20-Jan-2023)
Fixed an 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.
Added "Sheet Filter Batch Size" button to the Download ribbon gallery.
4.6.92 (09-Jan-2023)
Internal update.
4.6.91 (02-Dec-2022)
Internal update.
4.6.90 (30-Nov-2022)
Fixed Error 457 and Error 91 when initializing the Wizard in some instances.
4.6.89 (30-Nov-2022)
Fixed invalid UOM error when over 1000 UOMs exist in the system.
4.6.88 (22-Nov-2022)
Added DFF context Substitution for :DOC-TYPE-NAME.
4.6.87 (06-Oct-2022)
Fixed confusing error messages when opening the form when no parent data exists.
4.6.86 (30-Sep-2022)
Distribution Destination Type will now correctly be required or optional depending o the Accrue at Receipt value.
4.6.85 (06-Sep-2022)
Updated licensing modules.
4.6.84 (16-Aug-2022)
Blanket Release Close mode: Fixed error when uploading with a GL Closed Date.
4.6.83 (04-Aug-2022)
Change API mode: Fixed error when opening the lines form, when no PO Header exists.
4.6.82 (03-Aug-2022)
Internal update.
4.6.81 (03-Aug-2022)
Fixed issue where the Wizard forms were allowing to enter data in read-only fields.
4.6.80 (12-Jul-2022)
Fixed issue where the default mode would not appear in the ribbon after logging in to the Wizard, resulting in subsequent issues.
4.6.79 (07-Jul-2022)
Internal update.
4.6.78 (14-Jun-2022)
Fixed issue where the Concurrent ribbon buttons would display incorrectly for API modes when using Templating.
4.6.77 (08-Jun-2022)
Internal update.
4.6.76 (18-May-2022)
Change API mode: Changed the number range validation for new quantity line to accept values less than 1.
4.6.75 (03-May-2022)
Internal update.
4.6.74 (28-Apr-2022)
Fixed error when validating the distributions if no charge account was populated.
4.6.73 (27-Apr-2022)
Fixed the PayOn column to have a LOV control on modes Complex PO, SPO and BPA. Fixed the validation for getting a new CCID for dynamic insertion.
4.6.72 (26-Apr-2022)
Charge accounts will now be dynamically inserted during validation if Oracle setup allows it.
4.6.71 (20-Apr-2022)
Fixed error when downloading via form using a combination of Supplier Number and child criteria.
4.6.70 (20-Apr-2022)
Fixed issue where uploaded attachment cells would not be coloured correctly.
4.6.69 (11-Apr-2022)
Standard PO and Blanket PA modes: Added header column PayOn.
4.6.68 (06-Apr-2022)
Fixed labels and tooltips on the ribbon menu.
4.6.67 (05-Apr-2022)
Internal update.
4.6.66 (30-Mar-2022)
Fixed quantity validation when it compares parent data against children's data regarding this quantity columns.
4.6.65 (28-Mar-2022)
Standard PO, Blanket PA, Quotation and Complex PO modes: Added validation to verify if the Item is purchasing-enabled. The validation will fail if this Item flag is N.
4.6.64 (17-Mar-2022)
Internal update.
4.6.63 (04-Mar-2022)
Quotation mode: Line section is sorted by line number when download quotation records.
4.6.62 (09-Feb-2022)
BPA, Complex PO, Quotation modes: Line numbers are refreshed after Concurrent Program. This to fix issues when the lines have attachment information.
4.6.61 (20-Jan-2022)
Internal update.
4.6.60 (19-Jan-2022)
Blanket Release Close mode: Added read-only field 'Ship Current Quantity'.
4.6.59 (18-Jan-2022)
PO Close mode: Added read-only field 'Ship Current Quantity'.
4.6.58 (03-Dec-2021)
Internal update.
4.6.57 (02-Nov-2021)
Internal update.
4.6.56 (12-Oct-2021)
Standard Purchase Order mode: This enhancement is to add the columns 'Manual Req Number' and 'Manual Req Line Number' to enable the user to manually enter data in these fields.
4.6.55 (04-Oct-2021)
Internal update.
4.6.54 (01-Oct-2021)
Change API mode: Customisation for client uses Approver field. Hidden by default.
4.6.53 (24-Aug-2021)
Fixed defaulting for UOM which sometimes was ignoring Item based lines. Now it verifies Item and then Line Type as defaulting sources.
4.6.52 (06-Aug-2021)
DFF Defaults: ':PO_SHIPMENTS.PROMISED_DATE' and ':PO_SHIPMENTS.NEED_BY_DATE' are now ignored due to date formatting issues.
4.6.51 (03-Aug-2021)
Internal update.
4.6.50 (02-Aug-2021)
Fixed issue when using the following DFF form references: TYPE_LOOKUP_CODE, :PO_SHIPMENTS.PROMISED_DATE, :PO_SHIPMENTS.NEED_BY_DATE.
4.6.49 (20-Jul-2021)
Change API Mode: Will now upload and download the time stamp for 'New Promised Date' and 'New Need By Date'.
4.6.48 (29-Jun-2021)
Fixed issue when saving Wizard on SharePoint or OneDrive.
4.6.47 (23-Jun-2021)
Fixed issue regarding '400 Bad Request' and getting stuck after login and selecting responsibility.
4.6.46 (31-May-2021)
Change API mode: Added new Shipment column 'Source Line Num' for filtering downloads (sheet only).
4.6.45 (03-May-2021)
Resolved DFF Substitution for :${oa.PoHeaderMergeVO.TypeLookupCode}.
4.6.44 (28-Apr-2021)
Approval Required now downloads in the correct language.
4.6.43 (06-Apr-2021)
Internal update.
4.6.42 (06-Apr-2021)
Change API mode: Fixed 'Reference to uninitialized collection' error when uploading.
Also fixed incorrect handling of API Errors when using Validate Concurrent.
4.6.41 (01-Apr-2021)
Fixed error 9999 when clicking 'Refresh API Status' before the request has completed.
4.6.40 (01-Apr-2021)
Modes which use an API (rather than interface table) now have a Validate Option 'Validate Concurrent' which runs the upload as a background process. Use this for large uploads to avoid connection issues (e.g. timeouts).
4.6.39 (26-Mar-2021)
Distribution form - Issue validation of Destination type. Although the value is not in its list of values, it does not turn red.
4.6.38 (24-Mar-2021)
Download returns the Requestor Number and not the Requestor Name.
4.6.37 (23-Mar-2021)
Updated security.
4.6.36 (11-Mar-2021)
Quotation mode: Fixed Error 91 when uploading multiple breaks for a single line.
4.6.35 (09-Mar-2021)
Fixed another 11i issue where Price Breaks could not be loaded, error: "Information specified in po_lines_interface table does not match the parent record in po_lines table".
4.6.34 (01-Mar-2021)
Updated security.
4.6.33 (01-Mar-2021)
Fixed another 11i issue where Price Breaks could not be loaded, error: "Information specified in po_lines_interface table does not match the parent record ind po_lines table".
4.6.32 (10-Feb-0021)
Autocreate mode: Fixed issue where Requisitions with no site would not download.
4.6.31 (05-Feb-0021)
Fixed another 11i issue where Price Breaks could not be loaded, error: "Information specified in po_lines_interface table does not match the parent record in po_lines table".
4.6.30 (02-Feb-0021)
Updated security.
4.6.29 (29-Jan-2021)
Fixed 11i issue where Quotation line updates would incorrectly fail with error 'Pre-defined item description cannot be changed for this item".
4.6.28 (25-Jan-2021)
Fixed but where PO Number would be cleared on Refresh.
4.6.27 (24-Jan-2021)
xx
4.6.26 (12-Jan-0021)
Updated security.
4.6.25 (02-Dec-0020)
To move 'Ship Cancel' column from column AV to the left of 'Ship Cancel Reason'.
4.6.24 (01-Dec-2020)
Change API mode: Remove Qty Cancelled column.
4.6.23 (26-Nov-0020)
Need to know the quantities received, billed and cancelled when go to update (Change), Close or cancel PO lines.
4.6.22 (23-Nov-2020)
Fixed issue with attachments - when there are 3 rows of attachments, the Wizard cannot upload Header Attachments on the first 2 lines when there is a header and line attachment on 3rd row.
4.6.21 (19-Nov-2020)
Line numbers missing on worksheet after upload. The Line Numbers haven't been created on the sheet and therefore the Line Attachments haven't created.
4.6.20 (13-Nov-2020)
Example sheet has Catalog Item in cell AS6, Source Document BI6, Source Line BU6. These labels should be in row 9.
4.6.19 (05-Oct-2020)
Updated security.
4.6.18 (05-Oct-2020)
Fixed issue where DFF Contexts were not defaulting correctly from profile option reference fields.
4.6.17 (08-Sep-2020)
Fixed issue where Approval Import Settings were not saving/loading correctly for Contract settings.
4.6.16 (01-Sep-2020)
Updated security.
4.6.15 (31-Aug-2020)
Fixed issue where the complete error message from the API was not being displayed.
4.6.14 (25-Aug-2020)
Fixed error during validation when Catalog Item column wasn't on the sheet.
4.6.13 (18-Aug-2020)
PO Close mode - Fixed Error when downloading using line number criteria.
4.6.12 (03-Aug-2020)
Updated security.
4.6.11 (17-Jul-2020)
Fixed Error 5 when searching for categories (or any KFF) where a parent valueset is used in multiple flex structures with a different name.
4.6.10 (07-Jul-2020)
Internal updates.
4.6.09 (07-Jul-2020)
UOM Line column is now defaulting from Line Type setup getting its UOM. Standard PO, Blanket PA, Quotation.
4.6.08 (24-Jun-2020)
Blanket Purchase Agreement mode - Added 'Break Action' column as the only Break Action is 'ADD'.
4.6.07 (19-Jun-2020)
Fixed issue where lines with no upload action would be updated when the process option was 'Update'.
4.6.06 (11-Jun-2020)
For Payments Terms, to change the LOV from a short list to a search list in all modes.
4.6.05 (02-Jun-2020)
Fixed issue with DFF form reference ":$FLEX$.AR_RAXINV_CUSTOMER_CLASS" when downloading.
4.6.04 (02-Jun-2020)
Updated security.
4.6.03 (06-May-2020)
Error message displays when opening a form in the Example sheet.
4.6.02 (06-May-2020)
Updated security.
4.6.01 (20-Apr-2020)
Email address to be fully populated as the email is setup at the site level.
4.5.99 (17-Apr-2020)
Customer update.
4.5.98 (01-Apr-2020)
Fixed issues with bulk uploads.
4.5.97 (31-Mar-2020)
The message validation "Dist Quantity should be equal to Ship Quantity" is not correct when the line type is Rate Based Temp Labor.
4.5.96 (26-Mar-2020)
The button ribbon must show Select Wizard Mode message.
4.5.95 (28-Feb-2020)
Rebranding - Logo and colors.
4.5.94 (27-Feb-2020)
Rebranding - Logo and colors.
4.5.93 (14-Feb-2020)
Fixed issue where shipments would be incorrectly marked invalid during bulk uploads with error message "Enter a Need-By Date or Promised Date for your planned item".
4.5.92 (12-Feb-2020)
Autocreate downloads can now be ordered by the requisition line number checkbox in the Download form.
4.5.91 (28-Jan-2020)
Fixed errors when using "Manage Templates" in R11i instances.
4.5.90 (06-Jan-2020)
Fixed errors when using "Manage Templates" in R11i instances.
4.5.89 (06-Dec-2019)
Form fndLogin deleted.
4.5.88 (04-Dec-2019)
Added DFF Context Profile Reference for $PROFILES$.CURRENT_ORG_CONTEXT.
4.5.87 (07-Nov-2019)
Added DFF Context Profile Reference for $PROFILES$.ORG_ID.
4.5.86 (06-Nov-2019)
Added DFF Substitution for :$PROFILES$.ORG_ID.
4.5.85 (06-Nov-2019)
Updated security.
4.5.84 (01-Nov-2019)
Customisation for customer.
4.5.83 (30-Oct-2019)
Customisation for customer.
4.5.82 (22-Oct-2019)
Major update for Common, Core and Custom Query. Firewall compliant encoding added.
Fixed issue where download results returned underneath the selected criteria.
4.5.81 (22-Oct-2019)
Fixed issue where Header context value would not default correctly from the reference field.
4.5.80 (18-Oct-2019)
Added DFF Form Reference Substitutions for :line_type_id :po_header_id and :quotation_class_code.
4.5.79 (15-Oct-2019)
Added DFF Substitution for :TYPE_LOOKUP_CODE reference field for ALL modes.
4.5.78 (02-Oct-2019)
Added DFF Substitution for :TYPE_LOOKUP_CODE reference field.
4.5.77 (30-Sep-2019)
Added DFF Substitution for :LINE_TYPE reference field.
4.5.76 (27-Sep-2019)
Customisation for customer.
4.5.75 (26-Sep-2019)
Customisation for customer.
4.5.74 (26-Aug-2019)
Fixed bug where "Problem !!!" error message would appear when double-clicking form buttons.
4.5.73 (19-Aug-2019)
Improved the performance of bulk validation and uploads.
4.5.72 (19-Aug-2019)
Fixed issue where Autocreate could only be used if patch 18911810 was installed, this check now also includes patches 29197834 and 21198991.
4.5.71 (29-Jul-2019)
Internal updates.
4.5.70 (22-Jul-2019)
Stopped unnecessary error prompt when uploading attachments to closed POs.
4.5.69 (01-Jul-2019)
Updated security.
4.5.68 (24-May-2019)
Added new change log.
4.5.67 (13-May-2019)
Fixed error when downloading in AutoCreate mode using Requisition Line criteria.
4.5.66 (09-May-2019)
Refreshing will now return the line number to the sheet so that line attachments can be processed more easily.
4.5.65 (07-May-2019)
Fixed Download Errors in Contract Purchase Agreement and PO Close modes.
Fixed issue where you were not prompted to load line attachments on refresh.
Fixed issue where Submit Concurrent Program would result in error when import parameters were disabled in the setup.
4.5.64 (03-May-2019)
Fixed error when download via form in AutoCreate mode.
4.5.63 (03-May-2019)
Fixed SQL error when downloading via form in AutoCreate mode.
Fixed bug where AutoCreate mode was not allowed for 12.2 versions of Oracle.
When the Template123 sheet has been renamed or deleted, an appropriate message will be provided when clicking "Format Sheet".
Fixed error when validating the Supplier Site in the Form in Complex PO mode.
4.5.62 (17-Apr-2019)
Fixed issue where refresh would not display "Accepted" in the line status if the Price Breaks had an error.
4.5.61 (16-Apr-2019)
Upgraded Core Code to version 213.39
4.5.60 (15-Apr-2019)
Category will now default from Job and will error when they do not match.
Fixed issue where Price Break error messages would be written to the Line message column.
Complex PO Mode - Pay Type error messages now correctly say "Pay Type" instead of "Pay Price".
4.5.59 (15-Apr-2019)
Improved performance of bulk uploads.
4.5.58 (10-Apr-2019)
Fixed issue where Global DFF IDs were downloaded instead of their values.
4.5.57 (02-Apr-2019)
Fixed some colouring issues when uploading and refreshing Standard POs.
4.5.56 (20-Mar-2019)
Updated the colour scheme.
4.5.55 (21-Feb-2019)
Fixed issue where ship status would remain Pending when refreshing Standard POs in an 11i environment.
4.5.54 (19-Feb-2019)
Fixed error when refreshing Standard POs in an 11i environment.
4.5.53 (11-Feb-2019)
Standard PO Mode - Changed Distribution query to improve download performance.
4.5.52 (07-Feb-2019)
Fixed issue where names with leading spaces could not be validated correctly.
4.5.51 (21-Jan-2019)
Download PO Line number in Standard PO, Change API - Standard PO, PO Close, Blanket Release Close, Cancel PO modes.
Added Download PO's by shipment in Standard PO, Change API - Standard PO, Change API - Blanket Release, Blanket Release Close, Cancel PO modes.
4.5.50 (04-Jan-2019)
Fixed download errors in EBS 11.5.10
4.5.49 (19-Dec-2018)
Fixed error when searching Charge Accounts.
4.5.48 (12-Dec-2018)
Fixed the issue where download with attachment failed on R12.1.x with Oracle patch 22630717 applied.
4.5.47 (04-Dec-2018)
Fixed Requestor Number SQL performance issue.
New debug mode option 'End to End Trace Unlimited Size'.
4.5.46 (04-Dec-2018)
Change API - Added the bility to download via Line Item.
4.5.45 (30-Nov-2018)
Added the ability to download via Line Number in all the modes except CPA (Contract Purchase Agreement).
4.5.44 (28-Nov-2018)
Upgraded infrastructure.
4.5.43 (21-Nov-2018)
Fixed error when validating in Change API mode.
4.5.42 (15-Nov-2018)
Updated to latest download modules.
4.5.41 (14-Nov-2018)
Upgrade Core menu to the new structure.
4.5.40 (02-Nov-2018)
Contingent Workers are not accepting as requester.
4.5.39 (31-Oct-2018)
Issues in upload messages.
4.5.38 (21-Sep-2018)
Suppress incorrect update validaiton messages.
4.5.37 (21-Sep-2018)
Suppress incorrect update validaiton messages.
4.5.36 (20-Sep-2018)
Suppress incorrect update validaiton messages.
4.5.35 (17-Sep-2018)
Fixed DFF error when using :PO_HEADERS.CREATION_DATE_DISP or :PO_HEADERS.CREATION_DATE substitutions.
4.5.34 (12-Sep-2018)
Fixed internal error.
4.5.33 (03-Sep-2018)
Updating PO doesn't check if it is 'In Process' when validating.
4.5.32 (20-Aug-2018)
Adding Requisition Number and line number in Standard PO Mode, Distributions section.
4.5.31 (03-Aug-2018)
Errors between Windows 7 and Windows 10.
4.5.30 (03-Jul-2018)
Auto Create - Open Distribution form error.
PO Close - Returning STATE_FAILED Error message - finally close - there are outstanding invoices.
4.5.29 (28-Jun-2018)
Charge Account validation missing.
4.5.28 (26-Jun-2018)
Fix errors in Download by Sheet - Approval Status and in Download form - Supplier Item.
4.5.27 (26-Jun-2018)
Standard, Blanket, Quotation: Download using sheet data Header Contact.
4.5.26 (25-Jun-2018)
Fix error in Contract Mode - Download.
4.5.25 (21-Jun-2018)
Fix error in Manage Templates - Selected/deselected sections.
4.5.24 (19-Jun-2018)
Error: Note to Receiver should be enterable.
4.5.23 (19-Jun-2018)
Error: Column WIP_ENTITY_ID should not be NULL.
4.5.22 (18-Jun-2018)
Error: Column WIP_ENTITY_ID should not be NULL.
4.5.21 (15-Jun-2018)
Default select first tab in the form.
Change API - Description and Line item fields not greyed out.
4.5.20 (14-Jun-2018)
Default Values rows - DFF column fix.
4.5.19 (13-Jun-2018)
Fix for previous changes in Setting123 causing changed fields to required.
4.5.18 (12-Jun-2018)
Fixed Setting123 for required and mandatory fields.
4.5.17 (08-Jun-2018)
Fix Custom Query ribbon - Download from sheet icon missing.
Fix download of large Attachments causing error.
4.5.16 (08-Jun-2018)
Update to latest WHttpRequest.cls as it has fix for issue where HTTP queries would fail on Newer Apache Webservers.
4.5.15 (05-Jun-2018)
Clean up of Wizard.
4.5.14 (31-May-2018)
Fix Validate All setting the date type to default type, its changing date to number.
4.5.13 (22-May-2018)
Change API Mode - Fixed download error when filtering using a Release Number when not download anything.
4.5.12 (18-May-2018)
Blanket PO Mode - Removed New Sourcing Rule column as the Concurrent program ignored this.
4.5.11 (11-May-2018)
Change API Mode - Fixed error when attempting to update the Price and Quantity when there are DFF's on the sheet.
4.5.10 (23-Apr-2018)
Error: Column WI P_ENTITY_ID should not be NULL.
Source Line setting wrongly as required field.
4.5.09 (17-Apr-2018)
Fix secondary Quantity validation.
Added Req Source Line, Req Source Document columns.
4.5.08 (12-Apr-2018)
Fix Download form by Supplier Number not working.
4.5.07 (11-Apr-2018)
Fixing promised date and need bay date problem.
4.5.06 (10-Apr-2018)
Change Secondary UOM, Secondary Quantity comments.
Wizard errors on need by dates but then fill them in from row 10.
Not Validating Promised Date and Need By Date columns, if removed from the sheet for the planned item.
4.5.05 (05-Apr-2018)
Quotation Mode - The user needs to have the function PO_POXSCERQ_Q in order to upload Quotations.
4.5.04 (05-Apr-2018)
Quotation Mode - The user needs to have the function PO_POXSCERQ_Q in order to upload Quotations.
4.5.03 (28-Mar-2018)
AutoCreate Mode - Submit AutoCreate API popup approval form caption and label changed.
4.5.02 (28-Mar-2018)
AutoCreate Mode - Validation failed on the Source document and line.
Change Secondary Quantity validation message.
Change Secondary UOM, Secondary Quantity columns to not mandatory in Line and Shipment levels, change shipment UOM to not mandatory.
4.5.01 (23-Mar-2018)
Format of the dates in Add Search Criteria tab in Quotation mode to be consistent with Standard PO mode.
AutoCreate Mode - Validation failed on the Source document and line.
4.5.00 (22-Mar-2018)
Standard PO Mode - Download form supplier number and supplier name order changed.
4.4.99 (22-Mar-2018)
Buyer, Requester and number SQL slow.
4.4.98 (21-Mar-2018)
Previous space issue fix will cause error for R11.
4.4.97 (20-Mar-2018)
Space (rtrim) problem for requester number fix.
4.4.96 (16-Mar-2018)
Space (rtrim) problem for requester number fix.
Request call back fix for all the validators.
AutoCreate Mode - Download form supplier and site validation fix.
4.4.95 (15-Mar-2018)
Space (rtrim) problem for requester number fix.
4.4.94 (15-Mar-2018)
ValidatorSTDLineJob validation giving error.
4.4.93 (14-Mar-2018)
Space (rtrim) problem for buyer fix.
Supplier Number required to false.
Line type validation causing infinite loop.
4.4.92 (06-Mar-2018)
Security Updated.
4.4.91 (27-Feb-2018)
Blanket PO and Quotation Modes error: Price Break fails with ‘Item_Description cannot be null’.
4.4.90 (27-Feb-2018)
Blanket PO and Quotation Modes error: Price Break fails with ‘Item_Description cannot be null’.
4.4.89 (23-Feb-2018)
Standard PO, Blanket PO supplier SQL changed to improve performance.
4.4.88 (22-Feb-2018)
Create Standard PO with two lines equals - not defaulting if two continued lines have the same item.
4.4.87 (21-Feb-2018)
Encountered the blank SQL error when opening the Lines form.
4.4.86 (16-Feb-2018)
Requestor Number required only if user enters Requestor.
Fix Requester and Supplier validation.
4.4.85 (14-Feb-2018)
Updated Download Wizard modules.
4.4.84 (13-Feb-2018)
Supplier and Supplier Number fields, order changed.
Requestor and Requestor Number fields, order changed.
4.4.83 (08-Feb-2018)
Blanket PO Mode - A Blank line and sort ordering on the Download. Criteria added to exclude cancelled header, lines and breaks.
4.4.82 (01-Feb-2018)
ChangeAPI - When upload PO, the warning message for line and shipment 'At least one parameter must be provided for update' is returned by the API.
4.4.81 (26-Jan-2018)
Need validation error message for standard PO destination type inventory, missing ship to org.
4.4.80 (26-Jan-2018)
ChangeAPI - Only Last PO is going for approval work flow.
Remove Sec Qty is highlighted as read-only cell Standard, Auto PO.
4.4.79 (10-Jan-2018)
Fixing Issues pulling up a PO DFF value. End dated some of the values and disabled them but, they are coming in the list of values.
Standard Purchase Order Template.
ChangeAPI Mode - DFF profile options set wrong but even if DFF not in the sheet, its giving warning.
Added RTrim around Buyer drec for std, quo, cpa, cng, bpa, auto modes and requester's drec for cpo mode.
4.4.78 (28-Dec-2017)
Fixed secondary UOM, Quantity validation, defaulting.
4.4.77 (21-Dec-2017)
Fixed secondary Quantity validation.
4.4.76 (20-Dec-2017)
Added warning to the primary and secondary Quantity change.
Validation error message for standard PO destination type Inventory, missing ship to org. Specify the approval status on the AutoCreate mode.
AutoCreate Mode - Supplier Number not running qry. its disabled now.
4.4.75 (18-Dec-2017)
Added errors when using the Exchange Rate column with older shared packages.
4.4.74 (14-Dec-2017)
Added Secondary UOM and Qty for Standard PO, Auto Create Modes.
Added Supplier & Requestor Number.
4.4.73 (11-Dec-2017)
AutoCreate Mode - Fixed upload error 'ORA-01400: cannot insert NULL into ("PO"."PO_HEADERS_ALL"."STYLE_ID")' when submitting the API.
4.4.72 (08-Dec-2017)
AutoCreate mode - Fixed errors when the API Debugging was on.
4.4.71 (07-Dec-2017)
Added RTrim around Requestor and Buyer LOV's.
4.4.70 (06-Dec-2017)
Added RTrim around the buyer LOV.
4.4.69 (27-Nov-2017)
Blanket Release Close Mode - Fixed error where the columns were not being coloured in the sheet on upload.
4.4.68 (05-Dec-2017)
AutoCreate Mode - Fixed error when creating PO's that have DFF's.
4.4.67 (30-Nov-2017)
Fixed error when using currencies that aren’t the base currency.
Fixed error when with DFF defaults when colon's are a part of the default value.
4.4.66 (29-Nov-2017)
Fixed error in Blanket Release Close Mode. Wizard doesn't check line numbers are unique, user has to wait for concurrent program to fail.
4.4.65 (27-Nov-2017)
PO Close Mode - Fixed error where the columns were not being coloured in the sheet on upload.
4.4.64 (24-Nov-2017)
PO Close Mode - Fixed error validation error as was being incorrectly set to invalid.
4.4.63 (24-Nov-2017)
Fixed issue as the Concurrent Program was not submitting the correct Parameters.
4.4.62 (23-Nov-2017)
Fixed issues with Blanket Release Close and PO Close.
4.4.61 (21-Nov-2017)
Fixed error when having a Default Value on a DFF Attribute.
4.4.60 (16-Nov-2017)
PO Close Mode, PO Blanket Release Close Mode: Action "Close of Receive" only at shipment level and change in validater ValidatorPOCShipAction, not allow shipment action for its own status.
4.4.59 (01-Nov-2017)
PO Close Mode - Added filter to only Download Approved PO's.
PO Blanket Release Close Mode - Added filter to only Download Approved PO's.
4.4.58 (30-Oct-2017)
Adding new Mode Blanket Release Close and add Close Action 'Close for Receiving' to PO Close Mode.
4.4.57 (26-Oct-2017)
Quotations Mode - Fixed error with the Break FOB as was downloading the Lookup code instead of the Displayed field
4.4.56 (25-Oct-2017)
Fixed error with the Setup tab. Was being shown incorrectly when the Setup Visibility was 'Hide at Startup'.
4.4.55 (23-Oct-2017)
Fixed Order By functionality on the Manage Templates form as was not working as expected.
4.4.54 (23-Oct-2017)
Implemented Order By on the Manage Templates form.
4.4.53 (04-Oct-2017)
ChangeAPI Mode - Stopped ValidatorCNGNewPrice as it was not needed in this mode.
4.4.52 (04-Oct-2017)
Standard and Complex Modes - Added Support Control and Restrict Search to Project Task Number.
4.4.51 (04-Oct-2017)
Changed to make Line Description required.
4.4.50 (28-Sep-2017)
Standard PO Mode - Fixed validation error with the Source Line column.
4.4.49 (21-Sep-2017)
Standard PO Mode - Fixed error with the Requestor column as was incorrectly setting it to Invalid.
4.4.48 (20-Sep-2017)
Updated Security.
4.4.47 (20-Sep-2017)
Standard PO Mode - Made the Source Document column dependent on the Line Item.
4.4.46 (18-Sep-2017)
Standard PO Mode - Fixed error with the Requestor search.
4.4.45 (15-Sep-2017)
Blanket PO Mode - Fixed Supplier Number defaulting as was not working in some situations. Added Supplier Number to the Download form and Download via Sheet.
4.4.44 (13-Sep-2017)
Upgraded the core to 213 release.
4.4.43 (12-Sep-2017)
Fixed error with the FOB fields - was downloading the Displayed field but validating against the Lookup Code.
4.4.42 (11-Sep-2017)
Blanket PO Mode - Added Supplier Number column.
4.4.41 (11-Sep-2017)
Fixed error when using the Download form and using the Creation date From To criteria.
4.4.40 (11-Sep-2017)
Standard PO Mode - Fixed error where the DFF was not defaulting correctly when the Synchronize with Reference field is checked.
4.4.39 (08-Sep-2017)
PO Close Mode - Fixed error where PO were not being downloaded as expected.
4.4.38 (06-Sep-2017)
Standard PO Mode - Fixed error where the Line Description was not getting uploaded.
4.4.37 (01-Sep-2017)
Made the Batch ID parameter required when submitting the Concurrent Program.
4.4.36 (01-Sep-2017)
Fixed error where the FOB field was downloading the code and not the meaning.
4.4.35 (29-Aug-2017)
Fixed error where the Contact field was downloading incorrectly.
Fixed error with the Item LOV setting items to invalid.
4.4.34 (28-Aug-2017)
Changed the Wizard to not use BISM_TEMP as this table is patch dependent.
4.4.33 (22-Aug-2017)
All Modes - Fixed error where attachments of the same document were not being downloaded correctly.
4.4.32 (21-Aug-2017)
All Modes - Fixed upload error when attempting a large upload.
4.4.31 (10-Aug-2017)
Blanket PO Mode - Implemented Price Type column.
4.4.30 (09-Aug-2017)
Made the Download form open on the 'Search By' tab.
4.4.29 (04-Aug-2017)
Standard PO Mode - Fixed error where the Receipt and Invoice close tolerance columns were disabled on the form.
4.4.28 (03-Aug-2017)
Fixed error where Standard Date DFF columns were not downloading correctly.
4.4.27 (01-Aug-2017)
Fixed error where the Approval Import Settings functionality was not working as expected.
4.4.26 (24-Jul-2017)
Fixed error with the Download form as was erroring when trying to open.
4.4.25 (20-Jul-2017)
Fixed issue where the Concurrent program was erroring when trying to open the form.
4.4.24 (19-Jul-2017)
PO Close Mode - Fixed issue where only the last row's results were getting printed in an upload.
4.4.23 (10-Jul-2017)
PO Close Mode - Added functionality to be able to freeze and unfreeze Purchase Orders.
4.4.22 (03-Jul-2017)
Blanket PO Mode - Added the ability to download via sheet using the Item Number.
4.4.21 (03-Jul-2017)
Standard PO Mode - Fixed error when the Distribution Sub Inventory Column as LOV values were not correct.
4.4.20 (30-Jun-2017)
Fixed error where the concurrent program was erroring.
4.4.19 (27-Jun-2017)
Updated Downloader modules.
4.4.18 (26-Jun-2017)
Fixed download issue as was printing rows incorrectly.
4.4.17 (26-Jun-2017)
Fixed validation issues when validating the shipment Need By Date.
4.4.16 (23-Jun-2017)
Standard PO Mode - Updated comment on the taxable field.
AutoCreate Mode - Added supplier site grouping option in the Download form.
4.4.15 (12-Jun-2017)
Updated Security.
4.4.14 (08-Jun-2017)
Fixed error where child section data could potentially get orphaned.
4.4.13 (06-Jun-2017)
Fixed error when in a trial situation.
4.4.12 (02-Jun-2017)
Change API Mode - Fixed error when validating the DFF's to make sure we have permission to update them.
4.4.11 (30-May-2017)
Enabled closed status on the Download form for all modes.
4.4.10 (30-May-2017)
Fixed error when downloading with children that are the same.
4.4.09 (30-May-2017)
Enabled closed status on the Download form for all modes.
4.4.08 (30-May-2017)
Fixed automation error when showing the processing form using the Download form.
4.4.07 (29-May-2017)
Fixed error when downloading with children that are the same.
4.4.06 (26-May-2017)
Fixed automation error when showing the processing form using the Download form.
4.4.05 (24-May-2017)
Added entry points to the Download forms to return better error messages.
4.4.04 (24-May-2017)
Fixed issue where the Contract Purchase Agreement Concurrent program is not available.
Fixed issues with the Standard PO and Blanket PO concurrent program in 11i.
4.4.03 (24-May-2017)
Fixed DFF issue when having 2 Contexts with exactly the same Attributes.
4.4.02 (23-May-2017)
PO Close Mode - Fixed upload error with single quotes in the Closed Reasons.
4.4.01 (23-May-2017)
Fixed error with DFF Dependent value sets.
4.4.00 (22-May-2017)
Fixed DFF issue with Dependent value sets.
4.3.00 (15-May-2017)
Rewrote the Upload to remove dependency on the More4Apps XML package.
4.2.91 (09-May-2017)
PO Close Mode - Fixed upload error when attempting to close a large amount of PO's.
4.2.90 (09-May-2017)
Fixed download error with the Line Attachments.
4.2.89 (05-May-2017)
PO Close Mode - Implement GL Closed Date functionality when finally closing a Standard PO.
4.2.88 (05-May-2017)
Standard PO Mode - Fixed error where PO's using the closed Status in the Download form were not downloading the correct number of records.
4.2.87 (04-May-2017)
Fixed the issue where code blows up with running PL/SQL error when having lower database version like 10G or having non-UTF8 as encoding of database.
4.2.86 (04-May-2017)
Standard PO Mode - Added ability to download via the closed status in the Download form.
4.2.85 (03-May-2017)
Fixed error with the Refresh incorrectly setting statuses to Accepted.
4.2.84 (02-May-2017)
Autocreate Mode - Fixed too many records error when attempting an Upload.
Made Standard Purchase Order mode appear at the top of the list when selecting your mode.
4.2.83 (02-May-2017)
Updated Security.
4.2.82 (26-Apr-2017)
Standard PO Mode - Fixed SQL error with the Expenditure Type column.
4.2.81 (21-Apr-2017)
Standard PO Mode - Fixed Source Line validation as was incorrect if your Source Document was a Contract Purchase Agreement.
4.2.80 (18-Apr-2017)
Added defaulting to the Currency Code column to default to the base currency set in Oracle.
4.2.79 (18-Apr-2017)
Change API Mode - Fixed error with the Change API header form as was cutting off DFF attributes.
4.2.78 (12-Apr-2017)
Change API Mode - Changed message if the API errors from 'Rejected' to 'Warning' as was misleading because DFF values still get updated.
4.2.77 (10-Apr-2017)
Change API Mode - Implemented functionality to Update Header level DFF's.
4.2.76 (05-Apr-2017)
Quotation Mode - Fixed 'Delete from Interface' bug.
4.2.75 (05-Apr-2017)
Quotation Mode - Header ShipTo is now no longer a required field for upload. Removed defaulting for HeaderShipTo column, let concurrent program handling defaulting from site.
4.2.74 (31-Mar-2017)
Added Search Control to Standard ExpenditureType and ExpenditureOrg fields
4.2.73 (30-Mar-2017)
Cancel PO Mode - Fixed error where the Item field was erroring saying it was required.
Standard PO Mode - Fixed error when double clicking on the Distribution Item Date column to open the form.
4.2.72 (17-Mar-2017)
Fixed restricted search on Batch_ID - Concurrent Form.
4.2.71 (14-Mar-2017)
Standard PO Mode - Fixed error with the lines form when the 'Catalog Item' column was removed from the sheet.
4.2.70 (13-Mar-2017)
Updated Security.
4.2.69 (23-Feb-2017)
Now setting Language on Login: Language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.
4.2.68 (14-Feb-2017)
Added AECOM customization to default the Expenditure Organization based on the Project, Task and Supplier Site.
4.2.67 (08-Feb-2017)
Updated Security.
4.2.66 (31-Jan-2017)
Standard PO Mode - Fixed error when using different line types as was incorrectly setting them to invalid.
4.2.65 (31-Jan-2017)
Fixed error with the Downloader in 64 bit.
4.2.64 (27-Jan-2017)
Fixed error when opening the Wizard in 64 bit excel.
4.2.63 (27-Jan-2017)
Imported latest common modules
4.2.62 (27-Jan-2017)
Standard PO Mode - Fixed upload error with the Line Contract field.
4.2.61 (27-Jan-2017)
Updated Download modules.
4.2.60 (10-Jan-2017)
AutoCreate Mode - Added Supplier order by option on the Download form.
Quotations Mode - Added ability to Order the Download Results via options on the Download form.
4.2.59 (19-Nov-2016)
Modified Source Document SQL as was not returning Quotation Source documents correctly.
4.2.58 (30-Nov-2016)
All Modes - Fixed error when downloading using line criteria on the download form was returning too many headers.
4.2.57 (16-Nov-2016)
Quotation Mode - Changed Quotation Type column LOV to be multilingual.
4.2.56 (11-Nov-2016)
Change API Mode - Fixed upload error as headers were not being sent to for approval correctly.
4.2.55 (09-Nov-2016)
Fixed error where the Bill to Location was defaulting incorrectly when in a multilingual environment.
4.2.54 (04-Nov-2016)
Blanket PO Mode - Fixed error where the Generate Sourcing Rules program did not have the correct parameters.
4.2.53 (02-Nov-2016)
AutoCreate Mode - Fixed error in the API as we were passing in the wrong values.
4.2.52 (26-Oct-2016)
Change API Mode - Fixed issue where the Approval Workflow was not being launched when updating a Standard PO.
AutoCreate Mode - Added check to make sure that the Rollup patch for AutoCreate has been installed.
4.2.51 (26-Oct-2016)
Standard PO Mode - Made the Shipment Ship To Location column mandatory as is required.
4.2.50 (17-Oct-2016)
Standard PO Mode - Fixed issue where the Shipment Tax Code was uploading the wrong value causing the Concurrent Program to Error.
4.2.49 (13-Oct-2016)
Standard PO Mode - Fixed issue where you cannot add a line to a Standard Purchase Order.
4.2.48 (11-Oct-2016)
Fixed 'Language is not currently supported' issue when logging into the Wizard.
4.2.47 (08-Sep-2016)
Standard PO Mode - Fixed download so that cancelled PO Lines or Shipments will not download.
Change API Mode - Fixed download so that cancelled PO Lines or Shipments will not download.
4.2.46.7 (10-Mar-2017)
Fixed issue where users are being logged in with the wrong language.
Further Information: In EBS 12.2 a framework patch has stopped us from being able to select a language in the browser login page.
To work around this problem the language for the user is now being set from user's EBS preferences irrespective of what is chosen on the Browser Login page.
4.2.46 (01-Sep-2016)
Blanket PO mode – For client case, modified Amount Agreed validation as was incorrect.
4.2.45 (29-Aug-2016)
Auto Create mode - Fixed issue where the Download was returning Incomplete Purchase Orders. Fixed issue when opening the wizard after setting the Setup Visibility to 'Hide Permanently'.
Standard PO mode - Fixed issue where a Cancelled shipment was returning quantities.
4.2.44 (29-Aug-2016)
Standard PO mode - Fixed issue where the Shipment and Distribution Quantities were not being calculated correctly.
4.2.43 (25-Aug-2016)
Internal Enhancements.
4.2.42 (18-Aug-2016)
Blanket PO mode - Fixed issue with the Price Limit column as this was being uploaded incorrectly.
Auto Create mode - Fixed issue where the PO Number was being incorrectly set to be required.
4.2.41 (17-Aug-2016)
Quotation mode - Added validation to Price Breaks section so that either the Price or the Discount must be entered.
4.2.40 (11-Aug-2016)
Auto Create mode - Fixed Download error as was blowing up when downloading via form.
4.2.39 (05-Aug-2016)
Fixed Invalid XML error when saving and reopening a user created template.
4.2.38 (04-Aug-2016)
Standard PO mode - Fixed error when Downloading Shipment DFF's.
Fixed error when using the Clear Status Columns button.
4.2.37 (03-Aug-2016)
Fixed error in 64Bit Excel when trying to create or modify Templates.
Fixed errors in the Ribbon when opening the Wizard in non-english excels
4.2.36 (20-Jul-2016)
Fixed error where the Category Column was cutting off trailing zero's when defaulting from an item.
4.2.35 (19-Jul-2016)
Internal Enhancements.
4.2.34 (14-Jul-2016)
Blanket mode - Fixed issue where category value was defaulting incorrect values.
4.2.33 (07-Jul-2016)
All modes - Fixed Bug where Exchange Type would error when set to particular value sets.
4.2.32 (06-Jul-2016)
PO Close mode - Fixed error message as was popping up when changing the action type on the Download Form.
4.2.31 (05-Jul-2016)
Internal Enhancements.
4.2.30 (30-Jun-2016)
PO Close mode - Fixed error as was getting state failed when attempting to close a line.
Fixed download error as Purchase Orders without any Action History were not downloading.
4.2.29 (27-Jun-2016)
Quotations mode - Fixed upload error as the DFF was trying to upload into the wrong columns.
Fixed error as Exchange Rates with an Exchange Type of 'User' were not being uploaded.
4.2.28 (24-Jun-2016)
Internal Enhancements.
4.2.27 (17-Jun-2016)
Fixed 'A name contained an invalid character.' error on login.
4.2.26 (16-Jun-2016)
Fixed bug where the Exchange Rate column was being set to invalid where there is a current Code/Date/Type combination.
4.2.25 (14-Jun-2016)
Quotations mode - Fixed Upload error as the RFQ Field was uploading the Quotation ID rather than the Actual Quotation Number.
4.2.24 (13-Jun-2016)
Complex PO mode - Fixed upload error as the DFF was trying to upload into the wrong columns.
4.2.23 (13-Jun-2016)
Quotations mode - Fixed upload error as the DFF was trying to upload into the wrong columns.
4.2.22 (10-Jun-2016)
Complex PO mode - Removed Update option from the LOV of the process option on the ribbon as this was not being used.
4.2.21 (09-Jun-2016)
Complex PO mode - Fixed error where the Pay Items DFF's were not working correctly.
Standard PO mode - Added defaulting onto the Deliver To Location based off the Distribution Requestor.
4.2.20 (08-Jun-2016)
All modes – Fixed download records to now correctly match the multi-language equivalents (Yes/No).
4.2.19 (07-Jun-2016)
Internal Enhancements.
4.2.18 (03-Jun-2016)
Internal Enhancements.
4.2.17 (02-Jun-2016)
Internal Enhancements.
4.2.16 (30-May-2016)
All modes - Adjusted labels across all the forms to better cater for multi-language characters.
Fixed bug where server session data was not getting cleared properly when changing between servers.
4.2.15 (27-May-2016)
Changed the way we get the Master Org ID and the Operating Unit ID to prevent issues with Multiple Operating Units.
Added fix when using the wizard in a multi-language environment as was causing errors when translating the Wizard Form.
4.2.14 (25-May-2016)
All Modes - Fixed Currency error as the upload was erroring due to Date/Currency/Type combination not being valid.
4.2.13 (25-May-2016)
Standard PO mode - Fixed refresh error where Distribution status was being changed to Accepted when the Header and Line sections had errored.
Auto Create mode - Added the ability to download by Creation and Need by Date ranges on the Download Form.
4.2.12 (23-May-2016)
Internal Enhancements.
4.2.11 (23-May-2016)
Added Validation on currency date field so a date cannot be entered when using the base currency.
4.2.10 (20-May-2016)
Internal Enhancements.
4.2.09 (16-May-2016)
All modes - Fixed error where XML Parsing error message pops up when logging in.
4.2.08 (12-May-2016)
All modes - Fixed error when uploading DFF attributes that are dates as they were being uploading in the wrong format.
Complex PO mode - Fixed error in the Distribution form as you were not able to see your DFF attributes.
4.2.07 (10-May-2016)
Complex PO mode - Implemented Form substitutions.
4.2.06 (10-May-2016)
Internal Enhancements.
4.2.05 (10-May-2016)
Standard PO mode - Implemented validation for the Shipment Need by Date and Shipment Promised Date columns. Now made required if using a planned item.
Standard PO mode - Added validation to the Note to Receiver column so that it cannot be greater than 480 characters.
4.2.04 (09-May-2016)
All modes - Fixed error as no List of Values were coming back on a DFF attribute that is dependent on another DFF Attribute.
4.2.03 (06-May-2016)
Standard PO mode - Implemented Note to Receiver Column.
4.2.02 (06-May-2016)
All modes - Fixed SQL error 'String Literal Too Long' when logging in.
4.2.01 (05-May-2016)
All modes - Fixed SQL error 'String Literal Too Long' when logging in.
4.2.00 (26-Apr-2016)
Rounded Version Number for Release.
4.1.12 (22-Apr-2016)
Standard PO mode - Added R12 check around the Line Contract Column as this is only available in R12.
4.1.11 (22-Apr-2016)
Fixed error with change API Upload as was blowing up under certain situations.
Improved Change API Download performance.
4.1.10 (18-Apr-2016)
All modes - Removed the Max Rows functionality as this causes errors with the download.
Change API mode - Fixed error in the Lines form as the Line Number field was changing to be the PO Header ID.
4.1.09 (15-Apr-2016)
Standard PO mode - Made the exchange type LOV as the values were being cut off.
4.1.08 (13-Apr-2016)
Standard PO mode - Fixed issue with the Line Defaulting validator as it wasn’t being set to true, so was erroring the line.
4.1.07 (13-Apr-2016)
Standard PO mode - Changed SQL. Now displays the Source Type and Source number in the LOV on the Standard PO Lines Form.
4.1.06 (12-Apr-2016)
Standard PO mode - Modified Catalog Item SQL as this was returning incorrect values.
4.1.05 (11-Apr-2016)
Fixed error with the cancel button tooltips as was displaying 'HR_WEB_CONFIRM_CANCEL'.
Standard PO mode - Fixed error with the Catalog Item having ##NULL## in the LOV and repositioned the Line Description field on the sheet and on the form.
4.1.04 (07-Apr-2016)
All modes - Updated the message that is displayed when the Sheet mode is removed off row 7.
4.1.03 (05-Apr-2016)
All modes - Changed the message that is displayed when deleting a row above row 10.
4.1.02 (01-Apr-2016)
AutoCreate mode - Added Source Document and Source Line columns.
All modes - Fixed error that was occurring when opening a form in a mode without DFF's enabled.
4.1.01 (31-Mar-2016)
AutoCreate mode - If the Requisition currency is blank then default to the Base Currency when downloading and fixed error where DFF buttons on the ribbon were hidden.
AutoCreate and Standard PO mode - Made form labels wider for 'Contractor First Name' and 'Contractor Last Name' columns.
4.1.00 (30-Mar-2016)
Added Header and Line Standard PO DFF's to AutoCreate Mode.
Fixed error with AutoCreate API Parameters as was passing in the wrong value.
Added more Columns that is Downloaded in AutoCreate mode based on the Requisition.
4.0.99 (22-Mar-2016)
Fixed error in the AutoCreate Upload as the API paramaters are different in difference Oracle Instances.
4.0.98 (21-Mar-2016)
Added ability to add Attachments in AutoCreate Mode to an AutoCreated Standard PO.
4.0.97 (21-Mar-2016)
Fixed error as was getting issues when opening the wizard and your Computer settings is not in English.
4.0.96 (18-Mar-2016)
Added fix to AutoCreate mode so that you can't create a PO based off an already AutoCreated Requisition Line.
4.0.95 (18-Mar-2016)
Fixed error 'String Literal too Long' as was getting this when logging into the Wizard.
4.0.94 (18-Mar-2016)
Updated Security.
4.0.93 (18-Mar-2016)
Fixed error with PO Terms Defaults as it was defaulting with the wrong value when left blank on the sheet.
Changed the Link to the documentation on the Setup sheet from Sales Order Wizard to Purchase Order Wizard.
4.0.92 (17-Mar-2016)
Enabled AutoCreate mode.
Added Format Data Functionality on the Ribbon to all modes.
Added Requisition Preparer Column to AutoCreate Mode.
4.0.91 (15-Mar-2016)
Widened DFF form Columns as values were being cut off.
Wizard now checks if your cursor is below row 11 when opening a form via the ribbon.
Removed check on Expenditure Type column as was causing issues with the Wizard Validation.
Changed Standard Distribution Deliver to Location SQL to bring back data when no Ship to Org has been entered.
4.0.90 (14-Mar-2016)
Fixed issue in Blanket PO Mode when trying to update a Blanket PO Line.
4.0.89 (11-Mar-2016)
Changed default Group lines Parameter when submitting a Concurrent Request from Yes to No in Standard PO and Complex PO Modes.
Removed Shipment button on the ribbon when in Quotations mode.
4.0.88 (09-Mar-2016)
Changed focus on KFF Form as was opening on the aliases tab.
Made line number not required in Complex PO, Standard PO, Blankets and Quotations modes.
4.0.87 (09-Mar-2016)
Changed Ribbon labels when not logged in.
4.0.86 (09-Mar-2016)
Fixed issue in Standard Mode as upload was blowing up in R12.
4.0.85 (08-Mar-2016)
Removed functionality in Standard PO and Complex PO Mode as the upload was causing Grouping Errors when submitting the Concurrent Request.
4.0.84 (08-Mar-2016)
Fixed blow up that was occurring when Logging into the Wizard with a language that isn't currently supported.
4.0.83 (07-Mar-2016)
Fixed issue with the Defaulting in Standard PO Mode.
4.0.82 (07-Mar-2016)
Fixed issue where error messages were getting printed with Word Wrapping.
4.0.81 (04-Mar-2016)
Fixed issue on Windows 10 machines.
4.0.80 (02-Mar-2016)
Updated Security.
4.0.79 (26-Feb-2016)
Changed the Picture name on the template.
4.0.78 (25-Feb-2016)
Fixed issue where disclaimer on PO Close mode as this wasn't being printed to the sheet.
4.0.77 (24-Feb-2016)
Fixed issue with Captions on the KFF Form.
Fixed issue where 'Default Values' text was not being displayed when creating a new sheet.
4.0.76 (23-Feb-2016)
Fixed label on the KFF Form.
Changed wording on the Submit Request form from 'Cancel' to 'Close'.
4.0.75 (22-Feb-2016)
Fixed spelling errors in the Ribbon.
4.0.74 (19-Feb-2016)
Added if R12 check around project number SQL in Standard Mode as Project_Status_Code is not available in 11i.
4.0.73 (19-Feb-2016)
Fixed issue when Uploading due to % in the description.
Changed Project Number SQL in Standard Mode.
4.0.72 (15-Feb-2016)
Fixed issue with DFF printing.
4.0.71 (15-Feb-2016)
Fixed issue with DFF as the context wasn't defaulting correctly with a SYSTEM.CURRENTFORM reference.
4.0.70 (15-Feb-2016)
Fixed issue with DFF as the context wasn't defaulting when with a reference.
4.0.69 (10-Feb-2016)
Fixed issue with printing dates in the wrong format when downloading.
4.0.68 (09-Feb-2016)
Imported fixed SQL error when logging in.
4.0.67 (09-Feb-2016)
Fixed issue where Currency Columns were getting validated in Update mode.
4.0.66 (05-Feb-2016)
Imported new ribbon multi-language properties.
4.0.65 (04-Feb-2016)
Fixed issue with Currency Validation in Blanket mode.
Fixed issue in PO Close where Current Status on the sheet was bringing a different value back in the form.
4.0.64 (28-Jan-2016)
Fixed issue with PO Close Download.
4.0.63 (28-Jan-2016)
Added download of Closed reason in PO Close Mode.
4.0.62 (26-Jan-2016)
Fixed issue in PO Close where Validation was blowing up when selecting a Close Action.
Updated Security.
4.0.61 (21-Jan-2016)
Implemented mode specific DFF substitutions.
Fixed issue in Quotations where Effective from and effective to dates weren't being Uploaded.
4.0.60 (18-Jan-2016)
Fixed issue in ChangeAPI with the Pricing Validation when a Source Line is referenced.
4.0.59 (15-Jan-2016)
Fixed colouring on the sheet for ShipID column.
4.0.58 (15-Jan-2016)
Fixed issue with printing of data hierarchy.
4.0.57 (14-Jan-2016)
Changed Ship To Location SQL in Quotations and Blankets. Made dependent on Ship To Org.
4.0.56 (14-Jan-2016)
Fixed issue in ChangeAPI when you were getting an error message when trying to update Blanket Releases.
4.0.55 (13-Jan-2016)
Fixed issue in Quotations where Unit_price, Description, mix_order_quantity and max_order_quantity were not getting uploaded.
4.0.54 (12-Jan-2016)
Added validation to PO Close to control when you can Close and Finally Close the document.
4.0.53 (11-Jan-2016)
Fixed issue in Change API where the Line Number was being set to Invalid when it was valid.
4.0.52 (07-Jan-2016)
Added Change API Validation for Documents when a Source Document is referenced.
4.0.51 (06-Jan-2016)
Fixed issue with the download not bringing the right data back in certain circumstances.
4.0.50 (06-Jan-2016)
Added Warning message in Change API Mode when trying to Update Shipment or Line DFF's when the Profiles are turned off.
4.0.49 (23-Dec-2015)
Added validation to Price Breaks in Quotations mode to check that the Price Effective date must be less than the Header Expiration Date.
4.0.48 (22-Dec-2015)
Updated Security.
4.0.47 (22-Dec-2015)
Removed redundant validation in Change API.
4.0.46 (18-Dec-2015)
Added outer joins to FOB column in Blanket PO Mode as data wasn’t being returned.
4.0.45 (16-Dec-2015)
Added ability to download using Line Number in Standard PO Mode.
4.0.44 (16-Dec-2015)
Changed error message in Change API From "The Line Number should be NULL when TYPE_LOOKUP_CODE is BLANKET." to "The Line Number should be NULL when Document Type is BLANKET.”
4.0.43 (15-Dec-2015)
Fixed Upload in modes (Change API, PO Close, Cancel PO) as was blowing up when doing large loads.
4.0.42 (15-Dec-2015)
Added Line Number search controls to the following modes:
- Change API
- PO Close
- PO Cancel
Added Line Release Number search Control to the PO Cancel mode.
Fixed issue in templating when adding new columns to the wizard that are not on the existing template.
4.0.41 (14-Dec-2015)
Added Document Type Display only columns to Change API and PO Close Modes.
Added validation to PO Close Mode as you are unable to close shipments on a Blanket PO (since they are price breaks if you try to close a Blanket).
4.0.40 (10-Dec-2015)
Added ability to Update Shipment Level DFF's in Change API. Controlled by new profile option M4APS_POW_CHANGE_API_ENABLE_SHIPMENT_DFF .
4.0.39 (09-Dec-2015)
Added List Price and Market Price Columns to Blanket PO Mode.
4.0.38 (09-Dec-2015)
Changed the upload in Blanket, Standard, Complex PO and Quotation modes so we are only uploading the category if the Item is blank.
4.0.37 (08-Dec-2015)
Fixed issue where Defaulting values in Blanket Mode lines form wasn’t being printing to the sheet.
4.0.36 (07-Dec-2015)
Added ability to Download based on Line Release Number in Change API Mode.
4.0.35 (03-Dec-2015)
Added ability to remove Line and Shipments sections in Close PO Mode.
4.0.34 (03-Dec-2015)
Added Change API validation making sure the Quantities and the Price are the same between the Lines and Shipments section.
4.0.33 (03-Dec-2015)
Changed Standard Mode Distributions Deliver to Location SQL as was bringing back incorrect results.
4.0.32 (02-Dec-2015)
Fixed issue where you would keep getting an error saying the quantities don't match when in fact they did in Standard PO.
4.0.31 (02-Dec-2015)
Fixed issue where Category and header Supplier Ship to leading values were being cut off.
4.0.30 (01-Dec-2015)
Changed Ship To Location LOV SQL in Standard PO Mode .
4.0.29 (01-Dec-2015)
Fixed issue where Download Form was blowing up when trying to Download.
4.0.28 (01-Dec-2015)
Removed Source Line Defaulting when the Source Document has been entered
4.0.27 (01-Dec-2015)
Imported new code which fixes automation errors in the forms caused by clicking the X to close the form.
4.0.26 (01-Dec-2015)
Fixed issues with Source Line and Source Document columns. Made Source Line required if it can’t uniquely identify the Source Line.
4.0.25 (30-Nov-2015)
Fixed issue with Line Type validation as was blowing up when a required field was left blank.
4.0.24 (30-Nov-2015)
Fixed Line Document/line Sourcing validation.
4.0.23 (30-Nov-2015)
Changed Terms Defaulting SQL as was bringing back invalid results before entering a Supplier and Site.
4.0.22 (30-Nov-2015)
Changed SQL field in Carrier Defaulting as was bringing back an incorrect value in certain circumstances.
4.0.21 (27-Nov-2015)
Moved Expenditure type controls on the form.
4.0.20 (27-Nov-2015)
Changed Expenditure Type SQL when grants is installed, as expenditure type is dependent on the award number.
4.0.19 (27-Nov-2015)
Fixed issue where task number wasn’t being populated upon selecting a project number.
Fixed issue when putting an Award Number and tabbing out of it was causing it to blow up.
4.0.18 (26-Nov-2015)
Added Award Number Column to Standard PO.
4.0.17 (13-Nov-2015)
Added fixes for 64 bit excel when submitting the concurrent request.
4.0.16 (12-Nov-2015)
Added ability to Close Blanket Agreements in PO Close Mode.
Enabled Document Type Field on the Download Form for PO Close.
4.0.15 (12-Nov-2015)
Added fix for 64 bit when Uploading and Downloading.
4.0.14 (11-Nov-2015)
Improved Standard Distribution Requester query performance.
4.0.13 (10-Nov-2015)
Added fix for 64 bit excel when downloading.
4.0.12 (10-Nov-2015)
Added functionality to handle sourcing from Oracle Pricing Price Lists and Global Blanket Agreements - Not available in 11i.
Added Order by on Shipment Number column when Downloading.
4.0.11 (05-Nov-2015)
Added Shipment Number Column to Standard mode.
4.0.10 (04-Nov-2015)
Added Line Action Validation to Blanket mode.
4.0.09 (02-Nov-2015)
Fixed issue where Line DFF's weren’t getting uploaded in ChangeAPI.
4.0.08 (02-Nov-2015)
Added Autocreate Functionality (To be released after Version 4.0.90 release)
4.0.07 (30-Oct-2015)
Fixed Upload and Dependency issues for DFFs.
4.0.06 (29-Oct-2015)
Fixed price differentials section not being refreshed.
Fixed opening up temporary labour on standard PO causing error.
Fixed Price Differentials section unable to be uploaded.
Added new downloader which filters own section instead of passing filter up to header.
4.0.05 (28-Oct-2015)
Updated to common 2.1
Fixed validation ensuring at least one to one relationship (line to a shipment to a distribution) etc.
4.0.04 (23-Oct-2015)
Fixed validating sections missing from sheet but in template
Fixed messages being cleared from processing form during initialisation
4.0.03 (23-Oct-2015)
Fixed validation not being set correctly on category column
4.0.02 (23-Oct-2015)
Fixed Restrict To Modes Only profile option description
4.0.01 (23-Oct-2015)
Added 'Restrict To Modes Only' profile option for templating
Enabled toggle that prevents PO from being uploaded when any shipment/line (a child) errors
Fixed Catalog Item defaulting not correctly passing validation and erroring the line with no error message
4.0.00 (22-Oct-2015)
Users can now Login using the Log In button on the ribbon
Added the following features:
- Ribbon
- Validation to Price Breaks - only allow Discount or Break Price
- Templating - Users can now generate templates based on Wizard modes
- WHO Columns to Quotations and Blanket upload
- PO Cancel Mode
- Complex PO Mode
- Extra criteria to the Download form
- Downloader ribbon functionality
- Sourcing Rule columns
- Multi-language functionality
- Attachment Upload Selected and Upload All Functionality
- Profile Option: M4APS_POW_Use_Price_Break_Line_Locations to allow fix for Price Breaks on patch 12.1.3 or above
2.2.27 (12-Mar-2015)
Change API Mode: Added Column Header 'Shipment New Need By Date' to templates
2.2.26 (09-Mar-2015)
Standard PO Mode: Added Creation Date column to the wizard
2.2.25 (05-Feb-2015)
Quotation Mode: Added Creation_date to quotation upload sections
2.2.24 (28-Jan-2015)
Standard PO Mode: Changed Task LOV to cater for EBS 12.2.4. The new view the LOV is based on (pa_tasks_expend_v) is valid for 11i upwards.
2.2.23 (13-Jan-2015)
Quotations Mode: Added columns "New Sourcing Rule Name" and "Existing Sourcing Rule Name".
Logic: Can’t supply values for both at the same time - because it populates the same interface table column
"New Sourcing Rule Name" validates to make sure that it isn’t an existing sourcing rule.
"Existing Sourcing Rule Name" validates to make sure that it is an existing sourcing rule.
2.2.15 (13-Nov-2014)
Standard PO Mode: Added column TAX USER OVERRIDE FLAG
2.2.11 (31-Oct-2014)
Enhanced Descriptive Flexfields: Added defaulting from 'Reference Field'.
Context List is now restricted when context 'Synchronize with Reference Field' is checked. Now downloads all columns even if not in context
2.1.98 (28-Aug-2014)
Added new column ‘Line Action’ to allow users to specify whether the line is an update or an add to override the imports programs default behaviour
2.1.97 (25-Aug-2014)
Standard PO Mode: Added Catalog Item to form. Previously the Wizard supported the column on the sheet but not on the form
2.1.92 (31-Jul-2014)
Standard PO Mode: Added Contract column. Not supported in EBS 11.5.10.
Patchset dependent for EBS r12 see Oracle document Enhancement Request "ER 3733755: PDOI: CANNOT REFERENCE TO CONTRACT_NUM DURING INTERFACE PROCESS".
There is no patchset check in the Wizard. If the appropriate patch hasn’t been supplied the data will validate and be loaded into the interface table but will not be imported into the PO
2.1.91 (22-Jul-2014)
Standard Purchase Order Mode: Re-wrote tax_validation for r12
2.1.89 (26-Apr-2014)
Change API: Now ensuring the BPA is approved before we allow changes to the releases. Changing releases on non-approved BPAs changes the status of the BPA in Oracle to 'Requires Re-Approval' and the BPA then needs manual intervention to start the Approval Workflow
2.1.86 (21-Mar-2014)
Change API Mode: Added 'Release Status’,'Shipment Price','Release Item’ and 'Release Item Desc' info only columns
2.1.81 (14-Feb-2014)
Now supports systems that don’t have Items installed
2.1.78 (12-Dec-2013)
Change API Mode: Approval Flag set to 'Yes' for BPAs. So all uploaded releases of a BPA get approved
2.1.77.3 (21-Nov-2014)
Fix for handling long columns in EBS 12.1
2.1.77.1 (13-Oct-2014)
Fix for Descriptive Flexfield for 12.2
2.1.77 (19-Nov-2013)
Changed Trim to Rtrim on the function category in the class attClass so attribute categories with a space at the front of them don't get changed
2.1.76 (14-Nov-2013)
Spelling correction on bpaline form
2.1.75 (11-Nov-2013)
Labor Start Date, Labor End Date and Gl Encumbered date in distributions fix on values for year that are pre 1900
2.1.74 (11-Nov-2013)
Gl Encumbered Date not handling a year less than 1900, made change to check year value 2 or 4
2.1.73 (06-Nov-2013)
Line quantity and unit price needs to be validated prior to all fields been populated in the user form activate of the line form
2.1.72 (05-Nov-2013)
Added if not firstrun to cbolinetypeafterupdate and purchasingbasisenabled
2.1.71 (30-Oct-2013)
Updated UIPOClose to use SectionsPOClose vs SectionsC and lineSection.RowDetails.IsBlankRow to use start row of current row
2.1.70 (29-Oct-2013)
Updated ModeCheck to disable header form if cursor in row 9 or less
2.1.69 (29-Oct-2013)
Adjusted the Number text on the frmSTDHeader form
2.1.68 (29-Oct-2013)
PO Close disclaimer can now be viewed in full
2.1.67 (25-Oct-2013)
Stopped the dist quantity getting displayed after defaulting the value from the shipment quantity into the interface table
2.1.66 (25-Oct-2013)
Changed occurrances of “and upper(v.flex_value)” back to “and v.flex_value” in DependentLOVSQL and IndependentLOVSQL
2.1.65 (23-Oct-2013)
Made all occurrances of “and v.flex_value” say “and upper(v.flex_value)” to resolve no lov in bpa on totara submit parameter approval
2.1.64 (23-Oct-2013)
Changed the where condition on the freight terms in powShortList Freightterms and bpaValidators Freight_TermsValidator to ensure the correct list, previously returned more values than core forms in Oracle
2.1.63 (23-Oct-2013)
Removed the submit icon from the setup toolbar
2.1.62 (23-Oct-2013)
Internal Use only – Added FactoryReset function for cleaning the Wizard before release
2.1.61 (22-Oct-2013)
Fix for Case line_quantity validator incorrectly invalidates quantity for Standard Purchase orders. This was when tightening up rules around ‘FIXED PRICE’ line types
2.1.60 (22-Oct-2013)
Fix for case
2.1.59 (22-Oct-2013)
Never released. Implemented CDPs to control Import Approval Method options and the Open Shipments Only download option
2.1.58 (16-Oct-2013)
Added Dist Number to the standard PO template and distributions form
2.1.57 (16-Oct-2013)
Added not null validation to the line quantity on the standard PO template
2.1.56 (09-Oct-2013)
Added Transportation Arranged column to BPA
2.1.55 (03-Oct-2013)
Removed ActiveCell = TempStr from form Reverts – this was causing dates to be converted to USA format (switching the day and month around) and would cause problems with foreign number formats
Imported CDP Module, created CDPSetup Module which handles all the CDP Constant Names and contains CDPInitialise to create all of the defined Custom Document Properties for the Wizard.
When no parent information is added for PO Close and Change API modes, just a message box will display – the parent form will no longer open
When opening the shipment form with header information but no line info would result in an error
2.1.54 (02-Oct-2013)
Changed query in frmDownloader – cmdSearch – Click: to po_vendors and to return the vendor_id instead of the po_header_id and had to use a union on po_headers_v and po_headers_rfqqt_v to make it universal to quotations and other po documents
2.1.53 (25-Sep-2013)
Fix for opening Lines DFFForm. Error was: ‘Line Number Failed Validation. Column: AS> Duplicate Line Number: 1. This Line Number is already used on row: 11
2.1.52 (20-Sep-2013)
Quotation download fix. Supplier filter did not work
2.1.51 (11-Sep-2013)
Further work on fix in version 2.1.50. Change API mode fix for r12 error
2.1.50 (11-Sep-2013)
Change API mode fix for r12 error: “Unable to process your transaction. The operating unit is either invalid or it cannot be derived. Please verify your Multi-Org profile options. ORA-20001: SQL_PLSQL_ERROR: N, ROUTINE, MO_GLOBAL.VALIDATE_ORGID_PUB_API, N, ERRNO, -20001, N, REASON, ORA-20001: in Package PO_CHANGE_API1_S Procedure UPDATE_PO”
2.1.49 (28-Aug-2013)
Added Transport Arranged column to Standard PO Mode
2.1.48 (31-Jul-2013)
Customisation
2.1.47 (30-Jul-2013)
Item Revision SQL was being filtered by operating unit. Revision list should be available for all organisations that the item is assigned to. And operating unit may not be one of them ie if it is not an inventory org
2.1.46 (26-Jul-2013)
Customization Added
Fixed Standard PO validation error in ‘Validate Only’ mode for distributions. Validation was returning a -6508 message to the distributions Dist Error Status column
2.1.45 (23-Jul-2013)
Fix for 11i bug in Download Form. Issue was created in 2.1.44
2.1.44 (19-Jul-2013)
Added Open Shipments only filter to Standard Purchase Order download from form. (QUANTITY – QUANTITY_RECEIVED – QUANTITY_CANCELLED) is the filter on shipments table. This will be the Quantity downloaded to the sheet for the shipments – (QUANTITY – QUANTITY_RECEIVED – QUANTITY_CANCELLED).
2.1.43 (17-Jul-2013)
Added Buyer to Download from filter criteria
2.1.42 (10-Jul-2013)
Core code updated to 205
2.1.41 (23-May-2013)
Redone Task and Project in PO Distributions form. Added Task Description to LOV
Download queries changed for Shipment and Distributions. Performance was very poor.
Fix bug in Freight Terms LOV. Logic for Terms with Start Dates was back to front. ie Future Start Dates were being included in LOV all the rest were excluded
2.1.40 (16-May-2013)
Fixed validation error in Labour End Date validation
Further bugs fixed in STD PO lines form for Services Procurement implementation
2.1.39 (23-Apr-2013)
Upload PO (Standard Purchase Order Mode). Fixed bug where Wizard would stop validating PO when an error was found
Added Purchase Basis = Temp Labor functionality
Standard Purchase Order Mode: Fixed bug in Header Form. ‘GL Encumbered date’ was swapping month and day. Bug still partly there – occurs when you double click on a ‘GL Encumbered date’ cell and hit cancel. If you double click on any other cell this won’t happen
Standard PO template – removed BPA columns from header and lines
Standard PO forms fixed bug where forms would open above row 10
2.1.38 (17-Apr-2013)
Fixed bug where Price Break Freight Terms was downloading code rather than meaning
Fixed bug where ‘Code Combination IDs’ cache was not being reset. ‘Code Combination IDs’ from the test system were being loaded into production. These ‘Code Combination IDs’ either didn’t exist in the test system or belonged to other Accounts
2.1.37 (10-Apr-2013)
Download sort order of Alpha or Numeric is now decided by looking at the Purchasing Options Numbering
Added the ability to change spacing between headers in downloads.
Added check to see if concurrent request is finished giving the user the option to cancel the refresh. NB If the concurrent request has not finished running the status columns for some POs can be partially updated. These partially updated ones are never updated. Because the header status is flagged as accepted the Wizard doesn’t try to update child sections on subsequent refreshes. If this situation occurs replace all Accepted to Pending and re-run the refresh.
PO Change API mode – Added Header Description and Item Description as information only columns
2.1.36 (22-Mar-2013)
Internal changes only
2.1.35 (21-Mar-2013)
Change API: Fix for numeric problem caused by language issues. Decimal separator in Dutch is ‘,’. Wizard would invalidate this with the following message: Shipment New Quantity Failed Validation. Column: Q. Value must be numeric
2.1.34 (12-Mar-2013)
Standard PO: Fix for when Distributions DFF form is opened in Standard Purchase Order mode when the OP Job No, OP Operation Sequence, OP Resource Sequence columns not on the sheet. This error would occur: caused ‘Error 91 (object variable or with block variable not set) in procedure Validate of Module wCol. Fix for error when opening LinesDFF form if no line number was entered: Duplicate Line Number:1. This Line Number is already used on row: 1
2.1.33 (04-Mar-2013)
Version not released
Quotation Price Break and BPA Price Break: Added ‘Ship to Org’ to download. Changed ’Ship to Org column’ to use org_code as per oracle form – it was using org code + org name.
Fix for quotations broken in version ’2.1.20.
BPA Price Breaks Section Validation added for: Section Error: Enter values for at least one of the following price break attributes: Organization, Location, Quantity, Effective From Date, or Effective To Date
BPA Price Breaks: Added validation for: Error: Price Break Effective To Date cannot be earlier than the Price Break Effective From Date. Error: Effective Dates on Price Breaks are not allowed for Cumulatively Priced Blanket Lines
2.1.32 (01-Mar-2013)
Fix for Key Flexfield error caused by unhandled apostrophe in segment value
2.1.31 (21-Feb-2013)
Using a profile option to expose Line DFF updates from the Change API mode. NB this is not supported and involves direct table updates to the dff columns. Profile Details: M4APS_POW_CHANGE_API_ENABLE_LINE_DFF,’More4Apps: POW Change API Enable Line DFF’. Allows the P.O. Wizard to Enable the Change API mode to update line DFFs. This involves Non-Supported Direct Table Updates.
Change API Mode fixed bug in download from sheet – it was throwing a sql error
2.1.30 (19-Feb-2013)
Removed defaulting of requestor by distributions form. Fixes to distributions form requestor behaviour
2.1.29 (15-Feb-2013)
Download form: Made Purchase Order Number column wider so Long Purchase Order numbers can be viewed
Re-wrote distributions Requester functionality for Standard Purchase Order mode
Tacked employee number onto end to stop duplicate names problems
2.1.28 (14-Feb-2013)
Not for release – Diagnostics version only
2.1.27 (13-Feb-2013)
Not for release – Diagnostics version only
2.1.26 (12-Feb-2013)
Upgrade Request Viewer files to fix ora-01422: exact fetch returns more than requested number of rows
2.1.25 (11-Feb-2013)
Fixed DFF form Context bug. An invalid context caused this error: Error 381 (Could not set the Column property. Invalid property array index.) in procedure cboContext_AfterUpdate of Module DFFForm
2.1.24 (31-Dec-2012)
Internal enhancement
2.1.23 (31-Dec-2012)
Enhanced toolbar error handling
2.1.22 (21-Dec-2012)
Implementing Supplier Number column for Standard PO for customer
Fixed bug in download form when Document Type cbo was enabled ie for modes when Document Type can be used as a filter. Only occurred when a Document Type was selected. Affected ChangeAPI and Quotations
Fix for ChangeAPI oracle error in r12
Error: Unable to process your transaction. The operating unit is either invalid or it cannot be derived. Please verify your Multi-Org profile options
2.1.21 (20-Dec-2012)
Turned off Trace in attachments load_file_r12.
2.1.20 (04-Dec-2012)
Change freight terms to work off meaning rather than lookup code. Affects modes; Standard, BPA and Quotations
Added Attachments to BPA
Quotation Attachment not loading, probably something to do with pk1 and entity being handed up. Have last query from quotation need to compare to a last query from PO
Fixed bug in BPA Price Break download SQL. No results were being returned
2.1.19 (15-Nov-2012)
Fixed bug which caused Blankets and Quotations to do nothing
2.1.18 (05-Nov-2012)
Added support for Standard Purchase Order lines with value basis = ‘Fixed Price’
2.1.17 (29-Oct-2012)
PO Close functionality released. It is controlled by profile ‘More4Apps: POW Enable Purchase Order Close Processing’
Fixed bug where upload would continue when Cancel button chosen
Fixed unnecessary database calls caused by Expenditure Org when no expenditure orgs exist
Fixed unnecessary database calls caused by ‘Need By’ and ‘Destination Type’ causing Item to query for blank items
2.1.16 (26-Oct-2012)
Removed defaulting of the Deliver To Location in the distributions section
2.1.15 (27-Sep-2012)
Error handling enhancement
2.1.14 (12-Sep-2012)
Multi-Org fix – only affects r12
202.1 Common Modules update
Standard Login (SSO Bypass) added to setup toolbar
2.1.13 (24-Jul-2012)
Re-instated show toolbars menu
2.1.12 (19-Jul-2012)
Changed getCCID – added cursor sharing = ‘similar’ to try and improve performance.
Fix for when Distributions DFF form is opened in Standard Purchase Order mode – these errors would occur:
OP Job No validator programmed – please contact more4apps.
OP Job Failed Validation. Column: DD
OP Operation Sequence No validator programmed – please contact more4apps
OP Operation Sequence Failed Validation. Column: DG
OP Resource Sequence No validator programmed – please contact more4apps
OP Resource Sequence Failed Validation. Column: DH
2.1.11 (18-Jul-2012)
Added DFF Substitution:PO_HEADERS.TYPE_LOOKUP_CODE
Performance enhancement for Key Flexfield validationiv>
2.1.10 (13-Jul-2012)
Currency Validation for BPA and Quotation. Ignoring ratetype, rate and date when document currency same as functional currency
Fixed bug in DFF form (would occur when there were no GDE attributes):Error 91 (Object variable or With block variable not set) in procedure Load_Value_Set_Array and Process_Control_Value of Module DFF Form
Fixed bug in DFF form where some lists were not being populated
201 Core module upgrade
2.1.09 (11-Jul-2012)
BPA Template change: header dff columns on template were context and attributes 2,3,10 changed it to our standard context and attr 1,15
201 Core modules upgrade
2.1.08 (10-Jul-2012)
64 bit fix for attachment form
2.1.07 (03-Jul-2012)
Not for release. Internal Work only
2.1.06 (29-Jun-2012)
Upgraded to common modules version 201
2.1.05 (28-Jun-2012)
Enhanced Descriptive Flexfield error handling
2.1.04 (27-Jun-2012)
Minor change to refresh. If the interface table auto purges then refresh will set the header to accepted and bring back the Purchase Order number. However all the Child sections will still say pending if they imported successfully. Errored lines will be identified
2.1.03 (22-Jun-2012)
Descriptive Flexfield work for hidden contexts and defaulting contexts. Default code was being loaded into the form instead of value
Language work for Download
Security change for download in 12.1.3
2.1.02 (18-Jun-2012)
Item Download added to change api as an information only column
2.1.01 (30-May-2012)
Standard PO Mode – Shipment Quantity made mandatory column
Standard PO Mode – Added Distribution number to download
07/06/12 Change to refresh sql the reference_num in (” & CreateINClause(Me.IDsToRefresh) was causing a sql error when alpha PO Numbering existed
2.1.00 (22-May-2012)
Added messaging to submit parameters when cmd button clicked
2.0.20 (07-May-2012)
Fix for download form error caused by not handling languages properly
Fix error 91 bug when row9 is blank. Similar error to fix in 2.0.18. This fix is in the common modules
2.0.19 (01-May-2012)
Fixed bug in Key Flexfield. Table based dependences were not working in the form. Rather than looking at the parent value it was looking at the parent format type
2.0.18 (10-Apr-2012)
Added ‘Shipment New Need By Date’ column to change API – for r12 only
Fixed bug where ‘Standard PO’ and ‘Change API’ modes were not re-setting cached values when logging in
Fixed error 91 bug when the sheet isn’t a valid template type
2.0.17 (27-Mar-2012)
Fixed bug where named users could not be added
2.0.16 (31-Jan-2012)
Removed rounding from Distribution Total it was causing a problem when the Line Quantity had more than 10 Decimal places
2.0.15 (14-Dec-2011)
Fixed Change API for r12
Added approval for the ChangeAPI
2.0.14 (22-Nov-2011)
Changed icon for approval settings
GL Encumbered date: added to distributions download
GL Encumbered date: added to forms
2.0.12 (22-Aug-2011)
Fixed bug in BPA upload. BPAs would continue to upload when cancel
was chosen from validation message
2.0.11 (17-Aug-2011)
Added Approval Status column to Blanket Purchase orders
2.0.09 (09-Aug-2011)
Fixed bug in Standard PO upload. If the Head ID cell had a space in it the header would not load.
frmSubmitRequest – now disabling Submit button after a request has been submitted.
Added Approval method control form.
2.0.08 (08-Aug-2011)
Removed conditional formatting from set_status for 2007+ speed reasons
Imported latest generic code v171
Imported latest Request Display code.
2.0.07 (21-Jul-2011)
Outside processing – changed linetype query to include outside processing
Removed BPA columns from Standard PO sections
Updated queries so StatusBar doesn’t display false
Added MTLCategorySetID to POWConfigInfo
Changed ItemQuery to run off inventory org. Have traced the form in r12 tremor and it uses inventory org – organizaitons;financial system options
Set PO_ACTION_ALLOWED = False, PO_ACTION_ALLOWED_Done = False in post_login_events because changing responsibility or logging out wasn’t resetting them.
Outside processing added to standard purchase orders
2.0.05 (02-Jun-2011)
Quotation, Price Break Level, UOM changed to required field. It Was uploading into oracle causing the Quote to be invalid/incomplete until a value is entered.
Change API fixed bug where release was using the PO revision rather than the release revision and always giving ‘Revision Number doesn’t match the current revision.’ errors.
Attachment Uploader errored when uploading an excel file. It uploaded successfully but the attachment form throws an error afterwards
Removed SECURITY_GROUP_ID from ValueSet sql – some r12 instances don’t have this column.
2.0.04 (01-Jun-2011)
Fixed bug where toolbar for standard purchase order was not being created properly – this meant the forms were not showing when clicked on by the toolbar. Attachments also were not showing.
Removed Attachments from blanket toolbar because it doesn’t work. Need to re-implement.
2.0.03 (17-May-2011)
Stopped forms from placing the cursor in the cell when closing from double_click.
Fixed mouse pointer to change from hour glass to arrow on click events and forms
2.0.02 (02-May-2011)
Added Multi-Line to functionality to some fields on forms.
Fixed bug where Standard PO parse return string was writing a value to the charge account column if it was blank.
2.0.01 (15-Mar-2011)
Added Download by sheet functionality
Fixed Change API download to stop duplicates.
2.0.00 (14-Mar-2011)
BPAs split from Standard POs
1.3.97 (21-Feb-2011)
Added purchaseable flag filter to item query.
Re-wrote refresh – Rejected lines would show as Accepted if the PO was created.
Fixed bug in download SQL and DFF for 11.5.9
1.3.96 (26-Jan-2011)
Fixed bug in PO Header form – the Global flag was not enabling when when changing PO Type from Standard to Blanket.
Updated Descriptive Flexfields to latest code.
Fixed bugs in Line Effective and Line Expiration dates. These Bugs were in the Form, Validation and Download.
1.2.95 (25-Nov-2010)
Added modifications for non-standard 11.5.8 and 11.5.9 installs.
1.2.94 (24-Nov-2010)
Added Columns ‘Supplier Note’(Header Section) and ‘Note to Supplier’(Line Section).
1.2.93 (17-Nov-2010)
Fixed bug for when a cell is in an Error State eg #NA – Trying to retrieve a value from a cell would cause an error.
Modified PO Number validation for creates – Stopped checking of Database for blank PO Number.
Fixed bug in header form – site was being overwritten by the first site in the list when the form was loading.
1.2.92 (11-Oct-2010)
Fixed bug where SGA fix was breaking wizards on 11.5.9 and below.
Fixed incorrect logic where Exchange Rate Type, Exchange Rate, Exchange Rate Date and were being ignored by the the blanket upload.
Header Amount Agreed was downloading the wrong column.
Fixed bug where no information was returned when searching for data with an apostrophe in it i.e. O’Donnell would be searched for as O”Donnell
11.5.9 – Added inserting of line level action code for blanket updates. UPDATE or ADD for updating existing lines and adding new lines respectively.
1.2.91 (03-Oct-2010)
Bug Fix in customization
1.2.90 (27-Oct-2010)
Upgraded generic modules.
Added protection.
Fixed 2007 size/speed bug caused by conditional formatting in set_status.
Changed header form to allow invalid PO Numbers to be written back to the sheet
Fixed bug in request parameters – The batchID was not being passed through. So, all batches
were being submitted by the one request.
Fixed bug where non-numeric price value could be uploaded causing the wizard to error and the sql insert statement to error.
1.2.89 (12-Oct-2010)
Changed Template Sheet and Sheet 1 to general format because text format was wreaking havoc upon formulas.
DistributionTotal Check changed to ignore non numeric values and blank lines.
Fix to endrow in rowdetails object. If the last PO on the sheet was also the last populated row on the sheet then endrow
would return 500+ rather than the actual endrow.
1.2.88 (07-Oct-2010)
Removed fnd_look_up from header download sql.
Removed defaulting of ‘Deliver To Location’ (distributions level) for 11.5.8.
Added PO Wizard Package check so the wizard can run against both the old package and the new
package with the SGA changes.
1.2.87 (06-Oct-2010)
Supports package change for reducing SGA overhead for insert statements.
Item query changed. Poor performing UOM join removed.
Fixed bug in Key Flexfield filter where where non required segments would cause no data to be returned if they were not populated.
1.1.86 (16-Sep-2010)
Modified Keyflexfields to be compatible with 11.5.9 and 11.5.8
1.1.85 (30-Aug-2010)
Fixed bug where dates were not written to cells during download
1.1.84 (26-Jul-2010)
Rewrote Refresh – blank lines 100 clause was causing refresh to stop before completion if a non uploaded PO with more than a 100 lines came before uploaded POs.
Added Sales Credit DFFS.
Fixed DFF validation bug – if no dff columns are on the sheet but there is a required attribute.
Changed PO Validation to accept PO Numbers when entry is set to automatic. First checking to see that the number does not already exist.
1.1.83 (14-Jul-2010)
Changed Documentation links to point to Purchase Order Wizard rather than Receivables Invoice Wizard in setup sheet.
Fixed the Kill button on the Download Controller form.
1.1.82 (12-Jul-2010)
Modified Price validation. Now allowing Amount Base Line Types to be 1 or empty.
1.1.81 (07-Jul-2010)
Fixed bug where Key flex fields were failing to initialise caused by a language problem.
1.1.80 (05-Jul-2010)
Changed validation of distributions Deliver_To_Location. Apostrophes in the Location Name would mean no values would be returned from the database. Changed it to use the proc that the other locations use
Added back in ‘Upload All Attachments’. Was unable to replicate previous upload issue.
Added new setup sheet.
Common modules upgraded to v128.
Fixed bug in the Line Quantity/Distributions Quantity check. DistributionTotal was truncating the decimal values.
1.1.79 (02-Jul-2010)
Removed ‘Upload All Attachments’ from toolbar. It needs to be fixed
1.1.78 (29-Jun-2010)
Added a download progress form.
1.1.77 (24-Jun-2010)
Added LOVs to download form. Added further error handling to try to pick up errors any download errors
1.1.76 (09-Jun-2010)
Download upgraded.
Fixed bug – Line Number was not being uploaded.
Price validation. Fixed bug where it was impossible to load a line with an AMOUNT based line type.
Fixed bug in refresh where a 500+ line purchase order would cause POs below not to be refreshed.
1.1.75 (03-Jun-2010)
Fixed bug in Lines form which set continue_level = 3. Which then stopped the item query from returning data.
1.1.74 (28-Jun-2010)
Fixed bug in interface distributions download sql
Fixed bug where Line would not be uploaded when PO was being re-uploaded. This would only occur when the Line was not on the same row as the shipments
Further fixes for big uploads
1.0.57 (09-Dec-2009)
Made changes to Purchase Order Number validation. Now looks at Purchasing Options and will let Alphanumerics through
Adjusted toolbar positions with excel 2003
1.0.56 (23-Nov-2009)
Put a prepare_string around the location_code in modmain.get_deliver_to_location to remove morrisons bug with apostrophy in string.
Fixed bug where you would get an application error if the currency columns were removed from the wizard
Added missing column ‘Line Effective Date’ to sheet1 and template.
1.0.55 (10-Nov-2009)
Organization override re-added – because it was mistakenly removed
Supplier override removed because it was not implemented – so it was misleading to have it available in the list
Requestor added to download
Added defaulting of distributions ‘Deliver to Location’ from the requestor
Automatically generating line numbers if they are not provided
Updated concurrent request viewer
1.0.54 (30-Oct-2009)
Item key flexfield modified. It was not bringing back values when used against some r12 instances
1.0.53 (29-Oct-2009)
Fixed bug where a distributions insert at the start of an accumulate block processblockdata call would not have the lineID and hence the block with fail with a ora-00936 error
1.0.52 (28-Oct-2009)
Added concurrent request viewer
Changed item validation to work off the org_id from po_system_parameters rather than filtering on SOB
Fixed bug where a distributions insert at the start of an accumulate block processblockdata call would not have the lineID and hence the block with fail with a ora-00936 error
1.0.51 (21-Oct-2009)
Added override tables for ‘Blanket Approval Status’ and ‘Standard PO Approval Status’
Removed override tables that did not do anything – brought across from Requisition Wizard but never implemented
Item kff added code to allow a one segment item kff to have a delimiter as part of the item text.
Added validation check for duplicate line numbers on upload.
Restricted Download Type LOV to Blanket and Standard only. It previously included all the PO Types ie Quotations, RFQs etc
1.0.50 (24-Sep-2009)
Fixed r12 multi org bug where responsibility orgid was being used rather than the selected orgid
1.0.49 (27-Aug-2009)
Added global agreement and price limit columns
1.0.48 (26-Aug-2009)
Item validation changed on line form. Validates on after update rather than needing to open the flexfield form. And, updates category, unit of measure and price accordingly
Fixed bug where price was not being updated at times on line form
Changed submit form to default to the buyer who is logged into the spreadsheet
1.0.47 (24-Aug-2009)
Removed defaulting of the Charge Account – now letting oracle default the values if they are not provided.
1.0.46 (14-Aug-2009)
Added Line_type to context defaulting. Changed Context Defaulting to stop it using substitutions
1.0.45 (22-Jul-2009)
Fixed bug where rate type and rate date were transposed in download
Added l.line order by clause to download
Fixed Exchange Rate Date bugs in Header form
Fixed upload validation for currency
Fixed download bug where alphanumeric PO Number cell value was set to 0
Fixed bug in attachment upload – the wizard was looking to see where line attachments section ended and hence would not upload if it was below other sections
Fixed bug where the header attachments broke the delete messages for the line deletes
1.0.44 (21-Jul-2009)
Added Currency Columns to template sheet
1.0.42 (13-Jul-2009)
Changes in package call for 11.5.9>
Change order by clause in download selection
1.0.41 (08-Jul-2009)
Added column Allow Price Override to lines section
1.0.40 (02-Jul-2009)
Range delete bug fixed. Where ‘Lines distributions’ message would pop a lot
Fixed ‘effective date from’ bug on header form. If there was no ‘effective date to’ then the ‘expected date from’ validation would error
Date handling improvements
Fixed bug where wizard would try to delete from the interface tables when IDs on the sheet were blank or not numeric
Changes to the Batches form. Disallowed submission of Blanket, Create Sourcing Rules and Incomplete. This was causing the Request to fail without returning any messages to the wizard
1.0.39 (05-Jun-2009)
Fixed tax code defaulting for r12
1.0.38 (21-May-2009)
Key Flex upgraded to handle 14 segments