Bug 5741

Summary:	Store Purchase Vouchers not Approval
Product:	[01.IMIS] IMIS PURCHASE	Reporter:	Nirmal Gupta <nirmal.gupta>
Component:	IMIS PURCHASE FORMS AND REPORTS	Assignee:	Mahender <mahender.singh>
Status:	RESOLVED USER TO VERIFY
Severity:	enhancement	CC:	sharad.sharma
Priority:	---
Version:	unspecified
Hardware:	PC
OS:	Windows
Database:		Module ID:

Comment 2 Mahender 2021-02-05 18:01:49 IST

THIS IS DONE CHECK AND CONFIRM

Comment 1 Nirmal Gupta 2021-02-05 16:14:14 IST

UPDATE VW_STORE_PURCHASE_BILLS SET STORE_PURCHASE_BILLS_RECID=:1,COMPANY_CODE=:2,COST_CENTRE=:3,FOREX_RATE=:4,STATUS=:5,CREATED_BY=:6,CREATED_ON=:7,LAST_UPD_BY=:8,LAST_UPD_ON=:9,VOUCHER_TYPE=:10,VOUCHER_SERIES=:11,VOUCHER_NUMBER=:12,ENTRY_NUMBER=:13,VOUCHER_DATE=:14,SUPPLIER_CODE=:15,FOREX_CODE=:16,BILL_AMOUNT=:17,NARRATION=:18 WHERE ROWID=:19

Description Nirmal Gupta 2021-02-05 16:13:21 IST

Hi


 Store Purchase Vouchers not Approval  unit 6-C 
SPV NO- 55/P212-5199 DATE- 05/02/2021 

ERROR - ORA-01427: single-row subquery returns more than one row
ORA-06512: at "IMISMAIN.PKG_AP", line 11056
ORA-06512: at "IMISMAIN.SPV_TPC", line 151
ORA-06512: at "IMISMAIN.SPV_TRG", line 156
ORA-04088: error during execution of trigger 'IMISMAIN.SPV_TRG'