Activity Stream

Yesterday
new user registration
Diane Edwards joined our community! Welcome!

new user registration
Manas Ray joined our community! Welcome!

4 days ago
new user registration
Prashant Kalantri joined our community! Welcome!


new user registration
Vineet Verma joined our community! Welcome!

More than a week ago
new user registration
Thijs Janssen joined our community! Welcome!


Financials
Expanding a value set in your CoA
( 0 Votes )
General Ledger
Written by Jouke de Groot   
Monday, 14 September 2009 20:34

For some reason I always had the impression that CoA definitions are very static once the first transactions are created in the ledger. This still holds true. But when a customer asked me to investigate to increase the size of a value set from 3 to 4 positions, I learned that (with some restrictions) there is a bit more flexibility than I initially thought.

Read more...
 
Why Online Accounting in Payables is sometimes confusing
( 0 Votes )
Payables
Written by Jouke de Groot   
Tuesday, 18 November 2008 18:29

One of the blessings in Payables R12 is the possibility to create online accounting.This allows the user to enter invoices and payments and post the accounting immediately in General Ledger. I found out that unexpected behaviour of this process can cause (temporarily of course after reading this post) a reconciliation difference.

Read more...
 
ARNL 11i.5.10 - Setup check
( 0 Votes )
Receivables
Written by Joske   
Wednesday, 02 April 2008 13:22
ARNL is the Duch globalization for Direct Debits, but the setup can sometimes be challenging ...

Symptoms

  • In 11i.5.10 release while setting up ARNL flexfields sometimes it is not possible to save the entered values.
  • In 11i.5.10 release the ARNL remittance request runs into error: ORA-04063: package body "APPS.XXDBI_BATCHES_PKG" has errors has been detected in LOAD_AI_LINES
Read more...
 
How to create Conditional Flexfield Validations
( 2 Votes )
General Ledger
Written by Jouke de Groot   
Tuesday, 13 November 2007 20:01

Securing or validating account combinations is an important topic to discuss during the implementation of Oracle Applications. Basically, two methods are available to perform security: security rules and cross-validation.This document covers a third method of account combination validation: I call it 'Conditional Flexfield Validation'. This method is particularly useful to secure the account and sub-account combinations.

more
 
Overview of TCA tables and their identifiers
( 1 Vote )
Receivables
Written by Jouke de Groot   
Tuesday, 30 October 2007 21:27

When writing quickly a query on customers (e.g. to check the data migration), it's not always easy to find your way through the TCA tables. I use this overview of tables with (foreign) keys to make life a bit easier. Hint: try to start with the views, as they contain already a lot of useful information!

Read more...