Bug 5741 - Store Purchase Vouchers not Approval
Summary: Store Purchase Vouchers not Approval
Status: RESOLVED USER TO VERIFY
Alias: None
Product: IMIS PURCHASE
Classification: 01.IMIS
Component: IMIS PURCHASE FORMS AND REPORTS (show other bugs)
Version: unspecified
Hardware: PC Windows
: --- enhancement
Assignee: Mahender
URL:
Depends on:
Blocks:
 
Reported: 2021-02-05 16:13 IST by Nirmal Gupta
Modified: 2021-02-05 18:01 IST (History)
1 user (show)

See Also:
Database:
Module ID:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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'