This blog evolved to a public notepad after all these years. I mainly share Oracle ERP stuff but I'm not limited to that.
Content can be Turkish or English.
How to compare data in Excel?
Get link
Facebook
Twitter
Pinterest
Email
Other Apps
-
This example shows two ways to compare text in Excel. One is case-sensitive and one is case-insensitive.
You can use below SQL query to list down all shopping cateogry hierarcy (both browsing and purchasing ones) and description for English and Turkish languages. Please feel free to contact me if you relaize any mistake. SELECT prct.CATEGORY_NAME PARENT_CATEGORY_NAME_TR , prce.CATEGORY_NAME PARENT_CATEGORY_NAME_US , pch.PURCHASING_CAT_FLAG , CASE WHEN pch.PURCHASING_CAT_FLAG = 'Y' THEN ( SELECT ect.CATEGORY_NAME FROM EGP_CATEGORIES_TL ect WHERE pch.child_category_id = ect.category_id AND ect.language = 'TR' ) ELSE ( SELECT prct.CATEGORY_NAME FROM POR_BROWSE
Requisition Import process is used to import requisitions from other Oracle or third-party non-Oracle systems. Before R12.2.2, while importing requisitions from Oracle or third-party non-Oracle systems, if users do not provide charge account segment or CCID for other accounts in the Requisitions Interface table (PO_REQUISITIONS_INTERFACE), then these requisitions are not imported. The interface expects the accounts (charge, budget, variance, and accrual) as mandatory fields and does not process requisitions unless the charge account is populated. With this new feature, when requisitions are imported using the Requisition Import Process, the Charge, Budget, Variance and Accrual accounts for the requisitions are generated automatically by calling the Requisition Account Generator Workflow. Automatic generation of the charge account CCID happens only if the charge account and corresponding segments are empty. You can check following document to get more information. Auto
At first ensure that the forms you want to generate are not in use at the time you are generating them. If they are in use when you generate the fmx files, the forms client session terminates. You can follow this steps for compile operation. 1) Stop Oracle Forms Server. 2) Copy your new fmb file under the $AU_TOP/forms/US path. 2) Change your directory to $AU_TOP/forms/US. 3) Use ifcmp60 command to compile your fmd files and generate fmx files. Choose module_type parameter "FORM" . If you are compiling custom.pll, you must choose "LIBRARY" as a module_type parameter. Usage of userid parameter --> userid=apps/**apps_password**@**instance_name** Example: Forms compile ifcmp60 module=APXVDMVD.fmb module_type=FORM userid=apps/apps@TEST custom.pll compile ifcmp60 module=custom.pll module_type=LIBRARY userid=apps/apps@DEV
Comments
Post a Comment