tp's blog | 一路走来

You can download the lastest patch form support.oracle.com

• Oracle E-Business Suite Release 12.1.3 Release Update Pack(Patch 9239090)

For installation instructions for EBS 12.1.3, see:

• Oracle E-Business Suite Release 12.1.3 Readme(Note 1080973.1)

This release update pack (RUP) combines error corrections, statutory/regulatory updates, and functionality enhancements into a consolidated, suite-wide patch set.  This release is a maintenance pack and can only be installed on top of an existing EBS 12.1 environment.

What are the advantages of Drop Shipment Orders?

Here are the Details as per Mark

1.Order Entry

Here the activity is entering process where oe_order_headers_all (flow_status_code as entered) oe_order_lines_all . The order is booked as DROP SHIP

2. Order Booking

3. The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is
po_requisitions_interface_all

4. After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders

7. After the goods are successfully received invoices for vendors are created in accounts payables as in normal purchase orders.

8. Invoices are generated for customers In account receivables.

9. oe_order_lines_all (flow_status_code ’shipped’, open_flag “N”)

10. oe_order_lines_all (flow_status_code ‘closed’, open_flag “N”)

DropShip的工作场景：

企业A向客户B销售产品，但是企业A本身并不生产该产品，而是向供应商C来采购，并且在大部分的情况都是C向B直接发货，也就是说企业A大部分的交易都是贸易，属于贸易型企业，除了贸易型企业，对于一些集团公司的销售公司或门店也采用这种销售方式。即‘左手倒右手’。

1.create a item,and ensure this item have purchasable and salable properties.

(according step 4 error,we should also type a value to list price field)

2.Create a sale order,and ensure ‘Source Type’  is ‘External’.

if source type is ‘Internal’,it stand for that you will sale item from your stock.

if source type is ‘External’,it stand for that you will sale item from other supplier.(Drop ship Way)

3.The Purchase Release program passes information about eligible drop-ship order lines to Oracle Purchasing.The interface table which gets populated is

po_requisitions_interface_all

4.After Purchase Release has completed successfully, run Requisition Import in Oracle Purchasing to generate purchase requisitions for the processed order lines. The Requisition Import program reads the table po_requisitions_interface_all validates your data, derives or defaults additional information and writes an error message for every validation that fails into the po_interface_errors table.The validated data is then inserted into the requisition base tables po_requisition_headers_all,po_requisition_lines_all,po_requisition_distributions_all.Then use autocreate PO fuctionality to create purchase orders and then perform receipts against these purchase orders

After requisition import,In PR summary form,Try to find your PR.

But can Not find my PR.

Execute below query,

SELECT e.error_message

FROM po_requisitions_interface_all i, PO_INTERFACE_ERRORS e

WHERE i.TRANSACTION_ID = e.INTERFACE_TRANSACTION_ID AND item_id = 25875

Error is:This item is missing a list price in the item master setup window. Please enter a list price greater than zero (0) in the item master.

Then go back to Master item form,type a value to List price,

Becasue Req Import does not pick up interface records that previously failed.we also need update process_flag from ‘ERROR’ to ‘FUTURE’.

Script like:

update po_requisitions_interface_all set process_flag = ’FUTURE’ where item_id = 25875

Then re-run Requisition Import request.PR got generated sucessfully.

5.Auto create PO

6.PO approve

7.Receipt&Delivery

9.After receipt,a sale order issue txn will automaticlly generate.

Sale order line is closed.

Once customer receipt the PO,Then you can take the AR which created by SO to customer,

Customer will give amount 1350 to you.

在‘System Administrator’ responsibility下，Help > About Oracle Appliations可以看到更多的信息。
以下蓝色字体部分，就是在普通responsibility下无法看到的信息。

——————————–
Oracle Applications
Copyright (c) 2004 Oracle Corporation,
Redwood Shores, California.
All Rights Reserved.

—————————————-
Login
—————————————-
Site : tk10203
Application : System Administration
Responsibility : System Administrator
Security Group : Standard
User Name : MFG

—————————————-
Database Server
—————————————-
RDBMS : 10.2.0.3.0
Oracle Applications : 11.5.10.2
Machine : rws60124rems
User : APPS
Oracle SID : mz1yd102
System Date : 01-DEC-2009 22:08:25
Database Server PID : 7827
Session SID : 377
SERIAL# : 64378
AUDSID : 5947370
Database CPU Usage (in secs) : 15.96

—————————————-
Forms Server
—————————————-
Oracle Forms Version : 6.0.8.27.0
Application Object Library : 11.5.0
Machine : RWS60124REMS
Forms User CPU (secs) : 19.800989
Forms System CPU (secs) : 1.601756
Forms Process ID : 4548

