Report on Contract Lines Billing Resource — Cloud Customer Connect
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

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):

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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