Create and Maintain Company Cost Center Organizations process End Dates Organizations (Doc ID 1925145.1)

Last updated on JULY 06, 2016

Applies to:

Oracle Human Resources - Version 12.1 HRMS RUP6 and later
Information in this document applies to any platform.

Symptoms

On:

Production instance patched at R12.HR_PF.B.delta.6 pacth 16000686 with Oracle Payroll installed for ZA legislation (South Africa),
when running 'Create and Maintain Company Cost Center Organization' with sync start
and end dates option = Yes
the process end dates orginazations even though the balancing entity and cost centre values are not end-dated
and the following error occurs.


ERROR
-----------------------
ERROR #4:err=942 tim=1517379932487
CLOSE #18446744071453238272:c=0,e=7,dep=1,type=0,tim=1517379932751
EXEC #18446744071458229128:c=0,e=483,p=0,cr=0,cu=18,mis=0,r=1,dep=1,og=1,plh=3836922170,tim=1517379933488
CLOSE #18446744071458229128:c=0,e=2,dep=1,type=3,tim=1517379933535
PARSE #18446744071461280448:c=0,e=8,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=0,plh=0,tim=1517379933630
XCTEND rlbk=0, rd_only=0, tim=1517379933663
EXEC #18446744071461280448:c=0,e=72,p=0,cr=0,cu=1,mis=0,r=0,dep=1,og=0,plh=0,tim=1517379933723
CLOSE #18446744071461280448:c=0,e=2,dep=1,type=3,tim=1517379933750
EXEC #18446744071458229128:c=0,e=232,p=0,cr=0,cu=19,mis=0,r=1,dep=1,og=1,plh=3836922170,tim=1517379934062
CLOSE #18446744071458229128:c=0,e=1,dep=1,type=3,tim=1517379934100
XCTEND rlbk=0, rd_only=0, tim=1517379934124
EXEC #18446744071461280448:c=0,e=39,p=0,cr=0,cu=1,mis=0,r=0,dep=1,og=0,plh=0,tim=1517379934160
CLOSE #18446744071461280448:c=0,e=1,dep=1,type=3,tim=1517379934185
EXEC #18446744071458229128:c=0,e=163,p=0,cr=0,cu=18,mis=0,r=1,dep=1,og=1,plh=3836922170,tim=1517379934424
CLOSE #18446744071458229128:c=0,e=1,dep=1,type=3,tim=1517379934459
XCTEND rlbk=0, rd_only=0, tim=1517379934481
EXEC #18446744071461280448:c=0,e=35,p=0,cr=0,cu=1,mis=0,r=0,dep=1,og=0,plh=0,tim=1517379934513
CLOSE #18446744071461280448:c=0,e=1,dep=1,type=3,tim=1517379934534
XCTEND rlbk=0, rd_only=1, tim=1517379935020
=====================
PARSING IN CURSOR #18446744071453238272 len=150 dep=1 uid=61 oct=1 lid=61 tim=1517379935314 hv=253223829 ad='3889edac0' sqlid='gnv56j07jgswp'
CREATE TABLE HR.HR_CO_CC_TEMP_21 ( coa_id NUMBER(15) , co VARCHAR2(240) , co_vs_id NUMBER(15) , cc VARCHAR2(240) , cc_vs_id NUMBER(15) )
END OF STMT
PARSE



STEPS
-----------------------
The issue can be reproduced at will with the following steps:

1. Run the Create and Maintain Company Cost Center Organizations requests with sync start and end dates option = Yes

2. Receive error.


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, HR orginazations are incorrectly being end-dated to which the budget centre owners are attached.
This is causing no approvers to be found as customer uses Budget centre owners in the AME approval of IExpenses, Requisitions, etc.

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