—————————————-
Forms Server Environment Variables
—————————————-
AU_TOP : /slot/ems2570/appmgr/mz1yd102appl/au/11.5.0
FDBDMCHK : [Unset]
FDFGCXDBG : [Unset]
FDSQLCHK : [Unset]
FDUDEBUG : [Unset]
FNDNAM : APPS
FND_TOP : /slot/ems2570/appmgr/mz1yd102appl/fnd/11.5.0
FORMS60_APPSLIBS : APPCORE FNDSQF APPDAYPK APPFLDR GLCORE HR_GEN HR_SPEC ARXCOVER
FORMS60_CATCHTERM : 1
FORMS60_ERROR_DATETIME_FORMAT : [Unset]
FORMS60_ERROR_DATE_FORMAT : [Unset]
FORMS60_FORCE_MENU_MNEMONICS : 0
FORMS60_MAPPING : http://rws60124rems.us.oracle.com:8070/OA_TEMP
FORMS60_MMAP : [Unset]
FORMS60_OUTPUT : /slot/ems2570/appmgr/mz1yd102comn/temp
FORMS60_OUTPUT_DATETIME_FORMAT : [Unset]
FORMS60_OUTPUT_DATE_FORMAT : [Unset]
FORMS60_PATH : /slot/ems2570/appmgr/mz1yd102appl/au/11.5.0/resource:/slot/ems2570/appmgr/mz1yd102appl/au/11.5.0/resource/stub
FORMS60_RESOURCE : [Unset]
FORMS60_TIMEOUT : 5
FORMS60_USER_DATETIME_FORMAT : DD-MON-RRRR HH24:MI:SS
FORMS60_USER_DATE_FORMAT : DD-MON-RRRR
FORMS60_USE_CBO : [Unset]
NLS_DATE_FORMAT : DD-MON-RR
NLS_DATE_LANGUAGE : AMERICAN
NLS_LANG : AMERICAN_AMERICA.UTF8
NLS_NUMERIC_CHARACTERS : ,.
ORACLE_HOME : /slot/ems2570/appmgr/mz1yd102ora/8.0.6
ORACLE_PATH : [Unset]
ORA_NLS_CHARSET_CONVERSION : [Unset]
TNS_ADMIN : /slot/ems2570/appmgr/mz1yd102ora/8.0.6/network/admin/mz1yd102_rws60124rems
TWO_TASK : mz1yd102

—————————————-
Current Form
—————————————-
Form Application : Application Object Library
Form Name : FNDSCSGN
Form Path : UNKNOWN
Form Version : 11.5.124
Form Last Modified : $Date: 2006/10/24 10:54  $

—————————————-
Scheme Display Profiles
—————————————-
Java Look and Feel : ORACLE
Java Color Scheme : BLAF
Color Scheme Indicator : GENERIC
Indicator Colors : Y

—————————————-
Forms
—————————————-
APPSTAND : 11.5.33
FNDSCSGN : 11.5.124

—————————————-
Form Menus
—————————————-
FNDMENU : 11.5.51

—————————————-
Forms PL/SQL
—————————————-
APPCORE : 11.5.157
CUSTOM : 11.5.5.1150.1
FNDSQF : 11.5.111
GHR : 11.5.150
GLOBE : 11.5.46
GMS : 11.5.230.90.7
IGILUTIL2 : 11.5.97
IGILUTIL : 11.5.29
OPM : 11.5.33.115100.2
PQH_GEN : 11.5.118
PSA : 11.5.162
PSAC : 11.5.16
PSB : 11.5.24
VERT : 11.5.6

可以通过设定全局变量GLOBAL.FND_FLEX_FNDSQF_DEBUG来在Runtime调试Flexfield的一些信息

全局变量：GLOBAL.FND_FLEX_FNDSQF_DEBUG有’OFF’, ’EXCEPTION’, ’FAILURE’, ’DEBUG’ 四个级别的值。
可以通过
1.Diagnostics > Examine来设置这个全局变量
2.Block:GLOBAL,Filed:FND_FLEX_FNDSQF_DEBUG,Value可以有以下四种，

OFF – The default value. The debugger is turned off. Debug
messages will not be displayed.

EXCEPTION – Only exception debug messages will be
displayed. These messages come from ’EXCEPTION WHEN
OTHERS THEN’ parts of the code. Flexfields will still RAISE the
exceptions, that is, these exceptions will not be handled by the
flexfields code.)

FAILURE – Failure and exception debug messages will be
displayed. In general, these messages are from IF (NOT
FORM_SUCCESS) THEN parts of the code.

DEBUG – All debug messages will be displayed.

11i
f60genm INVTTMTX.fmb apps/apps100@mm1sb100 Compile_All=yes Forms_Doc=yes
R12
frmcmp_batch INVIDITM.fmb apps/apps@md0yd201 Compile_All=yes Forms_Doc=yes

INV:Inventory->Accounting Close Cycle->Inventory Accounting Period
PO:Purchasing->Setup->Financials->Accounting->Open and Close Periods
AR:Accounts Receivable->Control->Accounting->Open/Close Periods

发件人 BlogPic

MTL_TRANSACTION_ACCOUNTS(MTA)

• Holds the accounting information for each material transaction in MMT

• In most cases, each costed row in MMT should have at least 2 or more rows in MTA to represent the transaction Debit and Credit

• Join to MMT by TRANSACTION_ID

• Troubleshooting columns to verify:

• GL_BATCH_ID = -1

• REFERENCE_ACCOUNT = NOT NULL

• Module

• INLTGL: Transfer to GL

• Form

• Inv>Transactions>Material Distributions

• CSTFQITD

发件人 BlogPic

发件人 BlogPic

ORG_GL_BATCHES (OGB)

• Stores row for each batch of transactions interfaced to GL_INTERFACES

• Troubleshooting columns to verify:

• OGB.GL_BATCH_ID = MTA.GL_BATCH_ID

• ACCOUNT_PERIOD_ID

• ORGANIZATION_ID

• Module

• INLTGL: Transfer to GL

• Form

• Inv>Accounting Close Cycle>View General Ledger Transfers

• INVTTGGL

GL_INTERFACE (GLI)

• Stores row for each batch of transactions interfaced to GL_INTERFACES

• Troubleshooting columns to verify:

• REFERENCE1 = MTA.GL_BATCH_ID / ORGANIZATION_ID

• REFERENCE21 = MTA.GL_BATCH_ID

• REFERENCE22 = MTA.ORGANIZATION_ID

• Run Import to GL > GL Vision Ops (USA) Responsibility

• Designate Source (i.e. Inventory) and Optionally Group ID

• Journals>Import>Run

• Inquiry on Batch

• Inquiry>Journal

• Source = Inventory

• Period =

发件人 BlogPic

发件人 BlogPic