Trigger on AR_STATEMENT_HEADERS
Hi,
There is before insert trigger on AR_STATEMENT_HEADERS which copies the AR_STATEMENT_HEADERS table's data to a custom table.
BEFORE INSERT ON AR_STATEMENT_HEADERS REFERENCING NEW AS NEW OLD AS OLD FOR EACH ROW
All the values are getting populated correctly in custom table except :
line_cluster_id : populated as 0 in custom table.
remit_to_address_id : populated as -1 in custom table.
total_amount_due, : populated as 0 in custom table.
Bucket1, Bucket2 : populated as 0 in custom table.
All these columns are having values in AR_STATEMENT_HEADERS.
Kindly provide your input on this.
Thanks
Vandana