How can we get the contract terms in custom report with same formatting like the fusion application?
Summary: We want to develop a custom BIP report which needs to display the contract terms as it appears in fusion. We are getting the required contract terms information from base table but data is not formatted as in the fusion application frontend.
Version (include the version you are using, if applicable): Oracle Fusion Cloud Applications 23D (11.13.23.10.0)
Code Snippet (add any code snippets that support your topic, if applicable):
SELECT ch.contract_number,
cab.DISPLAY_SEQUENCE,
cv.DISPLAY_NAME,
REGEXP_REPLACE(DBMS_LOB.SUBSTR(cv.ARTICLE_TEXT, 3000),'<[^>]*>') CONTRACT_TERMS
--dbms_lob.substr(cv.ARTICLE_TEXT, 3000)article_text
FROM okc_k_headers_vl ch,okc_k_articles_b cab,okc_articles_all caa, okc_article_versions cv
Tagged:
0