When an Expense Report has a status of ‘Pending System Administrator Action’ a notification has usually been sent to the System Administrator for action to be taken. The reason for…
Read MoreWhen there is a genuine issue with a particular invoice in Payment Process Request(PPR), all other invoices are getting rejected with reason ‘Document payable was failed because of rejection level…
Read MoreSELECT hou.name operating_unit, xep.name legal_entity, cebb.bank_name, cebb.bank_number, cebb.bank_branch_name, cebb.bank_branch_number, cebb.bank_branch_type, — Branch type indicates which list the bank routing number is on. Valid types are ABA, CHIPS, SWIFT, OTHER. cbv.address_line1,…
Read More1.Overview The definition of SQL/XML is driven in part by the SQLX Group. Oracle supports several SQL/XML features which are subject to change as the standard evolves. SQL/XML Functions XMLELEMENT…
Read More1. Overview This Document is about to store the function result into the server result cache. 2. Technologies and Tools Used The following technologies have been used to achieve this Oracle…
Read More1. Overview This document is about the new features in Oracle 18c is Private Temporary Tables. 2. Technologies and Tools Used The following technologies have been used to achieve this Oracle…
Read More1. Overview This Document is about the data in a global temporary table is private, such that data inserted by a session can only be accessed by that session. The session-specific…
Read More1. Overview This document will be helpful to upload a excel file directly and view it as a report. 2. Technologies and Tools Used Oracle Plsql. 3. Use Case Customer wants to upload…
Read More