Hi,
I am using interactive report with below query :-
select APEX_ITEM.CHECKBOX(1,TLINE_ID,'UNCHECKED') TLINE_ID,
"BATCH_ID",
"INVOICE_NO",
"TYPE",
"INVOICE_DATE",
"AMOUNT",
ADJ_AMOUNT as BALANCE_AMOUNT,
APEX_ITEM.DISPLAY_AND_SAVE(3,INV_ID) INV_ID,
"CHECK_FLG",
"EXCHANGE_RATE",
"ORDER_NO",
--APEX_ITEM.DISPLAY_AND_SAVE(13,EXCHANGE_TYPE) EXCHANGE_TYPE,
--APEX_ITEM.DISPLAY_AND_SAVE(14,EXCHANGE_AMT) EXCHANGE_AMT,
"STATUS",
"INVOICE_AMOUNT",
PAID_AMOUNT,
--"DIE_AMOUNT",
"SUPP_ID",
(SELECT NAME FROM VENDOR_CUSTOMER_MAS VC WHERE VC.TYPE<>'A' AND VC.SBU_CODE=:P0_SBU_CODE AND VC.CODE=SUPP_ID) AS SUPPLIER_NAME,
"GL_DATE",
"USER_ID",
"CURR_CODE",
PROCESS_ID,
APEX_ITEM.DISPLAY_AND_SAVE(14,(NVL(PAYMENT_EXCH_RATE,0)-NVL(EXCHANGE_RATE,0)) * NVL(ADJ_AMOUNT,0)) EXCHANGE_AMT,
ABS((NVL(PAYMENT_EXCH_RATE,0)-NVL(EXCHANGE_RATE,0)) * NVL(ADJ_AMOUNT,0)) DIE_AMOUNT,
APEX_ITEM.DISPLAY_AND_SAVE(13,decode(SIGN((NVL(PAYMENT_EXCH_RATE,0)-NVL(EXCHANGE_RATE,0)) * NVL(ADJ_AMOUNT,0)),-1,'LOSS',1,'PROFIT',0,NULL)) EXCHANGE_TYPE
from TEMP_AP_PAYMENT_BATCH_DTL
WHERE BATCH_ID = :P619_BATCH_ID
and SUPP_ID=:P619_SUPPLIER
Now when I try to make payment of 200 records in one go it is working fine. However when I select 500 rows it show me bad request error :
Please suggest why it is showing error when I try to update 200+ records and not in 200 records.
Please suggest. Any suggestions would be appreciated.
Regards