The script standalone_posting_for_one.sql can be used to run Create Accounting from sqlplus for a single entity. The user can enter a single event_id. The script then determines the related entity_id, and runs Create Accounting for that entity.
The user can issue a 'rollback', and re-run the tool for the same test case again, for example to test a different setup.
The script can create a level 12 trace of the create accounting process, and informs about the trace file location.
The script can create debug log messages, and provide the sql to extract only the relevant messages from fnd_log_messages.
The output of the script shows the status of the event before and after Create Accounting, and the error messages.
Benefits
Results can be rolled back, and the same test case can be re-used.
Automation of the creation of trace and debug log files. Create accounting with debug log and trace can be created in one step from backend, without any additional configurations steps.
Traces and debugs for specific events can be created.
Error messages and event statuses are shown in the output of the script.
Restrictions
Should not be run without guidance/permission from Support or Development.
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!
