احتاج كورس oracle HRMS EBS 12 كامل مدفوع يحتوي على الاتي

1- core hr 
2- absence 
3- payroll
4- self service
5- talent 
6- recruiting 
7-OTL

عدد الافراد سكون 5

يرجى التواصل معي على الايميل لمن لديه امكانية اعطاء الكورس

انا مستخدم جديد لاوركال سؤالي هل يوجد مشاكل في الواجهات العربية للاوركال 

if you are interested,
please share your cv over whatsup to : 
 
 00971503640660
 00962786388341

Or Email 
mmalraie@gmail.com 
 

 Oracle E-Business Suite Installation and Upgrade Notes Release 12 (12.1.1) for Microsoft Windows Server (32-bit) [iD 761567.1]).

الملف الثانى

 (Recommended Browsers for Oracle E-Business Suite Release 12 [iD 389422.1]).

وشكرا ليكم مقدما
وجزاكم الله خير

ابحث عن مدرس خصوصي يشرح لي webservice rest  , soap  في نظام   oracle erp supply chain  

جوالي  0506699638

من خارج السعوديه   00966506699638

علما اني عن فاهم في  sql  , pl sql 

يفضل يكون حد شغال مش مجرد محاضر عشان هيبقي فيه شغل عملي . الكورس هيكون نقل جزء كبير فيه نقل خبرات عملية وعشان كدة العائد هيكون مجزي جدا جدا

الكورس شامل Essentials

المهتم ياريت يرسل محتويات الكورس على الميل apps.dev.job@outlook.com

ورقم الواتس 

كورس فيديو للاستاذ / سامح بكار بالعربى

http://www.araboug.org/ib/index.php?showtopic=52603

بعض الفيديوهات المجانيه من موقع سامح بكار

http://www.appslead.com/free-courses/

Oracle Financials دروس بالعربى

http://forum.arabseed.com/showthread.php?t=92021

http://www.mediafire.com/folder/cr34o5p325hx6/ESB

او دروس / الاستاذ خالد

http://forum.amrkhaled.net/showthread.php?473241-%DF%E6%D1%D3-%C3%E6%D1%C7%DF%E1-%DD%C7%ED%E4%C7%E4%D4%ED%E1-Oracle-Financial-%DD%ED%CF%ED%E6-%DA%D1%C8%EC

 او دروس / الاستاذ احمد حبيب

http://www.absba.org/showthread.php?p=10731701\

Oracle Supply Chain دروس بالعربى

http://www.mediafire.com/folder/26frxula1kndh,qqa7cia62842q,d9irzcocbf9uh/shared

دروس بالعربى Oracle Apps Developer للاستاذ / سامح بكار

http://www.mediafire.com/folder/x8mymycu6w4gc/Oracle_Apps_Developing

 Oaf Personalization - Oracle Discoverer  - EBS Forms Extension دروس بالعربى

http://www.araboug.org/ib/index.php?showtopic=51979

http://www.appslead.com/free-courses.html

Java- Oracle ADF - EBS Forms Customization دروس بالعربى

http://www.youtube.com/user/AppsStuff?feature=watch

  دروس بالعربى  Workflow

http://www.araboug.org/ib/index.php?showtopic=51979

http://www.appslead.com/free-courses/oracle-work-flow.html

موقع فيديو بالانجليزى

www.erpwebtutor.com

للتمرين حمل نسخهOracle Applications on VMware  من الموقع الاتى

http://www.mediafire.com/folder/cr34o5p325hx6/ESB

 او اتمرن  على احدى المواقع الاتيه مباشره

http://vis1213.solutionbeacon.net/OA_HTML/RF.jsp?function_id=1032925&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&params=sCrUCts8oybXeLFpvXhMOA

user: mg1011

pass: 1011mg

لعمل يوزر وباسورد خاصين بك على هذا الموقع من الفيديو الاتى

http://www.mediafire.com/download/zjhf8kdm25onycf/Solution-Beacon+-Account.wmv

سرفر ثانى للتدريب

http://ix-lin03-contractors.fs-server.com:8000/OA_HTML/RF.jsp?function_id=1032925&resp_id=-1&resp_appl_id=-1&security_group_id=0&lang_code=US&params=kHoI.D6Y6T8Gmqh-.aNK.A8N8.8dnrWe.DMROfsdMCk

