EGL9.2: Allocation Not Working Upon If Custom Fields Inserted Into TAO Tables After SEQUENCE_NBR_9 Column

(Doc ID 2337391.1)

Last updated on DECEMBER 11, 2017

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Issue:
---------------
When adding custom fields to the any allocation temp tables[addition of custom fields are required if those fields are to be used in pool/basis/target/offset tab],  Allocation process runs to success, but no journals are created.


Steps to Replicate:
---------------------

1. Set up allocation step to have custom fields on pool/basis/target/offset tab field list.
2. Add custom fields to allocation temp tables.
   (Add fields after SEQUENCE_NBR_9 column. If this column is not present in temp table then custom fields can be added towards end of the record )
3. Include the allocation step in a process group.
4. Run Allocation process


Expected behavior:
----------------------
Allocation should create journals

Expected behavior:
----------------------
Allocation should create journals

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms