Archive


Category: OracleSaaS

  • QRCode and PD417 in BIP- Oracle Cloud ERP

    Use the following code details to display the data in QRCOD or PD417 Format QR Code PDF417 Example : <?qrcode:QR_DATA; 100?> Example : <?pdf417:QR_DATA; 10?> Syntax : <?qrcode: <DATA>; <SIZE>[; <CHARSET>]?> Syntax : <?pdf417: <DATA>[; <XSCALE>[; <COLUMNS>[; <ROWS>[; <CHARSET>]]]]?> Oracle Doc : https://docs.oracle.com/en/cloud/paas/analytics-cloud/acpmr/2d-barcode-functions.html#GUID-E0D697B1-0B13-46A3-8578-1FE933F1A86D Live Session :

  • AR Invoice REST API – Error Applying List binding LOV_ShipToCustomerName with given set of values leads to multiple matching rows

    While Creating AR Invoice – below is one of the error which you may face : Applying List binding LOV_ShipToCustomerName with given set of values leads to multiple matching rows for a row of type:InvoiceHeader, key oracle.jbo.Key[    300000223632391] Reason : REST API – AR Invoice Create Payload : There are multiple records with same party name : Solution : Dont Pass the : “ShipToCustomerName”: “Business World” Extra Information leads to extra errors, so always try to […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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 […]

  • 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 […]