Users : HRMS Group
Pass : 12345

سرفر ثالث للتدريب

http://demo.appshosting.com/OA_HTML/AppsLocalLogin.jsp

User: MFG

Pass: welcome

مواقع مفيده لأخذ الخبره فى الاوراكل

Facebook Pages and Groups:

 oracle hrms group

ORACLE HRMS GROUP – APPSSTUFF

Oracle HCM Consulting

oracle financial consultant

Oracle Financial Support Group

step systems

oracle 4 all

Oracle  Mr ahmed hakem

oracle consultants

oracle apps tech

arab oracle professional

oracle custom application

oracle apps professional

Training Sites

http://www.appslead.com

http://www.erpwebtutor.com

http://www.araboug.org/ib/index.php?s=d5e29cdaef3cfb1b5a8da16515c17ef8&showforum=34

http://arabhardware.net/forum/forumdisplay.php?f=169

http://arabteam2000-forum.com/index.php/forum/8-%D9%82%D9%88%D8%A7%D8%B9%D8%AF-%D8%A8%D9%8A%D8%A7%D9%86%D8%A7%D8%AA-oracle/

http://arabopn.com/vb/

http://www.araboug.org/ib/index.php?showforum=18

http://free4arab.com/

http://www.waqfonline.com/category/information-technology/programming/oracle-developer-g11

http://oracleapps4u.blogspot.in/

http://appsstuff.appshosting.com/apex/f?p=606:1:2810657392357409

http://www.youtube.com/user/AppsStuff/videos?flow=grid&view=1

http://www.4shared.com/dir/mtBufDBp/HRMS_course.html#dir=mtBufDBp

http://training-oracle-erp.blogspot.com/

Training centers

http://stepsystems.blogspot.com/

https://www.facebook.com/ERPNextAcademy

http://www.emakacademy.com

https://www.facebook.com/pages/Be-Expert/218503111610464

http://www.appslead.com

http://www.cdo-eg.com/

http://www.camecenter.com/

الفرق بين الوظائف اللي ممكن نسمع عنها في أوراكل اي بيزنس

Oracle Functional consultant
بيشتغل فى شركه سوفت وير ووظيفته انه يعمل إمبلمينت (اى تسطيب) لتطبيق لأوراكل المحاسبى او الموارد البشريه او المخازن والمستودعات عند العملاء اى الشركات التى تريد العمل على هذا التطبيق فى مقرها

وممكن يشتغل عند العملاء اى الشركات التى تستخدم  تطبيق أوراكل المحاسبى او الموارد البشريه او المخازن والمستودعات بحيث يكون وظيفته الدعم الفني أو اضافة اي تعديل فى التطبيق  الموجود فى الشركه

Techno-Functional Consultant

غاليا شغلة بيكون عند العميل فقط و عنده  نفس مسؤليات الفنكشنال كونسلتانت بالاضافه الى انه  بيعدل تطبيق الاوراكل باضافه شاشات او تقارير اضافيه حسب طلب العميل وبيستخدم بعض أدوات الديفلوبر زى التود و الديسكفرر وعارف الجداول بتاعت الاوراكل

 (APPS Developer)
يشتغل فى شركه سوفت وير و بيكون ديفلوبر اصلا وبيبقي مسئول عن اضافة شاشات و تقارير للعميل وتعديل شاشات حسب حاجه العميل وعنده ادوات ديفيلوبر اكثر من التكنيكال كونسلتانت ولايشترط انه يكون فاهم فانكشنال

الوصف الوظيفى للثلاث وظائف :

oracle functional and techno functional job description

ORACLE  HRMS Functional Consultant FOR QATAR (ARABIC)
==========================================================

Job Location: Doha, Qatar
Start Date: 2 weeks
Contract Duration: 6 months on site

Position Name: Oracle HRMS Functional Consultant
Experience: 2 Full Cycle Implementation
Role: Implementation and User training
Module: Core HR (Mandatory)
Payroll: (Mandatory)
SSHR: (Mandatory)
OLM – (Optional)
iRecruitment – (Optional)

Kindly send us your CV ASAP on the following Email Id:

Attention: Mr. Abu Qadar Khan
Email Id: benghazits@gmail.com

