Oracle财务系统常用标准报表
总账系统系统报表名中文译名用途描述Journals-Voucher日记账传票通过提交该报表来打印日记账传票Journals-Document Nummber传票文档号按传票的文档序列号来打印日记账传票列表,可作为装订每月传票...
Oracle EBS API: OM模块主要API示例
在Oracle EBS OM模块中, 一个典型订单流程包括: 下单, 挑库, 发货确认; 创建客户安装Install Base, 以及失效Install Base等业务. 本文列出主要业务的API示例, 供客户化或系统集成时参考. (所有代码在11...
Jsp Upload CSV (02)
<%@ page errorPage="errorpage.jsp"%> <%@ page language="java" %><%@ page contentType="text/html; charset=GB2312"%><%@ page import="java.sql.*"%> <%@ page import="java.io.*, java.util.*, java.text...
Jsp Upload CSV (01)
<html><HEAD><meta. http-equiv="expires" content="0"><title>AP Invoice Upload</title></HEAD> <link rel="stylesheet" charset="UTF-8" type="text/css"href="../css/belton-oracle.css"><body><table sum...
Oracle Applications Interface Programs(Oracle EBS 常见API上)
Order Import Interface Item Import (Item conversion) Order Import Interface (Sales Order Conversion) Interface tables·&nb...
Oracle Applications Interface Programs(Oracle EBS 常见API 中)
ü On-hand Quantityü Customer Conversionü Customer APIü Auto Invoice Interfaceü Receipt APIü Auto Lockbox Interfaceü AP Invoice Interface On-hand quantity ...
Oracle Applications Interface Programs(Oracle EBS常见API 下)
ü Receipt APIü Auto Lockbox Interfaceü AP Invoice Interfaceü Vendor Interface/Conversionü Requisition Importü PO receipts interfaceü GL Interfaceü GL Budget Interfaceü GL Daily conve...
异常情况处理
1. 在11.5.10下的Responsibility "Inventory Vision Operation(USA)", 若要切换组织到 V1. 需要设置如下:方案:切换Responsibility 到 "Order Management Super User, Vision Operations(USA)", 打开路径Inventory...
ORA-14452錯誤及解決方法(临时表被锁)
-找到锁住表的sid和serial#select sid,serial# from v$session where sid in (select sid from v$lock &...
AP Match Receipt API
begin fnd_global.apps_initialize(user_id => 3532, &...
Oracle ERP Base
Here you can find some SQL samples and some selected commands.--Select select vendor_namefrom po_vendors --Whereselect vendor_namefrom po_vendors where vendor_name = 'Google'--Group byselect vendor_...
Payables data in Sub-Ledger Accounting (XLA) - R12
http://www.shareoracleapps.com/2011/01/payment-data-in-sub-ledger-accounting.html In this post, we will check the Payment Data related to the Payable INVOICE ( Invoice_id = 166014 ...
GL Subledger Accounting in R12
create or replace function BG_PRC_JOURNAL_DESCRIPTION(p_header_id number, ...