Receivables - EBS (MOSC)

MOSC Banner

Trigger on AR_STATEMENT_HEADERS

edited Nov 11, 2018 4:04AM in Receivables - EBS (MOSC) 1 commentAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center