Report on Contract Lines Billing Resource
Summary:
I am currently working on a report for Enterprise Contracts, to list out Billing Resources by Contract Line, and need to join tables PJB_BILLING_CONTROLS and OKC_K_LINES_B. Oracle documentation states that the foreign keys to join are LINE_ID, MAJOR_VERSION from OKC_K_LINES_B and CONTRACT_LINE_ID, MAJOR_VERSION from PJB_BILLING_CONTROLS. Using these join conditions only matches 335 out of 16,000 lines. Are these foreign keys correct?
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Oracle Fusion Enterprise Contracts 24D
Code Snippet (add any code snippets that support your topic, if applicable):