Several interesting packages in Oracle apps

查询特定源名称
最新推荐文章于 2020-11-27 22:23:23 发布
原创 最新推荐文章于 2020-11-27 22:23:23 发布 · 1k 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
文章标签：

#oracle

本文介绍了一个SQL查询案例，用于从all_source表中选取名称以'ORACLE%'开头的所有记录，并展示了如何使用SELECT DISTINCT语句去除重复的数据。

select distinct name  from all_source where name  LIKE 'ORACLE%'

 

wfa_html

 

BIS_RG_SCHEDULER_PVT

 

ImportError:version conflict: anaconda\lib\site-packages\psutil\win_amd64.pyd C extension module解决方案
weixin_43178406的博客
08-05 19万+
本文主要介绍了ImportError:version conflict: anaconda\lib\site-packages\psutil\win_amd64.pyd C extension module解决方案，希望能对使用Python的同学们有所帮助。 文章目录 1. 问题描述 2. 解决方案
ERROR: Could not install packages due to an OSError: [Errno 2] No such file or directory解决方案
热门推荐
weixin_43178406的博客
07-25 11万+
本文主要介绍了ERROR: Could not install packages due to an OSError: [Errno 2] No such file or directory解决方案，希望能对使用Python的同学们有所帮助。 文章目录 1. 问题描述 2. 解决方案
Oracle Built-in Packages完整电子版
08-17
Oracle Built-in Packages原文，可以当手册使用，2010年出版的。
Oracle Apps DBA工具:ADADMIN使用说明
田攀的日志
08-13 8528
ADADMIN用途ADADMIN主要用于Oracle Apps文件系统和数据库的维护工作，是Apps DBA常用的工具。（ADADMIN执行文件位于$AD_TOP/bin下）使用方法[oracle@bej301441 ~]$ adadmin如果ADADMIN命令无法运行，很可能是环境变量没有设置，可以运行下". $APPL_TOP/instance.env"来设置环境变量。adadmin执行过程中
理解site，site-packages in Python
漫步量化
11-27 4170
site module document source code site.py as a module is automatically imported during initialization. The automatic import can be supressed using the interpreter’s -S option. Importing this module will append site-specific paths to the module search ..
Production Issue: adjusted_amount_per_pqty column of oe_price_adjustments table contains strange amount
Alex Zhang's Blog
10-08 8814
Yesterday user reported they had wrong discount and unit price in one of the SO extraction program. After checking the oe_price_adjustments table, I found adjusted_amount_per_pqty, the column I used t
FNDWRR.exe后面的temp_id是如何生成的--解析Oracle EBS request log/output的url
Alex Zhang's Blog
12-25 6855
我们在EBS的view concurrent request 界面里, 通常会点击log或output, 然后在菜单里选copy file,从IE里来获取相应的log或output文件. 相应的url是http://host:port/OA_CGI/FNDWRR.exe?temp_id=2391709&login=APPLSYSPUT/PUB@VIS 这个url是如何生成的呢? 通过查看FNDRS
Modifying BOM using BOM_BO_PUB.PROCESS_BOM
Alex Zhang's Blog
01-25 6003
EBS Version: 11.5.8Requirement: User need to disable bom component by uploading a csv file which containing the TOP level assemblies to be disable by adding disable_date to all the components/subassem
OM: Good informational package in OM: OE_MSG_PUB
Alex Zhang's Blog
11-04 3368
Last week I started to working on an order import pragram. A sample program in our live system does similar thing but it has no price adjustment etc. To have more information when importing the order,
OM: Order Import using OE_ORDER_PUB.PROCESS_ORDER
Alex Zhang's Blog
11-04 3103
This article discusses som tips in importing sales order using oe_order_pub.process_order. The example is to import sales order with price adjustment.1. to update price_adjustments, the existing pri
How "Copy File" works in 'View Output" screen in Oracle Apps
Alex Zhang's Blog
11-11 2906
Usualy, when we submit a concurrent report and it finishes running, we click Output button to view the output and click Tools->Copy file to copy it to browser window and thus save to local disk.
What is SPAWN concurrent program and how to write such program?
Alex Zhang's Blog
09-21 2598
SPAWN program is C program in EBS.How do I compile a custom C program?         Spawned programs:         Step 1: Write the code                 Self-explanatory         Step 2: Compile the source   
How to get request_id of previous request in a request set?
Alex Zhang's Blog
01-11 2156
  FUNCTION get_prev_req_id(p_conc_program IN VARCHAR2) RETURN VARCHAR2  IS    l_parent_req_id         NUMBER;    l_request_id            NUMBER;  BEGIN    SELECT parent_request_id      INTO l_parent_r
How to delete a DFF Context
Alex Zhang's Blog
01-03 1498
Sometime Im quite annoyed by the typo mistake when creating a DFF context. The DFF segment screen doesnt allow deletion of context. Fortunately, Oracle has internal API to do such thing. Following i
OM:Manual Transaction in work flow
Alex Zhang's Blog
01-02 1483
In Order management, sometimes, we need to progress order, one example is Schedule - Eligible. How is this implemented in Workflow?  Basically, in Oracle workflow builder, we can see order goes to "
Carrying filename and request_id into table when doing sqlldr
Alex Zhang's Blog
01-11 1449
Sometimes when we sqlldr data file into table, we may need to carry filename and request_id into each line. sqlldr doesnt seem to be able to pass env variables into table, so what I can do is to mass
How to Register a Host Concurrent Program in Applications
Alex Zhang's Blog
09-21 1424
1. Create a simple unix script called TEST.prog in $FND_TOP/binEx:touch /u01/1153/visionappl/fnd/11.5.0/bin/TEST.txt2. Register this as a concurrent executable in Application Object Library called TES
APPS:How to view the concurrent request output of other users
Alex Zhang's Blog
12-17 1395
Basicaly, as Oracle documents, we can profile option "Concurrent:Report Access Level" to Responsiblity instead of default value User, then , user can view the request output of other users login as
Oracle ERP 11i 维护经验（转自http://zhulch.itpub.net/post/17395/194340）
Alex Zhang's Blog
06-01 1247
Oracle ERP 11i 维护经验（根据BBS上内容整理的）1. 在oracle applications 11i 中如何快速获得上次查询的SQL 语句方法：我们不必使用SQL Trace 来获得，有一个简单的办法，即：帮助->诊断->检查->在"块"中输入"system"，在"字段"输入" last_query "，然后把鼠标移动到"值"，你就可以看到你所要的SQL 语句，简单吧
oracle中Packages
最新发布
02-11
### Oracle 数据库中的包（Packages） #### 定义与作用 在Oracle数据库中，包是一种逻辑结构，用于封装和组织相关的PL/SQL程序单元。通过使用包，可以更好地管理复杂的应用程序并提高性能。包由两个部分组成：包...
评论 1
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值