Total Pageviews

Friday, 25 September 2020

FND: Profile Option Value updation using API

 Declare

Result Boolean;

BEGIN

   Result:= fnd_profile.SAVE ('XX_OTC_ROLE_PF' , null, 'USER',1677);

   IF Result

   THEN

      DBMS_OUTPUT.put_line ('Profile Updated');

   ELSE

      DBMS_OUTPUT.put_line ('Profile Not Updated');

   END IF;

   COMMIT;

END;

No comments:

Post a Comment

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...