Labels

2017 absence absence management Account accounting AIM aliases AME and API application application utilities lookups approval assignments ATO Australia Bank bi publisher budget business business groups CAGR candidates cartisian product case CEMLI Center Stage channels Classification competency concurrent Configuration configuration profile constants contextualization conversion correction cost costing coverage area customization data database date DateTracked deductions define design develop DFF diagnostics document earnings ebs EIT Element employee enhancements erp excel expression extension failure Fastformula FBT Flexfield FND fndload foreign key forms Formula fringe benefit FRM-40654 from FTE Functions fund fusion GL global transfer grade help hierarchy HR HRMS human resource management system implementation income information interfaces internet interview job join key flexfield KFF KPI language learning leave legal employer legislation links lists localization location management New Year obia obiee OLF onboarding oracle oracle applications oracle descriptive flex field oracle descriptive flexfield oracle ebs oracle erp oracle fusion HCM oracle hrms oracle hrms interview questions oracle hrms modules oracle hrms modules list oracle hrms organization oracle hrms table oracle hrms tables oracle hrms tutorial oracle irecruitment oracle legal entities oracle lookups oracle organization hierarchy oracle payroll oracle payroll interview questions oracle payroll tables oracle self service order by Organization organization type otbi package package body package specification patch payg Payment payroll people group perform person personalisation phase pl/sql position primary key process profile programs project qualifier Query question questions Recruiting Center Recruitment regex regular expression reporting tool reports requests requirement requisition resume retropay RICE salary schema security profile select SIT smartorg sql statutory stores STP Super Superannuation system systems Table Taleo taleo 15B Taleo Recruitment tax termination test testing trunc update user group user management user type value set variables View Views Web ADI webadi where work relationship

Sunday 30 July 2017

Integrated SOA Gateway - Finding API details within Oracle EBS

Oracle EBS Integrated SOA Gateway is the intrinsic part of Oracle E-Business Suite for service enablement. It provides the capability of invoking Web services and allowing Web service clients to make use of the services provided from Oracle E-Business Suite.




Oracle Integration Repository contains numerous interface endpoints exposed by applications throughout the entire Oracle E-Business Suite. It is not only an essential component within Oracle E-Business Suite Integrated SOA Gateway, but also provides a complete catalog of integration interfaces within Oracle E-Business Suite. You can use this tool to easily discover and search on interfaces, regardless of custom or Oracle seeded ones.

Major Features

  • A unified repository from which all integration interface types are exposed.
  • Updates are automated and documented.
  • Catalog is searchable on keywords and navigable by product family.
  • A powerful user interface to help you find the data you are looking for from the repository.
  • It supports composite services containing a collection of native interfaces.
  • It enforces security rules to allow only authorized users to perform administrative tasks such as generate and deploy Web services.
  • It supports custom integration interfaces.

Under the ‘Product Family’ view, Navigate to Human Resources Suite > Payroll > HRMS element entry


Select Element Entry API to view details

Click on ‘Delete Element Entry’

It will give you information on what this API function is about, its parameters, etc.

Description
This API deletes an existing element entry and element entry values. The role of this process is to perform a validated delete of an existing row in the pay_element_entries_f table of the HR schema
Licensing
This API is licensed for use with Human Resources.
Prerequisites
The element entry must exist at the deletion date.
Post Success
The element entry and the element entry values will have been deleted.
Post Failure
The element entry and element entry values will not have been deleted and an error will be raised.


Parameters (IN)

P_VALIDATE
If true, then validation alone will be performed and the database will remain unchanged. If false and all validation checks pass, then the database will be modified.

P_DATETRACK_DELETE_MODE
Indicates which DateTrack mode to use when deleting the record. You must set to either ZAP, DELETE, FUTURE_CHANGE or DELETE_NEXT_CHANGE. Modes available for use with a particular record depend on the dates of previous record changes and the effective date of this change.

P_EFFECTIVE_DATE
Determines when the DateTrack operation comes into force.

P_ELEMENT_ENTRY_ID
The element entry to delete.

Parameters (IN & OUT)

P_OBJECT_VERSION_NUMBER
Pass in the current version number of the element entry to be deleted. When the API completes if p_validate is false, will be set to the new version number of the deleted element entry. If p_validate is true will be set to the same value which was passed in.

Parameters (OUT)

P_EFFECTIVE_START_DATE
If p_validate is false, then set to the effective start date for the deleted element entry row which now exists as of the effective date. If p_validate is true or all row instances have been deleted then set to null.

P_EFFECTIVE_END_DATE
If p_validate is false, then set to the effective end date for the deleted element entry row which now exists as of the effective date. If p_validate is true or all row instances have been deleted then set to null.

P_DELETE_WARNING
Always set to null.

Labels: , , , ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)