Trigger with AR auto invoice program R12
Hi there
In the 11i version, we had a database trigger that updated the trx_number field when a new invoice was created (manul or autoinvoice).
Now in R12, we migrated the trigger, when I create a manual invoice, the trigger raises normally and update the trx_number field but when I run the autoinvoice master program I see no changes in the trx number field. (the autoinvoice gets the line from the Property Module)
This is the trigger:
create or replace TRIGGER csla_ar_trx_num_bru
BEFORE UPDATE OF complete_flag
ON ra_customer_trx_all
for each row