Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

APEX 24.1 Bug: Opportunities Sample Application

hamil10-OracleAug 12 2024

I've found two bugs with the Opportunities Sample App. The application is helpful, for demonstrating the functionality of APEX, but the bugs don't help to build confidence in the tool.

Bugs:

  • Leads (page 19)
    • Issue: Display As Pills are rendering as raw HTML instead of Pills
      • Root cause: P19_DISPLAY_AS – Escape special characters setting is turned ON
      • Resolution: P19_DISPLAY_AS – Escape special characters setting should be turned OFF
  • Create Opportunity (page 71)
    • Issue: The create opportunity Process throws an error (ORA-01840: input value not long enough for date format)
      • Root cause:
        • EBA_SALES_DEALS.DEAL_CLOSE_DATE is declared as Timestamp(6)
      • Resolution: Redefine the EBA_SALES_DEALS.DEAL_CLOSE_DATE as a DATE type, instead of Timestamp
Comments
Post Details
Added on Aug 12 2024
1 comment
279 views