Oracle Cloud ERP – Employee Creation From UI and Using REST API

———Employee Creation in Cloud ERP Using REST API—————– Create an Employee from UINavigation :(Search Person) –> My Client Groups –> Person Management(Create Person) –> My Client Groups –> New Person –> Hire an Employee GET All Employees URI: /hcmRestApi/resources/11.13.18.05/emps URL: https://adc2-zrej-fa-ext.oracledemos.com/hcmRestApi/resources/11.13.18.05/emps GET a specific Employee/hcmRestApi/resources/11.13.18.05/emps/{empsUniqID}empsUniqID: integer https://adc2-zrej-fa-ext.oracledemos.com/hcmRestApi/resources/11.13.18.05/emps?q=PersonId=300000047606111 This is the hash key of the attributes […] →Read more

Oracle Cloud ERP- Data Extraction Strategies

→Read more

Oracle Cloud ERP – Create AP Invoice Using REST API and UI

Create/View Invoices : Navigation:Payables –Invoice Get an invoice using REST API : /fscmRestApi/resources/11.13.18.05/invoices/{InvoiceId} https://ucf1-zrgs-fa-ext.oracledemos.com/fscmRestApi/resources/11.13.18.05/invoices/300000210791416 Create an Invoice using REST API /fscmRestApi/resources/11.13.18.05/invoices https://ucf1-zrgs-fa-ext.oracledemos.com/fscmRestApi/resources/11.13.18.05/invoices 3.Query : select * from ap_invoices_all order by creation_date desc select * from ap_invoice_lines_all where invoice_id = 300000210773443 Tools Used 1.Notepad++ — https://notepad-plus-plus.org/2.Postman — https://www.postman.com/downloads/ →Read more

How to create employee and user account in Oracle Cloud ERP Fusion

Navigation : My Client Groups à New Person à Hire an Employee Click on Hire an employee Further click on Next and Submit →Read more

Oracle EBS – Workflow – Approval Sample – For Your Action Notification- FYA

→Read more

Oracle EBS – Workflow Basics – Hello World Workflow

Workfow Source Code – WFT File : https://drive.google.com/file/d/1OdmA488B6kuWxwwj_EujZLdxi6oJ9iEt/view?usp=sharing →Read more

Oracle Cloud ERP (SaaS)- Asset Addition FBDI

1.N: Fixed Assets –Assets–Tasks : Transactions : Add Assets in Spreadsheet –MassAdditions.xlsx (gets downloaded)2.Open the file –enter the credentials3.Enter the data in the file : MassAdditions.xlsx —Click on Submit –After Validation — An Ess Job will be triggered(ESS Job : Prepare Assets Transaction Data) →Read more

Oracle Cloud ERP – Journal Import Using SOAP WSDL

Journal Import Using SOAP WSDL Involves the below steps : Load the data into the GL_INTERFACE tables using the SOAP WSDL : https://servername/fscmService/JournalImportService?WSDL Run the ESS : Import Journals : to load the data from Interface table to base tables *Tips : make sure to mention Group ID for every Journal Import and always validate […] →Read more

Oracle Cloud ERP – ErpObjectAttachmentService

ErpObjectAttachmentService is the generic attachment service for Purchas Orders, AP Invoices – etc . Few of the modules has their own attachment services, but few of them like PO, AP Inv don’t have their attachment services. In those cases – ErpObjectAttachmentService is the available service to be used. →Read more

SQL Query to fetch User Roles in Oracle Cloud ERP

→Read more