Thursday, 19 October 2017

Oracle Apps(EBS) - AR Receipt Register Query with Bank statement Header and Line Details

›
Below query is useful when you required  Non Misc Receipts Along with Bank Statement Header , Line Details and Activity name ( like Receip...
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: