Problem in Creating Trigger After Update (to insert Manual invoice using API)
Hi to all have a good day! Anybody can help me to solve my issue regarding in creating trigger because its not working, the interface_status is stil not updating to P for long time.....im creating trigger in ra_interface_lines_all if there is a data coming from sales order going to receivable i will create manual credit memo invoice using API base on interface and interface status is P... this is my trigger...Kindly Help Me and tell to me the problem ....Thanks....
CREATE OR REPLACE TRIGGER APPS.XX_CREATE_INVOICE_TRIG
AFTER update
ON ra_interface_lines_all