Tuesday, 17 October 2017

Query to get the Project Expenditures Defined for an Employee for a Specific Period

›
SELECT   EXPT.EXPENDITURE_TYPE ,   EXPI.Quantity ,   CASE     WHEN (EXPT.unit_of_measure='HOURS')     THEN NVL(CDL.PROJECT_BUR...
1 comment:
Monday, 16 October 2017

JDeveloper Installation and Setting Environment

›
Prerequisites  Desktop with 1.5 GB RAM  1.Telnet and FTP access to apps and db server  2.Database connectivity details: 3.Apps...

ORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_parameters

›
Symptoms:- Concurrent program completed warning with   “ORA-01792 maximum number of columns in a table or view is 1000 FROM mtl_param...

Enabling Create/View Accounting from Toolbar on Receipt Summary Form for a Custom Responsibility

›
How to Enable Create/View Accounting from Toolbar on Receipt Summary Form for a Custom Responsibility Goal:- What are the steps to ena...

Workflow download and upload commands in Oracle apps

›
Workflow upload WFLOAD <apps/pwd>@<connect_string> 0 Y {UPLOAD | UPGRADE | FORCE} <filepath>[<file_name.wft>] ...
Friday, 13 October 2017

Convert the Amount in to the Word using Function in Oracle Apps EBS R12

›
  Convert the Amount in to the Word using Function in Oracle Apps EBS R12. Function: CREATE OR REPLACE FUNCTION APPS.Get_amount_to_wo...
1 comment:

Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12

›
Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Dat...
4 comments: