My Oracle Support Banner

AIF/RPASCE: How to Resolve Batch Failure with Error: ORA-00904: "R_TIMESTAMP": invalid identifier? (Doc ID 3031767.1)

Last updated on JULY 01, 2024

Applies to:

Oracle Retail Merchandise Financial Planning Enterprise Edition Cloud Service Plus - Version 24.1 and later
Oracle Retail Inventory Planning Optimization Cloud Service Advanced Edition - Version 24.0 and later
Oracle Retail AI Foundation Cloud Service - Version 24.1 and later
Oracle Retail Lifecycle Pricing Optimization Cloud Service Advanced Edition - Version 24.1 and later
Information in this document applies to any platform.

Goal

RPASCE applications are at version 24.1.202.1. When the batch runs it fails with the following error: ORA-00904: "R_TIMESTAMP"

How can this be resolved?

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!

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