My Oracle Support Banner

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.


What is the SQL/Query used to populate the Recent Invoices section of the Manage Contracts component?


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.



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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.