Workflow Fundamentals
Introduction to workflow Tool from Oracle Works with Oracle Database PL/SQL Based Widely Used with Oracle Applications Can be Used Stand-Alone or with Oracle Apps Need of workflow Workflow can…
Read MoreOracle BI Publisher report output sorting
We can sort data in XML report a group by any element within the group. Sort data based on Empno: Syntax: <?sort:Field_Name?><?Field_Name?> It sorts the data in ascending order by Default. If Order…
Read MoreOracle Query for the Users who have access to a particular form
select a.menu_id , menu_name , c.responsibility_name , g.user_name , g.description from fnd_menu_entries a , fnd_menus b , fnd_responsibility_vl c , fnd_form_functions d , fnd_form_vl e , fnd_user_resp_groups f , fnd_user…
Read MoreOracle PO Inbound interface EBS
CREATE TABLE xxcus.XX_PO_HEADERS_STG ( INTERFACE_HEADER_ID NUMBER , BATCH_ID NUMBER, INTERFACE_SOURCE_CODE VARCHAR2(25), PROCESS_CODE VARCHAR2(25), ACTION VARCHAR2(25), GROUP_CODE VARCHAR2(25), ORG_ID NUMBER, DOCUMENT_TYPE_CODE VARCHAR2(25), DOCUMENT_SUBTYPE VARCHAR2(25), DOCUMENT_NUM VARCHAR2(20), PO_HEADER_ID NUMBER, RELEASE_NUM NUMBER, PO_RELEASE_ID…
Read MoreSyntax to user oracle functions in BI Publisher
XML Publisher has extended a set of SQL and XSL functions for use in RTF templates. The syntax for these extended functions is for extended SQL functions <?xdofx:expression?> for extended…
Read MoreQuery to find responsibility from a form name
SELECT FORMS.form_name, FORMSTL.user_form_name, RESTL.responsibility_name, FORMSTL.language FROM fnd_form FORMS, fnd_form_tl FORMSTL, fnd_form_functions FUNC, fnd_menu_entries MENU, fnd_responsibility RES, fnd_responsibility_tl RESTL WHERE FORMSTL.user_form_name LIKE ‘%Workbench%’ AND FORMS.form_id = FORMSTL.form_id AND FUNC.form_id = FORMS.form_id…
Read MoreBI Publisher If then Else Statement
Conditional Format Statements in BI/XML Publisher : If if-then-else choose- when-otherwise The Conditional Formatting using if statement: If statement: Use if statement to define a simple condition; for example, if…
Read MoreCreate Journal on a Spreadsheet Fusion
Please make sure to open the period where you want to post the journal. Let us create the following journal on a spreadsheet- Navigation- Go to General Accounting Dashboard and…
Read MorePayment process request technical details
Overview Under Funds disbursement page, users can submit Payment Process Requests (PPR) to generate payments. There is an option to submit a single Payment Process Request or schedule Payment Process…
Read MoreScript to delete concurrent program and the xml templates and data definitions
Begin fnd_program.delete_program(‘program short name’,’applicaton shot name’); fnd_program.delete_executable(‘program short name’,’applicaton shot name’); commit; End; Example: If you have a concurrent Progam called “Employee Details Report” with the short name EMPDTLSREP and…
Read More