How to Set Transaction Status During Transaction Import

March 8, 2006 on 4:57 pm | by Marian Crkon | In How To Guides | Enter Comments | Print Print | Email Email

You may need to know this when importing expenditure transactions into Oracle Projects. Follow these steps to import project expenditure transactions:

  • Upload transactions into Oracle Projects interface table (using WebADI, or some custom program)
  • Run the Transaction Import process from Oracle Projects

If transactions get rejected during the Transaction Import process, they are set to a rejected status (R) in the PA_TRANSACTION_INTERFACE table. In order for the transactions to become eligible for the next import, errors need to be corrected and status needs to be set to a pending (P).

You can fix data errors in the Review Transactions form. But unlike with FA Mass Additions, or other Oracle interfaces, users are unable to set the Transaction Status in the Review Transactions form. It takes a phone call into a DBA to run a simple custom Set Transaction Import Status script to make the transactions eligible for import again. Many clients register such script as a separate concurrent program.

No Comments yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment

XHTML: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Powered by WordPress with Pool theme design by Borja Fernandez.
Entries and comments feeds. Valid XHTML and CSS. ^Top^