Posts

Oracle Apex

 apex.item('name').getValue()   #get element by id  apex.item('name').setValue('asdf') Region PL/SQL Dynamic Content The sql to give HTML output Region Display Selector To show child regions as tabs Child regions should have parent as Region Display Selector Faceted Search(Switch on Region Display Selector to show as tab) Facet (sub-region) select Type as Faceted Search Select Filtered Region as Report Add Facets   Associate to column  Report(sub-region) select Types as Classic Report Processes(Client Side) Point Before/after Header, region, footer, processing, ajax call back Buttons Action Redirect to URL javascript:alert("adf"); Defined by Dynamic action Dynamic Actions event  Change, Click, Double Click,  Selection Type items, jQuery Selector  Action True False Page Processing Validations apex_error.add_error :APEX$ROW_STATUS javascript: apex.confirm('....','DELETE');
Post a Comment
Read more

ICS

 https://www.udemy.com/course/oracle-fusion-cloud-paas-technical-oic-vbcs-pcs-dbcs/learn/lecture/26772460#overview https://www.udemy.com/course/oracle-cloud-erp-technical/learn/lecture/16421954#overview https://www.udemy.com/course/oracle-fusion-cloud-paas-technical-oic-vbcs-pcs-dbcs/learn/lecture/24674844#overview OIC - Oracle Integration Cloud, a PaaS software from Oracle Integrate the Cloud and on premise applications Automate business processes gain insight into business processes develop visual user interfaces Why OIC 70+ adapters connecting different platforms Goes well with Oracle ERP applns Integrate cloud and  Integration Methods in Fusion OIC to Fusion SaaS FBDI -> file based data import for bulk data SOAP web service -> for real time data import REST web service -> for real time data import File Based loader -> non fbdi based bulk data import SaaS to OIC Business Events SOAP REST BI Publisher reports Cloud Computing Delivery of on demand resources includ...
Post a Comment
Read more

Oracle Process Cloud

https://www.udemy.com/course/oracle-cloud-erp-technical/learn/lecture/17309282#overview OIC -> PAAS offering from Oracle which comprises of following services Integration Cloud Services To design integration to integrate heterogeneous systems.  eg: ebs to sap, sap to orcl cloud, read from ftp and upload to ebs has integration with PCS Process Cloud Services  For notification and approval purpose - business automation To design BPM based application(similar to workflow in ebs) has integration with ICS VBCS To design web based pages in PAAS platform has integration with PCS B2B Oracle Process Cloud Service Space (ie folder) Application(ie file) Processes web forms business types decisions integrations/webservices indicators Integration Cloud Service(ICS) Also called OIC(Oracle Integration Cloud) It is iPaaS solution alternate to SOA Why to use customer using workday hrms & Oracle Financials, zeebra barcode Zeebra needs item details from Oracle what is required for integra...
Post a Comment
Read more

OCI

OCI Platform Infrastructure Databases Data & AI Analytics Applications Developer services Governance and Applications 41 regions + 9 planned 12 Azure interconnected regions Infrastructure Compute(perform calculations, execute logic, running applns) VM, BareMetal servers,  containers,  managed Kubernetes service & managed vm ware service Storage -> Store, access, govern, Analyze both structured and unstructured data discs attached to vms file storage object storage archive storage Networking Databases Oracle db and open dbs ATP data bases(oltp, olap, json, apex)  no sql and my sql Data & AI Data flow - Managed apache spark service Big data Data catalog Managed data science platform  Apache kafka service for event streaming  Analytics Oracle analytics cloud Applications serverless offering called events, functions, api gateway helps build micro services and event driven architectures Developer services apex vbcs Governance and Applications Security ...
Post a Comment
Read more

Services

 UploadFileToUCM Operation https://docs.oracle.com/en/cloud/saas/financials/21d/farfa/op-erpintegrations-post.html  https://www.udemy.com/course/oracle-cloud-erp-technical/learn/lecture/26073634#overview Base64 encoded Soap: https://www.udemy.com/course/oracle-fusion-cloud-erp-technical-with-oracle-soa-java/learn/lecture/26318682#overview
Post a Comment
Read more

Scaler

Responsibilities(or Roles) are different from Actions. Several actions can be performed to fulfil a responsibility(or role). The class should have one responsibility(SRP) but its functionality that fulfils that responsibility should be open to extend(OCP)    SOLID Single Responsibility - A class should have a single responsibility Open-Closed - This principle aims to extend a Class’s behaviour without changing the existing behaviour of that Class. Liskov Substitution - If S is a subtype of T, then objects of type T in a program may be replaced with objects of type S without altering any of the desirable properties of that program.   I — Interface Segregation D — Dependency Inversion - High-level modules should not depend on low-level modules. Both should depend on the abstraction. Abstractions should not depend on details. Details should depend on abstractions. HLD Netflix consume 15% of world internet traffic Sort list of strings which is of size Peta Bytes of dat...
Post a Comment
Read more

Discounts Aggregation

https://confluence.oraclecorp.com/confluence/display/DDA/Aggregations+flow https://confluence.oraclecorp.com/confluence/display/DDA/New+Aggregation+Implementation+after+Spark+no+longer+supported+by+AI+APPS   main () runProcess runProcess () extractSettings  //SettingsDaoImpl extractAndAggregateData saveSettings uploadDataInSolrCollection indexSuppliersInfoToSolr deleteOutdatedSolrDocuments extractSettings  get data from erp_ap_settings table returns MAP with minAPR, maxAPR, conversionType, gblCurrency extractAndAggregateData() InvoicePaymentsExtractor.prepareDataBeforeExtraction erp_ap_aggregation_pkg.clean_payments ( DiscountsDatabase/src/main/resources/db/migration/oracle/create) Defaults bucurrency and invoicecurrency on invoice payments if null from invoice & gl_currencies  calculator = new APRCalculator(minAPR, maxAPR); suppliersRDD(id, supplierPojo) = SuppliersExtractor.extractSuppliers(tenantId, jsc, calculator) getCount call extractSuppliersRDD() to retu...
Post a Comment
Read more