How Do You Input Both Date And Time In Parameters? [ID 275785.1]


Modified 11-JUN-2004     Type HOWTO     Status MODERATED

Applies To

Oracle Discoverer - Version: 4.1.47.09
This problem can occur on any platform.

 

Goal

How can you input both date and time value in parameters which are based on the database date field?
When you try to input both date and time value in the parameter it errors out.
For example with the following error:
Invalid value "01-DEC-2003 11:11:11" for parameter ""
Just inputting date value works fine.

 

Fix


Change the Format mask of the item in the Admin Edition to DD-Mon-YY HR24:MI:SS and also change the format mask in the Desktop edition to same.
In the Discoverer report, select the item "" and then right click.
Select the property "Format Data..." -> Date tab -> Custom
and 'Add' the following format if you do not have already,
DD-MON-YYYY HH24:MI:SS

==Try it at our env.==

1. Set Format Mask at this item which is date datatype.

image

2. Entry value which is date format at parameter dialog.

image

Success !!

Somebaby 發表在 痞客邦 留言(0) 人氣()

Reference : http://oracally.blogspot.com/2010/04/oracle-ebs-11i-new-entity-setup.html

Somebaby 發表在 痞客邦 留言(0) 人氣()

Document : Pricing Data Bulk Loader API

翻譯 By me…

Overview

這份文件是用來說明”Pricing Data Bulk Loader API”功能的概要。這個功能可以用在Base Pricing 與Advanced Pricing.對於Base Pricing 設置, 只需要提供基本要匯入系統的Pricing 資料即可;”Pricing Data Bulk Loader API”是由一組Interface tables 與一個Concurrent Program 組成。所有的檢核工作與預設值都會在資料被inserte,deleted or updated前就完成,系統會自動把以經成功轉入的資料從Interface Table清除。

Somebaby 發表在 痞客邦 留言(0) 人氣()

