General Ledger - EBS (MOSC)

MOSC Banner

How to clear records that are causing errors

edited Apr 1, 2009 6:03PM in General Ledger - EBS (MOSC) 2 commentsAnswered
 Hi:

I am testing the extraction of 810 credits in the eCommerce Gateway and received an error.  I want to remove the records from ECE_AR_TRX_HEADERS and ECE_AR_TRX_LINES tables, but don't know how to do so.  Is there a screen for these interface tables, or do I need to use SQL commands or PL/SQL to do this?

Cause

Each row in ECE_AR_TRX_HEADERS is purged after the data is written to the data file. 
In this case that table was not purged from a previous run of the 810 Outbound (INO)

Solution

1.  Remove the records from ECE_AR_TRX_HEADERS and ECE_AR_TRX_LINES table from the previous run. 

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center