Why Is Automatic SQL Tracing Not Working for the RPM 14.0.3 NIL Batch? (Doc ID 2166797.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Retail Price Management - Version 14.0.3 and later
Information in this document applies to any platform.

Goal

In Retail Price Management (RPM) 14.0.3, why is automatic SQL tracing for the New Item Location (NIL) batch not working?

When SQL trace for RPM NIL batch is enabled by setting up the trace flag to 'Y' in the RPM_BATCH_TRACE table, we expect to have SQL trace files created in the database server.  This is not happening.We checked the same for the injector batch, and this batch is working fine.


Steps to Reproduce:

  1. Log in to RPM database and change the Enable_Trace flag to 'Y' in RPM_BATCH_TRACE table for Batch_Name='NILBatch'.
  2. Run the RPM NIL batch and look for the trace files in RPM/RMS Database server.
  3. Trace files are not found.
     

Solution

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 hundreds of Community platforms