Have any question?
+2 0100 62 62 837
[email protected]
Register Login

Login with your site account

Lost your password?

Not a member yet? Register now

AppsLead | Learn Oracle From The LeadersAppsLead | Learn Oracle From The Leaders
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us
  • Home
  • Courses
    • About Courses

      • Free Training
        • Oracle ebusiness suite Free
        • Oracle Fusion Free
      • Online Live Training
        • Oracle ebusiness suite
        • Oracle Fusion
        • Oracle Database
        • Java & Middleware
      • All Training Courses
      • Training Schedule
      • Register For Live Course
      • Join Our Team
      • Exam Request
  • Blog
    • Oracle ebusiness Suite
      • Oracle Financial
      • Oracle HCM
      • Oracle SCM
    • Oracle Fusion
      • Fusion Financial
      • Fusion HCM
    • Our Authors
    • Be an Author
  • Schedule
  • FAQs
  • About Us
    • About Us
    • Our Services
    • Our Authors
  • Contact Us

Blog

  • Home
  • Blog
  • HRMS GOSI Migration

HRMS GOSI Migration

  • Posted by Sameh Bakkar
  • Categories Blog
  • Date March 19, 2011
  • Comments 0 comment
Hi guys today we will explain HRMS GOSI Migration

Declare
v_object_version_number    NUMBER;
p_comment_id               NUMBER;
p_soft_coding_keyflex_id   NUMBER;
p_effective_start_date     DATE;
p_effective_end_date       DATE;
l_date   date;
p_concatenated_segments    VARCHAR2 (250);
p_no_managers_warning      BOOLEAN;
p_other_manager_warning    BOOLEAN;
V_ERRCODE                  VARCHAR2 (3000);


begin

for i in (
SELECT object_version_number , gg.EFFECTIVE_START_DATE  , assignment_id
FROM per_all_assignments_f gg
where TO_NUMBER(TO_CHAR(EFFECTIVE_END_DATE,'RRRR')) > 4000
and SOFT_CODING_KEYFLEX_ID is  null)
--and  assignment_id  = 16547)

Loop
begin
hr_sa_assignment_api.update_sa_emp_asg
(p_effective_date              => I.EFFECTIVE_START_DATE , --sysdate,
p_datetrack_update_mode       => 'CORRECTION',
p_assignment_id               => i.assignment_id  ,
p_object_version_number       => i.object_version_number,
p_employer                    => '81',
p_gosi_num                    => 1,
p_gosi_annuities              => 'N' ,
p_annuities_branch_join_date  => SYSDATE  ,
p_gosi_hazards                => 'Y' ,
p_hazards_branch_join_date    => SYSDATE,
p_comment_id                  => p_comment_id,
p_soft_coding_keyflex_id      => p_soft_coding_keyflex_id,
p_effective_start_date        => p_effective_start_date,
p_effective_end_date          => p_effective_end_date,
p_concatenated_segments       => p_concatenated_segments,
p_no_managers_warning         => p_no_managers_warning,
p_other_manager_warning       => p_other_manager_warning
);
Commit;

dbms_output.PUT_LINE('DONE');
EXCEPTION
WHEN OTHERS
THEN
V_ERRCODE    := substr(SQLERRM,1,200);
dbms_output.PUT_LINE(V_ERRCODE|| i.assignment_id);



END;
end loop;
End;

Tag:HRMS, HRMS GOSI Migration, Migration

  • Share:
Admin bar avatar
Sameh Bakkar
Sameh Bakkar has over 15 years Oracle Applications implementation experience (EBS/Fusion) and he is an Oracle authorized trainer. He has in-depth technical and Functional knowledge of Oracle Applications and Oracle HCM Cloud. Sameh has excellent experience in Team management, Man Power and resource planning, and Pre-Sales management Process. Additionally he has also given Best Practices seminars on Oracle e-business suite and Oracle Fusion.

Previous post

HRMS Positions Migration in Oracle Applications
March 19, 2011

Next post

HRMS employee's Phone Migration
19 March, 2011

You may also like

  • Entering Request for Quotations (RFQ)
    19 June, 2012
  • HRMS Assignment Migration – API
    9 March, 2011

Leave A Reply Cancel reply

Your email address will not be published. Required fields are marked *

Search

Categories

  • Blog
  • Fusion HCM
  • Oracle ebusiness Suite
  • Oracle Financial
  • Oracle Fusion
  • Oracle HCM
  • Oracle SCM

Latest Courses

R12.x Oracle E-Business Suite Essentials for Implementers

R12.x Oracle E-Business Suite Essentials for Implementers

Free
R12.x Oracle HRMS Work Structures Fundamentals

R12.x Oracle HRMS Work Structures Fundamentals

Free
R12.x Oracle Payroll Fundamentals

R12.x Oracle Payroll Fundamentals

Free
AppsLead | Learn Oracle From The Leaders

+2 0100 62 62 837

[email protected]

Company

  • About Us
  • Blog
  • Contact Us

Links

  • Events

Copyright © 2017 AppsLead, All rights reserved. Developed by ECDSCS Co.

  • Privacy
  • Terms
  • Sitemap