Accrue On Receipt Flag in PO Shipments can not be Unchecked
Module: Oracle Purchasing Enter Purchase Orders Error : Can not uncheck the ‘Accrue On Receipt’ flag in PO shipments Error : Cannot update ‘Accrue On Receipt’ flag NOTE: Steps to…
Read MoreItem Ranging – Oracle Retail Merchandising System Module
Item Maintenance RMS is responsible for the creation and maintenance of all items. RMS uses a flexible data hierarchy for an item, with levels that allow you to model…
Read MoreWorkflow 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 MoreSetup a new store in Oracle RMS
To Setup a new store in RMS follow the steps given below Step 1: First open the browser and type the given URL: http://shk-oratestapp02.hk.oracle.se:7783/RetailWorkspace/faces/faces/RetailWorkspace.jspx login screen will be displayed.…
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 More