Requirement AP Invoice Approval Failing For Custom Conversion Rate Type Condition in Rules Application: Oracle Fusion Payables Cloud Service – Version 11 Detail of issue AP Invoice Approval Failing For…
Read Morescheduling-in-order-management Scheduling in Order Management
Read Morebill-of-material-work-in-process-end-to-end-cycle
Read MoreSEND NOTIFICATION (groovy) // Send Slack and Mail build notification def call(Map config = [:]) { slackSend ( color: “${config.slackSendColor}”, message: “${config.message}: Job ‘${env.JOB_NAME} [${env.BUILD_NUMBER}]’ (${env.BUILD_URL})” ) /* // send…
Read MoreIntroduction: These queries gives the modules used, data volumes, top products they have sold and other details about the Business. Queries: The below are the queries we have used to…
Read Moresupplier_.import_fbdldocx
Read MoreNeed to write output file using CLOB variable which contains more than 32767 bytes of data even it may contain up to 8 GB data. If it exceeds more than…
Read MoreUSER_TABLES Lists each table that belongs to your Oracle user.USER_TAB_COMMENTS Shows comments on the tables and views.USER_TAB_COLUMNS Tells you the names, data types, default values, etc. of each column in…
Read MoreCREATE OR REPLACE PROCEDURE BLK_CLCT_DELISL_LIMIT PLS_INTEGER := 20000; CURSOR C1ISSELECT row_idFROM s_invoice_itemWHERE person_id IN(SELECT b.row_idFROM disalloc A, S_CONTACT BWHERE A.PD_NEW_EYEE_ID = B.PERSON_UIDAND B.CON_CD = ‘Member’AND A.PD_DT_MODIFY BETWEEN ’01-JAN-2010′AND ’31-MAY-2010′); TYPE…
Read More