Oracle Financial Functional Consultant for Qatar (Arabic)
===================================
Job Location: Doha, Qatar
Project Duration: 6 Months
Start Date: ASAP

Oracle Financial Functional Consultant (AR,AP,GL,CM, FA)
Min 3 full cycle implementation experience
Role: New implementation and user training on Oracle R12

Oracle HRMS techno functional Consultant for Qatar (Arabic)
===================================
Job Location: Doha, Qatar
Project Duration: 6 Months
Start Date: ASAP

Oracle Technical Consultant Knowlwdge of OAF, Work Flow and User Hook.
Functional Knowledge of HRMS
Role: Techno-Functional Support on Implementation Project.

Please send us your CV ASAP on the following email:

Attention: Mr. Abu Qadar Khan
Email: benghazits@gmail.com

oracle apps developer

Skills required

ü   Strong Data Modeling skills

ü   Strong SQL coding and tuning skills

ü   Strong PL/SQL coding skills

ü   Strong knowledge in creating Functions, Stored Procedures And Packages in Oracle DB

ü   Data Modeling using Oracle Discoverer Administrator

ü   Create reports in Discoverer  and Publishing reports To web

ü   Knowledge in creating oracle forms

ü   Experience in ETL Tools like OWB is desirable

-          Assigned Tasks

ü   Writing PL/SQL codes to perform ETL operation

ü   Be able to set up and maintain the End User Metadata Layer (EUL) using Oracle Discoverer Administrator

ü   control access to information in Oracle Discoverer

ü   create conditions and calculations for Discoverer end Users include in their worksheets

ü   Be able to create Oracle forms to validate data quality

ü   Understanding of DW/BI concepts and ability leverage DW/BI best practices in current system

ü   Publish the reports on the web

The candidate will be Hired and Assigned for a Task in Qatar for 6 Months Then Egypt

3-5 Years Experience is Required

If you Are Interested please Send Your CV to HR@ste-eg.com with The Expected Salary, a Recent Photo and a copy of your Passport if Possibles with REF#QAT_DEV

شركات السوفت الى بتقدم حلول اوراكل  (منقول من المنتدى)

انت جديد , وبتدور علي شركات تشتغل فيها انت قدامك طريقين تشتغل فيهم على ال oracle application  يا اما استشارى او انك تكون يوزر زى موظف hr  او محاسب يعمل على ال application  ك data entry

اسماء الشركات السوفت وير الى ممكن تعمل عندها كاستشارى oracle consultant  وعلشان توصلهم :

1- تظبط سي في كويس كده وتبعتلة علي الميل وهاتجيب الميل من ع موقعهم .
2- نتواصل معاهم مع التليفون
3- نروح ليهم بنفسنا نسيب السي في وكمان نحاول اكتر اننا نقابل اى حد من جوة

Implementation Company

http://www.oprof-rec.com/اكاديميه ايماك لتوظيف الاوراكل   فقط  

http://www.egabi.com/

http://www.qemmah.com/

http://www.delta-sw.com/

http://www.catalyst-us.com/index.aspx

http://www.unitedconsultants-is.com

http://www.datagearbi.com/

http://www.efinance.com.eg/

http://www.etqan-tech.com/etqan-tech/

http://www.dmsegypt.net/

http://www.sphere-consulting.com/      hr@sphere-consulting.comv mdahab@sphere-consulting.com

http://www.ots.com.eg

http://www.microtech-eg.com/     cv to email    hr@microtech.com.eg

http://www.itsoft.com.eg

http://www.rayacorp.com

http://www.networksvalley.com

http://wwwpremium-skills.com

http://www.unitedconsultants-is.com

http://www.gizasystems.com

http://www.inatech.com

http://www.oratech-eg.com/

http://www.rayaintegration.com/

http://www.2e2s.net

http://www.hits-consulting.com

http://www.emakacademy.com/

http://www.meitweb.com

http://www.gizasystems.com

http://www.bbs.com.eg

http://www.gbn-net.com

http://www.cite.com.eg

http://www.fvsoft.com

http://www.comsyssoftware.com

http://accentia-me.com/          send  CV to hr@accentia-me.com

http://www.informatique-eg.com/

http://stepsystems.blogspot.com/       www.step-eg.com

http://www.talent-bay.com/services/career-counselling/

http://www.appspatrols.com/now/

http://www.andalusiagroup.net/

