My Oracle Support Banner

Troubleshooting Create Accounting: standalone_posting_for_one.sql Script To Analyze Issues with Create Accounting (Doc ID 1618952.1)

Last updated on APRIL 07, 2021

Applies to:

Oracle Subledger Accounting - Version 12.0.0 to 12.2 [Release 12.0 to 12.2Cloud]
Information in this document applies to any platform.

Purpose

The script standalone_posting_for_one.sql can be used to troubleshoot Create Accounting issues

Features

 

Benefits

Restrictions

 

Troubleshooting Steps

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
Purpose
 Features
 Benefits
 Restrictions
Troubleshooting Steps
 Usage
 Parameters
 Samples of Output Showing Instructions
 Instructions to get the trace and debug information are printed in the script output:
 The event status before/after create accounting, and the error messages are also displayed:
 Samples of output for different scenarios
 Scenario 1: Run Create Accounting for one event without issues
 Scenario 2: Run Create Accounting for one event with issues
 Scenario 3: Run Create Accounting for one event with issues and create trace and debug log

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