My Oracle Support Banner

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

Last updated on JANUARY 08, 2020

Applies to:

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

Symptoms


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 #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.


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
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.