Technical Overview This section is broken down into four (4) components and will help find the right APIs for your need, to ensure you select the right one and receive the desired result. White Papers/Reference Documents TCA API Procedures TCA API Programs Tables Update Tabs Description White Papers/Reference Documents This section will list out any […] →Read more
Oracle EBS/Cloud ERP – Get Country, State, County Details Using SQL Query
by admin
Country Details State/County/City Details →Read more
OAF – Invoke CallableStatement and Prepared Statement
Oracle Cloud ERP – Creating Customer Using WebServices
by admin
Creation of Organization/Person is available via REST Creation of Customer Account, Account Site, Account Site Uses, Account Profile via SOAP Release 20D Prior to release 20D New REST API is available for Organization & Person (Location and Organization/Person records gets created in one payload/call) All services are SOAP Webservices REST API’s/crmRestApi/resources/11.13.18.05/hubOrganizations/crmRestApi/resources/11.13.18.05/hubPersonsSOAP Web ServicesCreate Customer Account with Site & UsefoundationParties/CustomerAccountServiceCreate […] →Read more
Oracle Cloud ERP – Sales Order FBDI
by admin
Import Process Import Sales Orders UCM scm/sourceSalesOrder/import Interface Table Base Table/View DOO_ORDER_HEADERS_ALL_INT DOO_ORDER_LINES_ALL_INT DOO_ORDER_ADDRESSES_INT DOO_ORDER_BILLING_PLANS_INT DOO_ORDER_CHARGES_INT DOO_ORDER_CHARGE_COMPS_INT DOO_ORDER_DOC_REFERENCES_INT DOO_ORDER_HDRS_ALL_EFF_B_INT DOO_ORDER_LINES_ALL_EFF_B_INT DOO_ORDER_LOT_SERIALS_INT DOO_ORDER_MANUAL_PRICE_ADJ_INT DOO_ORDER_PAYMENTS_INT DOO_ORDER_SALES_CREDITS_INT DOO_ORDER_TXN_ATTRIBUTES_INT DOO_PROJECTS_INT DOO_HEADERS_ALL DOO_LINES_ALL DOO_FULFILL_LINES_ALL DOO_ORDER_ADDRESSES Import Process of Sales Order Please download the file SourceSalesOrderImportTemplate.xlsm from this location: https://docs.oracle.com/en/cloud/saas/supply-chain-management/21b/oefsc/order-management.html#importsalesorders-3179 SourceSalesOrderImportTemplate.xlsm à has 15 sheets, out of which the […] →Read more
Supplier Attachment Import Issue – zip file can’t be located
by admin
When loading Supplier Attachments, if the file type is URL or TEXT the content can be mentioned within the template file, but if you want to load any file like : PDF, PNG, JPG, DOC…etc , the file should be loaded in the UCM Account : /prc/supplier/import Make sure you follow the naming of the […] →Read more
How to view ESS jobs submitted by other user in Cloud (Fusion) ERP
by admin
Create a custom role of category : Common-Abstract RolesIn the role membership –> Add –> ESS Monitor RoleIn the Users tab you can add user to this new created roleRun ESS process ‘Import User and Role Application Security Data’Once completed logout/login again with the user which was granted accessVerify if the user is able to […] →Read more
Suppress the background noise in ZOOM
by admin
Open the ZOOM , on the top right click on the gear icon for settings and check the below option Suppress background noise, based on your requirement. →Read more
Laptop and Battery Best Usage Guidelines
by admin
Laptop: Protect the LCD display monitor: Before shutting down your laptop, make sure that there are no things such as pencil, sticks, pen etc lies on keyboard. These can break the display screen when shut and screen will get scratches if items are hard. Hence, avoid keeping things on keyboard. Do not use your laptop […] →Read more
How to add BI Admin Role in Cloud ERP
by admin
Login to Fusion Application and choose the “Security Console” option N: Tools à Security Console Under the Roles Tab, click on Create Role button Enter RoleName, RoleCode, Role Category, Description and Click next till you get to the “Role Hierarchy” Search for the BI Administrator Role and then click on “Add Role Membership” This […] →Read more