Total Pageviews

Showing posts with label EBS:Oracle Forms. Show all posts
Showing posts with label EBS:Oracle Forms. Show all posts

Monday, 27 February 2023

EBS: Oracle Forms : How to display message from database to Oracle Forms

 How to display message from database to Oracle Forms


User below code to print message in oracle forms


       fnd_message.set_name ('FND', 'FND_GENERIC_MESSAGE');
       fnd_message.set_token ('MESSAGE', 'Record already exists');
       fnd_message.raise_error; 

FUSION: Purchasing Query

  1) ---------CPA to PO Amount---------- select poh.segment1, (select sum(nvl(cpol.quantity,1)* cpol.unit_price) from po_headers_all cpoh,po...