This discussion is archived
6 Replies Latest reply: Nov 5, 2012 10:42 PM by 867787 RSS

Re: Saudi Direct Deposit issue

867787 Newbie
Currently Being Moderated
Hi,

I am facing a similar problem like others did in a previous forum thread:
Saudi Direct Deposit issue

After i run the PrePayments process i could see in SOE the correct values for Payment Method with all bank details and payment amount.

But when i run the Saudi Payment Output File i couldnt see the output file from the button View Output it gives me a message "Concurrent request did not create an output file".

Even we couldnt find any file on the server with extension as .mf

I checked in the Assignment Process Results for each assignment but could not find any record for Magnetic Tape.

I shall be thankful to you if you could let me know how you solved this issue.

Thanks,

Khan
  • 1. Re: Saudi Direct Deposit issue
    Vigneswar Battu Guru
    Currently Being Moderated
    Hi Khan,

    Did you go through the below -
    EFT File Is Not Generated And No Output For Saudi Payment Output File [ID 848057.1]
    What is the extension of Saudi Payment output file ? And where does it exist ? [ID 553518.1]
    Oracle HRMS for Saudi Arabia - Phase 3 [ID 263842.1]

    If you're running the processes in the same order you should be seeing the file under *$APPLCSF/out*
    1. PayRun( or QuickPay)
    2. Pre Payments
    3. Saudi Payroll Archiver
    4. Saudi Payment Output File

    Cheers,
    Vignesh
  • 2. Re: Saudi Direct Deposit issue
    867787 Newbie
    Currently Being Moderated
    Hi Vignesh,

    Thanks for your reply.

    I have gone through all these notes but no use. As per the Note: 848057.1 i have run everything in Sequence. Still unable to generate the file.

    In your reply you've mentioned to run Saudi Payroll Archiver. Is there any relation between Saudi Payment Output File and Saudi Payroll Archiver? As per the notes the archieved data is used to generate Payroll Register and Payslip report but not for bank file.

    However I run this process and after it was completed with staus as normal, i run the "Saudi Payment Output File" with no luck.

    Thanks,

    Khan
  • 3. Re: Saudi Direct Deposit issue
    Vigneswar Battu Guru
    Currently Being Moderated
    Hi Khan,

    Yep, Archiver is not needed for the EFT file.
    Did you make sure the start date of the EFT and prepayments are the same ?

    What does the log say ? Does the process error ?
    Can you check if the payroll_action_id for the request you created has any assignment actions created ?

    Cheers,
    Vignesh
  • 4. Re: Saudi Direct Deposit issue
    867787 Newbie
    Currently Being Moderated
    Hi Vignesh,

         I am sure I have given the same start date for EFT and prepayments processess.

    I have three records for each assignment in the tables PAY_PAYROLL_ACTIONS and PAY_ASSIGNMENT_ACTIONS.

    Action Type
    =========
    R = Payroll Run
    P = PrePayments
    X = Magnetic report

    Rather it should be four records one additional for Magnetic Tape which is missing.

    The log says the program has completed successfully without any errors. Below I have copied some parts of the log file.

    /*********************************************************
    SA_EFT module: Saudi Payment Output File

    Ended processing at : 05-NOV-2012 16:23:42
    Total Assignment count : 0
    Total Action count : 0

    -------------------------------------------------------------------------
    PL/SQL Output
    -------------------------------------------------------------------------
    -------------------------------------------------------------------------
    PL/SQL Output
    -------------------------------------------------------------------------

    Finished executing request completion options.

    Concurrent request completed successfully
    *********************************************************/
  • 5. Re: Saudi Direct Deposit issue
    Vigneswar Battu Guru
    Currently Being Moderated
    Hi Khan,

    You should definitely see a record in pay_payroll_actions -
    select * from pay_payroll_actions
    where request_id = <request_id> ;
    The records in assignment_actions depend on eligibility.
    The Saudi Payment output file is based on PYUGEN, so tough to debug as well.

    You can have some custom formulas for Header, footer and see if it works..
    Else I would suggest you to log an SR.

    Cheers,
    Vignesh
  • 6. Re: Saudi Direct Deposit issue
    867787 Newbie
    Currently Being Moderated
    Hi Vignesh,

    I found a record in pay_payroll_actions table against the concurrent request id with action type = 'M'.

    I've created custom formulas and used it but no way its working.

    I have already logged an SR with Oracle.

    Many thanks,

    Khan