Oracle ERP Apps Guide, Author at Oracle ERP Apps Guide

About Oracle ERP Apps Guide

This author has not written his bio yet.
But we are proud to say that Oracle ERP Apps Guide contributed 773 entries already.

Entries by Oracle ERP Apps Guide

Apps Technical, OPM, Oracle Apps, Query, Scripts, SLA, Toad

Query for Link Between SLA and Opm Accounting preprocessor Tables in R12

SELECT GEH.REFERENCE_NO, GEH.TRANSACTION_ID, GEH.TRANSACTION_DATE, gel.line_number, gel.journal_line_type, gel.entered_amount, gel.accounted_amount, FND_FLEX_EXT.GET_SEGS(‘SQLGL’, ‘GL#’,gcc.chart_of_accounts_id,gcc.code_combination_id) account, GL_FLEXFIELDS_PKG.get_concat_description( gcc.chart_of_accounts_id, gcc.code_combination_id) acc_descriptionFROM gl_code_combinations gcc, xla_ae_lines al, xla_distribution_links dl, gmf_xla_extract_headers geh, gmf_xla_extract_lines gelWHERE gcc.code_combination_id = al.code_combination_idAND al.ae_header_id = dl.ae_header_idAND al.ae_line_num = dl.ae_line_numAND dl.event_id […]

April 21, 2015/by Oracle ERP Apps Guide

Apps Technical, Basic Concepts, ERP, Oracle Apps, XML Publisher

XSL/XPATH for BI Publisher

When you start developing RTF Templates and try to do something a bit advanced most likely you start seeing these words, XSL, XSLT, XPATH, XSL-FO…. And they might have scared or confused you. I’ve met many people use those terms without a correct understanding and everybody uses them in different ways so even I get […]

April 8, 2015/by Oracle ERP Apps Guide

Apps Technical, Basic Concepts, Oracle Apps, XML Publisher

R12 – Basics of XSLT for BI Publisher

What is XSLT? Today, I’ll cover the basic of the XSLT. Basic development of BI Publisher RTF Template doesn’t require the XSLT coding. However, when you start developing advanced reports having a good understanding of the XSLT will help you to develop the RTF Template efficiently and provide richer functionality. I’ll cover the benefit of using […]

April 8, 2015/by Oracle ERP Apps Guide

Apps Technical, ERP, Tips N Tricks, WorkFlow

Solved: Workflow Error When Clicking View Status Diagram on Status Monitor

When you want to view the status diagram of workflow process on status monitor page from the workflow administrator responsibility, maybe you get the error page like below: The solution for the above issue is set the Server Timezone profile option on the Site level. After that you can able to see the status diagram in workflow […]

December 18, 2014/by Oracle ERP Apps Guide

Apps Technical, ERP, OAF, Oracle Apps, Tips N Tricks

Solved: You cannot run a page which is not Self Secured when the MAC fails

Sometimes we will face below issues in R12. Issue 1: You have insufficient privileges for the current operation. Please contact your System Administrator. You cannot run a page which is not Self Secured when the MAC fails. Resolution: Set the below 3 profiles to None 1) FND Function Validation Level 2) FND Validation Level […]