How can I set up a weekly notification that informs me that the project contract will expire in the next 60 days?

You can create a custom notification using Agents in OTBI:

1. Create an analysis that triggers your notification. For example, a contract within X days of expiry. Use the Enterprise Contracts - Contracts Real Time subject area. For more information on how to create an analysis, refer to the Create Your First Analysis section in the Creating Analyses and Dashboards in Oracle Transactional Business Intelligence guide.

2. Create an analysis for the payload of your notification. This analysis can include the contract name, number, value, and the expiration date.

3. Create an Agent in OTBI and associate the above analysis, specify execution frequency (for instance, weekly), recipients, and so on. For more information on how to create an agent, refer to the Create Agents to Deliver Content section in the Creating Analyses and Dashboards in Oracle Transactional Business Intelligence guide.