oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: Payroll Employer Costs Extract
http://oraclemasterminds.blogspot.com/2016/12/payroll-employer-costs-extract.html
Doyen System Pvt. Ltd. Wednesday, 21 December 2016. Payroll Employer Costs Extract. SELECT SUM(peevf.screen entry value). FROM pay element types f petf. Pay element entry values f peevf. Pay element entries f peef. Per all assignments f paaf. Pay input values f pivf. WHERE paaf.assignment id = p assignment id. AND p effective date between paaf.effective start date and paaf.effective end date. AND peef.assignment id = paaf.assignment id. AND peef.effective start date. AND pivf.name = 'Pay Value'. Oracle a...
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: iProcurement Setup Document and it's basic flows in R12.2
http://oraclemasterminds.blogspot.com/2015/04/iprocurement-setup-document-and-its.html
Doyen System Pvt. Ltd. Thursday, 16 April 2015. IProcurement Setup Document and it's basic flows in R12.2. Mandatory Setups for iProcurement:. Top Category (Browsing Category) -. Child Category (Browsing Category) -. Shopping Category (Item Category) -. Item Creation and Purchasing Category Assignment. Blanket Purchase Agreement Creation. Personalization's (Profile Option - ". Personalize Self-Service Defn = Yes. POR: Autocreate Shopping Category and Mapping. POR:Allow Manual Selection of Source. Root Ca...
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS
http://oraclemasterminds.blogspot.com/2017/01/learning-pentaho-itseasy-to-start-and.html
Doyen System Pvt. Ltd. Wednesday, 4 January 2017. It’s easy to start and learn Pentaho on its own. In-build sample code and easy to connect various database with drag and drop option base on Java. Adding to beauty it has been provide with Kittel and Pan Scripts, which make it unique in nature. My first project is just for presentation point of view. With time I explore some of best feature inside Pentaho. In short, I am presenting incremental data extraction concept on tables in this document. Figure 1&#...
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: Adding Condition While Calling the Bursting Program
http://oraclemasterminds.blogspot.com/2014/10/adding-condition-while-calling-bursting.html
Doyen System Pvt. Ltd. Friday, 24 October 2014. Adding Condition While Calling the Bursting Program. In the Below Program we would be restricting the Mails for which the outstanding balance is Less that Zero. Statement Generation Program Bursting. AR Statement Print report is used to send statements to customers on a regular basis to notify the outstanding balance that the customer needs to pay. The Program needs to Mail only if the Outstanding Balance is More than Zero. Formula column code snippet:.
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS
http://oraclemasterminds.blogspot.com/2017/01/purchaseorder-with-requisition-preparer.html
Doyen System Pvt. Ltd. Tuesday, 3 January 2017. Purchase Order (With Requisition Preparer). Fetch the Purchase Order along with Requisition Preparer details we can use the following queries. Query 1 To Fetch Cancel PO*/. Action date cancel po date. Po action history pah. Poh po header id. Object sub type code. Object sub type code. Po action history pah2. Poh po header id. Query 2 To Fetch Cancel Release PO */. Action date cancel release date. Po action history pah. Poh po release id. Gl sets of books gsb.
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: Query to Link AP Invoices, GL and SLA Tables: R12 AP GL XLA
http://oraclemasterminds.blogspot.com/2014/10/query-to-link-ap-invoices-gl-and-sla.html
Doyen System Pvt. Ltd. Friday, 10 October 2014. Query to Link AP Invoices, GL and SLA Tables: R12 AP GL XLA. SELECT SUM (xal.accounted cr), SUM (xal.accounted dr), aia.invoice amount,. FROM ap invoices all aia,. Xlaxla transaction entities xte,. Xla ae headers xah,. Xla ae lines xal,. Glgl import references gir,. Gl je lines gjl,. Gl je headers gjh. WHERE 1 = 1. AND aia.invoice id = NVL ("SOURCE ID INT 1", (-99). AND xte.entity code = 'AP INVOICES'. AND xte.application id = 200. 15 July 2015 at 22:18.
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: Steps to Controller Extension in OAF Page
http://oraclemasterminds.blogspot.com/2015/10/steps-to-controller-extension-in-oaf.html
Doyen System Pvt. Ltd. Wednesday, 14 October 2015. Steps to Controller Extension in OAF Page. To extend the OA Framework page you have 2 options, extend the VO or extend/create the controller. Extending a VO is on a global level and you pick this option if you want to add extra columns. Extending/creating a controller can be assigned on all levels (function/site/organization/responsibility/etc). Go to Project Super User Responsibility à. Click any project link à. Go to setup à. Connect the server through...
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: January 2017
http://oraclemasterminds.blogspot.com/2017_01_01_archive.html
Doyen System Pvt. Ltd. Monday, 16 January 2017. TOOL-TIP FOR THE REPORT COLUMN. The tool-tip displaying report column while hovering on the another report column. Is the report Column. Column’s display type as “Display As Text”. Column’s display type as hidden. Apply this Html code in the HTML Expression. Span data-tooltip="Department : #DEPT#
Manager : #MGR#" #ENAME# /span. 8220;Department : #DEPT#
Manager : #MGR#”. This will be displayed while hovering on to the employee name and “ 
”. Document Ma...
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS: IR & ISO - Internal Sales Order Cycle with Setup Steps in R12.2
http://oraclemasterminds.blogspot.com/2014/12/ir-iso-internal-sales-order-cycle-with.html
Doyen System Pvt. Ltd. Thursday, 18 December 2014. IR and ISO - Internal Sales Order Cycle with Setup Steps in R12.2. Internal Requisition/Internal Sales Order provide the mechanism for requesting and transferring material from one inventory organization to other inventory organization. Below is the process flow which has to be followed in each module in order to execute Internal Sales Order:. Create two different Locations. Create two Inventory Organizations. Create Internal Transaction Type. Here we ha...
oraclemasterminds.blogspot.com
ORACLE MASTERMINDS
http://oraclemasterminds.blogspot.com/2017/01/accounts-payable-trial-balancereport.html
Doyen System Pvt. Ltd. Tuesday, 3 January 2017. Accounts Payable Trial Balance Report. Account Payable Trial Balance Report meant to verify that total accounts payable liabilities in Payables equal those in the general ledger. Before closing a period, you can compare the cumulative total liability provided by this report with the total liability provided by your general ledger to reconcile these balances. Vendor name supplier name. Invoice num invoice number. Invoice date invoice date. Set of books id.
SOCIAL ENGAGEMENT