Ahmedtherock5@gmail.com

eng_mohamed_maher@yahoo.com

http://globalresources-it.com/

CV@AppsLead.com

Giza Systems
Certified Advantage Partner
17, Tiba Street
Mohandeseen
12311 Cairo
Egypt

اسئله انترفيو فى اوراكل الموارد البشريه
 

ORACLE HRMS functional and techno functional  Interview questions and answers

First Part:

Q1) What is the difference between a Job and a Position?

Job is general one, whereas Position is specific term to its role and responsibilities.

JOB:            MANAGER (generic term), SOFTWARE DEVELOPER

POSITION:  Finance Manager, HR Manager, Junior SOFTWARE ENGINEER, (this is position which is   specific to the role to be played.

Q2) What are the difference between extra information type (EIT) and special information type (SIT)?

EIT and SIT Both are provided by Oracle to Capture Extra Information. Basic differences would be EIT is similar like a DFF and also defined using DFF Definition Screen. SIT is KFF and defined using Personal Analysis KFF Definition screen.

SIT generally used at Person Level, EIT can be defined at PERSON, ASSIGNMENT, CONTACT, ELEMENT, LOCATION and JOB LEVEL.

There are 2 columns date_to and date_from in SIT while no such columns are there in EIT.

Q3) Tell me the name of important Key Flex-Fields (KFFs) in Oracle HRMS?

Job KFF,

Grade KFF,

People Group KFF,

Position KFF,

Cost Allocation KFF,

Comptence KFF

Q4) List of some Important Tables in HRMS

Per_all_people_F,

per_person_types,

per_person_type_usages,

per_addresses,

Per_all_assignments_f,

per_jobs,

per_job_Definitions,

per_grades,

per_grade_definitions,

hr_all_positions,

hr_all_position_definitions,

hr_all_locations,

pay_all_payrolls_F,

pay_element_entries_F,

pay_elements_links_F,

Q5) What is the difference between both SECURED VIEWS and NON SECURED VIEWS?

1.Secured views display information only for the current period

2.Unsecured views is used to get the information from the entire rows

Q6) Define APIs and use in Oracle HRMS?

API’s are used in HR to insert the data into the Base tables. As it’s very secured system, the user does not have the facility to copy the data directly into the Base tables. When we write the inbound interfaces / use WebAdI, the systems will use the APIs to store the data into system. The API are published by oracle with number of parameters. The different types of parameters are IN / INOUT / OUT of these parameters few are mandatory, without which the process won’t complete. Generally when we use API we give data FOR : Object Version Number, Effective Date, P_Validate

HR_EMOYEE_api example: hr_employee_api.create_employee

hr_organization_api Example: hr_organization_api.create_organization

hr_assignment_api

Q7) What are processing types of element?

Elements are nothing but the components of the salary.

For Example: Basic Salary, House Allowance, Transport Earning, Bonus, Loan Recovery etc.

There are 2 types of Processing

1. Recurring: if an entry of this element applies in every period until the entry is ended

2. Non Recurring: if an entry applies in one pay period only.

Q8) What are termination roles of an element?

Termination Rules of an Element:

a).Actual Termination:  For a nonrecurring element, select Actual Termination if you want the entries to close down at the end of the pay period in which the employee leaves.

.Final Close: if you want the entries to stay open beyond the employee’s leaving date so that you can continue to pay the employee.

c).The Last Standard Process date defaults to the last day of the pay period in which the employee is terminated, but you can set it to a later period when you terminate an employee.

Q9) What is costing?

Costing:

Recording the costs of an assignment for accounting or reporting purposes, Using Oracle Payroll, you can calculate and transfer costing information to your general ledger and into systems for project management or labor distribution.

Q10) What are 2 modes of date track in Oracle APPS?

There are two Date Track modes are as follow:

*Update

*Correction

Q11) Can a job has multiple positions?

Job is generic. Yes a job can have multiple positions.

Q12) Can you call PL/SQL Package functions from within a Fast Formula?

Yes you can

–>how do we do this?

There is a Define Function screen in HR. In this screen you will register the PL/SQL as “External Function”.

Q13) Can we want to pass a parameter PAYROLL_ID to this external PL/SQL Function, how do we do it?

The “Define Function” screen has a button named “Context Usage”. This button opens up a window in which you can register the parameters.

