Introduction
This Post is about to update the attribute in AR invoice Through API In Oracle EBS R12.
Please find the below script for update the attribute in AR Invoice
DECLARE
CURSOR c_ers_num
IS
SELECT trx_number, interface_header_attribute15
FROM ra_customer_trx_all
WHERE trx_number IN (SELECT DISTINCT trx_number
FROM xx_ar_cm_apply);
BEGIN
FOR i IN c_ers_num
LOOP
UPDATE ra_customer_trx_all
SET interface_header_attribute15 = i.interface_header_attribute15
WHERE ( trx_number = i.trx_number || ‘A’
OR trx_number = i.trx_number || ‘B’
OR trx_number = i.trx_number || ‘C’
)
AND interface_header_attribute15 = ‘Y’
AND org_id = 396;
DBMS_OUTPUT.put_line ( ‘Cursor Invoice#, ‘
|| i.trx_number
|| ‘A’
|| ‘ ,Base Invoice Updated Count#, ‘
|| SQL%ROWCOUNT
|| ‘ ,Cursor DFF val’
|| i.interface_header_attribute15
);
END LOOP;
COMMIT;
END;
Summary
This Post Described about update the attribute in AR invoice Through API in Oracle EBS R12.
Got any queries?
Do drop a note by writing us at doyen.ebiz@gmail.com or use the comment section below to ask your questions.
