Hello Alan,

It’s so simple as you open regular form .fmb in form builder just follow this:

1. First you need to download then latest version of CUSTOM library that comes with your Oracle EBS version. (downloaded from production server).
2. You can find the path of CUSTOM.pll under ($AU_TOP/resources) folder
3. Open Oracle Form Builder
4. Click File menu ==> Open ==> choose CUSTOM.pll from your local machine
5. After opening CUSTOM.pll into your form builder you can modify (CUSTOM) Package as per your requirements.

Hello PraveenM,

this error came because there is a setup of default rule was missing when you want to create new asset category.

just follow this steps to complete your setup required:

Navigate to Responsibility FA manager > Setup > Asset System > Category

Ensure that, at the bottom of the page, there is a Default rules button.

Enter the mandatory information in the second page for Default rules and Save.

Once the category book is defined with the default rules and saved, there should be no error.

Hello Chandra, First thing the revision tables is:

po_headers_all, po_headers_archive_all, po_lines_archive_all, po_line_locations_archive_all and po_distributions_archive_all

Note: How the Purchasing Archive tables are updated when using Archive on Approve method for archiving (To setup Archive on Approve go to Setup -> Purchasing -> Document Types) and here an example to understand and to get the revision’s of PO 1- We created new PO, sent it for approval 2- PO Approved Now run this query :

SELECT po_header_id, segment1, revision_num 
FROM po_headers_all 
WHERE po_header_id = &p_po_header_id

which is (&p_po_header_id) is ID for po has been created above. and here is the result expected:

3- Now add a new line in PO, then sent it for reapproval. 4- PO Approved Now run this query

SELECT po_header_id, segment1, revision_num 
FROM po_headers_archive_all 
WHERE po_header_id = &p_po_header_id

So now from archive table you can get all revisions for particular PO.