ITPub博客

ZZ: http://erpconsulting.yo2.cn/articles/%e5%86%8d%e6%ac%a1%e7%90%86%e8%a7%a3%e4%bb%80%e4%b9%88%e6%98%af%e2%80%9c%e5%ae%a2%e6%88%b7%e2%80%9d%ef%bc%9a%e5%85%b3%e4%ba%8eparty%e4%b8%8eaccount.html ...

sometimes the xlm report can't finished. as there have speical char in the report. we can use such query to check the special char: declare  s  varchar2(4000);  s1 varcha...

How To Import Item Catalog Descriptive Element Values [ID 360850.1]How to Import Item Catalog Descriptive Element Values?SolutionThis document is created to know how to use the following publi...

Indented Bills form,if we choosed the costs, cost type, in the find result form, we will see costed. we found some Assembly the costed has choosed, some didn't. checkec on metalinke with following is...

Issue: the item issued to wip job, some of the transaction value is zero, some of the transaction is not zero.Then  I checked the item’s transaction, and found there is no receive for item A to...

就是这三个,没想法这三个栏位很重要.INSERT INTO rcv_transactions_interface  (interface_transaction_id  ,header_interface_id  ,group_id  ,interface_source_code&nbs...

     Now we found one report finished with good , but there still have some data missed.  it is really headache thing. as we run the query in PL SQL, there is no issue fo...

it was his birthday. the whether is excellent. We deceided to book Photography for our wedding. When we went out,the bus came immediately. When we got to the bus station. We bought the last two t...

sometimes when we enter so, click Book, the so status is booked. only the so status is awaiting shipping, then the system will allow us to perform. pick release. we need use action---progress so in th...

Because of some reason, we need to clean the following interface table: INCOIN: Why Should the Interface Tables Be Truncated [ID 1347604.1]RCV_TRANSACTIONS_INTERFACEMTL_TRANSACTIONS_INTERFACE...

---receiptINSERT INTO mtl_transactions_interface  (transaction_interface_id,   transaction_header_id,   source_code,   source_header_id,   source_line_id,&...

 INSERT INTO MTL_TRANSACTIONS_INTERFACE    (TRANSACTION_HEADER_ID,     TRANSACTION_INTERFACE_ID,     SOURCE_CODE,     SO...

these days we met a new case with xml report issue. As we run the report, the report finished with good. but the user run the report, the report finished with warning. As we checked with user, ...

select * from apps.FND_FORM_CUSTOM_RULESwhere function_name like '%INVIDITM%'

When the user perfomer RMA receive: Cost Of Goods Sold Account Generation Failed with error : Value secured: Wrong Legal Entity!RCV_COGS_ACC_GEN_FAILED (ACCOUNT=.....-0-0-0) We also raise SR fo...

met issue: the user can't drop LPN, as check and found the avaible qty is negative. the onhand is 1, so line qty 2pickrelease qty 1but the aviable qty is -1 problem was user had manual...

Caused by: java.io.UTFDataFormatException: Invalid UTF8 encoding.The xml page cannot be displayedan invalid character was found in text content When we run the report, only part of the data in...

SELECT PAR.ORGANIZATION_CODE ORG,        MSI.SEGMENT1 ITEM,       MSI.DESCRIPTION,       msi.INVENTORY_ITEM_ID...

    It has been a long time i haven't check my space. Everyday just busy with work. but i can't find any progress during my work. Maybe it is the time for me to think more than just doi...

No discret job created in Oracle When the user  released item in ASCP but no Discret job has been created in Oracle.The cause is regarding the presence of duplicate items in BOM for the a...