Wednesday 17 August 2016

API to insert notes in AR transactions

To insert notes into AR transaction kindly used ARP_NOTES_PKG.insert_p API.
This API will take record variable as input parameter. we need to assigned value to it as shown in below given script.

================================================
DECLARE
  l_notes_rec ar_notes%rowtype;
begin

  --apps initialize
  mo_global.init('AR');
  mo_global.set_policy_context('S', '204');
  --
   l_notes_rec.customer_trx_id        := 1545557; -- Customer_trx_id
  l_notes_rec.note_type              := 'MAINTAIN';
  l_notes_rec.text                   := 'Test for AR note';
  l_notes_rec.customer_call_topic_id := NULL;
  l_notes_rec.call_action_id         := NULL;
  l_notes_rec.customer_call_id       := NULL;
 -- call API to insert note
  ARP_NOTES_PKG.insert_p(l_notes_rec);
--
  commit;
  dbms_output.put_line('Note inserted reference note id : ' || l_notes_rec.note_id);
END;
==================================================

screenshot for AR invoice workbench transaction notes.



===================================================
One can query this record from backend by using below given query.

select * from ar_notes_v 
where customer_trx_id=1545557;
===================================================

No comments:

Post a Comment

AP Invoice Notes related Table details in Oracle Fusion

 What is the table that stores the AP Invoice notes? AP notes are stored in ZMM_NOTES table with SOURCE_OBJECT_CODE = 'AP_STANDARD_INVOI...