Category: OracleSaaS
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 :
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 […]
Country Details State/County/City Details
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 […]
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 […]
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 […]
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 […]
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 […]
Process Flow : Sales Order –> AR Invoice –> SubLedger –> General Ledger (Journal) Tables ra_customer_trx_allra_customer_trx_lines_allra_cust_trx_line_salesreps_allra_cust_trx_line_gl_dist_all
OBIEE Oracle Business Intelligence Enterprise Edition BI Server: common enterprise business model and abstraction layer BI Answers: ad-hoc query and reporting BI Interactive Dashboards: highly interactive dashboards BI Delivers: proactive business activity monitoring and alerting BI Publisher: enterprise reporting and distribution of pixel-perfect reports BIP Business Intelligence Publisher Enterprise reporting and distribution of pixel-perfect reports […]