{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Release Information","Product Fixes","Product Enhancements","Impacted Objects","Schema Changes","HotFix Regularization","Infrastructure Component Issues","Infrastructure Impacted objects"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":1,"defined_names":11,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Release Information","index":0,"n_rows":50,"n_cols":3,"rows_kept":50,"cut":false,"hidden":false,"merged":[[22,2,22,3],[23,2,23,3],[25,1,25,3],[11,2,11,3],[12,2,12,3],[18,1,18,3],[21,2,21,3],[16,2,16,3],[14,1,14,3],[15,2,15,3],[19,2,19,3],[20,2,20,3],[49,1,51,3],[38,2,38,3],[39,2,39,3],[42,1,42,3],[43,2,43,3],[48,1,48,3],[40,2,40,3],[44,2,44,3],[46,2,46,3],[26,1,26,3],[35,2,35,3],[32,1,32,3],[37,2,37,3],[34,1,34,3],[36,2,36,3],[31,1,31,3],[28,1,28,3],[29,1,29,3],[10,2,10,3],[4,1,4,3],[5,2,5,3],[6,2,6,3],[8,2,8,3],[9,2,9,3],[7,2,7,3]]}
[]
[]
[]
[]
[null,"Release Details"]
[null,"Solution Name","Ramco Aviation Solution "]
[null,"Release Initiated By ","Ramco Aviation Product Team"]
[null,"Shipment To","All 5.7 Customers"]
[null,"Solution Release","Release 5.7"]
[null,"Base Release Number","Rel5.7.1.10"]
[null,"Last Released BASE HRMS CU ","SP5.1 CU 22"]
[null,"Release Type","Regular Shipment"]
[null,"Update Effected on","WEB, APP and RM Layer"]
[]
[null,"System Requirements"]
[null,"Hardware","As per recommended COTS"]
[null,"Software","As per recommended COTS"]
[]
[null,"Shipment Details"]
[null,"Published FTP Details ","ftp://ftp.ramco.com/BAVN-57-Common/Regular/Rel5.7.1.10"]
[null,"Shipment Size","12 MB"]
[null,"No. of Packages",1]
[null,"Expected System Downtime*","01:00 Hrs"]
[null,"Release Date/Time","19-Sep-2014 19:30 Hrs"]
[]
[null,"Prerequisites"]
[null,"1) Successful Deployment of Rel5.7.1.9\n\n2) Release package Rel5.7.1.10 should be deployed only using the deployment tool (Release Version : D5.5.0.5 )\n\n\n\n\n"]
[]
[null,"Installation Instructions"]
[null,"(1) Download the Product Release version Rel5.7.1.10 (Rel5.7.1.10.zip) from the follwing FTP path\n\nftp://ftp.ramco.com/BAVN-57-Common/Regular/Rel5.7.1.10\n\n(2) Download the latest \"ICMS_release_hdr.sql\" from the above FTP under folder \"/BAVN-57-Common/Regular/\" , Place the  file in specified local path as specified in Ramco Deployer User Guide.\n\n(3) Deploy the Release Package Rel5.7.1.10 using the deployment tool(version - D5.5.0.5). Refer the Ramco Deployer User Guide.\n\n(4) Please refer Configuration & Settings Section for Manual Deployment or Post Installation Steps if applicable.\n"]
[]
[null,"Configuration & Settings "]
[null,"(1) SecurityPatches available path….\\Regular\\Rel5.7.1.10\\SecurityPatches.\nThese Security patches are applied and verfied with our Application.\n\n(2) DataSource_Updation.docx available path ….\\Regular\\Rel5.7.1.10\\ManualDeployment.\nRun the DWDataSourceTool and update the Data source in all the OFMS laptops. "]
[]
[null,"Other Details:"]
[null,"Distribution Information"]
[null,"Distributed To","All 5.7 Customers"]
[null,"Copy To","Sam Jacob, Shanthi Krishna,Narayana G J P V,Sangeetha K,Off-shore Project Leads,  On-site Support Personnel "]
[null,"Support Contact Person","Vinoth Kumar K"]
[null,"Support Contact Person Mail ID","vinothkumark@rsi.ramco.com"]
[null,"Support Contact Hours","09:00 Hrs to 19:30 Hrs"]
[]
[null,"Authoring Details"]
[null,"Prepared By ","Mohan S"]
[null,"Prepared Date/ Time","18-Sep-2014  11:00 Hrs"]
[null,"Reviewed By","QA Team"]
[null,"Reviewed Date/ Time","18-Sep-2014  17:30 Hrs"]
[]
[null,"*Notes:"]
[null,"1. All Time  should be read in Indian Standard Time (IST) in 24 hour format. \n2. Shipment  will be available in the published FTP site for 5 Days from the date of release. \n3. Please report installation errors, if any, log a ticket in rTrack.\n4. Expected system down-time mentioned is tentative and it may vary according to the system configuration."]

{"sheet":"Product Fixes","index":1,"n_rows":71,"n_cols":14,"rows_kept":71,"cut":false,"hidden":false,"merged":[]}
[]
["Key","Component/s","Summary","Sequence and error encountered","Confirmed Issue Occurence","Root Cause Category","Root Cause Remarks","Resulted In Data Corruption/ Resolution","Follow-up Issue Id","What was Fixed?","Shipment Comments","Behavior Change","Test and Verification Details","Hot Fix Release #"]
["ARAH-300","Supplier Debit Credit Note","Account Based Note Debit - Multiline","When working in account based debit note screen and you have entered data in the multi line and you click create and authorize it is now requiring you to select the lines within the multiline that you want to create and authorize. This is an additional stop not necessary and needs to be removed.",null,"New Requirement","Previously the system induced user to select the details in multiline while creating account based note","No - No",null,"Removed the validation to select multiline details on execution of create, create and authorize note. \n\nSystem will allow to create / create and authorize note if multiline details are not selected by user.",null,null,"bavnwebnmv03/extui server \n\nTest Sequence : \n\nCreated account based debit note SAD-000023-2014 without selecting multiline details. \n\nCreate and authorized account based note # SAD-000024-2014 without selecting multiline details.","R57-HF-47"]
["AAMG-1021","Inventory Workspace","Action link navigates to the wrong GR if 2 GRs were created","Quick link navigates using the PO# as the context instead of the GR#. So if two receipts were created against the same PO# it doesn't always load the correct GR. It defaults with the first one that was created.",null,"Regular Defect","Purchase Order # was passed to the 'Manage Goods Receipt' for data retrieval, instead of the Receipt #, thus all the receipts created against that PO gets loaded and the Receipt that has got the least of the Status as per hierarchy got defaulted","No - No",null,"The Receipt # is passed for retrieval of details, instead of the PO #",null,null,"Test Environment: R56 ST Environment \nTest Data: \nGI #: GI0006712013 \nTest Case: \n1) Launched the Inventory Operations WorkSpace \n2) Retrieved a Receipt in 'Pending Serial / Lot Entry' status and launched the 'Manage Goods Receipt' link \n3) It was found that the Receipt # got defaulted in the screen and it's details were retrieved.","R57-HF-46"]
["AHLI-901","Supplier Payment","After bulk authorization of pay batches, in view screen, pay exchange rate column in the multiline does not show any value","1. In the bulk authorize screen, selected a few documents in the multiline and clicked Authorize. \n2. In the view pay batch/voucher screen, pay exchange rate column in the multiline did not show any value for those bulk authorized vouchers.",null,"Regular Defect","Coding logic of View screen did not consider Pay Exchange Ratec column","No - No",null,"The column has been added in the coding logic to get saved and display in the view screen.",null,null,"Server: Base 5.6 ST server \n1. In the bulk authorize screen, fetched 3 documents and authorized them. \n2. In the view screen verified for all the 3 documents that the pay exchange rate was displayed correctly.","R57-HF-46"]
["ASFC-169","Flight Log","Again, Total flight Cyc value became 1","1. View Journey Log #JLG-000528-2014 in which total flight cyc became 1 \n\nThis issue has been reported earlier twice in ASFC-148 and ASFC-155",null,"Regular Defect","System is failing to calculate cumilative value due variable size problem.","Yes - Only Fix Provided",null,"Variable size has been increased. Now system is calculating correct cumulative value.",null,null,"1) In FLIGHT OPERATIONS-->FLIGHT LOG \n2) Created Journey Logs for an aircraft with Flight Date back dated as well as using current date. \n3) Further approved the Journey Logs. \n4) We can see that Flight Hours & Flight Cycles is getting updated correctly in the Journey Logs.","R57-HF-46"]
["AAPC-448","Reports - Book Keeping","Alighment issues in Exporting the Detailed TB to Excel.","Alignment Issues on Exported Excel. \n\nattached Exported Excel for ease of reference",null,"Regular Defect","Alignment issues","No - No",null,"Alignment is corrected",null,null,"Server: Base 5.6 ST \n1. Launched the Detailed Trial Balance and converted it into XLS data format and verified that the alignment was correct.","R57-HF-46"]
["AAPC-522","Reports - Receivables Management","Amount truncating in Receivables Management --> Print Invoice--> Debit/Credit Note","Amount truncating in Receivables Management --> Print Invoice--> Debit/Credit Note",null,"Regular Defect","Amount field not enough to hold the large values","No - No",null,"Amount field length is increased to hold large values",null,null,"Server: Aplus training server \n1. In the Print Invoice screen, launched the report of Customer Debit Credit Note and verified that the amount did not truncate.","R57-HF-46"]
["IUCH-2140","Supplier Direct Invoice","Attempt to post invoice to AME#VP-0000-19-14","See attached",null,"Regular Defect","Incorrect coding logic due to which the line amount was not updated correctly-amount in the first line was updated in all the other lines.","No - No",null,"Coding logic modified to update the line amount of the respective lines",null,null,"Server: CHI training server \n1. Created an expense invoice with 3 lines having different amounts and same AME reference document. Clicked on Create and Authorize. \n2. The invoice was created and authorized without any error."]
["ARAI-52","Stock Maintenance","Balance qty (Drill down) = Issue qty - returned qty . Inconsistency in records count between 5.4 and 5.7.","\"1. Mismatch of Records count in SMN_SMNINQDTL_DRILLDOWN_DTL table . \n2.Mismatch In SP Script between 5.4 and 5.7\" \n",null,"Regular Defect","Issue document and issue Ou has been updated as null.","Yes - Only Data Update Provided",null,"Data patch has been given to update the issue document ,Issue OU and issue line no in Return table.",null,null,"In RAH Simulation. \nExecute the patch and verified. \nbacklog count has been reduced.","R57-HF-47"]
["AASI-162","Bank Reconciliation","Bank Reconciliation Module show only first transaction of the each voucher","Bank Reconciliation Module show only first DR and CR transaction of the each voucher. \n\nSo, if one voucher has more than 2 transactions, the module cannot capture 2nd transaction onward.",null,"Regular Defect","Vouchers are grouped by narration which causes the issue","No - No",null,"Vouchers are grouped by voucher numbers",null,null,"Server: AAA training server \n1. Launched the Reconcile Transactions screen and verified that the Journal Vouchers display the sum of credit and debit amounts respectively for reconciliation.","R57-HF-46"]
["ARAH-355","Repair Order","Block 4 - AHBF-2145 Error received when updating Spares from No to Yes","Error received: Unable to process row # \"1\". Quantity in the repair order exceeds the available quantity",null,"Secondary Defect","The validation to ensure that there is sufficient Qty available in Stock was handled irrespective of RO status. However, it is expected to be handled only for ROs in 'Draft' or 'Fresh' status","No - No",null,"The validation to ensure that there is sufficient Qty available in Stock is handled with respect to RO status. This validation will be made only if the RO is in 'Draft' or 'Fresh' status.",null,null,"Test Environment: R56 ST Environment \nTest Data: \nRO #: REP-000478-2014;REP-000479-2014; \nTest Case: \n1) Created a Repair Order and took it till authorization (Component RO with Spares Shipped defined as 'No') \n2) In the Edit Repair Order screen, modified the Spares Shipped as 'Yes' and clicked Edit RO. It was found that the modified value was successfully saved. \n3) To verify the error message is thrown properly if RO is in 'Draft' or 'Fresh' status, took a RO in Draft status. \n3a) Issued the Part in the RO by an Direct/Unplanned Issue \n3b) Clicked the 'Edit RO' button changing the Spares to 'Yes' and found that there was an error thrown stating that enough quantity is not available in stock.","R57-HF-47"]
["ARAH-347","Goods Inward","Block 4 AHBF-78 - Record Additional Receipt Info still defaults collapsed from Inspection screen","Record Additional Receipt Info is still defaulted to collapsed from the inspection screen. The enhancement notes for this item indicates this should default to expanded view.",null,"Secondary Defect","The latest deliverables (i.e.) the objects that control the screen appearance were not shipped and so the 'Record Addition Info' section appeared collapsed.","No - No",null,"The latest deliverables (i.e.) the objects that control the screen appearance are identified for shipment, so that the section 'Record Addition Info' section appeared expanded in 'Inspect Parts' screen by default",null,null,"Test Environment: R56 ST Environment \nTest Data: \nGI #: GI0007262013 \nTest Case: \n1) Launched the 'Inspect Parts' screen from left pane, as a link from 'Inventory Operations WorkSpace' and as a link from 'Manage Goods Receipt' screen. \n2) Found that in all the three scenarios, the section 'Record Additional Receipt Info' was expanded, by default.","R57-HF-48"]
["AUCH-2917","Stock Maintenance","Break in transaction history when SN change occurs at repair receipt","COMP-023133 was recieved as a new SN because of a vendor modification on RO. Part#/Lot# transaction history does not display transactiont history prior to receipt.",null,"Secondary Defect","when include part/serial revision box is checked , the revised serial# nd old part/serial # is not fetched","Yes - Data Update & Fix Provided","AHBE-13007","when include part/serial revision box is checked , the revised serial# and old part/serial # is fetched",null,null,"Bavnwebnmv03/extui \nTest Data: Part - BOEING-787 APU \nSerial:SSN0008 \nGR-000400-2014 \nTest Scenario: \nStep 1: For a part/serial# modify the part# or serial# through a repair order-repair receipt. \nStep 2: In part/serial history, if the original part# and serial # is given and the check box , include revisions is checked, then both the old and revised part#/serial# should be fetched.. \n\nthe same way checked with Part Serial change transaction and it is fetching correctly in Part - Serial #/Lot # transaction history screen.","R57-HF-46"]
["AAPC-559","Release Payment","CLONE -Regularization- In Screen, the sundry Payment voucher should not display the bank Charges recorded as separate multiline","1. In Record Bank Charges, the Sundry Payment is getting created as requested status against the Payment voucher which are in Paid status. 2. In Screen, the sundry Payment voucher should not display the bank Charges recorded as separate multiline",null,"Regular Defect","Existing functionality is to fetch all Payment vouchers which are in requested or paid status, in the Record Bank Charges screen.","No - No",null,"Logic modified to display the Sundry Payment voucher # only in the multiline column of Payment Voucher against which it was created. \nA separate Sundry Payment voucher will not be fetched in the multiline.",null,null,"Server: Aplus training server \n1. In the Record Bank Charges screen, recorded bank charges against a paid prepayment voucher. \n2. Verified that the Sundry Payment voucher number was displayed only the multiline column of the Prepayment Voucher and not as a separate multiline. \n3. After refreshing the screen, on click of search, the Sundry Payment Voucher did not fetch as a separate multiline.","R57-HF-47"]
["AUCH-3033","Shop Work Order","Certifiate of Maintenance (C of C) requires updated Director name","Scott Jacob is our new Director of Quality, but the report still reflects the old Director Chris Hankland",null,"New Requirement","The director name was embedded in the report design itself and hence there was no option to provide the new director name.","No - No",null,"The director name is now saved as metadata and thus any change can be updated by providing the required value to the metadata.",null,null,"http://bavnwebnmv03/Extui \nThe updated director name is displayed in the report."]
["IUCH-2136","Asset Capitalization","Clone - Regularization Asset Class Transfer for CME","Fixed Assets Management - Asset Disposal - Record Asset Transfer \n",null,"Regular Defect","For usage based asset the asset class transfer logic was not handled previously.","No - No",null,"Logic handled for asset class transfer of usage based assets \n",null,null,"Server: CHI training server \n1. In the Record Asset Transfer screen, selected an asset number and transferred it to another asset class and CME depreciation category. \n2. Clicked on confirm transfer and transfer was confirmed. \n3. Verified the accounting information."]
["AAPC-541","Customer Balance Adjustment","Conisistency query to check the adjustment amount is lesser than tran amount","Adjusted amount updated greater than tran amount",null,"Regular Defect","In the customer balance adjustment the adjusted amount not updated correctly due to the incorrect duplicate postings in bulk authorization","No - No",null,"Query added to find the adjustment amount is lesser than zero or is greater than the transaction amount",null,null,"Front end verification not required","R57-HF-47"]
["AAPC-566","Customer Balance Adjustment, Reports - Fixed Assets Management","Consistency query modification to retain the correct values and implement the correct logic","New Consistency query modification",null,"Regular Defect","Consistency query not handle as per the current logic so it shows the incorrect values as inconsistent data","No - No",null,"Implementing new logic in the consistency query to fetch the correct inconsistent data",null,null,"Front end verification not required","R57-HF-47"]
["ARAI-183","Maintenance Task","Description copying icons are not aligned properly in View Task Information page","Description copying icons are not aligned properly in View Task Information page",null,"Regular Defect","Improper alignment of controls and fillers","No - No",null,"Aligned the controls using fillers in View Task Information UI",null,null,"Envi: http://BAVNWEBNMV03/extui \n\nData: Task #: DSC \n\nTest case: \nA) Launch View Task Information UI \nB) Verify the description copying icon alignment near controls \"Task Description\", Long Description\", \"System Description\", and \"DSC Description\". \n\nResult: \nDisplay copying icon is aligned near data visible length of the controls \"Task Description\", Long Description\", \"System Description\", and \"DSC Description\"."]
["APAC-52","Reports - Fixed Assets Management","During generation of Asset Details Report","All Finance account",null,"Regular Defect","As per the cloud environments concern reports like exporting the excel directly was not working correctly","No - No",null,"Cloud environments concern rectified to enable launch of excel reports properly.",null,null,"Server: Base 5.6 ST server \n1. Launched Asset Details Report, Trial Balance-excel format and Transit Accounts in excel format and verified that the reports were launching properly without any error.","R57-HF-47"]
["APAC-44","Goods Inward, Unified Goods Receipt","Eating to much space in GR","Accounts of Purchasing & Logistics",null,"Regular Defect","Too much space occupied in the report due to pre design issue","No - No",null,"screen dimension are fixed",null,null,"Step 1: Create a Goods receipt against a Purchase order having 4 - 5 parts. \nStep 2: Generate a Goods Receipt Note . \nStep 3: Check if the footer details are printed on the same page. \n\nResult: Footer details are printed on the same page. \n\nEnvironment: bavnwebnmv03 \nData: GR # GI0007472013 \n","R57-HF-47"]
["ARAH-374","Aircraft Maintenance Execution, Component Replacement","Error message on Confirm CR","Error message recieved on creating a component removal: \"Unable to process. Please enter Attachment Date earlier then or equal to the system date.\" Shouldn't the validation be for the removal/replacement time rather than attachment? This was a removal only CR.",null,"Regular Defect","Error message on Confirm CR","No - No",null,"Logic handled not to validate when removal is done .",null,null,"Tested for the three cases given below \n1) Tried to remove a component with removal date & time in future \n2) Tried to attach a component with attachment date & time in future \n3) Tried to replace a component with another component with removal date & time in future \n\nIn all these cases it is verified that system is throwing valid error message based on the source"]
["ARAH-235","Flight Log, Time Tracking","Error message received when Clocking-off in the Record Employee Timesheet screen","After starting clock successfully for 5 tasks, an error message was received when using the end clock button. \"Conversion failed when converting date and/or time from character string.\"",null,"Regular Defect","DATETIME data type variable value is assigning to another variable of data type udd_date. Again trying to convert udd_date data type variable value to DATETIME data type. And hence conversion mismatch error is throwing. Further when user is selecting m","No - No",null,"Logic is handled (Cast of DATE) is added to the todate column, and totime (Cast of TIME) column is added newly in the insert to avoid conversion problem. Logic is handled to calculate row number value correctly, so that booking id column value is updating properly.",null,null,"1) In FLIGHT OPERATIONS -->FLIGHT LOG-->RECORD EMPLOYEE TIMESHEET \n2) Started clock for three tasks simultaneously and ended clock also simultaneously \n3) System showed success message that it was processed successfully \n4) It did not threw any error mentioned in the Issue \nTest Data: \nPackage# , Task# \nLC-001655-2014 , RTWO-DAY \nLC-005622-2014 , SERVICE CHECK \nLC-016896-2014 , CJQ400-32-42-400-0004 \n\nServer: http://ramcowebt11/Extui/extui/demo/launchpanel.htm \n\n\n"]
["AHLC-677","Configuration","Error message says to enter a part # which is in 'Active' status. When checking the p/n details the part is showing that it is in active status","i wanted to 'Build Model Config' and got this error message. \nI am wanting to change the configuration of the T/R Items. This error message affects items that are not related to the T/R Items.",null,"Regular Defect","In the model configuration when we build the model configuration by newly it will check for thew part is in active or inactive status. whereas when we enter in to the page and modify one line tat line alone will be checked for validation","Yes - Only Data Update Provided",null,"The validation has been handled properly to throw at all the sequence not to check a particular modification line alone.",null,null,"Tested the data in the simulation server. \n\nwhen enter in to the model configuration page, provide new part and position code in the new line and build tat line alone the validation is checking. \nafter the fix has been deployed validation has been checked for the over all model configuration data.","R57-HF-46"]
["ARAI-355","Repair Order","Error thrown on release for shipping against repair order in 5.7","Application throws error on release for shipping against a repair order in 5.7 Attached is the file.",null,"Regular Defect","instead of using exchange type , incorrect variable used while updating exchange fee in RO.","No - No",null,"Exchange type , used as variable while updating exchange fee in RO.",null,null,"1.Tried to create RO under Auth status with quote generation basis as \"Automatic\". \nOn hit on release for shipping RO got moved to Auth status \n\nREP-000452-2014"]
["APAC-49","Repair Order","Generating the RO","all user ID - with modules of RO",null,"Secondary Defect","The length assigned to the Terms and Conditions field was not high enough to accomodate the entire value","No - No",null,"The length assigned to the Terms and Conditions field is increased to accomodate the entire value",null,null,"Test Environment: R56 UT Environment \nTest Data: \nRO #: REP-000430-2014 \nTest Case: \n1) Launched the Repair Order report for the mentioned Repair Order \n2) Verified the Terms and Conditions field and found that it was well accomodated.","R57-HF-48"]
["AAMG-990","Goods Inward","Get Storage Info retrieves incorrect zone/bin","when recieving Part#100-384118-26 get storage info retrieved zone/bin FE/1B, however the placement strategy is Existing stock addition, and stock exists only in F/47B",null,"Regular Defect","System failed to pick the existing stock addition zone & bin details.","Yes - Only Fix Provided",null,"We have fixed to pick the existing stock addition zone & bin details based on placement strategy in the storage admin table.",null,null,"Environment details: http://180.179.170.253/Extui \n\nTest Scenario: \n\nIn the Manage Goods Receipt screen, while clicking the Get storage info. button system now fetched correct zone/bin as F/47B for existing stock addition placement strategy. \n\nAlso checked for other placement strategies: \n\n1) Storage Proximity - Picked zone/bin as F/1A based on placement priority correctly. \n2) Fixed storage - Picked zone/bin as FE/1B based on default placement zone & bin set in storage admin screen. \n3) Next empty storage - Picked zone/bin as F/47B. \n4) Manual - Picked zone/bin as FE/1B based on default placement zone & bin set in storage admin screen. \n\nTest Data: \n\nPart # 100-384118-26 \nWH - ICTS \n\n","R57-HF-46"]
["AMCI-316","Stock Issue","Getting a String or Binary error while clicking on a link \"Confirm Issue\"","Getting a String or Binary error while clicking on a link \"Confirm Issue\"",null,"Regular Defect","Clicking on \"Confirm Issue\" getting a String or Binary error .","No - No",null,"Category length has been increased.",null,null,"Environment details: \nhttp://avnwarsgi5/extui \n\nTest and Verification details: \n\n1) In Stock management>>Stock issue>>Edit issue screen search by Issue # MI-025553-14. \n\n2) Below click the link Confirm Issue. \n\n3) Now System lauches the Confirm Issue screen."]
["IUCH-2098","Goods Inward","Goods Inward allowed to move the quantity for existing part/serial # in SMN","Goods Inward allowed to move the quantity for existing part/serial # in SMN",null,"Secondary Defect","There was no validation in Move Parts task of Goods Inward to ensure that the Part # - Serial # combination moved to stock is already available in Stock","No - No",null,"A new validation is added in Move Parts task of Goods Inward to ensure that the Part # - Serial # combination moved to stock is already available in Stock",null,null,"Test Environment: R56 ST Environment \nTest Data: \nGI #: GI0007392013 \nTest Case: \n1) Created a PO for a Serial Controlled Part and authorized it. \n2) Created GI for Part # - Serial # combination P1-S1 and confirmed the INspection for it. \n3) Created an Unplanned Receipt for 'P1-S1' and confirmed it. \n4) Now, on click of Move Parts, an error stating that the Part # - Serial # combination is already available in stock was thrown."]
["AHLC-672","Aircraft Maintenance Program","In Edit Component Effectivity Screen and View Component Scren, the Tasks Description is not shown in full.","Description not shown in full",null,"Regular Defect","Task Description length has to be increased . model level changes has to do","No - No",null,"Task Description length has to be increased in Edit task effectivity screen and view task effectivity screen in model level .",null,null,"Data: Task#: 01-REP-X00-00-043169 \n\nTest Cases 1: \nA) Create a task having description defined \nB) Click in Edit Component Effectivity \nC) Verify the Task Description control in Edit Component Effectivity \n\nTest Cases 2: \nA) Launch Edit task UI \nB) Click in Edit Component Effectivity \nC) Verify the Task Description control in Edit Component Effectivity \n\nTest Cases 3: \nA) Launch Manage Activated Task UI \nB) Click in Edit Component Effectivity \nC) Verify the Task Description control in Edit Component Effectivity \n\nTest Case 4: \nA) Launch View task UI \nB) Click in View Component Effectivity \nC) Verify the Task Description control in View Component Effectivity \n\n\nResult: \nVisible length of Task Description control in Edit/View Component Effectivity has increased."]
["AAPC-545","Reports - Book Keeping","In Report on tax Transactions - Voucher Type Prepayment is not reflected in the report","APPPV-000058-2014 \nAPPPV-000065-2014 \nAPPPV-000039-2014 \nAPPPV-000045-2014 \nAPPPV-000104-2014 \nAPPPV-000117-2014 \n\nThe above prepayment Doc are not reflected in the Report on tax Transaction report",null,"Regular Defect","Coding logic not handled to retrieve Supplier Prepayment Voucher documents in Report on tax transactions","No - No",null,"Coding logic handled to retrieve Supplier Prepayment Voucher documents in Report on tax transactions",null,null,"Server : 5.6 System Testing Server \nIn the Report on Tax transaction screen when View action is performed the report generated reflects the tax effects on prepayment voucher.","R57-HF-48"]
["AAPC-542","Customer Receipt","In View Receipt for Adjusted Status - Un-applied amount shows some value - This should be Zero","In View Receipt for Adjusted Status - Un-applied amount shows some value - This should be Zero \nReceipt # - TT-OR2258",null,"Regular Defect","Coding logic incorrectly handled for calculation of the adjusted amount, due to which the unadjusted amount was incorrectly displayed","No - No",null,"Coding logic modified to compute the adjusted amount correctly and thereby the unadjusted amount.",null,null,"Server: Aplus training server \n1. Created a receipt with foreign currency debit document. \n2. Created Customer multiline adjustment to adjust the credit and debit document. \n3. In the view receipt screen, retrieved the receipt and verified that the unadjusted amount was displayed correctly.","R57-HF-47"]
["AMAC-358","Component Maintenance Program","In part program, column \"Estimation Duration\" and \"Time Unit\" is not inherit from Task Master.","In part program, column \"Estimation Duration\" and \"Time Unit\" is not inherit from Task Master. \nSample Part: 001-LG-01-0040",null,"Regular Defect","In part program, column \"Estimation Duration\" and \"Time Unit\" is not inherit from Task Master.","No - No",null,"Now the logic has been handled to inherit \"Estimation Duration\" and \"Time Unit\" from Task master.",null,null,"1) In MAINTENANCE PROGRAM-->MAINTENANCE TASK \n2) Created a Task of Applicability Component \n3) Further in Maintain Part Program,added the Task and gave Update Program \n4) It was verified that in Part program,task is inheriting Estimated Duration and Time Unit from Task Master"]
["AMAC-261","Aircraft Maintenance Planning","In planning board screen, package details multiline contains \"Export to MSP\" option and it is not working.","In planning board screen, package details multiline contains \"Export to MSP\" option and it is not working.",null,"Secondary Defect","In planning board screen, package details multiline contains \"Export to MSP\" option and it is not working.","No - No",null,"Amplanmntacplan_amplanmntacplanent_user.Js file has been modified",null,null,"1) In Maintenance Planning-->Aircraft Maintenance Planning-->Plan Aircraft Maintenance \n2) Searched with Aircraft Reg# \n3) Further in Package Details chart,selected a Package and gave export to msp,where we can see Package Detals getting fetched in the Microsoft Project Document"]
["AUCH-2989","Asset Depreciation Processing","July 2014 Depr. Processing","Fixed Asset Management - Depreciation Processing - Confirm Usage & View Depreciation -Compute",null,"Regular Defect","For One-time task if NSV is null than table will store value as 0.00. due to which the join between usage table and depreciation table has failed. Due to this failure the system does not fetches the usage details.","No - No",null,"The logic is handled such a way that instead of storing the value as Zero, system will save the value as Null. So on search system will fetch the usage details.",null,null,"Environment : 172.16.0.98\\simdb \nComponent : COMP-007000 \nSystem fetch the usage value correctly. \n"]
["AHLC-686","Loan Order","Loan order reports don't have critical information on them","When creating a loan order all the details are put in as per the insttructions given by the Ramco team however when generating the loan order report the most important piece of information which is the part number and description is missing. This is a completly embarrassing failure from the Ramco system. How does anybody submit a loan order when the part you are a loaning doesn't even come up on the report. I had to physically write the part number on the loan order that was sent to the supplier and they were very disapointed in what was sent and found it quite humerous that our new system couldn't even generate the most important piece of information to be on the loan order.",null,"Regular Defect","Loan order reports don't have critical information on them","No - No",null,"sub report information's are not defined for dw reports previously which is now defined therefore enabling the display of the required details in the Loan Order report.",null,null,"Step 1: fetch the loan order in the multiline by click of search in the View Loan Order screen . \n\nStep 2: select a loan order document from the multiline and click on the Generate Loan Order report link \n\nStep 3; Check for the Display of required fields in the generated Loan order report. \n\nResult: The part details and other necessary information are displayed properly in the Loan Order report. \n\nEnvironment: /bavnwebnmv03 \nData: Loan Order # : LO-000092-2014","R57-HF-47"]
["ARAH-389","Goods Inward","Manage Goods Receipt multiline goes blank after Reverse Receipt","When a receipt is confirmed and the Reverse Receipt is clicked the multi-line details go blank and users must re-lauch the GR in order to get them back.",null,"Secondary Defect","Logic not handled to refresh the Serial/Lot Details tab in the Manage Goods Receipt screen whenever 'Reverse Receipt' is done, with the focus available in Serial/Lot Details tab.","No - No",null,"Logic handled to refresh the Serial/Lot Details tab in the Manage Goods Receipt screen whenever 'Reverse Receipt' is done, with the focus available in Serial/Lot Details tab.",null,null,"Test Environment: R56 ST Environment \nTest Data: \nGI #: \nTest Case: \n1) Created a PO based Receipt with Serial controlled Parts and confirmed the Receipt after recording Serial/Lot details. \n2) Reversed the Receipt with the focus available in 'Serial/Lot Details' tab \n3) It is expected that the data available in the Serial/Lot Details tab should be refreshed,after reversal. It was found to happen so.","R57-HF-46"]
["ARAI-274","Aircraft","Manage Part Restrictions does not fetch any lines on search","Manage Part Restrictions does not fetch any lines on search",null,"Regular Defect","incorrect code - null handling not done properly","No - No",null,"null handling done properly while fetching records in search task for serial and lot controls. Now, if we do blank search records will get fetched",null,null,"RAH ST server - After applying the fix and 5.4 migrated records are getting fetched in multiline"]
["AHBF-3814","Work Monitoring and Control","Manual Time Booking Allowed for Employee without Work Center Access","Manual Time Booking Allowed for Employee without Work Center Access",null,"Regular Defect","Employee stored in the multiline needs to be checked for workcenter access.","No - No",null,"System will check for the employee stored in the multiline for workcenter access.",null,null,"Test Case: \nEnsure Employee has Work center access otherwise throw an error. \nTest Actuals: \nPackage#VP-001022-2014","R57-HF-46"]
["ARAH-378","Maintenance Task","Manufacturer # required on task revision","Launched screen, entered 1 in New Revision # field. Entered Revision Date and clicked Edit Task. Error \"Manufacturer # \" \" does not exists.\" \nThis validation should not be thrown.",null,"Regular Defect","since the Manufacturer # is coming as a empty string ,system throwing error as Manufacturer # required on task revision.","No - No",null,"Manufacturer # is coming as empty string.Logic has been changed to assign it as null.",null,null,"1) In MAINTENANCE PROGRAM-->MAINTENANCE TASK-->MAINTATIN ACTIVATED TASK \n2) Gave new revision no,new revision date and gave Edit Task . \n3) System successfully created new revision for that task unlike the error mentioned in the Issue."]
["AEGF-265","Goods Inward","Not able to move parts against GR","Created & confirmed GR-001200-2014, not able to move it. System is throwing error message. \n\n\"Quantity specified is not available in the specified storage location for Stock Conversion # SSC-000016-2014 \"",null,"Regular Defect","While doing GR system failed to update the source flag in SMN table.","No - No",null,"Now we have fixed to update the source flag correctly.",null,null,"Environment details: URL : http://avnwarnmv11/Extui \n\nTest Scenario: \n\nFor the reported GR 'GR-001200-2014' tried to move, parts moved successfully & SSC done correctly. \n\nChecked in inquire stock availability - stock & source document document updated correctly. \n\nTest Data: \n\nGR-001200-2014","R57-HF-48"]
["AUCH-2653","Aircraft Maintenance Execution","OFMS- Due For Maintenance Error Received When Confirming CR","When attempting to confirm a Component Replacement, multiple aircraft are receiving the error \" Unable to Process. Issue cannot be confirmed as either the part # ______ Serial# _________ or any of its child is due for maintenance. \n\nWhen reviewing the records in the CHI-Production server, all records are good and nothing is due for maintenance. This error has been occurring across multiple aircraft within the OFMS for past two weeks. \n\nSee attached screen shots from N6682D and P2-CHE",null,"Secondary Defect","Inventory forecast getting failed due to task duplication in program.Root cause is whenever part change is happened thru SWO ,Program information are deleted from CMP tables and reinserted with same revision using the new part program","No - No",null,"Program deletion and reinsertion logic in SWO Part serial change procedure have been commented out.",null,null,"CHI UAT Server \n\nThe program deletion does not happen and hence the record is not duplicated. The user is able to confirm the CR without gettign the error.","R57-HF-46"]
["AUCH-3124","Configurator","OFMS_SMN_Imp_SP::Violation of PRIMARY KEY constraint 'SMN_SMN_SRL_LOT_SCH_HDR_rep_pk'. Cannot insert duplicate key in object 'dbo.SMN_SMN_SRL_LOT_SCH_HDR'. The duplicate key value is (0767d7c6-6f3b-e411-94cb-f4b7e2e62ec1).","OFMS_SMN_Imp_SP::Violation of PRIMARY KEY constraint 'SMN_SMN_SRL_LOT_SCH_HDR_rep_pk'. Cannot insert duplicate key in object 'dbo.SMN_SMN_SRL_LOT_SCH_HDR'. The duplicate key value is (0767d7c6-6f3b-e411-94cb-f4b7e2e62ec1).",null,"Regular Defect","Insertion of record more than one time during same load.","No - No",null,"Deletion of duplicate record which is trying to insert for the second time during load process",null,null,"In CHI simulation envi, \nthe script has been executed. and the duplicated records got deleted.before loading. \n"]
["AAPC-531","Reports - Book Keeping","On Opening of the report - WHT Report for tax Type - Philippines WHT - :String or Binary Error","On Opening of the report - WHT Report for tax Type - Philippines WHT - :String or Binary Error - August Month",null,"Regular Defect","Column length mismatch","No - No",null,"Modified the table column length.",null,null,"Able to open the report and no error displayed","R57-HF-47"]
["AAPC-532","Reports - Book Keeping","On Report on Tax Transactions - Issues mentioned in the Desc.","Selected Criteria - Attached Screenshots \n\n1. Account Code is not appearing fully \n2. Supplier Invoice # - is Blank \n3. Posting Doc # is appearing in PDF Format but not in Excel Format \n4. Amounts in PDF and Excel, Comma Separator is not Displaying even after Updating the Set preference \n5. EXP-000862-2014 - This document # is fetching in the PDF Output, but the same is not getting fetched in the excel output ( Request to run the query) \n\nAttached Screen Shot",null,"Regular Defect","Incorrect coding logic due to which supplier invoice # could not be fetched","No - No",null,"Coding logic modified to fetch supplier invoice # correctly.",null,null,"Server: Aplus training server \nLaunched the report on tax transaction and verified that the supplier invoice # mentioned in the defect was retrieved correctly."]
["ARAI-248","Goods Inward","On click of move parts, getting sql error \"Cannot insert null values\"","On click of move parts, getting sql error \"Cannot insert the value NULL into column 'GIMVTMP_HAZMAT_FLAG', table 'AVNAPPDB_TEMPDB.dbo.GI_GIMVTMP_PART_MOVINFO_TMP'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'GIMVTMP_HAZMAT_FLAG', table 'AVNAPPDB_TEMPDB.dbo.GI_GIMVTMP_PART_MOVINFO_SIML_TMP'; column does not allow nulls. INSERT fails. The statement has been terminated. The statement has been terminated.",null,"Regular Defect","On click of move parts, getting sql error \"Cannot insert null values\"","No - No",null,"validation was not handled previously when a receipt document is not eligible for movement, was modified manually and move parts was initiated",null,null,"Step 1: select a Goods receipt document which is not eligible for movement . \n\nStep 2: Click the Movement details tab and provide the qty in the multiline ignoring the validation thrown by the system. \n\nStep 3: Click on the move parts button . \n\nResult: The system validates correctly and throws an error \" Unable to process. There are no parts in Receipt # \"GI0007482013\" eligible for movement.\" \n\nEnvironment: /bavnwebnmv03 \nData: GI # : GI0007482013","R57-HF-47"]
["AAPC-520","Customer Service Invoice","Performance issue in aplus","cso_ordval_pendinfo_fetch_sp \ncso_ordval_tskinfo_fetch_sp",null,"Regular Defect","ras_getdate function is called more than once in a update logic in sp","No - No",null,"ras_getdate function is used find the exchange date which needs to be computed for exchange rate. Logic is changed to update the exchange date before computing the exchange rate.",null,null,"Test Environment: http://54.255.191.117/APLUS/extui/demo/launchpanel.htm \nTest Actuals: CO-000016-2014; 5J-000016-2014 \nTest Cases: \n1. Executed the query for cso_ordval_pendinfo_fetch_sp and cso_ordval_tskinfo_fetch_sp and found that the performance issue is solved. \n2. The query got completed within 2 minutes. \nThis issue is now handled and working fine."]
["AIBW-64","Shop Work Order","Plan work order is loading inactive Shop Work Order Types","Plan work order is loading inactive Shop Work Order Types. \n\nOnly active should be loaded.",null,"Regular Defect","Ou instance join not handled","No - No",null,"Since Ou is not handled system loaded inactive workorder type.Ou Join handled to load only active workorder types.",null,null,"Environment details: \nhttp://avntrg1.ramco.com/Extui \n\nTest and Verification details: \n\n1) In Maintenance setup>>Common master>>Define Process Entities screen selected Entity type-Shop Work order type. \n\n2) In the multiline select Entity -EWO and FWO. And Change status to Inactive. \n\n3) Component Maintenance>>Plan Work order screen, SWO# drop down system doesnt show Inactive entities of EWO and FWO. \n"]
["AUCH-3119","Configurator","Primary Key Violation on data packet load","Data packet from field base 92 has failed to load in main base due to the following error. \n\nOFMS_SMN_Imp_SP::Violation of PRIMARY KEY constraint 'smn_pscc_prtsrlnc_condchng_log_pk'. Cannot insert duplicate key in object 'dbo.smn_pscc_prtsrlnc_condchng_log'. The duplicate key value is (2, MR, PCDC-000517-14, A02R2505-1, A11930). \n",null,"Regular Defect","Insertion of record more than one time during same load.","No - No",null,"Deletion of duplicate record which is trying to insert for the second time during load process.",null,null,"In CHI simulation envi, \nthe script has been executed. and the duplicated records got deleted.before loading."]
["AUCH-3072","Shop Work Order","Ramco will not allow status of SWO# 147018 and SWO# 147017 to be changed to complete","Ramco will not allow status of SWO# 147018 and SWO# 147017 to be changed from In-Progress to Complete.",null,"Secondary Defect","Due to Enhancement AHBE-14355","No - No",null,"Error message description handled to show the error to user.",null,null,"Test Environment:- \nCHI SIMDB \nTest Data & Procedure:- \nSWO# - 147018 and 147017 \nTried to close the Work orders from WMC screen and verified that system displays a valid error."]
["AHBD-8460","Stock Receipt","Regularization for AHBB-2183 :Cost not updated properly in the auto stock transfer receipt transaction.Identified in RAH DHMG consistency","Create a Stock Transfer - updation mode - Auto, type - Specific , lot controlled part, Weighted average part. \nfor example : \nin the stock \nwarehouse W1 - Z1 - B1 - Part P1 - Lot L1 - Qty 2\nwarehouse W1 - Z2 - B2 - Part P1 - Lot L2 - Qty 1\ncreate stock transfer and authorize.\nIf tried this type of data cost not updated properly in the auto stock transfer receipt. \nIn the stock transfer receipt table transaction cost and receipt cost updated incorrectly.\n",null,"Regular Defect","Cost calculated and updation logic as been failed in stock receipt.","No - No",null,"When stock transfer is created for the parts and moved in the manner that is given in the issue , then the cost gets updated properly in the receipt table.",null,null,"Took a lot controlled , weighted average part . \nhad them in the stock in the following way \nW1-Z1-B1- LOT1 -2 \nW1-Z2-B2-LOT2 -1 \n\nCreated a stock transfer with auto mode , and authorized it . \nNow, checked the transaction cost and receipt cost in the tables, cost got updated properly . \nEnvironment: bavnwebnmv03 \nData: \nST-000552-2014;STI-000497-2014"]
["IUCH-2130","Shop Work Order","Regularization for AUCH-3076-Modified Serial # is not getting displayed in part tag report","SWO # 132569, modified Serial # CH-5713 is not getting displayed in part tag report and instead original serial # DUMMY-1 is displayed.",null,"Regular Defect","When a serial# is modified then the modified serial# should be fetched in the serial# field instead it was showing old serial#. In the reported case it should have been CH-5713 instead of dummy-1","No - No",null,"Logic modified to fetch the modified serial# instead of old serial#.In the reported case it should have been CH-5713 instead of dummy-1",null,null,"Test Environment:- \nCHI SIMDB \nTest Data & Procedure:- \nSWO# - 132569 \nGenerated Part Tag and verified that modified serial# is getting printed in the report."]
["AHBF-735","Repair Order","Regularization from 5.4 to 5.6 for Defect id: AHBE-13362 and AHBE-11434-> SQL error \"Cannot insert the value NULL into column 'BAL_PART_STATUS', table \" on confirm GR : Exchange","A) Create an RR based on RO. \nB) Perform Part # / Part # - Serial # / Serial # Exchange. \nC) Confirm Receipt \n\n\nSQL error \"Cannot insert the value NULL into column 'BAL_PART_STATUS', table 'AVNAPPDB_New.dbo.SMN_BAL_WHZNBN_LOT_SRL_LVL_BAL'; column does not allow nulls. UPDATE fails. Cannot insert the value NULL into column 'cmpid_pref_status', table 'AVNAPPDB_New.dbo.AC_CMPID_COMPONENT_ID_INFO'; column does not allow nulls. UPDATE fails. The statement has been terminated. The statement has been terminated.\"",null,"Regular Defect","while deriving component ou , partno taken from header which is incorrect.","No - No",null,"while deriving component ou , partno taken from header which is incorrect. Its fixed",null,null,"Test Case \nA) Create an RR based on RO. \nB) Perform Part # / Part # - Serial # / Serial # Exchange. \nC) Confirm Receipt \n\nSystem saved data successfully."]
["IUCH-2018","Customer Order Management","Removed from A/C Reg Info - Error message correction required while manual CO creation","1. Part # 725725-5 & Serial # N123A removed from A/C # AC001 belongs to VP-000022-14 of aircraft Contract # MAF-Test-01 \n2. When tried to create a CO against the removed part # / serial # for part contract # MAF-PART-01 while on evaluate contract system displayed with the below error message \"Contract is not matching the defined attributes.\" \n3. As per contract # MAF-PART-01 removal of a/c reg # is required so after when A/C reg # is provided system didn't displayed the error message and the evaluate contract scenario gone through. \n4. Appropriate error message need to be handled in order to guide the user.",null,"Regular Defect","While evaluating a contract, error with respect to 'removal from AC info' was not explicitly thrown","No - No",null,"While matching attributes for evaluating contract, 'removal from AC info' should be indicated as a separate error message.",null,null,"Test Environment: \nCHI simulation \nTest Actuals: \nCO-000811-14 \nTest Cases: \nA co was created against the contract MilitaryGen for which removal from AC info is set as required. \nWhile evaluating the CO for COntract withour specifying the rem from AC# error is thrown.","R57-HF-46"]
["AIBW-77","Engineering Order","Search is bringing duplicate records","a) Launch Set authorization rule, select interface. \nb) Search \nSystem is retrieving duplicate records",null,"Regular Defect","Since Ou instance join not handled.,Search was bringing duplicate records .","No - No",null,"Ou instance join handled in where conditons so that the system doesnt fetch the duplicate records.",null,null,"Environment details: \nhttp://avntrg1.ramco.com \n\nTest and Verification details: \n\n1) In Engineering Change Management>>Engineering Document >>Set Authorization rules screen select Eng doc.type- EO and Search,shows Source Doc Type AD,SB. \n\n2) Now system doesnt show duplicate records in the multiline."]
["AMCI-133","Aircraft Maintenance Forecast","String or binary data would be truncated. error for this column MF_FSL_FORECAST_SCHEDULER_LOG","String or binary data would be truncated. error for this column MF_FSL_FORECAST_SCHEDULER_LOG \ncolumn :FSL_REMARKS-length-2000 in 5.4 length 100-5.7",null,"Regular Defect","The length of the column remarks was restricted to 100 characters.Since this error was thrown.","No - No",null,"The length for the column remarks has been increased to 2000 characters .",null,null,"Tested in Data Migration Mock upload in avnwarsgi5"]
["AEGF-257","Shop Work Order","Task sequence is wrong. If we have more than 1 subject in plan, now sytem is printing first operation of all subjects are sequenced first and then second operation of all subjects and then third and so on....","Selected all the tasks in Work Scope & printed the task instruction report. \n\nTask sequence is wrong. If we have more than 1 subject in plan, now system is printing first operation of all subjects are sequenced first and then second operation of all subjects and then third and so on……. \n\nAll operation in the sequence given by AG should be printed first for subject-1 and and All operation in the sequence given by AG should be printed for second subject and then third subject…… See my markings and comment on first page of the attached file. \n",null,"Secondary Defect","The Task were sequence based on Sequence number.","No - No","AHBF-4005","The operational tasks are sequenced within the subject task after sequencing the subject tasks.",null,"The operational tasks are sequenced within the subject task after sequencing the subject tasks. \n\nKindly refer the attached generated report.","http://ramcovm436/extui \n\nKindly refer the attached generated report."]
["AABI-65","Stock Issue","Unable to confirm Exchange MR based Direct Issue","Create CO - Adv Exch \nEXO created automatically for Any part \nEx MR created \nUnplanned Issue created for a serial # \nGo to Edit Unplaned Issue and change serial # \nOn Confirm Unplaned Issue error displayed \nUnable to process the document # : \"UPI000015\". Specified part cannot be allocated. Sufficient quantity not available.(Input values : Part # : 5003245 , Available Qty : 0 & Allocated Qty : 1.)",null,"Regular Defect","while doing exchange MR based direct issue, System does not knock off hard allocated qty in Stock.","No - No",null,"Now we have fixed to knock off the hard allocated qty. in the exchange MR based direct issue.",null,null,"Environment details: http://avnwarsgi06/Extui/ \n\nTest Scenario: \n\nCreated Customer order based exchange MR - direct issue done - In edit storage info. changed the serial no. & updated the storage info. \nNow tried the confirm the direct issue. System allowed to confirm the issue & knocked off the hard allocated qty. \nHard allocated qty. updated in stock correctly. \n\nTest Data: \n\nCO000041, EXO000009, MR000074, UPI000021 \n"]
["ASFC-175","Stock Transfer","Unable to create stock transfer, even if part is available in stock system says Qty not available","1.Edit Stock Transfer# ATST-000092-2014 \n2.Click on Edit Serial # / Lot # Details \n3.Part#NAS626-30 and Lot# LOT-004871 \n4. Same available in Warehouse \n\nUnable to make transfer",null,"Regular Defect","Total Issue qty. taken logic is failed from stock warehouse (from WH.)","Yes - Only Fix Provided",null,"Now we have fixed to update the issue qty. correctly from stock warehouse (from WH.)",null,null,"Environment details: http://61.19.78.30/Extui \n\nTest Scenario: \n\n1) Created STR with transfer type as Specific - issue qty. allocated correctly & checked the reqd.qty from issue WH. - Created ST Receipt. \nUpdated the new stock WH correctly. \n\nAlso checked that the different lot no.s like L1, L2 & L3 & it picks up all the Lot no.s in the edit serial/lot details screen & user can able to edit the reqd transfer qty. & updated the qty. in stock correctly. \n\n2) Created STR with transfer type as General - issue qty. updated correctly - Created ST receipt. \n\nTest Data: \n\n1) ATST-000101-2014, ATST-000104-2014 \n\n2) ATST-000103-2014"]
["AHBF-599","Stock Maintenance","Unable to issue a loaned part from stock","The part# 70BM012010, Serial# 01423 which has been received through LR-000096-14 and it is available in stock. \n\nBut the Inquire Warehouse Stock Balance does not show this part#/serial# as available in stock or it get is getting auto issued during CR transaction in AME. \n\nOn Selecting auto issue in AME system says \"Part is not available in stock\" on unchecking the auto issue flag system says \"Part is available in stock\" .",null,"Regular Defect","source flag not updated as \"LRR\" if the existing source flag is 'WO','CFG','TLOG','CR'","No - No",null,"Fix given to update the source flag appropriately if existing source flag is 'wo','cfg','tlog', 'cr'. \nEarlier if the source flag was one among 'wo' ,'cfg','tlog','cr' , then if the part is returned through LRR , the source flag did not get updated and the stock was not updated in the SMN table",null,null,"Created a LO and receipt for a part whose source flag is CR and checked if it gets updated in the smn table on completion of the receipt and also checked if it gets issued properly. \n\nEnvironment: bavnwebnmv03 \nData: \nLO-000099-2014 \nLRR-000095-2014 \nLIS-000026-2014"]
["AABI-33","Goods Inward","Unable to route customer parts for external repairs from DCGR","Unable to route customer parts for external repairs from DCGR. Error displayed \"Unable to setup Repair Order. Please ensure Repair Agency is specified in the Customer Order # 'CO000009'.\" \n\nScenario \n1. Contract set to look into part master for execution facility \n2. Part # set as Outsourced execution with preferred repair agency \n3. DCGR part and on confirm Recepit+auto insp+Auto movement, error displayed \n\n",null,"Regular Defect","Repair shop no not passed on generation of RO from Customer order as Order mode was not passed","No - No",null,"cso order mode is updated as A wherever it is null",null,null,"Test Environment: \n5.6 ST \nTest Actuals: \nCustomer Order # \nCO-000254-2014 \nRepair Order # \nARO-000210-2014 \nTest Cases: \nA direct CGR was created for the part \nAnd auto inspection done and auto movement done \nOn confirmation of receipt, it was ensured that the RO was generated","R57-HF-46"]
["AAPC-525","Reports - Book Keeping","VAT Output report total not matching with VAT Output Account balance for August","VAT Output report total not matching with VAT Output Account balance for August. \nReason : \nThere will be scenarios where the VAT will be recorded in Invoice and adjusted against Credit note. This should not be reflected in the report output. Only adjustments against receipt to be displayed in the report output. \n",null,"New Scenario","Adjustment of Invoice with Credit Note","No - No",null,"Adjustment of Invoice with Credit Note results only in Deferred Tax knock-off which should not be considered for Reporting.","NA","NA","a) Launched VAT Output Report for August and matched with Account Ledger \na) Launched VAT Return for August and matched with Account Ledger","R57-HF-46"]
["ARAH-305","Supplier Debit Credit Note","View Account Based Note Credit/Debit","View Account Based Note Credit/Debit - When you go to view it is requiring you to selelct debit or credit. When the number is entered the system can distinguish if its a debit or credit so this should not be a requirement.",null,"Regular Defect","Previously the system induced user to select note type without itself identifying the note type based on the document number provided.","No - No",null,"Modified the code to retrieve the document by identifying the note type based on the document number provided by user, so that user need not select note type.",null,null,"Verified in BAVNWEBNMV03/extui server \n\nTest Sequence : \n\nIn select Debit/Credit Note of View Debit / Credit Note screen entered supplier item based credit note # SIC-000004-2014 \n\nNote type : Debit \n\nClicked Item based note link \n\nView supplier item based credit note screen launched","R57-HF-46"]
["ASFC-171","Component Maintenance Planning","Violation of Primary key constraint error while routing un serviceable parts for external repair","1.Select Part# 3G9560V00332 and serial # 153 \n2.Select stock transfer mode as auto issue and receipt \n3. Click on external repair \n\nThis shows attached error",null,"Secondary Defect","When the Tasks that are due for a Component are pulled into the Repair Order WorkScope Details, the Sequence # for the Tasks is not populated correctly, thereby violating a Primary Key","No - No",null,"When the Tasks that are due for a Component are pulled into the Repair Order WorkScope Details, the Sequence # for the Tasks is populated sequentially, so that the Primary Key is not violated.",null,null,"Test Environment: R56 ST Environment \nTest Data: \nComponent #: COMP-006227 \nTest Case: \n1) Retrieved an Unserviceable Part for which there are few Tasks that are pending for executioin as per 'Pending Tray' in the Route Unserviceable Components/Parts screen \n2) Clicked the External Repair button and found that a Repair Order got generated successfully with all the pending tasks taken into it.","R57-HF-46"]
["AATC-351","Supplier Order Based Invoice","We cannot authorize some invoices with supplier discount applied","For some invoices where supplier discount is applied, total amount invoiced calculated by the system does not match with the total amount of the supplier invoice. The difference is not significant but we have to register the accurate amount invoiced. We tried to match the system amount by adding a TCD type charge with the difference, but the system does not accept the authorization as well. \nPlease need some clarification to match the amount.",null,"Regular Defect","When a PO with discount is invoiced, the item amount was incorrectly saved in the table causing it to validate on authorize","No - No",null,"Logic modified to updated correct Item amount",null,null,"Server: Base 5.6 ST \n1. Created a PO with discount and authorized it, \n2. Created GR. \n3. In the maintain invoice screen, retrieved the PO and added charges in the TCD tab. \n4. The invoice was saved without any error regarding mismatch in supplier invoice amount and total invoice amount.","R57-HF-48"]
["AAPC-533","Customer Balance Adjustment","When Authorizing Customer Balance Adjustment voucher duplicate account posting happens","Click authorize and again click on authorize button",null,"Regular Defect","GU ID not deleted properly and validation not handled to check the voucher number existence","Yes - Data Update & Fix Provided",null,"Concurrency check and voucher number existence check handled. \n",null,null,"Server: Aplus training server \n1. In the Authorize Adjustment Voucher screen selected a document and clicked on Authorize button multiple times. \n2. Verified that the posting has happened only once and that duplicated postings did not happen.","R57-HF-47"]
["AHBF-649","Stock Transfer","create STO manually from Inter Stock Transfer for that MR reference. On submit the mentioned error is thrown.","Specifi Serial is requested in MR1 for 2 parts ( P1 - 2 qty ( S1 - Acc1, S2 - Acc ), P2 - 1 qty ( s1 - Acc ) ). Stock is available in Alternate warehouse. On MR authorize, STO - STI got generated. Cancel that STI and Shortclose the STO. Now trying to create the STO manually from Inter Stock Transfer for that MR reference. On submit the mentioned error is thrown. \n\nCannot insert the value NULL into column 'INTERAD_TO_ZONE', table 'AVNAPPDB.dbo.TRN_INTERAD_ZNBNTRNSFR_ADL'; column does not allow nulls. INSERT fails. The statement has been terminated.",null,"Secondary Defect","For Specific Serial Request, isnull is not handled for Zone and Bin ( That is, zone and bin from MR srllot table is populated into Transfer zonebin table","No - No",null,"For Specific Serial Request, isnull is not handled for Zone and Bin ( That is, zone and bin from MR serial/lot table is populated into Transfer zone-bin table )",null,null,"Bavnwebnmv03/extui \nTest Data: \nPart: 0-10000PSIG:26952A; 0-10000PSIG:F6882 \nMR: MR-001665-2014 \nTest Scenario: \nStep 1: Specific Serial is requested in MR1 for 2 parts ( P1 - 2 qty ( S1 - owned, S2 - owned ), P2 - 1 qty ( s1 - owned ) ). \nStep 2: Stock is available in Alternate warehouse. On MR authorize, STO - STI got generated. \nStep 3: Cancel that STI and Shortclosed the STO. \nStep 4: STO got created sucessfully for that MR reference."]
["AAPC-538","Reports - Book Keeping","in WHT Report, the Tax rate is showing as incorrect rate.. this should be capture from the variant Value of TCD Code","in WHT Report, the Tax rate is showing as incorrect rate.. this should be capture from the variant Value of TCD Code",null,"Regular Defect","Sum the tax rate is not correct","No - No",null,"removed the summing of tax rate",null,null,"Verified and found correct. The tax rate is now showing in a percentage basis","R57-HF-47"]
["AHLC-675","Reports - Fixed Assets Management","po is differenct with acutal invoice for those fixed assets items ,","\nOtherwise , we will face : capital WIP has the discount off amount which should record the actual invoice amount , not the difference \nAlso fixed assets module can’t clear the po items , \n\nBoth will affect our GL code in fixed assets ,Balance sheet . \n",null,"Regular Defect","Invoice was retrieved in amend asset record only if the account posted to a FA SUSPENSE autopost account type","No - No",null,"Code modified to retrieve invoice in amend asset record if the account posted to a FA SUSPENSE autopost account type or Capital work in progress control account type",null,null,"Server: CHI training server \n1. In the create asset record screen, capitalized the GR value and authorized it. \n2. In the amend asset record screen, capitalized the invoice value which is -390.6. \n3. The above actions were performed without any error.","R57-HF-46"]
["AMCI-330","Aircraft Maintenance Execution","~#~ is appear in corrective action box","1. Launch the AME Screen. 2. Fetch Data for Aircraft 249. 3. Select the record from Open Item. 4. Click Next button in Discrepancy",null,"Regular Defect","~#~ is appear in corrective action box","No - No",null,"Logic handled to display it as Null when the corrective action is coming as ~#~",null,null,"ENVIRONMENT DETAILS: \nhttp://avnwarsgi01/Extui \n\nTest and Verification details: \n\n1) In Aircraft Maintenance>>AME screen search by Aircraft Reg# 0167. \n\n2) Select Job card-105806 from the open item. \n\n3) Click Next button in discrepancy. \n\n4) Now system doesnt show ~#~ in corrective action box. \n"]

{"sheet":"Product Enhancements","index":2,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
["Key","Component/s","Summary","Behavior Change","Shipment Comments","Test and Verification Details"]
["AHBF-3491","Aircraft Maintenance Planning","converting the report from Service based to SP based report-OFMS","Converted the Service based report to SP based report. \nEnhancement Notification is not required for this changes. \n",null,"Test Cases & Actuals are available in enterprise tester against the batch id : R58-QA-SP4-T1-57-01(RAH-Due Report). Required information will be furnished on request basis."]
["AAGI-206","Purchase Order","Customized comments in terms and conditions column","Report logic has been modified in such a way that data getting displayed in comments column under Terms and condition can be customized for each customer \nEnhancement notification is not required for this change",null,"Test Case : Launch the PO Report and check for the display of necessary fields in the report. \nResult: The Report is generated successfully with the necessary details displayed in it. \nEnvironment: bavnwebnmv03 \nData; POA-000993-2014"]

{"sheet":"Impacted Objects","index":3,"n_rows":166,"n_cols":4,"rows_kept":166,"cut":false,"hidden":false,"merged":[[0,0,0,3],[165,0,165,2]]}
[]
["Key","Component Name / BPC Name","Object Type","Object Name"]
["aabi-33","Customer Order - Services","Stored Procedure","cso_autogen_sp.SQL"]
["AABI-65","Stock Maintenance","Stored Procedure","HrdAllocQty01S.SQL"]
["AABI-65","Stock Maintenance","Stored Procedure","INTSMN16.SQL"]
["aagi-206","Procurement Reports","ILBO-EXTJS-DWAR","Dw_ER_purchaseordermainreport.zip"]
["aagi-206","Procurement Reports","Stored Procedure","PRPO12F.SQL"]
["aagi-206","Purchase Order","ILBO-EXTJS-DWAR","Dw_ER_po_termscond_rpt.zip"]
["aagi-206","Purchase Order","ILBO-EXTJS-DWAR","Dw_ER_purchaseorder_report.zip"]
["aagi-206","Purchase Order","ILBO-EXTJS-DWAR","Dw_ER_purchaseorderview_report.zip"]
["aagi-206","Purchase Order","Stored Procedure","PRep_PO_MainMul_Sp.sql"]
["aagi-206","Purchase Order","Stored Procedure","PRep_PO_VwMul_Sp.sql"]
["aagi-206","Purchase Order","Stored Procedure","PRep_PoDoc_TermsCond_Sp.sql"]
["aamg-1021","NULL","BIN","baseavn.portlet.inventoryoperations.asset.dll"]
["aamg-1021","NULL","BIN","baseavn.portlet.inventoryoperations.service.dll"]
["aamg-1021","NULL","BIN","baseavn.portlet.inventoryoperations.web.dll"]
["AAMG-990","Stock Receipt","Stored Procedure","IPlStr04S.SQL"]
["AAPC-448","Reports - Book Keeping","ILBO-EXTJS-DWAR","Dw_ER_CSOL-GA-001-02.zip"]
["Aapc-520","Customer Order - Services","Stored Procedure","cso_ordval_pendinfo_fetch_sp.sql"]
["Aapc-520","Customer Order - Services","Stored Procedure","cso_ordval_tskinfo_fetch_sp.sql"]
["Aapc-520","Customer Order - Services","Stored Procedure","cso_ordvalcomp_sp.sql"]
["Aapc-520","Customer Order - Services","Table","01-R58-BAVN-aapc-512-ALTERTABLETMP.sql"]
["AAPC-522","Reports - Receivables Management","ILBO-EXTJS-DWAR","Dw_ER_edk_DrCrnote_account_report.zip"]
["AAPC-525","Reports-Book Keeping","Stored Procedure","REP_BK_VATMON_HDR_SP.sql"]
["AAPC-525","Reports-Book Keeping","Stored Procedure","REP_BK_VATOP_DTL_SP.sql"]
["AAPC-525","Reports-Book Keeping","Stored Procedure","REP_BK_VATQUART_HDR_SP.sql"]
["AAPC-531","Reports-Book Keeping","Table","AAPC-531_REPBKEDK_AlterTempTable.sql"]
["AAPC-532","NULL","Stored Procedure","edkbk_reptax_trandtl_sp.sql"]
["AAPC-533","Customer Balance Adjustment","Stored Procedure","CBAAuEntSpBUAuHdr.SQL"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_VATIP_HDR_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_VATMON_HDR_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_VATOP_HDR_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_VATQUART_HDR_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_WHT_MonRtn_DTL_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_WHT_MonRtn_HDR_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_WHT_Report_DTL_SP.sql"]
["AAPC-538","Reports-Book Keeping","Stored Procedure","REP_BK_WHT_Report_HDR_SP.sql"]
["AAPC-541","NULL","Metadata","03-Alter_MetaData-AAPC-541.sql"]
["AAPC-541","NULL","Stored Procedure","DHMG_RM_36_Sp.sql"]
["AAPC-542","Customer Receipt","Stored Procedure","RPTVwMnSpFetHdrFetch.Sql"]
["AAPC-545","NULL","Stored Procedure","edkbk_reptax_trandtl_sp.sql"]
["AAPC-559","Release Payment","Stored Procedure","rpreportbkspschml.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_FAM_16_Sp.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_FAM_18_Sp.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_FAM_45_Sp.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_PM_48_SP.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_PM_68_SP.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_PM_69_SP.sql"]
["AAPC-566","NULL","Stored Procedure","DHMG_RM_26_Sp.sql"]
["AASI-162","Bank Reconciliation","Stored Procedure","abr_bank_reconcile_data.SQL"]
["AASI-162","Bank Reconciliation","Stored Procedure","abr_get_bankbook_bankstmt.sql"]
["AATC-351","Finance Book Processing","Stored Procedure","fin_cmn_taxamt_upd_sp.sql"]
["AEGF-257","Shop Work Order","Stored Procedure","SWO_EPUBS_PrintTskCard_XMLGen_SP.sql"]
["AEGF-265","Stock Maintenance","Stored Procedure","Int_Smn_GI_StkUpd_Sp.sql"]
["AHBD-8460","Stock Receipt","Stored Procedure","IntSt01S.SQL"]
["AHBF-1181","Physical Inventory & Cycle Count","Stored Procedure","MdShM16S.SQL"]
["AHBF-1968","Flight Billing","Stored Procedure","fb_cmn_price_wrap_sp.sql"]
["ahbf-1968","Flight Billing","Stored Procedure","FBinvrelSp_SaveBC_HChk.sql"]
["ahbf-1968","Flight Billing","Stored Procedure","FBinvrelSp_SaveBCDocML.sql"]
["ahbf-1968","Flight Billing","Table","01-R58-SM-AHBF-1968-Altertable_tmp.sql"]
["AHBF-2351","Stock Issue","Stored Procedure","IntStkTrnsfer.SQL"]
["AHBF-2441","Customer Order - Services","Stored Procedure","CSO_orderdtls_multi_val.sql"]
["AHBF-2504","Logistics Common Master","Stored Procedure","LCMmain11SpSetParSucc.sql"]
["AHBF-3192","Goods Receipt","ILBO-EXTJS-DWAR","Dw_ER_GRGoodsReceipt.zip"]
["AHBF-3357","Aircraft","Stored Procedure","AAcIn12S.sql"]
["AHBF-3491","Aircraft Maintenance Planning","DESKTOP-UI","VWDesktop_Data_BASAMPLAN.zip"]
["AHBF-3491","Aircraft Maintenance Planning","Stored Procedure","Aircraft_maint_due_rpt_sp.sql"]
["AHBF-3491","Aircraft Maintenance Planning","Stored Procedure","Ampl_Aircrat_Maint_Due_Rep_Sp_Fmt135.sql"]
["ahbf-3673","EDK Reports Payables Management","ILBO-EXTJS","edk_act_rmtadvrep_uds_pm_remit_adv_rep_R7_report.aspx"]
["ahbf-3673","Reports - Payables Management","ILBO-EXTJS-DWAR","Dw_ER_edk_act_rmtadvrep_uds_pm_remit_adv_rep_r7_report.zip"]
["ahbf-3693","Repair Order","Stored Procedure","Rep_AutoQuote_SP.sql"]
["AHBF-3739","Stock Maintenance","Metadata","1-AHBF-811-BasStockMnt-Metadata.sql"]
["AHBF-3739","Stock Maintenance","Stored Procedure","Smn_Vw_MatCnt_Go_Hfet_Sp.sql"]
["AHBF-3739","Stock Maintenance","Stored Procedure","Smn_Vw_MatCnt_Go_Mfet1_Sp.sql"]
["AHBF-3739","Stock Maintenance","Stored Procedure","Smn_Vw_MatCnt_Lnk_Hfet_Sp.sql"]
["AHBF-3739","Stock Maintenance","Table","1-R58-MAT2-AHBF-811-BasStockMnt-CREATE-table.sql"]
["AHBF-3749","Sundry Payment","Table","01-01-FIN1-AHBF-3749-AltertempTable.sql"]
["ahbf-3798","Repair Order","Stored Procedure","RO_INVOICED_FLAG_BACKUPD.sql"]
["AHBF-3814","Shop Work Order","Stored Procedure","cmn_mx_timesheet_upd_auth_val_sp.sql"]
["AHBF-3841","Purchase Order","Stored Procedure","POVW03T.SQL"]
["ahbf-3849","Maintenance Task","ILBO","tskmnttask.dll"]
["AHBF-3855","Stock Maintenance","Metadata","1-AHBF-811-BasStockMnt-Metadata.sql"]
["ahbf-3947","NULL","Metadata","03-R58-MAT1-AHBF-3947-1-Workspace-depdb.sql"]
["AHBF-4152","Flight Log","Stored Procedure","ame_StatusChange_cmn_sp.SQL"]
["AHBF-4212","Goods Inward","Stored Procedure","GIMngRcpSpfetMltSrL.sql"]
["ahbf-599","Stock Maintenance","Stored Procedure","IntLRR1.SQL"]
["AHBF-649","Stock Transfer","Stored Procedure","AdTer19S.SQL"]
["AHBF-735","Logistics Common Master","Stored Procedure","LCMmain11SpSetParSucc.sql"]
["AHBF-735","Logistics Common Master","Table","1-AHBE-13362-BasLogCM-CreateTable.sql"]
["AHBF-735","Repair Order","Stored Procedure","Rep_EdMn_Sub_MltMain_sp.sql"]
["ahlc-672","Maintenance Task","BRO","BASTASK.dll"]
["ahlc-672","Maintenance Task","BRO","BASTASK.Resources.dll"]
["ahlc-672","Maintenance Task","BRO","Bastask.zip"]
["ahlc-672","Maintenance Task","ILBO","tskmodtask.dll"]
["ahlc-672","Maintenance Task","ILBO","tskvwtask.dll"]
["ahlc-672","Maintenance Task","ILBO-EXTJS","Tskmodtask_tskmodtaskcompadl.htm"]
["ahlc-672","Maintenance Task","ILBO-EXTJS","Tskmodtask_tskmodtaskmain.htm"]
["ahlc-672","Maintenance Task","ILBO-EXTJS","Tskvwtask_tskvwtaskcompinq.htm"]
["AHLC-675","Supplier Order Based Invoice","View","2-01-AHLC-675_SIN_AlterView.sql"]
["ahlc-677","Configuration","Stored Procedure","MdCfg02S.sql"]
["AHLC-686","Loan Order","ILBO-EXTJS-DWAR","Dw_ER_loan_ord_rpt_12a115.zip"]
["AHLI-901","Supplier Payment","Stored Procedure","spyaurpenspblkautpbdtl.SQL"]
["AIBW-64","Shop Work Order","Stored Procedure","SWO_PLN_SpinitSWONo1.sql"]
["AIBW-77","Engineering Order","Stored Procedure","MnApr06T.sql"]
["amac-261","Aircraft Maintenance Planning","ILBO-EXTJS","Amplanmntacplan_amplanmntacplanent_user.js"]
["amac-358","Component Maintenance Program","Stored Procedure","MnPrt21S.SQL"]
["AMCI-133","Aircraft Maintenance Forecast","Table","AlterTable_BasMF_AMCI-133.sql"]
["AMCI-316","Stock Issue","Table","Altertable_AMCI_316.sql"]
["AMCI-330","Aircraft Maintenance Execution","Stored Procedure","QTLmainSpNextTaHdrRef.sql"]
["apac-44","Goods Receipt","ILBO-EXTJS-DWAR","Dw_ER_GRGoodsReceipt.zip"]
["apac-49","Procurement Reports","ILBO-EXTJS-DWAR","Dw_ER_prep_termscond_rpt.zip"]
["apac-49","Purchase Order","ILBO-EXTJS-DWAR","Dw_ER_purchaseorder_report.zip"]
["apac-49","Repair Order","ILBO-EXTJS-DWAR","Dw_ER_PRep_Ro_Doc_rtp.zip"]
["APAC-52","EDK - Reports Fixed Asset Management","ILBO-EXTJS","Edkfamaccdep_edkfamaccdep_user.js"]
["APAC-52","EDK - Reports Fixed Asset Management","ILBO-EXTJS","Edkfamadr_edkrepsfamadr_user.js"]
["APAC-52","EDK - Reports Fixed Asset Management","ILBO-EXTJS","EDKREPSFAM_ITK.zip"]
["APAC-52","Finance Book Processing","ILBO-EXTJS","FBP_ITK.zip"]
["APAC-52","Reports - Book Keeping","ILBO-EXTJS","REp_ITK.zip"]
["APAC-52","Reports - Book Keeping","ILBO-EXTJS","Reptb_reptbmain_user.js"]
["ARAH-235","Flight Log","Stored Procedure","TMSHT09T.sql"]
["ARAH-235","Flight Log","Stored Procedure","TMSHT15T.sql"]
["ARAH-300","Supplier Debit Credit Note","Stored Procedure","scdncaspsav1src.sql"]
["ARAH-300","Supplier Debit Credit Note","Stored Procedure","scdncaspsavesrc.SQL"]
["ARAH-300","Supplier Debit Credit Note","Stored Procedure","scdneaspauthsrc.SQL"]
["ARAH-305","Supplier Debit Credit Note","Stored Procedure","scdnvaspfethfet.sql"]
["ARAH-305","Supplier Debit Credit Note","Stored Procedure","scdnvispfethfet.SQL"]
["ARAH-347","Goods Inward","ILBO-EXTJS","GiInsPrt_InsPrtMain_State.xml"]
["arah-355","Repair Order","Stored Procedure","Rep_EdMn_Sub_MltMain_sp.sql"]
["ARAH-374","Component Replacement","Stored Procedure","IntTl01S.SQL"]
["arah-378","Maintenance Task","Stored Procedure","MnTsk17S.SQL"]
["ARAH-389","Goods Inward","Stored Procedure","GIInsPrtSpRcpNomltInespO.sql"]
["ARAH-389","Goods Inward","Stored Procedure","GIMngRcpSpfetMltSrL.sql"]
["arai-183","Maintenance Task","BRO","BASTASK.dll"]
["arai-183","Maintenance Task","BRO","BASTASK.Resources.dll"]
["arai-183","Maintenance Task","BRO","Bastask.zip"]
["arai-183","Maintenance Task","ILBO","tskvwtask.dll"]
["arai-183","Maintenance Task","ILBO-EXTJS","Tskvwtask_tskvwtaskinq.htm"]
["ARAI-248","Goods Inward","Stored Procedure","GIMngRcpSpMveprtMltMov.sql"]
["ARAI-274","Aircraft","Stored Procedure","BACmai123SpSearchRest_dspO.sql"]
["ARAI-52","NULL","Stored Procedure","DHMG_MAT_MCISU_DRILL_QTY_01_SP.sql"]
["ASFC-169","Aircraft","Stored Procedure","IPPVU02S.sql"]
["ASFC-171","Repair Order","Stored Procedure","IntRO01S.sql"]
["ASFC-175","Stock Transfer","Stored Procedure","MdAd207S.SQL"]
["auch-2653","Shop Work Order","Stored Procedure","Swo_partserial_ChangeSp.sql"]
["AUCH-2917","Stock Maintenance","Stored Procedure","SMN_CMN_PARTSERIAL_ID_GEN.sql"]
["AUCH-2989","Aircraft","Stored Procedure","AC_SUB_CAL_USAGE_DEPRICIATION_SP.sql"]
["AUCH-3010","Stock Conversion","ILBO","sscmodssc.dll"]
["AUCH-3033","Shop Work Order","ILBO-EXTJS-DWAR","Dw_ER_certi_of_confor_sr_report.zip"]
["AUCH-3033","Shop Work Order","Stored Procedure","SWO_ICOM_Sp_CFAP1_Rprt__O.sql"]
["AUCH-3033","Shop Work Order","Stored Procedure","SWO_ICOM_Sp_CFRP1_Rprt__O.sql"]
["AUCH-3033","Shop Work Order","Table","01_AUCH-3033_BasSWO_AlterTable.SQL"]
["AUCH-3072","Shop Work Order","Metadata","01_AUCH-3072_BasSWO_AlterMetadata.sql"]
["AUCH-3072","Shop Work Order","Stored Procedure","Swo_StatusChange_cmn_val_sp.sql"]
["AUCH-3119","Stock Maintenance","Stored Procedure","OFMS_ImpPrePrcs_ERR_Sp.sql"]
["IUCH-2018","Customer Order - Services","Stored Procedure","CSO_MCO_SpEvaluaHdrChk.sql"]
["IUCH-2098","Goods Inward","Stored Procedure","GI_CMN_MVEPART_VALIDATIONS_SP.sql"]
["IUCH-2098","Goods Inward","Stored Procedure","GIBinPrtSpSaveBinDet.sql"]
["IUCH-2098","Goods Inward","Stored Procedure","GIMngRcpSpMveprtMltMov.sql"]
["IUCH-2130","Shop Work Order","Stored Procedure","SWO_ICOM_Sp_RPT_tag_sp.sql"]
["IUCH-2136","Asset Capitalization","Stored Procedure","ainq_cmn_tagprop_sp.sql"]
["IUCH-2136","Asset Disposal","Stored Procedure","adispIFBRSpconfMLInf.SQL"]
["IUCH-2136","Asset Disposal","Stored Procedure","adispIFBTSpsrchMLInf.SQL"]
["IUCH-2140","Account Group","Stored Procedure","cmn_ame_tskcostinfo_fetch.sql"]
[]
["Note : "]
["\n* Includes internal minor fixes for defects reported as part of Product Testing activity\n* Impacted base objects which is part of regular release will be available in ICMS_Release_Dtl table of Proj_EnvDB\n"]

{"sheet":"Schema Changes","index":4,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
["Database Name","Table Name","Modified Event","Column Added","Columns  Modified","Columns Dropped"]
["AVNAPPDB","cmn_mxro_mx_report_option_dtl","CREATE_TABLE","New Table","New Table","New Table"]
["AVNAPPDB","LCM_SET_OPTION_DTL_HIS","CREATE_TABLE","New Table","New Table","New Table"]
["AVNAPPDB","MF_FSL_FORECAST_SCHEDULER_LOG","ALTER_TABLE","NULL","FSL_REMARKS","NULL"]
["AVNAPPDB_TEMPDB","cso_val_tskproc_in_tmp","ALTER_TABLE","cso_ou_date","NULL","NULL"]
["AVNAPPDB_TEMPDB","REP_BK_WHT_MONRTN_RPT_TMP","ALTER_TABLE","NULL","Individual_Tmp","NULL"]
["AVNAPPDB_TEMPDB","REP_BK_WHT_MONRTN_RPT_TMP","ALTER_TABLE","NULL","RegName_Tmp","NULL"]
["AVNAPPDB_TEMPDB","si_expusg_bkup_pop_tmp","ALTER_TABLE","si_mode_flag","NULL","NULL"]
["AVNAPPDB_TEMPDB","spy_printpaybatchout_tmp","ALTER_TABLE","NULL","supdocno","NULL"]
["AVNAPPDB_TEMPDB","VAT_INPUT_TMP","ALTER_TABLE","NULL","SUPPLIER_NAME","NULL"]
["AVNAPPDB_TEMPDB","VMC_PRTDT_TRAN_LIST_DTL_TMP","ALTER_TABLE","NULL","VMC_PRTDT_DOC_PRIO","NULL"]
["AVNAPPDB_TEMPDB","VMC_PRTDT_TRAN_LIST_DTL_TMP","ALTER_TABLE","VMC_PRTDT_TRAN_QUANTITY","NULL","NULL"]

{"sheet":"HotFix Regularization","index":5,"n_rows":44,"n_cols":3,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
["Defect ID","Hotfix ID","Included"]
["AHLC-677","R57-HF-46","Yes"]
["AAPC-525","R57-HF-46","Yes"]
["AUCH-2653","R57-HF-46","Yes"]
["AAPC-448","R57-HF-46","Yes"]
["ASFC-169","R57-HF-46","Yes"]
["AUCH-2917","R57-HF-46","Yes"]
["AUCH-3010","R57-HF-46","Yes"]
["ARAH-305","R57-HF-46","Yes"]
["AHLC-675","R57-HF-46","Yes"]
["AAPC-522","R57-HF-46","Yes"]
["IUCH-2018","R57-HF-46","Yes"]
["AABI-33","R57-HF-46","Yes"]
["ASFC-171","R57-HF-46","Yes"]
["AHLI-901","R57-HF-46","Yes"]
["AAMG-990","R57-HF-46","Yes"]
["ARAH-389","R57-HF-46","Yes"]
["AASI-162","R57-HF-46","Yes"]
["AHBF-3814","R57-HF-46","Yes"]
["AAMG-1021","R57-HF-46","Yes"]
["AHBF-3947","R57-HF-46","Yes"]
["ARAH-300","R57-HF-47","Yes"]
["APAC-44","R57-HF-47","Yes"]
["ARAI-248","R57-HF-47","Yes"]
["AAPC-533","R57-HF-47","Yes"]
["AAPC-541","R57-HF-47","Yes"]
["AAPC-566","R57-HF-47","Yes"]
["AHLC-686","R57-HF-47","Yes"]
["AAPC-531","R57-HF-47","Yes"]
["ARAI-52","R57-HF-47","Yes"]
["AAPC-538","R57-HF-47","Yes"]
["AAPC-542","R57-HF-47","Yes"]
["ARAH-355","R57-HF-47","Yes"]
["APAC-52","R57-HF-47","Yes"]
["AAPC-559","R57-HF-47","Yes"]
["AAPC-545","R57-HF-48","Yes"]
["ARAH-347","R57-HF-48","Yes"]
["AAGI-206","R57-HF-48","Yes"]
["AEGF-265","R57-HF-48","Yes"]
["APAC-49","R57-HF-48","Yes"]
["AATC-351","R57-HF-48","Yes"]
[]
["Note: The defect has been shipped in Hotfix release but on hold for today's shipment. The same will be regularized in next shipment"]

{"sheet":"Infrastructure Component Issues","index":6,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Call Id","Issue Summary","Area that needs to be tested","Expected Result","Layer affected"]

{"sheet":"Infrastructure Impacted objects","index":7,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
["Impacted Layer","Impacted Object"]