Oracle E-Business Suite – TCA API’s

 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

Country Details State/County/City Details →Read more

OAF – Invoke CallableStatement and Prepared Statement

Callable Statement Prepared Statement →Read more

Oracle Cloud ERP – Creating Customer Using WebServices

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

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

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

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

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

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

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