Q14)  How do you debug a Fast Formula?

You can create a message variable in Fast Formula.

This message variable must also be registered as a Formula Result ( In “Formula Result Rule” window).

Q15)  What are the various levels where you can Set up Payroll Costing Accounts?Which levels take the highest precedence?

Element Entry => Highest

Assignment => Second Highest

Organization => Third Highest

Element Link => Fourth Highest

Payroll => Fifth Highest

Q16) Technically speaking, how do you know from tables that an Employee has been terminated?

(a) The Person_Type_ID in PER_PERSON_TYPE_USAGES_F will correspond to System Person Type EX_EMP

( A record gets created in table PER_PERIODS_OF_SERVICE with Actual_Termination_date being not null

Q17) How can you make Employee Number generation Automated based on business rule etc?

Use Fast Formula.

Q18) What is the difference between per_people_f and per_all_people_f?

PER_PEOPLE_F is a secured view on top of PER_ALL_PEOPLE_F. The secure view uses an API hr_security.show_person. This API internally checks for an entry in table PER_PERSON_LIST for the logged in person’s security profile. A concurrent program named “Security List Maintainence program” will insert records in PER_PERSON_LIST.

Q19) If you do personalization at both FUNCTION level and Responsibility level, which personalization has higher precedence?

Responsibility level. Responsibility level will override FUNCTION level personalization’s.

Q20) Say you have done a lot of Personalization’s to Self Service Screens. But all these Personalization’s were done in DEVELOPMENT environment. How will you migrate these personalization’s to PRODUCTION environment?

Before 11.5.7…Use AKLOAD

This is a java program given by Oracle. This is the only way you can script it.

In DEV you will do AKLOAD DOWNLOAD ( & other parameters)

In PRD you will do AKLOAD UPLOAD ( & other parameters)

On or after 11.5.10 Use responsibility “Functional Administrator”, then click

on Personalization Tab, and then click on Import/Export.

Next select the documents to be exported.

Go to the UNIX box and tar the personalization’s into a .tar file.

On the Production environment unzip this tar file in location as entered in profile “FND: Personalization Document Root Path”.

Setting up of this profile is mandatory or else Oracle Framework wouldn’t know where to search for the files to be imported.

Q21) How to restrict iRecruitment external visitors to access only responsibilities on the external server?

Set the Server Trust Level for the server to External, Set the Trust Level of the iRecruitment external responsibilities to External too.

Q22) Is SSHR a dependency for iRecruitment?

iRecruitment has no dependence on SSHR

Q23) Does iRecruitment support “Candidate Qualifying Questionnaires” where the candidate must answer vacancy-specific questions correctly prior to submitting an application?

iRecruitment currently does not support this function, For now this can be achieved by having a set of simple questions using flexfield to get those responses and a user hook to validate them as part of the apply process.

Q24) Do we track vacancy history?

iRecruitment does not track changes to the vacancy. If changes to a field are to be traced use the Audit capability in APPs.

Second Part:

What are the minimum classifications to create a Business Group?

(i) Business Group

(ii) GRE/Legal Entity

(iii) HR Organization

What are the Pre-Requisites for creating a Business Group?

(i) Value Sets

(ii) Key Flexfields

(iii) Location

What is the use of HR Organization?

If we want to assign the employee information to a Business Group then we need to have HR Organization classification under a Business Group.

What is People Group?

(i) It is a Flexible area for holding user-defined assignment data.

(ii) Data can be used for Grouping sets of assignment together.

(iii) People group can be used for Element eligibility.

(iv) This information is used by the Payroll Run.

(v) The data will be held in PAY_PEOPLE_GROUPS.

(vi) GROUP_NAME field holds the concatenation of Segment data.

What is the KFF structure for SIT?

Personal Analysis Flexfields.

What is the DFF structure for EIT?

(i) Extra Person Information

(ii) Assignment Extra Information

(iii) Extra Location Information

(iv) Extra Position Information

(v) Extra Job Information

(vi) Organization Developer DF

How to enable EIT?

Switch Responsibility to ‘Human Resources, Vision Enterprises’

Double click on ‘Security’

Click on ‘Information Types’

Create your own ‘Information Types’ under your ‘Responsibility Name’.

How to enable SIT?

Switch Responsibility to ‘Human Resources, Vision Enterprises’

