Hi Chandra

You can use this query to list all customizations across all modules

SELECT   PATH.PATH_DOCID CUSTM_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH
FROM     JDR_PATHS PATH
WHERE    PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID
                             FROM   JDR_COMPONENTS
                             WHERE  COMP_SEQ = 0
                             AND    COMP_ELEMENT = 'customization'
                             AND    COMP_ID IS NULL)
ORDER BY CUSTM_DOC_PATH;

and if you want to get only specific module you can use following query:

SELECT   PATH.PATH_DOCID PERZ_DOC_ID, JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID) CUSTM_DOC_PATH
FROM     JDR_PATHS PATH
WHERE    PATH.PATH_DOCID IN (SELECT DISTINCT COMP_DOCID
                             FROM   JDR_COMPONENTS
                             WHERE  COMP_SEQ = 0
                             AND    COMP_ELEMENT = 'customization'
                             AND    COMP_ID IS NULL)
AND      (JDR_MDS_INTERNAL.GETDOCUMENTNAME (PATH.PATH_DOCID)) LIKE '%/ar/%'
ORDER BY CUSTM_DOC_PATH;

Hi Olivier,

it common that z += 5.6 are equivalent to z = z + 5.6, it’s one the assignment operators it takes the value of z then add 5.6 to it and at the end store the new result into z

ex:

double z = 5.5
z += 0.1 // the result of z now is : (5.6)

but be careful in java because if “z” is not of type double you will get an compilation error.

hope this help.

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.