有用的Metalink documents

    WHITE PAPER: Oracle WMS Personalization Framework [ID: 469339.1]
    WHITE PAPER: Oracle Order Management Suite White Papers [ID: 113492.1]
    WHITE PAPER: Intercompany Invoicing Overview [ID: 336129.1]
    Where Is The Best Place To Store Barcodes At Uom Level In Oracle?
    Warehouse Management Knowledge Browser Product Page
    Troubleshooting: Troubleshooting Grouping Rules In AutoInvoice [ID: 1084554.1]
    Troubleshooting: How To Setup And Troubleshoot Freight In AutoInvoice And The Transactions Form [ID: 1096942.1]
    Troubleshooting: Auto Sourcing And Auto Create/Release Checklist [ID: 417966.1]
    Troubleshooting Oracle XML Publisher For The Oracle E-Business Suite
    Script: Receiving Transactions Data Collection Script rcv11i_sa.sql [ID: 402245.1]
    Script: Data Collection Scripts for Cost Management [ID: 378348.1]
    Sample WMS Open Interface Insert Scripts / Examples howto Insert into Transaction Open Interface
    Sales Orders to MRP Data Flow Diagram
    Sales Orders to ASCP Data Flow Diagram
    Reference: Procurement (Purchasing) Product Documentation [ID: 67108.1]
    Reference: Patch Requirements for Extended Support of Oracle E-Business Suite Release 11.5.10 [ID: 883202.1]
    Readme: About Web Applications Desktop Integrator Mini-pack 11i.BNE.D [ID: 287080.1]
    Readme: About Oracle Receivables in Financials Family Pack G [ID: 290394.1]
    Readme: About Oracle Purchasing in Oracle Supply Chain Management Family Pack J [ID: 258521.1]
    Problem: Unable to Perform Actions For New WebADI User [ID: 875954.1]
    Problem: Unable To Invoice Sales Orders After Lines Are Closed [ID: 754320.1]
    Problem: Poor Performance In Scheduling Organizer Querying [ID: 568013.1]
    Problem: Pick More Option Is Not Working On Mobile Device [ID: 556331.1]
    Problem: Multi Line Requisitions are Created and Some Lines do not Import to OM [ID: 352835.1]
    Problem: Error -The Connection to the Server is Unavailable When Upload Web ADI - Interface Columns Integrator [ID: 394680.1]
    Problem: End Tag Does Not Match Start Tag 'Fsg:Rptline'. [ID: 390638.1]
    Problem: Download WebADI Document Stuck at "Do not close this window until processing completes" [ID: 752760.1]
    Problem: Credit Hold Set, But Order Still Booked [ID: 359696.1]
    Oracle PO, OM R 11.5.x : OEXOEORD Unable to split Internal Sales Order lines manually from Sales ...
    Oracle Inventory News Volume 9, May/June 2007
    How To: Vision Demo - How To Use the Cancel PO API [ID: 1077153.1]
    How To: ORDER MANAGEMENT SUITE CREDIT CHECK / EXPOSURE SETUP IN ORDER MANAGEMENT LIBRARY [ID: 444837.1]
    How To: Multi-Org Credit Checking and Global Exposure [ID: 209479.1]
    How To: Manage Global Agreement access setups [ID: 282880.1]
    How To: How to use Budget Wizard functionality in WebAdi (step-by-step) [ID: 471044.1]
    How To: How To Personalize Columns Names Downloaded On A Spreadsheet From A Compensation Workbench (CWB) Worksheet Via Web ADI? [ID: 389624.1]
    How To: How to get a list of Internal Requisition that do not have an associated Sales Order [ID: 397514.1]
    How To: How To Find Global Blanket Purchase Agreements From The Standard Purchase Orders or Vice Versa [ID: 578957.1]
    How To: How to Create Profile Option GL: Default Desktop Viewer [ID: 556280.1]
    How To: How to create a standard Purchase order referencing a Global Purchase Agreement [ID: 261852.1]
    How To: How to create a Global Purchase Agreement [ID: 261850.1]
    How To: How to Check The Correct Setup of Intercompany Accounts to Avoid the Error16 [ID: 1012982.102]
    How To: How to Add 'Kosovo' to FND_TERRITORIES? [ID: 739280.1]
    How To: Functionality to Enable Global Blanket Purchase Agreements for All Operating Units in Forms [ID: 745732.1]
    How To: FAQ: Inventory Transactions Process Flow? [ID: 741477.1]
    How To: FAQ: Inventory Standard Datafixes [ID: 568012.1]
    How To: Create a Intercompany invoice AR and AP overviews [ID: 784679.1]
    How To: (Pics) What Are The Steps Required To Setup An Internal Requisition In Purchasing? [ID: 406312.1]
    How To: (Pics) How Can The Receiving Data Collection Script Be Run From Within The Oracle Application? [ID: 423279.1]
    How to investigate printing issues and work towards its resolution ?
    How to Create a Link to a Discoverer Workbook in Apps11i
    Getting Reports Ouput to MS Excel - Techniques and References
    FAQ: FAQ: Receiving Transaction Processor (RTP) [ID: 210188.1]
    FAQ: FAQ - PO Document Control [ID: 1261814.1]
    ETRM DIRECT ACCESS DOCUMENT
    Diagnostics, Tracing and Debug Guide for Oracle Discoverer 4i (4.1)
    Cannot Setup Defaulting Rule To Default Pricing Date from Sale...
    Bulletin: Using Web ADI with Internet Explorer 7 [ID: 416321.1]
    Bulletin: SE-SM: Carrier Ship Method Form - FAQ [ID: 122300.1]
    Bulletin: Payables Suppliers Setup and Usage [ID: 204274.1]
    Bulletin: Oracle Order Management Product Information Center [ID: 1273931.1]
    Bulletin: Oracle Inventory News Current Edition [ID: 205.1]
    Bulletin: List of Patches in Web Applications Desktop Integrator (Web ADI) for Releases 11i and 12 [ID: 726989.1]
    Bulletin: Inventory Setup for Intercompany Invoicing [ID: 112437.1]
    Bulletin: Intercompany Invoicing: Troubleshooting [ID: 112803.1]
    Bulletin: Credit Checking Setup in Order Management [ID: 744642.1]
    Advanced Barcode Strategies

Somebaby 發表在 痞客邦 留言(0) 人氣()

Version : 11.5.10

Use the SQL script Req.imp.sql to insert your Requisition information from a non-Oracle Feeder system into PO_REQUISITIONS_INTERFACE_ALL table.

The columns in PO_REQUISITIONS_INTERFACE_ALL are described below. Mandatory columns are mentioned in BOLD.

image

NOTE: We have to give a Unique Requisition Number.
REFERENCES: Oracle Purchasing Applications Technical Reference Manual

Somebaby 發表在 痞客邦 留言(0) 人氣()