Double click on ‘Other Definitions’

Click on ‘Special Information Types’

What is the use of Date Track?

1) It is used to maintain the record history by creating a new record when the date track mode is UPDATE and override on the existing record when the Data track mode is CORRECTION.

2) The value of the Data Track record depends on the date.

3) Tables ending with _F are date track tables.

4) To control data tracked rows, every Date Track table must include Effective_start_date & Effective_end_date.

5) The Effective_Start_Date indicates when the record inserted.

6) The Effective_End_Date indicates when the record updated or deleted.

What is the use of Object Version Number?

1) It is used to capture the latest record from the data base table.

2) When a row is inserted its number is set to 1.

3) If any updates performed on the row then the OVN is incremented.

4) Every API has the OVN parameter.

5) For create API this parameter is defined as an OUT parameter.

6) For update API this parameter is defined as an IN OUT parameter.

7) The APIs use it to check a row has been updated by another user, to prevent overwriting their changes.

What is the Element?

It is a Data Structure which is used to hold information for both Human Resources and Payroll.

In Human Resources elements may represents compensation types including Earnings such as Salary, Hourly Wages and Bonuses.

In Payroll, elements constitute all the items in the Payroll run process.

What are the Classification Priorities?

(i) Information

(ii) Non-Payroll

(iii) Earnings

(iv) Pre-Tax Deductions

(v) Tax Deductions

(vi) Employer Tax

(vii) Voluntary Deductions

(viii) In Voluntary Deductions

What the Element can represent?

Earnings –> such as Salary, Wages & Bonuses

Benefits –> such as employee stock & pension plans

Non-Payroll items –> such as Expenses

Absences from work

Voluntary and In-Voluntary deductions

Employer Taxes and other Liabilities.

What are the pre-defined Elements?

UK Payroll legislation provides many predefined elements

–Tax

–National Insurance (Employee/Employer)

–Court Orders

These Elements cannot be modified.

What are the Element Entry Concepts?

Recurring à Recurring Entries can exists over many Payroll periods

Non-Recurring à Non-Recurring Entries are valid for single Payroll period only.

What are the types of Element Entry?

There are four types

Normal Entry

Override Entry

Additional Entry

Adjustment Entry

–Additive Adjustment

–Replacement Adjustment

–Balance Adjustment

How can we add a new input value to an existing Element?

We can add an additional input values to an existing Element if the element has not been processed in a Payroll run and the Effective data is the same date of creation of the Element.

What is the use of ID_FLEX_NUM?

It is used to define the Structure Definition.

The Structure Definition is held in FND_ID_FLEX_STRUCTURES

The Structure Segment Definition is held in FND_ID_FLEX_SEGMENTS

What is the Element Link?

Links identify one or more assignment components that must be included in an employee’s assignment for them to be eligible.Elements can, but they don’t have to, be linked by: Organization GroupJob PositionGrade LocationEmployment Category (i.e., Fulltime-Regular, Part-time-Regular)

Payroll Salary Basis

What is API?

Ø API is packaged procedure which can be used as an entry point into Application.

Ø The advantage of using an API is we can enter new information or alter the existing data without manual enters the information into the Application.

Ø APIs allow users to maintain HRMS information without using Oracle Application forms.

How do i use an API to upload the data?

Ø API package contains many procedures to insert/update/delete the application data.

Ø The API is not executed on its own, the API must be called or executed by other pl/sql program.

Ø The API package should never be modified for custom use, if modified Oracle will not be able to support them.

Ø None of the HRMS APIs issue commit, the calling module should manage the commit of the transaction.

How do i identify the Package name and version of the API?

SELECT text

FROM all_source

WHERE name like ‘HR_EMPLOYEE_API%’

AND text LIKE ‘%Header%’;

Where can i find information on an API and its parameters?

Review the package header file for the particular API file (.pkh).

What is Object version number and how do I assign values for it in an API?

Ø Object Version number is an assigned number to a row in a database table.

Ø When a new row inserted its number is set to 1

Ø If any updates performed on the row then the Object version number is incremented.

Ø Every API has the p_object_version_number control parameters.

Ø For create APIs this parameter is defined as an OUT parameter the API assigns the Object version number to be 1 for row inserts.

Ø For update APIs the parameter is defined as IN OUT, for update API the object version number is mandatory.

