ECA: What SQL/Query Gets Executed to Display the Content for “Recent Invoices” Pagelet Section under Contracts Homepage > Manage Contracts?
(Doc ID 2962784.1)
Last updated on JULY 25, 2023
Applies to:
PeopleSoft Enterprise FIN Contracts - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Goal
What is the SQL/Query used to populate the Recent Invoices section of the Manage Contracts component?
Scenario:
Navigation: Customer Contracts > Manage Contracts
Under Manage Contracts, all of the Related Information page populates correctly. The section "Recent Invoices" says "No data to display". Adjusted the Number of Prior Days to Display in Related Content to 5000 in My Preferences but still no data is displayed. Please provide information on what SQL gets triggered that helps display information in this section.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |