Skip to main content

Hi,

 

Is anyone aware of this error, I had 3 cancelled invoices and I want to print 2 invoice so that status changed from preliminary. error is as below

 

Error rOracle Error 01427: Subquery for one row returns more than one row] in

Report method dCUSTOMER_ORDER_IVC_RPI.Report_Invoice]

Hi Shantanu,

Please report this issue with your technical team. There is an issue with one of the fields in Customer Invoice layout. Some additional conditions need to be add.

 

Regards

Abdul Rehman


Hi Abdul,

 

This shall be the issue in the report itself right?

I am from Functional background and I have to get this resolved.

Is there a work around to that?

also, a point to note, there is already a Customer invoice in preliminary stage cancelled, i suspect this might be issue, but I cant delete that 


Hi Shantanu,

Reported error is very generic and often comes for customised reports. It is not possible to identify the reason without debugging the report rpi.

Let me try to explain, this error comes when system getting more than one values for a report field when one single unique value can be printed. e.g., only single value can come in Currency field in report output, however, system somehow getting two different currencies and therefore, unable to decide which Currency would be considered for report layout. 

You would need some technical assistance to understand where is the issue exactly.

 

Regards

Abdul Rehman


Reply