When the HR_7155_OBJECT_LOCKED raised?

The current value of object_version_number must be passed in the API call and it is compared to the version on the row in the table. If the versions are different then the HR_7155_OBJECT_LOCKED is raised.

What is the p_validate control parameter?

Every API has a p_validate control parameter.

When the parameter is set to FALSE then all the business function validation is performed.

If every thing is validated then row can be inserted/updated/deleted.

If p_validate is set to TRUE then only the actual operation is validated.

A savepoint is issued at the start of the call and a rollback is done at the end of the call.

Can I use an API on an application table on which an event-based alert is defined?

Ø No, if an event-based alert defined on an application table then the API will give error.

Ø To run API the alert has to be disabled and re-enabled after the API has been executed.

What is the difference between an API and a publicly callable API?

Ø An API is an alternative entry for data to be insert/update/delete from the application.

Ø The Oracle HRMS

Ø Publicly callable APIs engage in validation in the same manner as the forms do with in the application.

Ø Validation is performed in terms of data integrity, insuring that data relationship exist properly between related tables.

Ø Validation is also performed against business functionality as the application form would enforce it.

Ø Therefore, only publicly callable APIs should be used to insert/update and delete data from the application.

oracle application arabic videos links.rar

واجهت مشكلة لما جيت أعمل  run لأي فورم من داخل الأوراكل erp بتظهر لي رسالة 

In order to access this application, you must install the J2SE Plugin version 1.6.0_07. To install this plugin, click here to download the oaj2se.exe executable. Once the download is complete, double-click the oaj2se.exe file to install the plugin. You will be prompted to restart your browser when the installation is complete.

الحل: إستخدامنا لل Internet Explorer وعمل الخطوات التاليه :

1- عمل uninstall لكل الجافا علي الجهاز

2- تنزيل برنامج وتسطيبه Java_Runtime_Environment_(64bit)_v8_Update_231

3- افتح internet explorer >>>internet options >>>security >>internet >> custom level>> Enable XSS filter>> Disable>> ok

4- control panel>> programs >> java>> security >>Edit list site>> add 

في الخطوة دي بتحط لينك ERP بتاعك  وبيكون شبه ده 

http://erpprod.fin.com:8000/

الحقيقه انا كنت تعبت من فيديوهات الهنود عن اوراكل فيوجن ، و بحثت كتير قوى عن دورات بالعربى لاوراكل فيوجن لكن دون جدوى ،، لكن الحمد لله الان وجدت موقع AppsLead بيقدم دورات فيوجن عربى و اون لاين كمان ، فحبيت افيد الجميع و كمان فيه فيديوهات مجانيه عن اوراكل فيوجن يلا استعدوا لطلبات الماركت و جهزوا نفسكم و ربنا يقوينا جميعا على اوراكل و تطوراتها الاسبوعيه

انا شوفت الفيديو على على موقع AppsLead و بصراحه منظر الفيوجن تحفه و الامكانيات اللى فيها اكثر من رائعه و دا رابط الفيديو:

http://www.appslead.com/free-courses/oracle-fusion-applications.html

كمان فيه كورس هايبدا قريب عن اوراكل فيوجن و الكورس اون لاين ودا رابط الكورس لتعم الفائده

http://www.appslead.com/e-learning-courses/oracle-fusion-applications.html

لا تنسونا بالدعاء و الى الامام دائما و لو اى حد عنده معلومه عن فيوجن يا ريت ما يبخل علينا و لو فيه اى روابط نذاكر منها ياريت بس تكون عربى طبعا زى فيديوهات  AppsLead

اتمنى الافادة

وشكرا

فى علامة     الدبوس فى القائمة 

Doc1.docx

Kindly note that i have EBS 12.2

during define calendar period i set September as start from 2-sept-2021

how to fix it to start from 1-sept-2021

محتاج ال EBS VM بتاعت ال Vision  ... أي حد في القاهرة أقدر أقابله وأخدها منه وشكرا

ضروري للتطبيق عليه لاني بدرب HRMS

انا من القاهرة وجزاكم الله خيرا

مساء الخير 

ابحث عن مدرب اوراكل hr  خاص او ملخصات للمادة 

في الرياض 

او لو يوجد حد محترف ممكن انصق معاه كورس online