Total Pageviews

Showing posts with label EBS: OAF Personalization. Show all posts
Showing posts with label EBS: OAF Personalization. Show all posts

Thursday, 13 April 2023

EBS : OAF Personalization : How to add Custom Fields in Supplier Page Purchasing TAB (Oracle APPS R12)

How to add Custom Fields in Supplier Page Purchasing TAB using OAF Personalization in R12


Step1: Go to Functional Administrator-> click on Personalization TAB

Step2: Enter Document Path as “/oracle/apps/pos/supplier/webui/ByrPurchPG”  and click on GO Button. Click on Personalize Page “Pencil Icon”.

Step3: Select “Complete” and click on “Expand All”.
Step4: Search for “Table: Purchasing“ and Click on “Create Item” as highlighted below
Step5: Enter Following details as mentioned in below table as shown in below screenshot

Property

Value

*ID

XX_Custom_fields

Prompt

XX_Custom_fields

View Attribute

Attribute4

View Instance

SitesVO


















Step6: And click on Apply to save the records.


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