`

GL_BC_PACKETS表说明

阅读更多

GL_BC_PACKETS是跟预算控制有关的主要的表,对于一个账户来说有三种余额类型:A,E,B-最专业的ERP社区,帮助你在ERP行业实现价值!
表中ACTUAL_FLAG主要表示影响的是账户的那种类型的余额
资金保留流程在表gl_bc_packets中插入记录,并且ACTUAL_FLAG,过账程序把这条记录删掉。
举个例子:在应付模块定义一张发票,包含一个分配行,金额为100,下面是这些信息在gl_bc_packets表中的变化:
a 输入一张发票,并且分配行金额为100
b 验证这张发票。资金保留流程会在gl_bc_packets表中创建一条记录,并且ACTUAL_FLAG='E'
c.执行传送至总帐的程序,这个过程在gl_interface创建了一条日记帐的记录(actual_flag=A),并且je_bach_id= null. 这个时候,保留款余额就为0了,实际余额就是100。实际的余额在gl_bc_packets中登记,不单单是在gl_balances表中
d.执行日记帐导入过程,这个过程会创建一个实际的日记帐输入,金额为100
执行日记帐过账,删除了gl_bc_packets表中的相应的内容


关于GL_BC_PACKETS中的数据,有17种情况:
1. A need to make a correction on a journal that has been created from a sub ledger. These transactions cannot be updated in the Journal form because the funds reservation was done in the sub ledger. These journals cannot be updated without some SQL updates and deletes to be performed. The purpose is that if any correction needs to be done it should come from the source. This keeps your sub ledger and General Ledger in balance. However, there is from time to time a need to have a correction made in the General Ledger for one of these types of journals.

2. Transactions are stuck in the GL_BC_PACKETS table with a JE_BATCH_ID –1 From time to time there may be records in the gl_bc_packets table that have a je_batch_id = -1. There are a few reasons why this condition could happen. Records from payables were stuck in gl_bc_packets during Payables transfer to GL. Sometimes it is all related to a certain transaction date. All rows for detail accounts had je_batch_id = -1 and je_batch_id = null for summary accounts. This can happen if a user had created GL batch after correcting stuck rows in gl_interface.

3. Orphan lines left in the GL_BC_PACKETS table after a user has deleted a manual journal from the form. This will leave the rows in the GL_BC_PACKETS table causing an orphan record. The correct procedure would be to post the journal. Reverse the journal and then post the reversal. If a journal is deleted the rows in the GL_BC_PACKETS and GL_BC_PACKET_ARRIVAL_ORDER table are orphaned. The deletion process does not clear the table of the matching rows.

4. Very old records from very old periods are left in the GL_BC_PACKETS and GL_BC_PACKET_ARRIVAL_ORDER table that have not been deleted for some reason and the records are too old to complete a root cause. This can happen because of some customization or custom triggers that might have been in place at some time.

5. Journal posting process has gotten hung up on a journal that has funds reservations completed. Usually this type of problem is cause by a disruption in the concurrent manager.

6. Funds reservations have gotten hung up during the reservation process. This can happen if there is a disconnection from the applications while funds reservation process is being performed.

7. Encumbrance lines remain in the GL_BC_PACKETS table with an account_type of ‘E’ and the customer is a Federal Customer.

8. Encumbrance lines remain in the GL_BC_PACKETS table with an account_type of ‘A’ and the customer is using encumbrance accounting and should not have any account_types of ‘A’ left in the table.

9. Users have turn encumbrance accounting on and off which should NOT be done once encumbrance accounting is turn on. This causes negative encumbrances in the General Ledger.

10. If a user has made any corrections to a journal in the applications through the Journals->Import->Correct. This may leave corrupted rows in the gl_bc_packets table.

11. Program – Create Journals created journals for encumbrances and actual.

12. ERROR12 in journal entry posting form.

13. An account that was used in a sub ledger while entering in transactions has been disabled or end dated and journal import or the posting fails because of this end dated/disabled account combination or end dated/disabled segment value.

14. Grant Management System (GMS) Funds Checking (GMSFCUPB) NOT POPULATING THE GL_BC_PACKETS TABLE CORRECTLY FROM GMS

15. JOURNAL COMING FROM AP ARE CHECKING FUNDS AGAIN IN GL. The packet_id that is in the gl_je_batches does not match the packet_id in gl_bc_packets table for the same transactions.

16. FUNDS RESERVATION DOES NOT FAIL WHEN TWO INVOICES WERE VALIDATED AT SAME TIME - Creates duplicate rows in the gl_bc_packets table. The source of the transactions is from the inventory sub ledger.

17. BUDGETARY CONTROLS CREATED JOURNALS ENCUMBRANCES AND ACTUAL. The issue was that Auto Post running for multiple sources, such as Payables and Purchasing, etc., while the Create Journals was starting to submit for both Actual and Encumbrance journals in Auto Posted. Actual and Encumbrance journals should not be set up to be ran through Auto Post at the same time

 

分享到:
评论

相关推荐

    draw_packets.rar_des MATLAB_packets

    TRAITEMENT DES EMAGE

    TCPIP作业:写一个类似wireshark的抓包程序,并分析数据报_Homework_Catch_Packets.zip

    TCPIP作业:写一个类似wireshark的抓包程序,并分析数据报_Homework_Catch_Packets

    Accept_Reject_Packets.zip_Destination

    "Accept_Reject_Packets.zip_Destination" 文件压缩包提供了一个示例代码,帮助我们理解如何让路由器根据特定条件接受或拒绝来自某个目的地的数据包。这个场景常见于网络安全、访问控制以及流量管理等应用。 1. **...

    Android 蓝牙 A2dp 听歌卡音?audio数据到a2dp通道流程解析----A2dp流控原理(Acl Flow Con

    每当主机控制器有数据分组待发送,就会发送NumberOf_Completed_Packets事件,直到所有ACL数据分组都已发送或缓冲区溢出。 举一个例子,蓝牙芯片通常有固定的ACL缓冲区,比如6个BR/EDR ACL buffer。在蓝牙重置后,...

    mysql提示got timeout reading communication packets的解决方法

    user: ‘root’ host: `localhost’ (Got timeout reading communication packets) MYSQL server has gone away 引起这个原因是不可怕的.原因是更改了系统的断开时间. mysql>show gloable variables like “%time...

    0-1packets.zip_packets 算法

    0-1背包问题是一种经典的组合优化问题,在计算机科学和运筹学中有着广泛的应用。它描述的是这样的场景:我们有一组物品,每种物品都有一个重量和一个价值,我们需要将这些物品放入一个容量有限的背包中,使得背包中...

    leach协议 matlab仿真

    packets_TO_BS=packets_TO_BS+1; PACKETS_TO_BS(r+1)=packets_TO_BS; S(i).type='C'; S(i).G=round(1/p)-1; C(cluster).xd=S(i).xd; C(cluster).yd=S(i).yd; plot(S(i).xd,S(i).yd,'k*');

    mqtt_packets_tcpdump.pcap数据包

    mqtt协议数据包pcap

    Wireshark- A Guide to Color My Packets

    ### Wireshark: A Comprehensive Guide to Coloring Your Packets #### Introduction In the realm of cybersecurity and network analysis, tools like Wireshark play a pivotal role in detecting anomalous ...

    scap:网络嗅探器(扫描并捕获传入的数据包)

    用法 scap [-i] [-d] [-h]options are: -i # dump header info in file -d # dump data in file -h # print help and usage -o filename # export output to PCAP file -s ip_src # filter packets by IP source -t ...

    Route Packets, Not Wires On-Chip Interconnection Networks

    标题与描述:“Route Packets, Not Wires:On-Chip Interconnection Networks” 此标题与描述主要探讨了在芯片设计中采用网络互连而非传统布线技术的概念。文章由斯坦福大学计算机系统实验室的William J. Dally和...

    Wavelet Packets and Their Statistical Applications

    电子书《小波包及其统计应用》(Wavelet Packets and Their Statistical Applications)是该领域的经典著作。这本电子书由Khalil Ahmad和Abdullah撰写,并由Springer出版。这本书深入探讨了小波包在统计分析中的理论...

    POJ1017-Packets

    标题中的"POJ1017-Packets"指的是北京大学在线编程平台POJ(Problem Set of Peking University)上的第1017题,这是一道关于数据包处理的问题。题目通常要求参赛者编写程序来解决特定的算法或逻辑挑战。 在描述中...

    Ralink_WIFI_TX_RX流程分析

    在发送处理流程中,首先要通过rt28xx_send_packets函数将数据包准备就绪,之后APHardTransmit函数会把数据包从准备好的缓冲区中搬运到环形缓冲区中,为实际的发送操作做准备。环形缓冲区是网卡发送数据时用到的一种...

    USB4 1.0 ECN - Storing Credit and TMU Packets.pdf

    Adapter has 10 credits, it can receive up to 10 Transport Layer Packets before needing to request more credits from the sender. This credit-based mechanism ensures efficient bandwidth utilization and ...

    Stable matter-wave packets in a traveling lattice potential

    标题“Stable matter-wave packets in a traveling lattice potential”中提到的“稳定物质波包”和“移动格子势”涉及量子物理领域中的玻色-爱因斯坦凝聚体(Bose-Einstein Condensate,简称BEC)的概念。...

    load-balance-agents

    7MIN_PERSISTENCE = 1PACKETS_STD_MEAN = THROUGHPUT_META_STDMARIAN_CONSTANT = 3.0ALPHA = 2BETA = 0.01 THROUGHPUT_META_MEAN 从中得出节点吞吐量2的高斯平均值。THROUGHPUT_META_STD 从中得出节点吞吐量的高斯...

    Packets with Deadlines A Framework for Real-Time Wireless Networks

    在介绍这篇题为《Packets with Deadlines: A Framework for Real-Time Wireless Networks》的文章之前,我们需要了解文章所涉及的几个关键领域:实时无线网络、网络资源包动态规划以及通信网络。本文的作者是来自...

    局域网渗透

    -O is dump matched packets in pcap format to pcap_dump 保存匹配的数据包到一个pcap数据包格式的文件里 -W is set the dump format (normal, byline, none) 设置数据包显示的格式,一般,按行,无格式三种 -F ...

Global site tag (gtag.js) - Google Analytics