You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How can we get the contract terms in custom report with same formatting like the fusion application?

edited Feb 1, 2024 5:17AM in Enterprise Contracts 3 comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!