Objective: To generate multiple excel sheet report from OBIP using data template SQL queries. Scenario: Customer needs multiple sheets excel report from OBIP. While developing it, developer came to know…
Read MoreObjective: To generate reports from OBIP using data template SQL queries. Scenario: Customer has given a requirement to develop the report in OBIP. While developing it, developer came to know…
Read MoreObjective: To generate DDL source code using Oracle SQL. Scenario: Customer asks us to generate all the DDL source code for some database objects. So I just found the little…
Read MoreObjective: To create a template to split records in excel sheet in Oracle BI Publisher 10g. Solution: Template Creation – EXCEL Step 1: Open the Excel. (See below image) Step…
Read MoreObjective: To call Oracle package in Oracle BI Publisher 10g. Scenario: Oracle BI Publisher is just a reporting tool. From which we can download excel, csv, xml, rtf, PDF reports.…
Read MoreHere is how to fix Pending Distributed Transactions SELECT * FROM DBA_2PC_PENDING COUNT(*)————– 1 select max(fail_time) from dba_2pc_pending; MAX(FAIL_————–03-DEC-16 select ‘exec dbms_transaction.purge_lost_db_entry(”’||local_tran_id||”’ )’ , ‘commit;’ fromdba_2pc_pending ‘EXECDBMS_TRANSACTION.PURGE_LOST_DB_ENTRY(”’||LOCAL_TRAN_ID||”’)”COMMIT;’ exec dbms_transaction.purge_lost_db_entry(‘15.41.373682’…
Read More— Query to retrieve customer PO details SELECT obha.order_number, obha.sold_to_org_id, obha.cust_po_number, obha.header_id, obha.org_id, TO_DATE (obha.attribute16,’YYYY/MM/DD HH24:MI:SS’) po_last_calc_date, …
Read MoreAR Cash Management Description This blog is used to load Bank and Branch data from the load files. It end date the bank accounts which are invalid. Create new bank…
Read MoreWorkflow Mail Notification Description This blog is used to send an email notification to the transaction types like Purchase Order, Requisition, Requisition Change Order and IExpense. The Select queries…
Read MoreWorkday Integration Process Description This blog is used to Creating new Person, Assignment, Job creation, Location creation, and Rehiring Person. This blog includes the updating of Person, Job, and assignment…
Read More