Posts

Technical overview of HCM Extracts

Image
  Technical overview of HCM Extracts HCM Extracts is a powerful tool used in Oracle Fusion HCM Cloud for extracting bulk data.  Note: It cannot be used for extracting Finance and Supply Chain Objects. To access HCM Extracts, Navigate --> My Client Groups --> Data Exchange --> HCM Extract.  Key management options: Extract Definitions: Used to create and manage new extracts. Submit Extracts: Used to run existing extract definitions. View Extract Results: Used to check the status and output of previously submitted extracts. User Entities: The core data sources for HCM extracts, similar to how table names are used in BIP or subject areas in OTBI. Extract Types and Configuration: When creating a new extract, users must select an "extract type," which determines the purpose of the data retrieval.  Common types include: Archive Retrieval: Used for permanently archived data, such as payslips. Benefit Carrier: Used for providing data to third-party benefit providers....

About SOAP Web Service

 Web Service: SOAP Navigation, Go to OER Oracle-->Choose Cloud Applications-->Choose Domain--->Integrate Click on "Review SOAP Services". In Oracle Fusion Cloud Financials,  business objects such as: Journal Entries,  Invoices,  Payments,  Assets,  and Customer Accounts) are exposed through SOAP Web Services and REST APIs. SOAP Web Services, use WSDL (Web Services Description Language) endpoints to define: service interface,  operations,  and schemas for each business object. -------------- Standard SOAP WSDL For the Business Object:  1.Journals Service WSDL  Syntax https://(Fusion_Instance)/(Context-Root)/(Service-Name)?WSDL For Example: https://Fusion_Instance_URL/fscmService/JournalImportService?WSDL 2.ERP Integration Service WSDL https://Fusion_Instance_URL/fscmService/ErpIntegrationService?WSDL 3.Payable Payables Invoice Service WSDL https://Fusion_Instance_URL/fscmService/InvoiceInterfaceService?WSDL Common Context-R...

Fault Handler in Oracle Integration Cloud

Image
   Fault handling in Oracle Integration Cloud (OIC) Fault handling in Oracle Integration Cloud (OIC) is an essential mechanism for managing errors that occur during integration execution. It is like fixing a problem when it happens so it doesn't go ignored. Purpose  Instead of allowing an integration to fail silently,  fault handling logic executes recovery actions or notifies the appropriate persons.  Common techniques include: Email Notifications: Sending email about error codes, messages, and details to business or support teams for rectification. Audit Tables: Dumping error records and instance IDs into custom tables (such as ATP or DBAS) for periodic review and tracking. Generic Error Handlers: Building a single, reusable REST API integration for error handling that can be invoked by multiple other integrations to save time and avoid repetitive tasks. Bulk Record Handling: For high-volume data loads (like FBDI), failed records can be stored in a file and em...

HDL Process in Oracle HCM Fusion

Image
  HDL-Human Capitable Data Loader HSDL HCM Integration Specialist Recent logs Stage tables are temporary tables. after we move the data to base tables then we will delete the data in staging area We need to understand the Workforce Structure flow: Locations Refresh All Objects before we download template What is the extension of data file? .DAT The file name should be same name as the template name. UI navigation Myclient Groups--->Workforce Structures-->Create Location Approval Groups or Flow Tools-->Transaction Console By pass the approval flow