Who's Online Now
0 registered members (), 3 guests, and 11 spiders.
Key: Admin, Global Mod, Mod
Newest Members
rdeshab, samba, kkshahbaaz, dpf6jbez9, hcmconfig
1293 Registered Users
Recent Posts
Retrieving Balances using SQL
by CT. 04/12/19 11:01 AM
IR35 Legislation
by CT. 04/12/19 11:00 AM
Help > Diagnostics > Examine
by CT. 26/11/19 12:25 PM
Top Posters(30 Days)
delboy 7
CT 6
SBi 1
Popular Topics(Views)
488,453 PAYE RTI
58,999 HR_PF.K RUP4
Previous Thread
Next Thread
Print Thread
Rate This Thread
#12156 - 20/06/18 02:45 PM Wrapper script -issues when calling 'RTI - Full Pa  
Joined: Aug 2015
Posts: 42
pxlewis Offline
enthusiast
pxlewis  Offline
enthusiast

Joined: Aug 2015
Posts: 42
Our developer here, has had to look at re-writing his wrapper script to call the RTI FPS process for the new XML version of 'RTI - Full Payment Submission Process (FPS) 2018/2019'. This used to spawn seperate runs against each payroll. But with new parameters for the concurrent program not able to get this to work as has done before. So getting java errors as below

Anyone else come across this - assume other clients will have previously looked to use wrapper
scripts potentially for this need...


Raised with Oracle with the wrapper script call and error stack but no response currently

------


Payroll: Version : 12.1

Copyright (c) 1998, 2013, Oracle and/or its affiliates. All rights reserved.

GBIREXE: GB IRMark Generator
+---------------------------------------------------------------------------+

Current system time is 03-MAY-2018 10:59:40

+---------------------------------------------------------------------------+

Entering generateIRMark
inside while nvtARCHIVE_REQUEST_ID
value 51
requestId 51
inside while nvtARCHIVE_REQUEST_ID_HIDDEN
value PAY_GB_XML_SUBMISSION_DTLS
tableName PAY_GB_XML_SUBMISSION_DTLS
aftre while
getIRMark
java.lang.NullPointerException
at oracle.apps.pay.xmlrep.webui.PayGBIRGeneratorCP.clobToString(PayGBIRGeneratorCP.java:281)
at oracle.apps.pay.xmlrep.webui.PayGBIRGeneratorCP.getIRMark(PayGBIRGeneratorCP.java:224)

------

Regards
Peter L.

#12158 - 04/07/18 10:13 AM Re: Wrapper script -issues when calling 'RTI - Full Pa [Re: pxlewis]  
Joined: Oct 2014
Posts: 7
sheebs Offline
lurker
sheebs  Offline
lurker

Joined: Oct 2014
Posts: 7
Newcastle Upon Tyne
Is the wrap around script used to view the concurrent output in the screen rather than in Database directory?

#12160 - 04/07/18 10:33 AM Re: Wrapper script -issues when calling 'RTI - Full Pa [Re: pxlewis]  
Joined: Jul 2011
Posts: 117
Jay Kavia Offline
nothin' better to do
Jay Kavia  Offline
nothin' better to do

Joined: Jul 2011
Posts: 117
UK
Hi Peter,
We don't have a wrapper script for this particular concurrent program, but we do for about 20 others and it's worked without fail (we use an AUL to group payrolls into blocks of 30 or so), so not sure what is different with this particular one but I'd be interested in the outcome.
Anytime we've previously had an issue it's been due to a parameter mismatch for what is actually sent to the concurrent program.
Regards, Jay

#12171 - 24/07/18 10:19 AM Re: Wrapper script -issues when calling 'RTI - Full Pa [Re: Jay Kavia]  
Joined: Aug 2015
Posts: 42
pxlewis Offline
enthusiast
pxlewis  Offline
enthusiast

Joined: Aug 2015
Posts: 42
Hi Jay,
For reference this did end up going to Oracle Support/Development and issue was found to be a 'hidden' parameter that hadn't been defined in the wrapper program and caused the error when not being set...

Regards
Peter

------

"The issue occurs because MAGFILE_GENERATE_IN_FS parameter is null.

Parameter details:
Magfile Generate in FS
SELECT 'MAGFILE_GENERATE_IN_FS='||DECODE(:$FLEX$.PAY_GB_XML_STORAGE_MODE,
'FSD', 'Y', 'SD', 'N' )FROM sys.dual

Problem -
MAGFILE_GENERATE_IN_FS should be 'Y'. Currently, this parameter is not defined while submiting the concurrent program request, thus, it is coming as null in the backend.
Solution - Add another argument with 'MAGFILE_GENERATE_IN_FS=Y' "


Moderated by  CT, delboy 

Forum Statistics
Forums60
Topics2,226
Posts12,024
Members1,294
Most Online195
Nov 16th, 2019
Today's Birthdays
No Birthdays
Recent vacancies
Top Posters(All Time)
CT 2,113
delboy 1,306
bcooper 1,291
paulgos 439
SBi 427
pat 254
Gus 252
vkumar 223
December
S M T W T F S
1 2 3 4 5 6 7
8 9 10 11 12 13 14
15 16 17 18 19 20 21
22 23 24 25 26 27 28
29 30 31
Powered by UBB.threads™ PHP Forum Software 7.6.0
Page Time: 0.019s Queries: 15 (0.006s) Memory: 2.7557 MB (Peak: 2.9061 MB) Zlib disabled. Server Time: 2019-12-13 01:10:38 UTC