My Oracle Support Banner

EEX 9.1+: DEPT_ID in EX_ACCTG_LINE Table Is Not Being Populated from the EX_SHEET_DIST Table (Doc ID 2340894.1)

Last updated on JULY 21, 2020

Applies to:

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

Symptoms

The Department ID in EX_ACCTG_LINE table is not being populated from EX_SHEET_DIST line

 

Steps:

1. Create and submit an expense report with 2 lines - each line having a different department ID than the employee's department ID from the profile. Now get it approved.
2. Post liabilities, check the PS-EX_ACCTG_LINE table and note that the DEPTID populated from the employee profile and not from the EX_SHEET_DIST.

 Actual Result:

The Department ID in EX_ACCTG_LINE table is not being populated from EX_SHEET_DIST line

Expected Result:

The Department ID in EX_ACCTG_LINE table is populated from EX_SHEET_DIST line

Please see the replication steps document for more details.

NOTE: In the  attached document, user details / company name / address / email / telephone number represent a fictitious sample (based upon made up data used in the Oracle Demo Vision instance).  Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.