Receivables - EBS (MOSC)

MOSC Banner

Trigger with AR auto invoice program R12

edited Nov 9, 2017 8:16PM in Receivables - EBS (MOSC) 4 commentsAnswered ✓

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

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